I'm running A/R statements with a Print Date and Cutoff Date of 5/31/22.
However, the statements are not including balances that were outstanding as of 5/31/22 but were paid between 6/1 and 6/6/22 (today).
For example,
Customer ABC, had 2 invoices outstanding on 5/31/22: Invoice 1 for $1,000 and invoice 2 for $2,000. $3,000 total outstanding.
Invoice 1 was paid on 6/6/22, prior to statements being ran.
Statement (with a print date and cutoff date of 5/31/22) only shows invoice 2 for $2,000 outstanding.
How do I get the statements to correctly show all amounts outstanding as of the cutoff date of 5/31/22?
Thank you.