Skip to Content
1
Former Member
Apr 11, 2008 at 07:38 PM

Incoming orders - functional question

19 Views

Dear experts,

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.

For eg.

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.

Best regards,

KK