Hello everyone ! I would like to implement in my Sambapos the ability to save receipts for a certain customer and then print the totals of each receipt and the total sum of all its receipts. I try to explain better, if Mario Rossi’s coming to dinner for 10 days in a row, I die every day for a receip…

[image] QMcKay: Getting Ticket Tags or Order Tags via SQL is not straight-forward. I have an idea. I changed GetStatement Script as follows. What I basically did is including Ticket Tags. declare @entityType varchar(255) = 'Customers' declare @entityId int = 0 declare @dateFilterBeg datetim…

Very cool @emre ! I did not know we could do that. Rather, I forgot about the JSON Parser feature.

Many Thanks!! This work fine. EDIT: For add Total I use {SETTING:AS Entity Balance} , but is whitout ,00 . Is possible to add [image]

[image] Michel_Aimonino: {SETTING:AS Entity Balance} Use FN() function, something like: [=FN('{SETTING:AS Entity Balance}')] You might need to use that in the Formatting section instead, so please show your full Template. For example, it might be like: <J00>{0}|{1}|[=FN('{2}')]}

[LAYOUT] <L00> Data |R.N°|Euro <F>- {REPORT SQL DETAILS:@@GetStatement;Customers: F.TxDate.desc,F.TicketTags(TN=Rievuta Fiscale No)TV,F.Amount,,:: <L00>{0}|{1}|{2} } <F>= <EB> <L00>TOTALE: {SETTING:AS Entity Balance} EURO <DB> <C11> {ENTITIES} [ENTITIES:Customer] -- Customer entity for…

So either of these should work: <L00>TOTALE: [=FN('{SETTING:AS Entity Balance}')] EURO <L00>TOTALE: [=F('{SETTING:AS Entity Balance}','0,00')] EURO

I don’t think so… [image] [image]

try <L00>TOTALE: [=F('{SETTING:AS Entity Balance}','0.00')] EURO fyi: comma , is used to define thousand separator.

[image] emre: <L00>TOTALE: [=F(‘{SETTING:AS Entity Balance}’,‘0.00’)] EURO this work…Once again thanks a lot.

I have one more thing what’s popping in my head but I can’t do … when a customer pays his debt I need to clean up your transactions, there is an action that let me? [image] transactions related to that customer

Print bill with customer

V5 Question

emre November 12, 2016, 3:08pm 35

No. You should keep them for reporting.

While printing account statements you can print transactions only after last zero balance date. See this topic for more information.