can anybody help me out to develop the report
The report should run according the customer hierarchy ie Payer, Sold-to and Ship-To where the payer is the highest level.
Example:
Payer: 18037
Sold to Party: 18013
Ship to Party: 10761, 10763, 10766 and 10769.
When the selection is unit: 18037 (Payer level)
First page of the report should then be the total of the payer (including all underlying figures of the sold-tos and ship-tos)
The second page will then be the sold-to
The third page will then be the various ship-tos belonging to the sold to
The following page will then be the next sold-to..etc
The result should be that on payer level the total amount appears of all underlying levels, on sold-to level all ship-tos that belong to the sold-to.
When the selection is unit: 18013 (Sold-to level)
The first page will then be the total amount of the sold-to (inclusing all underlying figures of the ship-tos)
The second page and further will then be the various ship-tos belonging to the sold to
When the selection is unit: 10761 (Ship-to)
In this case the existing report can be used.