Skip to Content
0
Former Member
Sep 21, 2014 at 11:40 PM

Link between actual ship date of an item and schedule line in Sales Order

1537 Views

So, we are developing a custom report that compares actual Ship Date (Goods Issue Document MKPF-BUDAT) and the date the item should've been shipped (Schedule Line Date).

I am able to link the GI Document to Delivery Document and can then link to Sales Order Number/Item Number. However, a line item can have multiple schedule lines. What logic can be put in the mapping so that the correct scheduling line is picked for the GI date to be compared against?

Example:

Sales Order 123

Item 10 Product X - Quantity 10

Schedule Line 1: 11/15/2014 8 pieces

Schedule Line 2: 12/15/2014 2 pieces

Let's say first shipment gets delayed 2 months and ships 1/15/2015

Due date in report should know to select 11/15/2014 to calculate that shipment was late 60 days

Any way to link delivery document to a specific schedule line??

Thanks!!