Stuck Outstanding Vendor Invoice - Business Central

(0) Share

Report

Posted on by Community Member

Hello!

One of my clients accidentally deleted a posted purchase order invoice and now it is stuck in the outstanding vendor invoice/AP aging reports. A credit memo was issued for the vendor which washed out the cost on the books but that invoice entry can't be removed because it wasn't posted from a journal. Any idea's on how to delete the record? Not sure if I can write a SQL delete statement or access the setup table from the front end?

Any assistance would be greatly appreciated!

I have the same question (0)

All responses (11)

Answers (1)

Bilal Haider 414 on at

Like (0)

Report

Hi, I have not understood what is meant by it was'nt posted from a journal. And please add some detail if you can.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Brendand,

Happy New Year. When a User is on the Posted Purchase Invoice list and clicks Delete on the Action bar, if the Purchase & Payables setup has the field Allow Document Deletion Before filled in, with a valid date, the User can delete the Document. It will NOT delete the actual transaction posting to the GL and Vendor Ledgers. Your correction of a Credit Memo was right on, to resolve the Vendor Balance and Aging. As an Accountant, I would leave this alone since I would want to see the audit trail. I am sure you Applied the Credit Memo to the Invoice to zero out the remaining balance.

I think you are fine. Below is the setup field in case you want to blank this out from happening again.

Thanks,

Steve

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Steve,

Happy New Year as well! Thank you for the response. We did in fact apply the credit memo; however, it did not remove the open amount in overdue vendor invoices/overdue purchase invoice amount. The GL is balanced out correctly but this still displays in the customers environment. It will show on AP aging report, but at a zero dollar cost.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Hi Bilal,

Thank you for the response. The entries made by the posting of the invoice cannot be deleted as the system would only ever allow me to reverse/remove transactions from an entry made through a journal (by a user). I added some more detail in my response to Steven.

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (0)

Report

Interesting scenario. If Credit Memo has been applied to Invoice then there should be no vendor outstanding invoice entry. Try to find that credit memo entry from vendor ledger and see if it is closed or not. And if closed then with which entry it is closed. And if it is not closed then you can close it with the wrong Invoice entry using application.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Brendand,

Do me a favor and run the AP Aging, for the Vendor Ebay, in Detail. Also, go to the Vendor Card and open History/Ledger Entries and take a screen shot of the Invoice and Credit Memo record.

If you applied the CM to the Invoice, nothing should appear. Your images of the $10 activity tile is what you are referring too. If yes, pplease also click the tile and send the screenshot.

I have my test case and can review my example to yours.

Thanks,

Steve

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Steve,

Thanks for the response. See attached zip file will screenshots and detailed entry export. Appreciate the help!

.AP-Vendor-Issue-_2D00_-Business-Central.zip

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

Brendand,

Got it. In the Vendor Ledger Entries each document reflects a Remaining Amount. This is the culprit.

Follow these steps:

1. In the Vendor Ledger Entries highlight the Credit Memo document and on the Action bar click Process/Apply Entries. You will see something like this:

2. You will see the Invoice record and highlight the line, click Process/Set Applies-to ID. Then Process/Post Application.

Now check the Activities Tile and Aging. You should be good.

Thanks,

Steve

Was this reply helpful? Yes No
Suggested answer

Bilal Haider 414 on at

Like (0)

Report

So our guess was right that entries are not applied. I have given solution briefly but Steven has given properly it step by step. Follow it and your issue will be solved.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Steve,

Thank you for the assistance. It looks like the issue is resolved. Happy New Year!

Was this reply helpful? Yes No