Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

RM - Statements showing documents that have zero balance. Have already done paid transaction removal??

Posted on by 15

Hello,

We are wanting to print our customer statements, however some of our customer statements are showing documents that show a zero balance still after we have already processed paid transaction removal. How do I remove from customer statement documents that have zero balances? 175276.Capture.JPG

Categories:
  • RE: RM - Statements showing documents that have zero balance. Have already done paid transaction removal??

    If the debit memo is in OPEN, and the credit memo is not, and you want to apply them to each other, you need to use the "RM unapply transaction' tool in Professional Services Tools library to unapply the credit memo and move it back to open.   Once both are in open, you can re-apply them to each other again.     If further assistance is needed you may want to reach out to your Microsoft Partner, or open a support case with Microsoft Dynamics GP Support and we can help you further if needed.  

    Thank you, 

    Cheryl W

    Microsoft Dynamics GP support 

  • Casper123 Profile Picture
    Casper123 15 on at
    RE: RM - Statements showing documents that have zero balance. Have already done paid transaction removal??

    Hi Cheryl,

    The debit memo is only open payment and credits are not, how would I go about correcting this?

  • RE: RM - Statements showing documents that have zero balance. Have already done paid transaction removal??

    Since it is in open, you can go to Transactions | Sales | apply sales documents.  Select the debit memo.   Unmark the apply record to the credit memo. save.   exit the window and then come back in and apply it again to the credit memo again.  

    If that doesn't work, then run the Sales reconcile utility for this customer for 'outstanding document amounts', and then try the steps above again.

    Cheryl

    MS Support

  • Casper123 Profile Picture
    Casper123 15 on at
    RE: RM - Statements showing documents that have zero balance. Have already done paid transaction removal??

    34562.Capture.JPG

    By looking at these screens are you able to guide me into the next step, to fix this.......

    Debit-431 was paid with Credt-386

    Credt-386 was applied to IN0173 0 amount and Debit431 0 amount how can I correct this?

  • RE: RM - Statements showing documents that have zero balance. Have already done paid transaction removal??

    In Inquiry, verify the 'amount remaining' on it is 0.00 and you can drillback to see the apply record on it in the full amount.   If so, then try running PTR again and restrict to this customer. 

  • Casper123 Profile Picture
    Casper123 15 on at
    RE: RM - Statements showing documents that have zero balance. Have already done paid transaction removal??

    Hi Cheryl,

    Thank you for your feedback. It does show open, is there a reason it did not move to history when we processed paid transaction removal??

  • Suggested answer
    RE: RM - Statements showing documents that have zero balance. Have already done paid transaction removal??

    Thank you for the screenprint.   The RM statement only shows documents in OPEN status.  Can you double-check  this document in INQUIRY window to verify if it has OPEN or HIST next to it?  If it has been moved to history, it should not be included on the statement at all as the statement does not look at historical tables, so I think it may be fully applied and still in open.  Please verify.

    Thanks,

    Cheryl Waswick

    Microsoft Dynamics GP Support

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