Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Discount taken not applied properly in RM and cannot clear off aging report...PLEASE HELP!

Posted on by 20

We have a situation as follows and all transactions are posted and are in HIST:

(as seen in Receivables Transaction Inquiry Zoom - Apply screen)

Invoice #1   amount $714

Applied against it was:

a credit memo CR ($16)

a customer payment  PMT ($698)

and also a discount was taken (in error) against this invoice for same PMT (16)

Therefore, there should be a credit balance of (16) on this document, but it shows $0.

Also as seen in the Receivables Transaction Inquiry Zoom - main screen it shows:

Payment amount $0

Discount taken $16

On account $698

---------------------------------

On the HATB detail report (AR Aging report) it shows the following line item amounts remaining:

Invoice #1 $698 

CR ($16)

PMT ($698)

the report shows the PMT line item for when the discount was taken but it is blank, i.e. $0

Total ($16)

My question is how do we clear this balance off the HATB if the discount taken is already applied and the document itself is zero?

We have already tried running Check Links and Reconcile Sales Documents with no luck.

Any assistance you could provide would be greatly appreciated.

Thanks!

Carrie

 

 

 

 

*This post is locked for comments

  • Andy Sather Profile Picture
    Andy Sather on at
    Re: Discount taken not applied properly in RM and cannot clear off aging report...PLEASE HELP!

    Hello Carrie - I would recommend opening a Support Case to troubleshoot this.  We will need to look at the tables in SQL to determine the cause.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans