Hi,
I have a scenario as follows:-
I want to aggregate the values of Product based on the First Sales Document.
For a Specific Job Number, there are many Sales Quotes, For example:
Job number----
Sales Quote
12345----
001, 002, 003 and so on.
and each Sales Quote is Consists of Some Materials with their quantity.
In the report i have to consider only the First Sales Quote No that is 001 for each Job Number and its products.
I achieved this by creating a Replacement path variable.
But When i am trying to generate the report based on Product it is aggregating the products from all the Sales Quotes.
How can i restrict the Product aggregation based on the First Sales Quote No.
I always appreciate your thoughts and inputs.
Regards
Shaan
Edited by: chintada shankar on Sep 22, 2008 5:38 PM