Invoice Consolidation Maintenance

From CTMS

You can define consolidation customers through the Consolidation button provided in the Customers screen.

Cust consol.png

You can define the customers to whom the selected customer can consolidate, or choose all customers.

You can also define consolidation at the group level, to consolidate all customers within a group.

You can define the DU types and categories to be consolidate, and enter the reset quantity by DU Category.


The example below illustrates this feature.

Let the charges to transporting a given number of pallets from a location to another is as per given below:

No of Pallets Charge
1 100
2 90.00
3 80.00
4 70.00
5 60.00
6 50.00
7 40.00
8 30.00
9 20.00
10 10.00

Assume that a customer, say KRAFT has 3 orders that need to be transported to Tesco Warrington in the same day. If the orders are to transport individually, then the charge for the each of the orders based on the number of pallets to be transported in given in the Charge column of the table below (charge derived from the table above). If the 'Consolidate Orders' flag is checked, then the orders will be consolidated and the customer charged for 9 pallets at 20.00.

Order No Pallets Charge Total
1 4 70 280
2 3 80 240
3 2 90 180
Total 9 - 700
Total by Consolidation 9 20 180