Skip to Content
0
Former Member
May 18, 2005 at 05:45 AM

can anybody help me out to develop the report

18 Views

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-to’s and ship-to’s)

The second page will then be the sold-to

The third page will then be the various ship-to’s 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-to’s 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-to’s)

The second page and further will then be the various ship-to’s belonging to the sold to

When the selection is unit: 10761 (Ship-to)

In this case the existing report can be used.