This Charge Table holds up to three charge basis definitions for each Charge service.

To setup a Charge Table the following parameters must already be established:

Charge basis (TMSPS/CBSE0 – TMSPS/CBSE9)
Charge accumulation method (TMSPS/CAMD)
Calculation method (TMSPS/CALM) System defined.
Charge/Cost Tables must have been associated with a Client and their product hierarchy via Publisher Client Maintenance (PSM010).
Transaction Groups must have been established if Service type charging is applicable via Transaction Group Maintenance (PSM020).

In the example below we have established the matrix which determines what charges to apply depending on the value of the invoices and number of picks plus a set or constant additional fee.

Charges are calculated based on the number of times a location is visited to pick the Publisher Clients products in a month. A set rate per visit, 20c in this example, is established for this charge basis. In addition a Client will be charged 15% of the net value of their invoices for that month.

How much to charge can then be broken down by quantity breaks. So for example if the number of picks is greater than a selected quantity the charge rate can reduce. The same applies to the value of the invoices, the higher the value, the less the charge based on up to 5 quantity or value breaks. In this example if the net invoice value is greater than $10,000 the charge reduces from 15% to 10%.

A constant value can also be included in the charges, a constant being a set additional charge, for example administrative fees or IT services. In this example a constant charge of $500 per month will be added.

More examples of services or transactions attracting charges are:

Invoice-only transactions where no inventory handling is required
Remainder transactions where no picking or packing is required
Returns processing which includes putaway
Returns processing which results in remainders or pulping. A minimum order surcharge may be applicable.

Warehouse services that may be charged could include:

Deliveries local or overseas
Bulk stickering
Price stickering at pick face
Rubber banding
Shrink wrapping
Making up packs
Storage charges – fee structures for forward locations and excess locations

Example:

Charge Table	GEN
Transaction Group Code	Invoice
Service Provided	Customer Service
Minimum charge	$1500.00
Charge Accumulative Method	A (A=Addition, H=Highest, L=Lowest)
	Charge Value Break
Charge Basis	Cal mtd	1	2	3	4	5
Invoice net value	%	15.00	10.00
			10000
Number of picks	V	.20

Constant	C	500

Formula:

Minimum charge value = <, >.

Charge accumulative method = Add, Highest, Lowest.

Charge basis 1 x Cal Mtd + Charge Basis 2 x Cal mtd + Charge basis 3.

Example:

For a monthly net invoice total of $20,000.00 (according to the Distribution Transaction files at the time of running the extraction process) the above table would charge $20000 x 15% + 110 (number of picking slips) x .20 + $500 = $3522.00. Minimum charge does not apply here.

Answer:

$20000 x 15% + 110 x .20 + $500 = $3522

Freight Proportioned for 3^rd Party Distribution

The weight is used as the factor to proportion the total consignment weight across the invoice lines in the consignment.

Example:

Consignment Weight 6.0kg

Product Weight 5.8kg 96.67%

Packaging Weight .2kg 3.33%

Consignment Cost $ .28

Product Cost $ 8.22

5 invoice lines in the consignment

Product Calculations – $8.22

Invoice Line	3P Member	Product Weight	% Proportion	$ Consignment Packaging Value – $0.28	$ Consignment Product Value $8.22	$ Consignment Total Value $8.50
Line 1	A	2.5	43.10	.13	3.54	3.67
Line 2	B	0.5	8.62	.02	.71	.73
Line 3	C	1.3	22.41	.06	1.84	1.90
Line 4	A	1.0	17.24	.05	1.42	1.47
Line 5	B	0.5	8.62	.02	.71	.73
		5.8	99.99	.28	8.22	8.50

Add a charge matrix

In the menu, expand Publishing Modules > 3rd Party Logistics > Maintenance and double-click 3PL Charge Maintenance. PSM030 Publisher Client Charge Maintenance panel appears.
Click Add. PSM030 Publisher Client Charge Maintenance panel appears in add mode.

Field	Description
Charge table	Select the Charge Table (TMSPS/CCTBL) for which charges/costs are being established.
Service	Select the Service Charge (TMSPS/CSRV) for which Charges/costs are being established.
Transaction group	Select the Transaction Group for which charges/costs are being established. Charges will be based on the quantities or values of these transaction groups.
Accumulation method	Select the Accumulation Method to be applied to the Charge Bases. A=Addition will add the three charge/calculation methods together. H=Highest chooses the highest value of the three charge/calculation methods. L=Lowest chooses the lowest value of the three charge/calculation methods.
Minimum charge	If a minimum charge is to apply for the selected charge table, service and transaction group, a value must be entered here. If the value for the transactions generated falls below the minimum, the minimum value is used.
Break type	Break type for the charge basis as set up in TMSPS/BRKTYP.
Charge basis	Each service type has a set of system defined variables called a Charge Basis. The Charge Basis is dependent on the Charge Table/Charge service chosen. Use the search function to select it from the setup in control files TMSPS/CBSE0 to TMSPS/CBSE9.
Cal mtd	These system defined calculation methods for charging: C=Constant, %=Percentage, V=Value and Z= Nil Charge.
Charge value breaks 1-5	Charge value breaks can be setup up to apply charges based on a value or quantity increase. When C=Constant is used there can be no quantity breaks in the definition.

Enter the required fields and click OK. Charge matrix gets added.