Small and medium business | Business Central, N...

Create Sales Invoice for Sales Shipment using Get Shipment Lines fails - Sales Order deleted!!

(0) Share

Report

Posted on by batteryacid

One of my clients have several Posted Sales Shipments that has never been invoiced, but, they have managed to delete the Sales Orders, therefore, when trying to use the "Get Shipment Lines" functionality, the system cannot find the Sales Order lines and it will not populate the Sales Invoice Lines.

One cannot simply create an invoice, since that will need to create Item Ledger Entries for the Inventory, and the Inventory is already depleted by the Posted Sales Shipment

Anyone have some advice? Has anyone else ever had to resolve this?

All responses (5)

Answers (0)

Suggested answer

Suresh Kulla 47,789 on at

Like (0)

Report

RE: Create Sales Invoice for Sales Shipment using Get Shipment Lines fails - Sales Order deleted!!

I don't think there is an option for you without customization you need to customize the get shipment lines process to look at the posted sales shipment and create the invoice.
Suggested answer

Community Member on at

Like (0)

Report

RE: Create Sales Invoice for Sales Shipment using Get Shipment Lines fails - Sales Order deleted!!

Hello,

You should first figure out how the customer deleted the Sales Order without performing Post-Invoice. This is troubling. In either case, you have NO Sales Order to post an invoice from. I would do the following:

1. Create a new Sales Order with the same Items, Quantity, and dates

2. Post Ship on the day it was Shipped and Post the Invoice

3. For the original Post Shipment, I would do an Item Journal adding the Inventory back noting it was a SO Error.

Hope this helps.

Thanks,

Steve
batteryacid 30 on at

Like (0)

Report

RE: Create Sales Invoice for Sales Shipment using Get Shipment Lines fails - Sales Order deleted!!

Combine Shipments also didn't work, as it uses the same function- Get Shipments Lines - as you had mentioned
batteryacid 30 on at

Like (0)

Report

RE: Create Sales Invoice for Sales Shipment using Get Shipment Lines fails - Sales Order deleted!!

I cannot restore the Archived Sales Order, it is partially shipped/posted.

You cannot simply create a new Sales Order, as nothing has been shipped on it. I need something that has already been shipped and not invoiced. I will try the combine shipments
JAngle 89 on at

Like (0)

Report

RE: Create Sales Invoice for Sales Shipment using Get Shipment Lines fails - Sales Order deleted!!

If the sales order needs to exist why not add it back? It will be a filter check it fails on for the error most likely. You can delete it again once the invoice is dealt with. Just a case of juggling the number series so you can add a manual number. You can use copy document if the sales order is big - maybe from the archived copy if you have that turned on.

Failing that try using the combine shipment report. I think it uses the same “get shipment lines” function, but just in case it doesn’t. I think the customer needs to have the “combine shipments” Boolean field set as true before you run the batch job