3rd Party Logistics

Introduction

3PL processing allows you to generate 3rd Party charges based on activities performed for clients as well as reimbursing clients for any sales. The principal charging mechanism depends on the type of service offered and the type of work needed to perform these services. The following types of services are catered for:

Transactional charges – charges by order details, picking for dispatch and freight costs etc.

Locational based charges – storage and movement of stock in warehouse

AP charge back – external charges that are set up for immediate invoicing e.g. printing cost

Royalty charges – charges for royalty contracts against the 3PL client.

Stock by year charge – this charge is based on how many years of stock is in the warehouse.

Miscellaneous charges – any additional miscellaneous charges e.g. advertising.

Charges can be calculated as a percentage of each service and/or as a fixed value for a particular activity. For example, you may need to charge differently for small single orders. Returns and credits will require different methods of charging. Carrier Freight costs on transactions can be charged using a transaction based Charge Basis. A database is established to identify which products belong to a specific client.

Process flow

  1. Setup all the control files as listed in the business rules below.
  2. Establish a Charge/Cost file definition for each 3rd Party using 3rd Party Maintenance.
  3. Establish the definitions for all the relevant Transaction groups using Transaction Group Maintenance.
  4. Establish the Cost Definitions for each Cost Table, indicating the Service Groups and Transaction Groups applicable. Costs can be accumulated by adding (A) the results of various Charge Bases calculations or taking the highest (H) value of these calculations or the lowest (L) value. Per client, costs and the comparative charges can be view on the Client Charge Management option.
  5. Establish the Charge Definitions for each Charge Table, Service Group and Transaction Group. Charges can be accumulated in the same way as Costs. A minimum charge can be set. The Charge Basis is calculated against transactions locations and freight charges.
  6. Enter/maintain the GL Expense account for any external AP charges (GLE355).
  7. Enter any applicable miscellaneous charges (PSM060)
  8. Run all the extractions for the 3PL charges/costs for the period using the 3rd Party Logistics Period End Menu options:
    1. Transaction Extract which includes freight.
    2. Location Summary
    3. Location Extract
    4. Yearly Stock Extract
    5. Royalty Extract
    6. Miscellaneous Extract
  9. Generate the Charge/Cost update
  10. Review the generated Charge/Cost using the 3PL Charge Management menu option:
    1. Select the Company/Period, defaults to the user company and current period.
    2. Select 2=Details, to review the details for generated charges against the charge type.
    3. Select 1=Details, against each line to view the original transaction.
    4. In the case of the location summary, the view is at the lowest level of stock storage.
  11. If the results are not as expected, go back to steps 2, 3, 4 and 5 and make the necessary changes in the definition.
    1. Re-run the steps in 8 and check the maintenance file in step 8.
    2. Steps 2-8 can be re-run as many times as required to achieve the desired results.
  12. Generate invoices.
    1. Generate invoices for all clients, leaving the selection fields blank. Or choose the table and client range within a given period.
    2. Alternatively the invoice can be generated from the 3rd Party Charge Management Menu option. Selection is against each Charge table for the specific client.

Setup

Business rules

The following business rules have to be setup to handle 3rd Party Logistics. Business rules for 3rd Party Logistics must be setup with support from Iptor IP1 consultants. It is critical to understand the setting of control files and how it works. Control files must be setup correctly for the system to operate as intended. Any changes to the control files setup should be addressed cautiously and in consultation with Iptor IP1 consultants.

Note This document does not cover customised setup tasks of specific companies. Deviations from this setup should be covered by setup tasks written by individual companies.
Control files  Setup
TMSPS/CCTBL Charge/Cost table

Setup the charge table as charge type or cost type along with the source of transaction and the type of sale. Charge/cost table is used when setting up the charge matrix and is assigned to a publisher client.

TMSPS/CSRV Charge Services

Setup all the service codes and their descriptions, along with the type of the service i.e. Sales reimbursement, Transaction based, Locational based, Royalty contract, Stock by year, Miscellaneous charges or AP Charge back for immediate invoicing. For each Service code setup, a non-stock item must be created in the Item Masterfile. These non-stock items are used in the invoice generation process.

Note: AP Charge back service charges are for direct invoice and will generate AP invoice immediately.

TMSPS/BRKTYP Break type

Break type for the charge basis can be by month to date value, year to date value or highest value within the month. This is system defined.

TMSPS/CALM Calculation method This is a system defined control file that holds the calculation method for publisher client charging i.e. as a percentage of each service or a fixed value for a particular activity etc.
TMSPS/CAMD Charge accumulation method

Charge accumulations methods are system defined. It allows you set up the charge  matrix with the options defined in this control i.e. to either add all the charge amounts or charge the highest or the lowest amount if there are multiple charge basis.

TMSPS/CBSE0 Sales Reimbursement Basis This is a system defined control file that holds the Sales reimbursements charge basis codes.
TMSPS/CBSE1 Sales Transactional Charge Basis This is a system defined control file that holds the Transactional charge basis codes.
TMSPS/CBSE2 Locational Charge Basis  Holds system defined Locational charge basis codes.
TMSPS/CBSE3 AP Charge Back Basis

Holds system defined charge basis codes for AP charges that has to be charged back.

TMSPS/CBSE4 Royalty Charge Basis

Holds system defined Royalty Charge Basis codes.

TMSPS/CBSE5 Stock by year Charge Basis

Holds system defined Stock by year Charge Basis codes.

TMSPS/CBSE9 Miscellaneous Charge Basis 

Holds system defined Miscellaneous Charge Basis codes.

TMSPS/TGC Transaction group code Establish the transaction groups for the various transaction types. Charges will be based on the quantities or values of these transaction groups.

Maintenance

Tasks Instructions
Setup publisher client and item hierarchy with the charge/cost tables

Each publisher client must be setup with the applicable item hierarchies and charge/cost table (TMSPS/CCTBL) that will be used for the charge or cost.

For details of this setup see Publisher Client Maintenance (PSM010)

Establish transaction group criteria

If transactional based service charge is required then transactions groups must be setup with the various transaction types and criteria.  Transaction group codes are defined in control file TMSPS/TGC. Charges will apply based on the quantities or values of these grouped transactions according to the definition established in Client Charge matrix.

For details of this setup see Transactions Group  Maintenance (PSM020)

Set up the client charge matrix (charge maintenance)

The charge matrix holds the formula for charging/costing i.e. it determines what charges to apply based on the charging criteria.  You have to setup charge/cost methods and rates for each combination of charge/cost table, service charge and transaction group. Up to three charge basis definitions with different charging criteria can be setup for each combination.

For details of this setup see Publisher Client Charge Maintenance (PSM030).

Establish GL expense accounts for external charges

For any external charges/expenses that is to be paid via AP, set up the GL expense accounts. These must be charge services that is setup with Type = 3 (AP Charge back, immediate invoice) in TMSPS/CSRV.

For details of this setup see 3PL Expense Account Entry.

Charge management

Tasks Descriptions
Regenerate subledger invoice This process can be used to used to regenerate any AP invoice charges. For details of this task see Regenerate Subledger Invoice (PSO025).
Enter miscellaneous charges For details of this task see Miscellaneous Charge Entry (PSM060).

Period end processing

Distribution end of period must be run before 3PL period end processing. In 3PL period end processing 3PL costs/charges are calculated for period based on latest 3PL setup and using latest location and completed transaction data for the selected period.

 Tasks Instructions
Run transaction extraction

This extraction process uses the Distribution Transaction Header (DSTRA00P) and Detail files (DSTRB00P) and the Warehouse Transaction file (WHTRF00P) to collate all the necessary transactions according to the setup in the client charge matrix and build Charge/Cost History Source file (PSCHD00P). For details of this task see Transaction Extract (PSO005).

Run month end location summary

This process takes a snapshot of the warehouse location of the current stock for charging.

For details of this task see Location Summary (PSO015).

Run location extract

Location extract takes the Warehouse Location file (WHLOC00P) and uses the setup in the client charge matrix to build Charge/Cost History Source file (PSCHD00P).

For details of this task see Location Extract (PSO020).

Run Yearly Stock Extract

Run this extract to calculate the number of years of stock in the warehouse.

This charge is based on how many years of stock is in the warehouse. Its calculated by taking the stock on hand at the EOP less gross shipments (sales + transfer outs).  Transfer outs will exclude any movements between internal warehouses. It then uses the calculated number of years of stock and selects the applicable client charge matrix for the stock by year charge basis to calculate the charge.

For details of this task see Yearly Stock Extract (PSO021).

Run Royalty Extract

These can be for number of new contracts, number of all contracts or number of contracts at royalty period and contracts at royalty period by payment frequency.

For details of this task see Royalty Extract (PSO030).

Run Miscellaneous Extract

This process must be run to extract all the miscellaneous charges entered manually; Miscellaneous extract (PSO040).

Run charge/cost update

This process is run after the transaction, location and the subledger allocation extract is completed. It will take the updated Charge/Cost Source file and update the Charge/Cost History file and the Charge/Cost History Header and Details files.

For details of this task see Charge/Cost Balance Update (PSO010).

Review charge management

The updated charges in the History file can be reviewed before the invoices are generated. You can also run the 3PL charge report to review the updated charges. If there any incorrect charges or errors, you can go back to the charge matrix and change the criteria/formula and re-run the extraction and the charge/cost update.

For details of this task see Publisher Client Charge Management (PSM050)

Generate invoice for the period

Once the charge/cost is updated to the Charge/Cost History file and the charges are reviewed and approved, the invoices can be generated.

For details of how to run the invoice generation see Publisher Client Invoice Generation (PSO050). Once the invoice has been generated, the details of that invoice can be viewed by taking the Invoice Details option from the 3PL Charge Management (PSM050).

Note The invoice cannot be reversed. If an error has been made in the initial setup and the invoice is incorrect, a credit note will need to be generated in the claims module