Custom Report Advice

1

Hi guys,

I’m trying to generate a custom report to show all the pending payments & receipts within the business for the coming period, I succeeded in generating the report with one problem, the pending payments I have are added to the report twice, one in (+) and once in (-), while those pending payments should only be in (-) and deduct from the total amount at the end of the report, the pending receipts on the other hand are showing correctly as (+) only, check below screenshots for the generated report and its settings, can someone advice what am I doing wrong here?

Screenshot-2021-03-10-221418GB
Screenshot-2021-03-10-221418GB861×1135 201 KB

Screenshot 2021-03-10 221442
Screenshot 2021-03-10 2214421073×1137 123 KB

2

I think that you should add “isAccountsPayable” is not checked under where

1 Like
3

I tried, the total number down is different now but many payments are still added in (+) and (-)

4

I always suggest in plann8ng a custom report to show the accounts as a column while setting it up to understand where Manager writes those numbers. You can always exclude it later.

1 Like