Hi , Here are few more answers : 9) How do we account for pipeline inventory once the good in received? Once the goods are received, the next data warehouse refresh should have that information from transactional system. The same information will then be fetched into IO. The next batch run of IO then takes care of the new information. 10) What if customer order or purchase order is cancelled?How is it to be processed? Same as #9 above. Once the transactions ( Cancellation of PO or CO) takes place, the transactional system is supposed to update its database, and the next datawarehouse refresh will bring the information ( changes) to IO datamart. The next IO batch run will then take care of it. Hope this helps ! Regards Shriram Upadhye SRDI, Pune, India ... View more