All Items which delivered late

Question: Hi all...
I have created a KF in the Delivery Item ODS which will mark any items with the Actual GI Date > GI Date. My problem occurs when I am trying to flag an item that does not have an actual goods issued date and the GI Date is < todays date.

For Example the order was entered on 07/20/04 with a GI Date of 08/02/04. Up until the 2nd I don't want this item to be considered late. Is there a way to put this on the same report (any functions/formulas in BEX) as my KF from above? When I try to add a variable in BEX where I pull everything where Actual GI Date is # then I lose my KF items from above where the Actual GI Date > GI Date.

Any help would be much appreciated.

Thanks,
Jon

Answer:
Jon,

Build that logic using update rules in the key figure - delivered late flag.

Answer:
Unfortunately it looks as if I only get a delivery item record in the ODS when an item is scheduled for shipment and then an update of that record when the order is actually shipped. We are still in the early stages of implementating SAP so I could be wrong about only getting delivery records at that time, am I?

Jon
Copyright ?2007 - 2008 www.jt77.com