Skip to Content
author's profile photo Former Member
Former Member

Incoming orders - functional question

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 12, 2008 at 07:55 AM

    Hi,

    I am using the DataSources of 2LIS_11_* too...

    For reporting I don't use the item creation date (ERDAT). Instead of that I use the field VDATU which is used for statistical update.

    So, I guess that VDATU has either a date of an item creation or a date of statistics updating. In case of order posting it is going to be a current date.

    Regards

    Andreas

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      sorry I understand you not correctly...

      This is an other business logic as we use. We use the Delta mode for updating our reported incomming orders.

      For statistical date in our reports we use the VDATU field.

      I suppose in your case if you want to report changes you have to implement your own solution. You can use VDATU to do it.

      If the order is created VDATU is the creation date. After that it includes the date of statistics updating. This logic is also necessary for you.

      Now you can build your DSO depending on your reporting logic. I think in your case a solution could be to use time dependent key field in your DSO.

      An other solution could be to implement a start routine in transformation for your business logic. This routine have to look in your DSO and set your key figures.

      Regards

      Andreas

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.