Total amount in custom report

1

Hi guys,

I’m trying to generate the following custom report:

Final Report
Final Report788×782 104 KB

Using these settings:

Report Settings
Report Settings753×852 65.8 KB

The problem is, with the invoice circled in red, this amount has been reduced by 0.44 (rounding difference), yet the report still shows it before reduction, i tried to look for a better criteria than “Credit” but couldn’t find, any suggestions?

2

Please show the edit screen of the invoice of concern

3

Edit screen is very large, i tried to cut the important part:

Invoice Edit
Invoice Edit1728×900 160 KB

And here is the final invoice:

Final Invoice
Final Invoice1072×695 192 KB

4

Since you showed only credits you missed the debits of the rounding (since is a reduction). The way you are filtering the sales (showing only credit column) invoices is not optimal, ie is prone to many possible errors.

You better start from filtering the transaction correctly:
image

and than replace the Credit with Amount

1 Like
5

It worked, the only problem is that the sales invoices value now showing in minus (the correct values though)! any idea how to reverse it to be in the +?

Thanks

6

Use Amount x-1. There are several variables where the mathematical conventions of the program produce oppositely signed numbers from what standard reports usually show. So in most cases, there is an option for ZZZZZ x-1.

1 Like