I am trying to report on the orders. I am currently using the datasource 2lis_11_vaitm and the netvalue of the item.
However, in a scenario where the Item quantity or value is changed the report reports on the item creation date.
If Order is created in Jan with Net value $500
If an item is added in Feb for the same order in Feb of $200
If the netvalue of the item is changed to $300 in march
All the result would show up in the item or order creation date. But I would expect $500 for the same order in Jan and $200 in Feb and $ 300 in March.
Is there a way we can create such a report. Basically this is to report on the same period where the order actually has come but not the actual order was created.
I believe this is very common problem lot of companies have. I would like to know how this is worked.
Any thoughts or datasources which provide this info. Please let me know.