Dynamics Community Forum Thread Details

Error trying to correct a Purchase invoice using a Credit Memo

I m trying to correct an invoice by creating a corrective credit memo. I apply the credit memo to the invoice

Then I try to do preview posting and I get this error message

There is no Vendor Ledger Entry within the filter. Filters: Vendor No.: V000578, Document Type: Credit Memo, Document No.: ='***', Open: Yes

not sure why is that because the credit memo has a doc number and it looks fine

any idea why this is happening?

Thanks

Hello Ola Darwish,

It appears that you may be dealing with a reported scenario that was determined to be outside of the Corrective process design.

To confirm: Does the Vendor have a Payment Method assigned with a Balancing Account Type and Balancing Account No., such as a Bank or G/L Account, so the Payment was posted as the Invoice was posted and applied to the Invoice?

The following is the detailed scenario:

Using the CRONUS company go to Payment Methods and find the CASH payment method, and add the Bal Account No 10300.
Go to Vendors, create a New Vendor and assign the CASH Payment Method in the Payments Fast Tab.
Create and Post a new a Purchase Invoice for your new Vendor. The Vendor should remain at a 0.00 balance because they have a CASH payment method and when the Invoice is posted it is immediately paid off.
Go to the Vendor Card, click More Options if needed, then click Navigate > History > Ledger Entries.
Click on Payment and go to Actions > Functions > Unapply Entries and Unapply the Invoice and Payment in the Ledger.
Back in the Vendor Ledger Entries, click on the Invoice line and go to Actions > Show Posted Document.
On the Invoice click Correct > Cancel, you will get a message that "The posted purchase invoice will be canceled, and a purchase credit memo will be created and posted, which reverses the posted purchase invoice. Do you want to continue?, click YES.

Result:
You receive the following message: "Canceling the Invoice failed. There is no Vendor Ledger Entry within the filter.Filters: Vendor No.: ..."

Expected Result:
The posted purchase invoice will be canceled, and a purchase credit memo will be created and posted, which reverses the posted purchase invoice.

We then open the credit memo and to be able to post it we need to clear the Applies to Do. on the Electronice Invoice FastTab.
Once posted it is applying the refund to the credit memo and the original invoice and payment remain open.

To workaround this, the following process is recommended:
1. In the Vendor Ledger Entries, unapply the Refund and Credit Memo.
2. Apply Refund to the Payment.
3. Apply the Credit Memo to the Invoice.

Development deemed that the use of Bank Payment Method with balancing account would then preclude the corrective process from wroking because now an Invoice and Payment were posted as part of the same transaction.

I hope this helps explain the result and workaround process sufficiently.

Best Regards,

Tom

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS