Auto calculate sum of just 2 payment types or more on report ticket

i mean the ticket template name is both cash and credit card same as the payment account name

with me ticket template name is different from the account payment name

What do you mean by ticket template name?

i meant payment template name

like i said dont know if its that but will test it out by changing Cash acount to espece also see what it gives :slight_smile:

Oh yes that could be why…

so yeah that seems to be the prob it now shows espece but not bouteille espece cause that has no fixed account

There may be a different syntax expression I just havnt looked it up yet. Surely there is something to reference Type. Let me look at the database table I might be able to guess it.

take your time :wink: have to close up right now so will be busy anyways and will take my backup pc with sambapos on it at home so that i can work from there

I just looked… there is no current syntax for that. The table has reference to it but its via an ID #… you would need SQL to determine that. Unless @emre has created a tag specific for that… and we just dont know about it… I doubt it though.

hmm thats to bad, still thanks for all the help :wink: but could you give me link for where you can find all the syntaxes im still gonna try some stuff tonight and would help if i could look what is possible

found the solution so right syntax is

[Payments:2, 1, 2]
{REPORT PAYMENT DETAILS:P.Type,P.Amount.Percent,P.Amount.Sum:Payment.Amount > 0}
>Total|{REPORT PAYMENT DETAILS:P.Amount.Sum:Payment.Amount > 0}
>>Espece|{REPORT PAYMENT TOTAL: (PT=espece) OR (PT=bouteille espece)}