Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Answered

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

Posted on by 235

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:
  • Roderick McCall Profile Picture
    Roderick McCall 110 on at
    RE: A/R Statement Balance Includes Payments Received After the Cutoff Date

    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

  • PattiK323 Profile Picture
    PattiK323 235 on at
    RE: A/R Statement Balance Includes Payments Received After the Cutoff Date

    Thank you for your help.  This explains the issue!

  • Verified answer
    Roderick McCall Profile Picture
    Roderick McCall 110 on at
    RE: A/R Statement Balance Includes Payments Received After the Cutoff Date

    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:

    pastedimage1654633097186v1.png

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

    pastedimage1654633139733v2.png

    Statement after running PTR:

    pastedimage1654633162339v3.png

    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

  • PattiK323 Profile Picture
    PattiK323 235 on at
    RE: A/R Statement Balance Includes Payments Received After the Cutoff Date

    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?

  • Verified answer
    Roderick McCall Profile Picture
    Roderick McCall 110 on at
    RE: A/R Statement Balance Includes Payments Received After the Cutoff Date

    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:

    pastedimage1654630898291v1.png

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

    pastedimage1654630956355v2.png

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans