Share
ReportI'm using the MC Blank Form to print my customers Statement. Each month end after running the Aging Process, i'm setting the statement criteria as follows. (Using End Jan as example)
Date to Print : 31-Jan-14
Summarize To : 31-Dec-13
Cut-Off Date : 31-Jan-14
When checking on the printout, i noticed that the amount in the Aging Buckets are incorrect. I'll explain the scenario using the example below.
Last month BBF : 150,000
This Month Sales : 50,000
This Month Collections : 80,000
This Month Credit Doc : 1,000
Ideally, i should see the Aging Amount as below.
Current : 49,000 | 31-60 Days : 70,000
However, i'm getting the aging amount below instead, which is definitely wrong.
Current : -31,000 | 31-60 Days : 150,000
I tried tweaking around the report options, by checking the "Reduce Oldest Aging Period Amounts by Unapplied Credit Amouts" i manage to get the closest result, though still not 100% correct.
Current : 50,000 | 31-60 Days : 69,000
2 Important notes:-
1. The statement body is always showing correct document amount and information, and the subtotal is always correct, regardless of the print options.
2. When i don't set any date in "Summarize to" field, then the Aging Amount are all correct.
Hence, the key question now is, how to get the correct Aging Amount in the statement, with the criteria of Summarize to Last month end date, and NO aging on Unapplied Credit Documents?
*This post is locked for comments
All responses (
Answers (
9,142
