Question:
Sales dilemmma using Line Item Processing.
When a delivery (VL01) document is created in R/3, the Orders Schedule Line Item extract (2LIS_11_V_SCL) structure is updated as follows:
- reverses out the Open Order Qty and Open Order Dollars columns
- Populates the Delivery Qty and Dollars column.
When a billing (VF01) document is created in R/3, the only structures that get updated are the Header (2LIS_13_VDHDR and Line Item (2LIS_13_VDITM).
Is there a way to reverse out the Delivery Qty and Delivery Dollars on the the Orders Orders Schedule Line Item extract (2LIS_11_V_SCL) structure when processing Billing documents? The reason why we want to reverse out the Delivery Qty and Delivery Dollars is because our sales application reports "Open Orders" using both Open Order Qty/Dollars and Delivery Qty/Dollars columns.
Thanks.
JRZ
Answer:
I am having the same problem....did you (or has anyone in the forum) found a way to do this ?
MJF
Answer:
I have had problems with the way 2LIS_11_V_SCL handles deltas (reverse images for order changes, and change records for deliveries). I would recommend using the 2LIS_11_V_SSL extractor (in combination with orders items) to combine orders and deliveries.
Back to your question - would combining orders/deliveries/billing items in an ODS keyed by sales order document and item to provide the data you need?
Ken