Booking History is duplicated during collections
We noticed an issue during our sales history collection of booking data. In our Demantra worksheet for a specific item-location combination we have booking data of 480 units in Dec-10 and 480 units in Jan-11. When we look at the source Sales Order Line data, there is only one SO line for this combination and the request date is 04-Jan-2011. There is no SO line data for this combination in Dec-2010.
We suspect that the following sequence occurred:
1) Original request date for the SO line was in Dec-2010 when the order was booked
2) Booking History was collected and record was created in Demantra for this combination with qty of 480 in Dec-2010 period