…
this is the database admin 2302
Thank You
OK. I don’t have V4 installed atm. I’ll check that when I’ll get back at home.
PS: Please don’t post databases publicly and do it with PM when staff requested. Thanks.
Oh ok …sorry and thank you for your help…
Production databases may contain sensitive info about the business or licenses. That’s why we request backups via PM.
btw. I can remember we solved an issue related with that error that can happen when two different terminals tries to settle same ticket at the same time. You’re using 4.1.82 and that’s fine but do you remember when did you updated to 4.1.82?
I straight install ver 4.1.82 and import the database .from other PC
Ah… i remember when we are testing a tablet order , one tablet try to settle same ticket which already been settled by the other tablet .
is there anyway to fix this ? We need to see/print 02/08/2015 sales report
You can quickly review Accounts > Transactions that generated for tickets created at 02/08/2015. Transaction raises that error will contain multiple calculation transactions of same type (eg double discount lines or service). After finding that transaction delete one of these duplicate lines and report will work fine.
However 4.1.82 should handle that multiple tablet issue. Please be sure all terminals updated to 4.1.82 version and please let me know if same issue occurs again.
1 Like
found ticket number 6093 with paid status but zero amount , is it possible this ticket cause the problem ? how to delete this ticket ?
Try adding an order to that ticket and then settle it again. Then go back and void the order.
@kendash i try adding an order to that ticket and then settle it again then void the order , its not fixing the problem . still cannot generate 02/08/2015 report ,
Doubt that was it then. Do what emre said.
Did you checked accounts > transactions?
There should be a transaction document that have double calculation transactions.
i’ve checked workperiod 02/08/2015 transactions.
i use two calculation transactions ,discount and service charge
i could not find any double calculation transactions except discount and service charge .
Emre , if you could check my database i would be very grateful
I’ve checked your transactions and found 6259 has multiple service transactions.
Delete highlighted one and it will work fine.
2 Likes
its solved … thank a million Emre !!!.
1 Like
Hi Emre …
this issue occurs again .several times…
I hv 2 terminal adn 4 tablets and all terminal using ver 4.1.82
Are both terminals sharing same database… which terminal is the tablets connecting too?
So can you give us more details about your configuration? Is it again double service issue? How do you apply services manual or automatic? If we can reproduce it on our side we can easily solve that so something specific for your setup that can give us a hint about the issue will help us a lot. From screenshot I’ve added we can clearly see second service amount added after payment made. Do you have any idea about how it can be possible?
Yes using same database
my setup is
Sambapos with Mssql 2014 as a server ,
one computer as terminal using database @ sambapos server
and 4 tablets connect to Sambapos server using RDP
Can you fill us in more specifically with what he asked?
manual service charge