Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Purchasing Document Sh...
Finance | Project Operations, Human Resources, ...
Suggested answer

Purchasing Document Shows Open, but has $0 in unapplied

(1) ShareShare
ReportReport
Posted on by BP-23052126-0 6
We have 2 purchase invoices still showing /OPEN/ and the corresponding payment /Open/ on the vendor account. I am unable to void the historical or void open transactions as they are applied or on hold. I have tried reconciling the vendor account and returns no errors, I have tried links issue as well. 
 
Thank you.
Categories:
Microsoft Dynamics GP
  • BJ-09051414-0 Profile Picture
    BJ-09051414-0 248 on at
    Purchasing Document Shows Open, but has $0 in unapplied
    Hello,
     
    I can provide you an example. You need to review the data and verify if there are apply records if there are, the apply records are valid and the document applied is valid. You don't just want to go and start making changes in SQL without knowing that these need to be made.
     
    To update the current amount, example steps are below. You will need to tailor them to your record you want to update.
     
    1. Log into SQL Server Management Studio.
      1. If you are user, you likely do not have access to this and will need your IT's assistance.
    2. Open a new query against the company database that has the Invoice that you want to update the current amount.
    3. Run a select statement on the PM20000 to get the Dex_row_ID that you will use as a restriction for the update statement.
      1. Select * from PM20000 where Docnumbr = 'Enter Document Number Here'
      2. Run this and then review the results to locate the Document in question.
      3. Scroll all the way to right and not the Dex_row_Id.
    4. Once noted, create an update statement to update that column.
      1. Example script.
        1. Update PM20000 set CURTRXAMT = 'Value you want to update to' where Dex_row_Id = 'Enter the Dex_row_Id from the select statement'.
        2. Execute the update statement to update the amounts.
    5. Again, this assumes you have verified the data beforehand and understand what you are doing in the backend.
      1. If you do not, I Highly suggest reaching out to your partner. If you make a mistake like not using a restriction, it can cause further issues.
      2. If you do not have a Partner, please feel free to reach out to Enavate, to create a ticket and we would be happy to review the data and get your issue corrected.
    The above is provided AS-IS. 
     
    I hope this helps!
     
    Thank you!
     
  • BP-23052126-0 Profile Picture
    BP-23052126-0 6 on at
    Purchasing Document Shows Open, but has $0 in unapplied
    Are you able to tell me how to "update the PM20000 record"
  • Suggested answer
    BJ-09051414-0 Profile Picture
    BJ-09051414-0 248 on at
    Purchasing Document Shows Open, but has $0 in unapplied
    Hello,
     
    If there are no applies, then you will need to update the PM20000 record so the Current Amount column is the same as the Document Amount in SQL. This assumes there is no data damage.
     
    Thank you!
  • BP-23052126-0 Profile Picture
    BP-23052126-0 6 on at
    Purchasing Document Shows Open, but has $0 in unapplied
    There are no items applied to the 2 invoices when I click the applied documents.  I am not able to void or un-apply any credits. I think there was an error when the manual payment was being applied and it didn't post to these 2 invoices but did post on 2 other invoices. 
     
     
  • BJ-09051414-0 Profile Picture
    BJ-09051414-0 248 on at
    Purchasing Document Shows Open, but has $0 in unapplied
    Hello,
     
    The Current Amount gets reduced when a Credit Document is applied to it. With the Current Amount being zero, this points to something being applied. The applied document could be damaged and only have remnant records.
     
    What we would do to correct this:
     
    1. First, you need to review the Invoice in SQL and determine if there are any applied records linked to the Invoice.
    2. Once determined, if there are apply records, then the Document for the Apply Records needs to be reviewed in SQL to verify the transaction.
    3. Depending on what is found, would determine how to correct this.
      1. If no Credit document is applied to the Invoice, then you would need to update the Current Amount in the PM20000 for the Invoice. This should then allow you to either Void or Apply a Credit Document to it.
      2. If there is a Credit Document Applied and it is not damaged, then you can go and unapply the Credit Document using the Apply Payables Document window. This should set the current amount back to the document amount so you can void it.
      3. If there is a damaged document applied, then you will need to remove the bad data and update the current amount so you can void or apply a valid document.
    If you are not able to review the data in SQL and make a determination on how to correct this, I would suggest reaching out to your partner for assistance in cleaning this up.
     
    If you do not have a partner, you could reach out to Microsoft or find a partner that can assist with this.
     
    Thank you!
     
    Brandon,
    Enavate Functional Consultant.
     

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans