@pauln saying that depending on your card terminal reports it may well report cash back in a seperate total, have seen machines handle tips in different ways similarly, included in total with tips value seperate or a sales/payment total and tips on separate line.
If that the case just noticed you can have multiple translation types on a calculation so you could probably add a second transaction type to have a side account for ‘cashback payments’ to separate from ‘sales payments’ while still ‘returning/refunding’ the amount from cash…
Hi JTR - thanks for your efforts!
Just up and need to go to my sons hockey game in absolute driving rain and stormy conditions! I work through your screen when I get back.
Thanks.
@pauln May i know how didi you achieved this as i discussed few times but this is what exactly i need , in my country most people ask for cashout with sale . So whatever cashout needs - cash amount in till and report as your screen shot , it would be helpful as compared with my setup iam doing some wrong thanks.
Yea but you got involved! haha - just kidding busting my butt checking out hardware and bench testing so only keeping 1 eye on the forum.
.
Anyway here is the GIF:
Sorry to ask again , Account Screen showing correct but Yah I do followed and using since few months @JTRTech, but some how the cash amount not showing negative when Eftpos goes up same time the till cash need to be reduced , what I did ( cash=cahout-discount) etc but how can I get it by default? I seen your report how you did it ?
I think I showed exactly what I did :-S
If you want to see another screen shot I can try and find out which DB I did that on if you tell me what you want to see…
Ive set this up following the screenshots and it works as it should do, to a point.
On my payments report the cash out isn’t deducted from cash making the total wrong. This means that when my staff cash up at night, it will look like we are out 66 baht (the cash back). How do I rectify this?
Second. I would like this to be automatic, ie no need to use the cash out button. We will be using it mostly for tips through credit card, so to make it easy i would prefer if we could just enter the total amount credit card tendered and the excess would be registered as cash change, not credit card. Is this possible?
You pictures aren’t loading for me but if you creating account transaction outside of a ticket payment that wouldn’t be reflected in default reports as it is reporting ticket details not account details. You would need to adjust the report to account for this.
I made 2 sales for the same item and paid one with cash and one with credit card cash back.
The result is that my payment report says that I’ve received 300 on credit card and 234 in cash. This should be 300 cc and 168 cash (234-66 cash received - cash back)
Your pictures from before didn’t load so don’t really know what you have setup.
But as I said before if you are reporting ticket payment details this is correct, the ticket was paid with 300 card and 234 cash. the background account transactions are not ticket payments. You would need to tweek the report to shown more than just ticket payments.
The key bit to check your calculation settings is to look at the accounts screen rather than ticket payment details on default report.