A/R Statement Balance Includes Payments Received After the Cutoff Date

(0) Share

Report

Posted on by PattiK323

281

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.

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Roderick McCall 110 on at

Like (1)

Report

Hi PattiK323,

One thing you will want to consider is if Paid Transaction Removal (MDGP > Tools > Routines > Sales > Paid Transaction Removal) was run on the customer id, since the invoice was fully applied

I created new customer id and posted invoice for 1,000 and 2000 with date of 3/14 and posted cash receipt with date of 4/12 and ran report for 4/12 for print date and cutoff date.

Before running PTR:

After running PTR after fully applying payment to invoice for 1,000

Use the Paid Sales Transaction Removal window to remove paid transactions. Paid transaction removal consolidates all balance forward transaction amounts and adds the total to the noncurrent period amount. If you’re keeping history, transactions are transferred to history; otherwise they’re deleted.

Once PTR is run there is no way to reverse this. If you are maintaining history on the customer, you can check the RM00401 table for document status. Document status of 3 means 'HISTORY'. You can also check the RM30101 table as well.

Hope the above is helpful.

Kind Regards,

Roderick

Was this reply helpful? Yes No
PattiK323 281 on at

Like (0)

Report

Thank you. I did run paid transaction removal; but, with a cutoff date of 5/31/22. Shouldn't that ignore any transactions after that date?

Was this reply helpful? Yes No
Verified answer

Roderick McCall 110 on at

Like (1)

Report

Hi PattiK323,

Even with a cutoff date of 5/31 in PTR window, if the invoice was fully applied, this will move it to HISTORY, and I would not expect the invoice to show on statement.

I entered another invoice for 1,0000. Created cash receipt with transaction date in June and applied to invoice for 1,0000.

Print the statement with print date and cutoff date of 4/12:

Ran PTR with cutoff date of 4/12, and report shows the following:

Statement after running PTR:

The cutoff date i used will still move the invoice because the transaction date on the invoice was 3/14.

When entering a cutoff date for transactions to be removed, transactions with a transaction date on or before the cutoff date you enter will be removed. This leads me to believe the transaction date of the invoice not showing on statement was on or before 5/31 cutoff date in PTR window.

Kind Regards,

Roderick

Was this reply helpful? Yes No
PattiK323 281 on at

Like (0)

Report

Thank you for your help. This explains the issue!

Was this reply helpful? Yes No
Roderick McCall 110 on at

Like (0)

Report

Hi PattiK323,

You are most welcome, and I am glad the information provided was helpful and explained the behavior you were encountering.

Kind Regards,

Roderick

Was this reply helpful? Yes No