1 Purchase Line to 3 Sales Lines Reserve by Shipment Date

David_CoxDavid_Cox Member Posts: 509
Dynamics NAV 2009, Cronus UK

I am working on a project which is automating SOP and POP in codeunits, driven by importing files, this needs to use reservations, to test the workflow I am processing manually.

The problem I have is that when part receiving a PO line that could have many Sales Lines the reservations are not applied by "Shipment Date" priority.

PO#1 Line 100 Units due in batches
First Batch of 20 Due 1st April

SO#1 raised 20th March future requirement, 20 Units promised from PO#1 Shipment Date 15th April
Reservation entry #1 against PO#1 (Sales line to Purchase Line)

SO#2 raised 23rd March urgent requirement, 20 Units promised from PO#1 and Shipment Date 4th April
Reservation entry #2 against PO#1 (Sales line to Purchase Line)

You would think that when the first Batch is received the allocation would be by "Shipment Date" to Reservation #2 and SO#2, when testing the reservation went against Reservation #1 and SO#1 ignoring the shipment date priority.

Anyone dealt have a fix?

Regards

David
Analyst Developer with over 17 years Navision, Contract Status - Busy
Mobile: +44(0)7854 842801
Email: david.cox@adeptris.com
Twitter: https://twitter.com/Adeptris
Website: http://www.adeptris.com
Sign In or Register to comment.