There is a very useful application for inventory names S2GS https://play.google.com/store/apps/details?id=dynamiqdata.s2s&hl=en_US
Did you find a suitable solution to the numbers problem?
I make workbench code for check this mistak : SELECT receipt ,datenew,ticketid, (SELECT (round (total,0)!= round (sum(unitsprice1.05),0)))as dfrnt, round (total,1) as TL ,round (sum(unitsprice1.05),1)as S , tendered FROM receipts, ticketlines ,tickets, payments where ( ticketlines.ticket =payments.receipt)and (payments.receipt= receipts.id)and (payments.receipt= tickets.id) and (datenew between '2024/01/01 07:00:00' and '2024/08/04 07:00:00') group by ticket;
I make workbench code for check this mistak : SELECT receipt ,datenew,ticketid, (SELECT (round (total,0)!= round (sum(unitsprice1.05),0)))as dfrnt, round (total,1) as TL ,round (sum(unitsprice1.05),1)as S , tendered FROM receipts, ticketlines ,tickets, payments where ( ticketlines.ticket =payments.receipt)and (payments.receipt= receipts.id)and (payments.receipt= tickets.id) and (datenew between '2024/01/01 07:00:00' and '2024/08/04 07:00:00') group by ticket;
I make workbench code for check this mistak : SELECT receipt ,datenew,ticketid, (SELECT (round (total,0)!= round (sum(unitsprice1.05),0)))as dfrnt, round (total,1) as TL ,round (sum(unitsprice1.05),1)as S , tendered FROM receipts, ticketlines ,tickets, payments where ( ticketlines.ticket =payments.receipt)and (payments.receipt= receipts.id)and (payments.receipt= tickets.id) and (datenew between '2024/01/01 07:00:00' and '2024/08/04 07:00:00') group by ticket;
I make workbench code for check this mistak : SELECT receipt ,datenew,ticketid, (SELECT (round (total,0)!= round (sum(unitsprice1.05),0)))as dfrnt, round (total,1) as TL ,round (sum(unitsprice1.05),1)as S , tendered FROM receipts, ticketlines ,tickets, payments where ( ticketlines.ticket =payments.receipt)and (payments.receipt= receipts.id)and (payments.receipt= tickets.id) and (datenew between '2024/01/01 07:00:00' and '2024/08/04 07:00:00') group by ticket;
can do that from workbench
Hello, I thank everyone who helped and helped make this blessed project a success Sometimes the bid and total are repeated for two consecutive invoices (as in the picture), which changes the total daily sales After searching for a solution, we found the following solution: 1. Edit the invoice with the duplicate bid and total and press the space button (as if you were issuing an invoice again) The invoice will be modified and moved to the bottom of the list of invoices