Unable to perform return of goods for a Received Purchase order.

(0) Share

Report

Posted on by Mav

Hi folks,

Quick question should we be able to return of goods for a line in a PO which was received but never invoiced.

If yes then please suggest a fix for me , because when i try to do ROG (return of goods) for a line item i get the error message ""A pending vendor invoice exists for this product receipt and must be removed."//

Further debugging & investigation reveals that error is coming from below code and

Class PurchFormLetter_packing slip

void clicked()
{
InventQualityOrderTable inventQualityOrderTable = vendPackingSlipJour.openQualityOrder();
VendPackingSlipJour localVendPackingSlipJour = vendPackingSlipJour.data();

if (localVendPackingSlipJour.existsPendingVendorInvoice())
{
throw error("@SYP4986046"); // "A pending vendor invoice exists for this product receipt and must be removed."//
}

I have the same question (0)

All responses (17)

Answers (1)

Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

Hello Mav,

No need to fix this through coding as you can fix this issue from the front end.

First; check in that PO. There must be an invoice is created and not posted. You can see this as Pending invoices in that PO.

You can further check this in Accounts payable > Invoices > Pending vendor invoices. Find the invoice which is created in that PO where you are getting this error and simply delete this record from this form.

Once this is deleted; the same pending invoice record will be removed from that PO too.

After that, go to the "Product receipt" journal; select the posted line and click on Cancel to cancel the product receipt.

Kindly check and update.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

My pending invoice button is disabled, i m the sys admin. Any other solution ?

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

Hello Mav,

Could be related to data sync issue!

Can you deploy the db in test environment and check if a synchronization helps you fixing this case?

Is there any customization made in PO form?

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

Good Morning Mav,

Have you tried posting a $0 invoice?

If you never received an invoice for a couple of years then you will probably not receive it in the future.

Why is it that you want to return the goods?

If your supplier basically gave them to you for 'free'; that is, without an invoice send, why would you return it?

That's not your company's fault.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

Hello Mav,

Kindly check the suggestions made and provide us an update on this thread. Is this sorted out?

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

I can see the invoice now but nothing happens when i click delete , it does not get deleted , screen just refreshed & i can still see that invoice. Tried editing the invoice to add lines as it has no lines, but could not add lines in edit mode.

How do i delete this invoice ?

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

Hello Mav,

Have you synchronized the database as requested before?

Can you please do this and check after that it is working fine or not.

In addition; please check if removing the cache from the user IDs (or resetting the usage data in D365) is helping you to get this issue fixed!

Kindly check and update us.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

I have tried that cache clearing and dB synchronization but unfortunately it does not help.

Was this reply helpful? Yes No
Suggested answer

SouravDam 11,730 on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

Hello Mav,

'Something' is stuck somewhere in system for sure!

Please check with the developer to set the debugger if they can find anything.

Else, please create a support ticket to MS to move ahead on this case.

Best regards,
Sourav Dam

Kindly mark this thread 'Yes' if this is answered your query which may help other community members in this forum.

Was this reply helpful? Yes No
Mav on at

Like (0)

Report

RE: Unable to perform return of goods for a Received Purchase order.

I am the developer & shared the debugging report in 1st post.

I can see that an invoice was created without line items & has the status of executed , perhaps this is why I cannot delete it.

What i am trying to understand now is how can i prevent such things at user level with no customization as i think users will always run into this issue of creating invoice in error without line items, forgeting about it & it is not pragmatic to go into Prod & delete the record from backend. There has to be some way using which , users could be restricted to do such things.

Was this reply helpful? Yes No