Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Matthew Arp]

I have a AP Credit Memo, that is stuck in OPEN. The CM was fully applied to an Invoice (which was correctly moved to History), but the CURTRXAM was not properly reduced on the CM (the INV does show $0 due). The apply record exists as you’d expect, so it’s just that the system didn’t finish applying the CM. I have run reconcile and CheckLinks, all with no errors any suggestions on clearing up this errant transaction? I know that I can simply update the CURTRXAM on the CM to be $0, but that won’t move it to history.

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————

[Jo deRuiter]

?Good Afternoon

Occasionally GP does not complete the posting process.  In your case just make sure that the tables indicate in both Curtrxam for both the Credit Memo and the Invoice that the Credit Memo was fully applied.    And that in the apply tables the applied amount for both the apply to and apply from are correct. 

You can try running reconcile for purchasing and/or checklinks on Open and History transactions, but that usually won’t do the trick.   You may need to manually move the transaction into the history tables.

This is work that needs to be done very carefully and by someone familiar with this type of work, so please exhaust all other options before commencing a manual move.?  Please talk to your Partner first, as well.

——————————
Jo deRuiter
Senior Financial Systems Consultant
Wipfli
Eau Claire WI
770-906-4504
——————————
——————————————-

[Matthew Arp]

I was really hoping there was another solution. C‘est la vie…

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[Bert Green]

,

There is another way that you can try. It would be to void the credit memo and then set it up again and reapply to the Invoice. The only item on this is that it is all being done in the application.

I would see what happens in a test environment first though.?

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
GPUG All Star 2017
——————————
——————————————-

[Matthew Arp]

, I though about that, but the invoice the CM applied to did move to history. I’m honestly surprised PSTL or Power Tools doesn’t have something for this.

——————————
Matthew Arp
Business Systems Developer
Hunton Group
Houston TX
——————————
——————————————-

[Bert Green]

,

When you void the credit memo the invoice should be moved back to open and have the unapplied amount be equal to the credit memo (if it was fully applied to the invoice).?

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
GPUG All Star 2017
——————————
——————————————-