Need help calculating 2 fileds

V5 Question
1

I have a custom report, but got lost in brackets somewhere…

  [VERKOOP 21%:2,1, 1]
  {ACCOUNT TRANSACTION DETAILS:Sales Hoog}
  >Sales Hoog||€ [=F(TN('{ACCOUNT CREDIT TOTAL:Sales Hoog}'),'#,#0.00')]
  >BTW Hoog||€ [=F(TN('{ACCOUNT CREDIT TOTAL:BTW Hoog}'),'#,#0.00')]
  >TOTAAL||€ [=F({ACCOUNT CREDIT TOTAL:Sales Hoog}]+[=F{ACCOUNT CREDIT TOTAL:BTW Hoog})]
  [VERKOOP 6%:2,1, 1]
  {ACCOUNT TRANSACTION DETAILS:Sales Hoog}
  >Sales Laag||€ [=F(TN('{ACCOUNT CREDIT TOTAL:Sales Laag}'),'#,#0.00')]
  >BTW Laag||€ [=F(TN('{ACCOUNT CREDIT TOTAL:BTW Laag}'),'#,#0.00')]
  >TOTAAL||€ [=F({ACCOUNT CREDIT TOTAL:Sales Laag}]+[=F{ACCOUNT CREDIT TOTAL:BTW Laag})]`

Now main problem is this line:

>TOTAAL||€ [=F({ACCOUNT CREDIT TOTAL:Sales Laag}]+[=F{ACCOUNT CREDIT TOTAL:BTW Laag})]`

For some reason it is not calculating… :frowning:

2

Try this instead:

[=TN('{ACCOUNT CREDIT TOTAL:Sales Laag}')+TN('{ACCOUNT CREDIT TOTAL:BTW Laag}')]

OR

[=F('{ACCOUNT CREDIT TOTAL:Sales Laag}')+TN('{ACCOUNT CREDIT TOTAL:BTW Laag}')]

2 Likes
3 
>Totaal||€ [=F(TN('{ACCOUNT CREDIT TOTAL:Sales Laag}')+TN('{ACCOUNT CREDIT TOTAL:BTW Laag}'),'#,#0.00')]

Works perfect!

Is there a way to put a report number to the report? (Like the unique table ID?)
Its to make sure there is no missing report in the books.

5

Every workperiod has a unique ID, and i want it to be printed in the end workperiod report.
Is there a way to query it out of the DB?

1 Like
6

So use {WORKPERIOD ID}

blob.jpg852×488 116 KB

2 Likes
7

:scream: Shame on me! Ok, got it! must have missed it :stuck_out_tongue:

1 Like
8

LOL no I was just posting that so others that read this can see we have tag shortcuts documented for us right inside SambaPOS. Lots of people miss that feature.

2 Likes