View source for WHS0330 Charge Codes Table Maintenance

CHARGE CODES will be defined to enable the production of charges.

Each can have an associated RATE ID for the calculation of the CHARGE VALUE, or can use an 'ad-hoc rate' when entered manually.

Each can be applicable to a particular BUSINESS TYPE, or for general use.

Each can be applicable to a 'specific level' within the Invoicing processes – namely COMPANY / WAREHOUSE / STOCKIST / STOCK or PRODUCT TYPE.

===Charge Code Maintenance – Main Tab===
<center>[[File:WHS0330.png|800x800px]]</center>
{| class="wikitable" border="1"
|-
!'''Field Name'''!!'''Description'''!!'''Options'''
|-
|''CHARGE CODE''||Unique identifier||User input
|-
|''SHORT DESCRIPTION''||Free text||User input
|-
|''FULL DESCRIPTION''||Free text||User input
|-
|''RATE ID''||If entered, must be a valid ID else it will default to '+' to enable use for entry of an 'ad-hoc rate||User input
|-
|''BUSINESS TYPE''||Enable charge generation within specific WMS processes – referred to as 'in Process charges'.||Can be left as '+' to enable use as an 'ad-hoc' code, otherwise it must relate to a valid code from the GENERAL CODES table for type BUSN records
|-
|''WAREHOUSE, OWNER, PRODUCT, PRODUCT TYPE''||These elements, and all of the above, form the unique identifier for the charge code table. See below for full description relating to the entry of these four elements.||User input – all codes must be valid for the type of entry –
Ie, Valid WAREHOUSE_ID, STOCKIST_CODE, STOCK_CODE, PRODUCT_TYPE
|-
|''USE LATEST RATE''||Flag used to enable the recalculation of any charges not yet invoiced if new rates / charges are introduced||User input from drop down box – Options are Yes / No / Blank. Must select Yes if previously generated charges are to be updated.
|-
|''CHARGE TYPE RCB''||Descriptive flag relating to whether the code is Cost / Revenue or Both||User input
|-
|''CHARGE TYPE''||Descriptive flag relating to the type of charge.||Allowable values are – Ancillary, Cyclical, Handling, Landing, Miscellaneous, Processing, Rent, Sales and Special Forces
|-
|''MIN / MAX CHARGE''||The Minimum / Maximum charge value to be applied to the charge code on an invoice. Note that all charges on an invoice are 'subtotalled at charge code level' so this will allow for the application of a MIN/MAX charge for Invoice Level charges for a specific charge code.
|
|-
|''DELETE FLAG''||System use only
|
|-
|''SENSITIVE FLAG''||System use only
|
|-
|''CALCULATION OPTION''||Defines how the system generates charges||AUTO SEMI-AUTO MANUAL
|-
|''LEVEL INDICATOR''||Define the level that the charge is to be applied to.|| HEADER – the total quantity for process in question <br/>  |DETAIL – each detail on the process in question 
PALLET – each pallet on the detail in question
|-
|''TAX CODE''||The VAT code and related descriptions||User input
|-
|''TYPE CODE''||For use within the Special Order Handling processing||Type codes will be checked against specific codes on an Order, to define if the charge is applicable.
|-
|''TYPE VALUE''||Value for comparison with TYPE CODE||See below
|-
|''ACCOUNT CODE 1 and 2''||The 'SAP Account codes' for the Charge. Details are included for EDI interface to SAP Account system.||User input
|}


The following elements are grouped, to enable the definition of the 'Level of charge' to be applicable.

* WAREHOUSE The Warehouse id 
* OWNER The Stock Owner 
* PRODUCT The Stock 
* PRODUCT TYPE the Type of Stock (eg, Chilled, Frozen)

No values means that it is a Company Level charge, Warehouse only means it is Warehouse level, Warehouse and Owner means Owner Level for specific Warehouse Owner only means Owner level (applicable to all warehouses) Owner and Stock means it is a Product Level charge Owner and Product type means it is Product type charge for a specific Owner Product type only means Product type level across all owners / warehouses Product Type and Warehouse means Product type within warehouse


''TYPE CODE'' should be set to the type of code to be checked against, e.g. Order Priority (Express Order), Request Type (Collection Order), Order Type (EDI or COD)

''TYPE VALUE'' should be set to the actual value defined to identify the type specified (as defined by individual users) – e.g. Order Priority of '1' to identify 'top priority / express orders.

===Charge Codes Maintenance – Charge Group Tab===
There two possible uses for this tab –

1. BUSINESS TYPE = INV

Defines the CHARGE GROUP DETAILS, including any MIN/MAX values, for the production of Invoice Level Charges during Invoice Production processing. Note the INV type codes can only define ONE GROUP. It is this charge code that identifies the fact that a specific charge is to be raised and holds the relevant VAT and Account codes.

2. BUSINESS TYPE NOT = INV

Defines the CHARGE CODE as INCLUDED in the GROUP for all GROUP CODES listed.  Note that non-INV codes can belong to multiple groups.<center>[[File:WHS0330-CrgGrps.png|800x800px]]</center>
{| class="wikitable" border="1"
|-
!'''Field Name'''!!'''Description'''!!'''Options'''
|-
|''CHARGE GROUP''||The Unique identifier for the CHARGE GROUP that the CHARGE CODE is a member. If it is 'INV' type Charge code, then it can only be a single group, otherwise a code can be a member of many groups||User input
|-
|''DESCRIPTION''||Free text description||User input
|-
|''INVOICE MIN / MAX Value''||The min / max value applicable to the calculated charge value for the group.||Define the Min / Max value for 'Invoice Level' charges Use for Min Rent / Max Insurance etc…
|}
===CHARGE CODES USED FOR SPECIAL PROCESSING===
'''Charge Codes with a Business Type of 'INV' (Invoice Process)''' Codes with-

Zero value for Max / Min value, and NO Charge Group

This is an 'In Process type' charge that will be raised within the Invoice Production process, e.g. a charge for actually raising an invoice. They will normally be set to use a RATE with a Fixed Amount charge.

'''Codes with-'''

'''Zero value for Max / Min value, and Includes Charge Group '''

This is an 'Invoice Level charge' that will be raised within the Invoice Production process based on the values generated for for a GROUP of Charges, e.g. additional Charge for Energy / Insurance etc.

Charge will normally be based on the overall value of the charges within the group, or a percentage of the value / quantity.

'''Codes with-'''

'''Non-Zero Minimum charge value'''

This is charge that will be raised within the Invoice Production process if the total value of the charges for the same Charge Code (non-INV type) is less than the Minimum value stated, e.g. if Rent charges do not reach a minimum value then the INV charge will raise an additional charge for the difference

===Business Type ORD Codes (Order Handling)===
{| class="wikitable" border="1"
|-
!'''Field Name'''!!'''Description'''!!'''Options'''
|-
|'OHPEX'||Charge required as Pallet Exchange accounts missing||Charge for the number of pallets that are not covered by  pallet exchange account codes, but only when both Consignor and Consignee do not have codes available. Charge will be raised against the Stock Owner (Consignor)
|-
|'ORDH'||Charge for handling the Order||Always a single unit charge to be raised simply for raising an order, regardless of quantity involved
|-
|'ORDL'||Charge for the  Order Lines handled||Charge for number of order lines. AS above but based on the number of lines on the order
|-
|'ORDP'||Charge for pallets handled||Charge for the number of pallets. As above but based on the number of pallets on the order
|-
|'WAYB'||Charge for waybill prints||Charge to be raised for each Waybill raised. Will need to check for the production of additional waybill for Trunk orders, or consolidated orders onto a single waybill
|-
|'DHPT1'||Charge for Full Pallet picks||Charge to be raised for each Full pallet of stock picked
|-
|'DHPT2'||Charge for Part pallet picks from Pick locations||Charge for stock picked in case quantity (rather than pallet) from a Pick location
|-
|'DHPT3'||Charge for Part pallet picks from Non-Pick locations||Charge for stock picked in case quantity (rather than pallet) from a location other than a Pick location – eg. from bulk / block stack etc.
|}
===Business Type DES Codes (Despatch Process)===
If Owner Level Charges found with the first three characters of the Charge Code = 'DHH', and Type Code is not blank/null, then a charge will be raised according to the following checks:

* If Order Code Type = 'P'
** Then the ORDER PRIORITY must match the TYPE CODE 
* If Order Code Type = 'R'
** Then the REQUEST TYPE must match the TYPE CODE 
* If Order Code Type = 'C'
** Then the COD FLAG must match the TYPE CODE 
* If Order Code Type = 'E'
** Then the EDI CREATED must match the TYPE CODE
* If Order Code Type = 'O'
** Then the ORDER TYPE must match the TYPE CODE

In all of the above cases the quantity value must always be 1 thus generating an additional charge depending on the type of order being despatched.

===Special Rent Processing Charges===
Special Charge processing is required within the Cyclical Rent charge generation processing to cater for the 'Reserved Pallet Location' processing.

Charge Codes with the first 3 characters of

'RPLxx' – will be used for Reserved Pallet Locations

'RULxx' – will be used for Reserved Unused Locations.

Controlled by the use of an Owner level Warehouse Rule, 'OWRL', the Rule Flag will be set to 'RUL' with the number of locations that the Owner has Reserved in total being stored in the breakpoint value of the Rate details record that holds the rate to be charged for unused locations.

The 'RPL' and 'RUL' Charge Code details will be set 'in pairs' to reflect the rate to be charged for the quantity of Used and Unused locations.

In Normal circumstances, each rent cycle / period will generate two charges for this processing - One Charge will be raised for the Total Pallets in the Warehouse for the 'RPL' Used value – and A second charge will be raised for the Total Reserved – minus - Total Used for the 'RUL' Unused value.

If the total pallet count is greater than the total reserved, then no charge will be raised for the Unused locations.
<noinclude>
[[Category:Finance Maintenance]]
</noinclude>