Customer & Supplier Setup

INTRODUCTION

This document describes the required screens to be used in setting up the information concerned with the Sales Order Process in the warehouse. Other guides describe the set up of company, user, warehouse, owners etc.

This is a generic guide based on the version of the CALIDUS WMS system at the time of writing.

It can also be used by clients to specify their specific data values to aid initial system set up as well as for future reference.

Note that fields marked '**' are mandatory and are needed to ensure correct set up of the system.

CUSTOMER CLASS MAINTENANCE (SOPCUCL01A)

Field Name	Description	Options	Generic Value
Class **	Code used to determine the type of customer (i.e. retail, wholesale etc)	4 character free text field	Defined by the client
Description	Description of the customer class	20 character free text field or left blank	Defined by the client

CUSTOMER TYPES MAINTENANCE (WHS4010)

Field Name	Description	Options	Generic Value
Type **	The type of customer being delivered to	2 character free text field	Defined by the client
Description	The description of the customer type	30 character free text field or left blank	Defined by the client

CUSTOMER PRIORITY MAINTENANCE (CASS5017)

Used for cross docking and order segregation, a priority set against a customer will determine which customers can be cross docked to.

Field Name	Description	Options	Generic Value
Priority **	The priority code used	1 character free text field	‘X’
Description	The description of the priority code	30 character free text field	Defined by the client

CUSTOMER WIZARD - DELIVERY DETAILS (WHSORA035)

Customer Wizard - Invoice Address (WHSORA035)

Field Name	Description	Options	Generic Value
Partner Code **	Customer code and sub code (Sub code must always be ‘001’)	10 character free text field	Defined by the client
Full Name **	Full name of the customer	35 character free text field	Defined by the client
Currency **	The currency code for the customer is to be invoiced in	Must have been created in currency codes maintenance – LOV available	Defined by the client
Address Type **	The default address type for this customer and the address number	DEL – you can have multiple addresses for one customer	DEL
Name **	The customer’s name	35 character free text field	Defined by the client
Address **	The first two lines of the customer’s address	2 x 35 character free text field (note, 2nd line can be left blank)	Defined by the client
Town **	The town the customer resides in	35 character free text field	Defined by the client
Post Code **	The post code/zip code for the customer	10 character free text field	Defined by the client
County	The county /state for the customer	15 character free text field or left blank	Defined by the client
Country	The country code for the customer	Must have been created in Country codes maintenance or left blank – LOV available	Defined by the client
Phone No	The telephone number for the customer	15 character free text field or left blank	Defined by the client
EAN Reference	Client specific EAN number for this customer	13 character free text field or left blank	Defined by the client
Transport Charge	The amount to be charged to the customer for transport	10 digit numeric field	Defined by the client
Invoice Date	The date the customer was last invoiced	Display only	N/A
Customer Creation Date	The date the customer code was created	Display only	N/A
Last Amendment Date	The date details of the customer code were changed	Display only	N/A
Statement Date	The last statement date for the customer	Display only	N/A
Last Payment Date	The date the customer last paid an invoice	Display only	N/A
Buttons
New Delivery Address	Enables the user to add a new address for the customer	n/a	n/a
Warehouse Details	Enables the user to enter warehouse specific details for the customer (not migrated)	n/a	n/a

Customer Wizard – Invoice Address (WHSORA035)

Field Name	Description	Options	Generic Value
Address Type **	The default address type for this customer and the address number	INV – you can have multiple addresses for one customer	INV
Address **	The first two lines of the customer’s invoice address	2 x 35 character free text field (note, 2nd line can be left blank)	Defined by the client
Town **	The town of the invoice address	35 character free text field	Defined by the client
Post Code **	The post code/zip code for the invoice address	10 character free text field	Defined by the client
County	The county /state of the invoice address	15 character free text field or left blank	Defined by the client
Country Code	The country code of the invoice address	Must have been created in Country codes maintenance or left blank – LOV available	Defined by the client
Phone No	The telephone number of the invoice address	15 character free text field or left blank	Defined by the client
Buttons
New Invoice Address	Enables the user to add an additional invoice address for the customer	n/a	n/a

Customer Wizard – SOP Details (WHSORA035)

Field Name	Description	Options	Generic Value
Customer Type	The customer type for this customer	Must have been created in customer types maintenance	Defined by the client
Part of Desp Order	Determines whether an order can be despatched if the whole order is not fulfilled (not migrated)	Y or N	Defined by the client
Part of Desp Item	Determines whether an order can be despatched if the whole product quantity is not fulfilled (not migrated)	Y or N	Defined by the client
Priority Code	The priority code for the customer	Must have been created in priority codes maintenance – LOV available	Defined by the client
Payment Set	The group code for the customer under which the invoice will be paid (not migrated)	1 character free text field or left blank	Defined by the client
Paying Office	The office name where the invoice will be paid from (not migrated)	10 character free text field or left blank	Defined by the client
Paying Office Ac No.	The account number for the invoicing paying office	3 character free text field or left blank	Defined by the client
Package Labels Req	Does this customer require packing labels	Do Not Print Labels	Defined by the client
		Print At All Levels
		Print Labels
Detail Labels Req	Are packing labels required at detail level? (By stock code)	Do Not Print Labels	Defined by the client
		Print At All Levels
		Print Labels
Transport Labels Req	Are transport labels required	No Simplified Labels Required	Defined by the client
		Yes, Produce Simplified Labels
Area Manager	The name of the area manager for this customer	4 character free text field or left blank	Defined by the client
Special Pack Msg Id	The id code for a message that is to be produced at packing	6 character free text field or left blank	Defined by the client
Weekly Invoicing	Does the customer require invoicing? (not migrated)	Y or N	Defined by the client
Vat Applied	Is V.A.T to be applied to the customer’s invoices? (not migrated)	Y or N	Defined by the client
Automatic Charge Code	If an automatic charge is to be applied to the invoice, what is the code for this charge	5 character free text field or left blank	Defined by the client
Customer POD Req	Does the customer require a POD	Y or N	Defined by the client
Depot POD Required	Does the customer require an additional depot POD (not migrated)	Y or N	Defined by the client
Only Accept Complete Back Order	If backordering is used, will the customer only receive orders that completely fulfilled (not migrated)	Y or N	Defined by the client
EDI Identifier	The code that will be used to identify this customer on EDI flows (not migrated)	11 character free text field or left blank	Defined by the client
Prevent Ordering	If set to ‘Y’, orders will not be able to be raised against this customer	Y or N	Defined by the client
Client Account Code 1	An account number for the customer which will be produced on outbound documentation	10 character free text field or left blank	Defined by the client
Client Account Code 2	An additional account number for the customer which will be produced on outbound documentation	10 character free text field or left blank	Defined by the client
SSCC No. Required	Are SSCC numbers to be used for this customer	Y or N	Defined by the client
Last Order Date	The date an order was last raised for this customer	Display only	N/A
Repalletise	Do orders need to be repalletised for this customer	Y or N	Defined by the client

Customer Wizard – Customer Restrictions (WHSORA035)

Field Name	Description	Options	Generic Value
Picking Note Text 1-6	Text entered here will be produced on the picking list	6 x 40 character free text fields or left blank	Defined by the client
Despatch Note Text 1-10	Text entered here will be produced on the delivery note	10 x 40 character free text fields or left blank	Defined by the client

Warehouse

Field Name	Description	Options	Generic Value
Fast Dial
Region Code
Out of Rotation Flag		No, Yes	Yes
Salesman
Sales Territory
Sales Area
Contact
Post Code/Region Flag
Delivery Mode		Direct, Trunk	Direct
Despatch Code
Direct Route
Trunk Route Code

Tariff/Charges

Field Name	Description	Options	Generic Value
Tariff Zone
Carrier Code

Handling Charges

Field Name	Description	Options	Generic Value
Product Code
Handling Charge

Vehicle Restrictions

Field Name	Description	Options	Generic Value
Vehicle Type
Restriction Text

Picking/Delivery

Field Name	Description	Options	Generic Value
Owner	The owner. Display only
Reference	Any reference
Picking Instructions	if entered will appear on the pick note for that customer.
Delivery Instructions	if entered will appear on the despatch note for that customer.

Note: Not all pick note and despatch note formats will display instructions.

SUPPLIER CLASS MAINTENANCE (PLGSPCL01A)

Field Name	Description	Options	Generic Value
Code **	The code for the supplier class	4 character free text field	Defined by the client
Description **	The description for the supplier class code	20 character free text field	Defined by the client

SUPPLIER WIZARD - SUPPLIER DETAILS (WHSORA045)

Field Name	Description	Options	Generic Value
Ledger Code **	The ledger code the system uses to define which information can be used	PL1	PL1
Short Name	An abbreviated version of the customer name	10 character free text field or left blank	Defined by the client
Supplier Type **	The type of supplier this is. (Note, no maintenance screen has yet been created for this – so an Aptean staff member will have to create this using SQL)	Must have been created in supplier types – LOV available	Defined by the client
Supplier Class **	The class of supplier this supplier is grouped under.	Must have been created in supplier class maintenance – LOV available	Defined by the client
Currency **	The currency code for this supplier	Must have been created in currency codes maintenance – LOV available	Defined by the client
Tax No	The VAT number for the supplier	20 character free text field or left blank	Blank
Cust Ledger/Customer	The default customer code for this supplier (note, the ledger code always needs to be prefixed)	SL1/Customer code – customer must have been created in customer wizard – LOV available	SL1/Defined by the client
Settle Method	The frequency in which the supplier will settle their invoices (not migrated)	Month, Day	N/A
Settle Days	The number of days before an invoice needs to be settled (not migrated)	4 digit numerical field	N/A
Bonded Flag	Determines whether a supplier is bonded or not (not migrated)	Y or N	N/A
SSCC Control Flag	Determines whether this supplier requires SSCC labels	0 – SSCC are Optional	Defined by the client
		M – SSCC are Mandatory
Invoice Required	Determines whether an inbound commercial invoice will be required for the supplier (client specific)	No Comm Inv Required	No Comm Inv Required
		Comm Inv Required Std Rec Only
		Comm Inv Required All Rec
Dispute Code **	The code used for disputing an invoice (not migrated)	1 character free text field	0
Payment Set	The payment group for the supplier (not migrated)	1 character free text field or left blank	Blank
Buyer	The buyer code for the supplier (not migrated)	4 character free text field or left blank	Blank
Discount Days	The number of days the discount will be valid for (not migrated) - will default to 1	3 digit numerical field or left blank	Blank
Discount %	The Discount percentage to be applied to the invoice (not migrated) - will default to 0.00	7 digit numerical field or left blank	0
Credit Amount	The amount of credit this supplier has on an invoice (not migrated) – will default to 0.00	0 – 99999999.99	0
Credit Limit	The amount of credit limit this supplier can have (not migrated) – will default to 0.00	0 – 99999999.99	0
Balance	The current invoice balance for this supplier	Display only	N/A
Turnover	The turnover balance for this supplier	Display only	N/A
Approved Supplier	Is this supplier approved? (not migrated)	Y or N or left blank	Blank
Duplicate Advice Note No	Does the supplier allow duplicate advice note numbers at receipt?	Y or N	Defined by the client
Date Created	The date the supplier was created	Display only	N/A
Amendment Date	The date the supplier details were last changed	Display only	N/A
Date Last Invoice	The date the supplier was last invoiced	Display only	N/A
Date Last Payment	The date the supplier last paid an invoice	Display only	N/A
Date Last PO	The date the supplier last raised a purchase order	Display only	N/A
Date Last GR	The date a receipt was last raised for this supplier	Display only	N/A

Supplier Wizard – Further Details (WHSORA045)

Field Name	Description	Options	Generic Value
Normal Order Method **	The method by which orders will be raised (not migrated) – will default to EDI	EDI, Post, Fax, Telex	EDI
Normal Payment Method	The method by which the supplier will pay invoices (not migrated) – will default to Cheque	Cheque, BACS, Credit Transfer	Cheque
Transfer Threshold	The maximum value before an invoice can be transferred (not migrated) – will default to 0.00	0 – 99999999.99	0
Delivery Warehouse	The warehouse the supplier will default to (not migrated)	Must have been created in warehouse maintenance or left blank – LOV available	Blank
Own Transport	Does this supplier have their own transport (not migrated) – will default to Yes	Y or N	Yes
Report Frequency	The frequency in which reports are produced, If set to Day, the days they are to be produced on (not migrated) – will default to Week	Day	Week
		Week
		Month
Invoice Frequency	The frequency in which invoices are to be produced (not migrated) – will default to Weekly	Daily	Weekly
		Weekly
		Monthly
COO Days Retention	The number of days stock will be stored under this supplier before moving to another supplier (not migrated)	3 digit numerical field or left blank	Blank
Bank Sort Code	The bank sort code for this supplier	6 character free text field or left blank	Blank
Bank Account No	The bank account number for this supplier	15 character free text field or left blank	Blank
Swift Account No	An account number for the Swift carrier account number (client specific)	8 character free text field or left blank	Blank
Intl Bank Code	The international bank code for the supplier	35 character free text field or left blank	Blank
Bank Name	The Bank Name for the supplier	15 character free text field or left blank	Defined by the client
Address	The Bank address for the supplier	35 character free text field or left blank	Defined by the client
Routing Code	The route code for the supplier	35 character free text field or left blank	Defined by the client
EDI Output	The method by which the edi output will be produced (not migrated) – will default to Both	Autofax	Both
		Both
		Edi
		File
		None
		Print
Base Balance	The base value balance for this supplier (not migrated)	Display only	N/A
Last Year Sales	The amount of sales for last year (not migrated) – will default to 0.00	0 – 9999999.99	0
Agreed Max Level	Does this supplier have an agreed maximum credit limit (not migrated)	Y or N or left blank	Blank
Head Office A/C	The head office account number for the supplier (not migrated)	10 character free text field or left blank	Blank
Pallet Reg A/C	The registration account number for the supplier’s pallet account (not migrated)	10 character free text field or left blank	Blank
EAN/UCC Code	The EAN code for the supplier	10 character free text field or left blank	Defined by the client

Supplier Wizard – Buyer Address (WHSORA045)

Field Name	Description	Options	Generic Value
Address Type **	The default address type for this customer and the address number	BYR – you can have multiple addresses for one customer	BYR
Name **	The supplier’s name	35 character free text field	Defined by the client
Address Code	The unique address identifier given by the WMS	Display only	N/A
Address **	The first three lines of the customer’s invoice address	3 x 35 character free text field (note, 2nd and 3rd line can be left blank)	Defined by the client
Town **	The town of the invoice address	35 character free text field	Defined by the client
Post Code **	The post code/zip code for the invoice address	10 character free text field	Defined by the client
County	The county /state of the invoice address	15 character free text field or left blank	Defined by the client
Country	The country code of the invoice address	Must have been created in Country codes maintenance or left blank – LOV available	Defined by the client
Buttons
New Buyer Address	Enables the user to add an additional buyer address

Supplier Wizard – Payment Address (WHSORA045)

Field Name	Description	Options	Generic Value
Address Type **	The default address type for this customer and the address number	PAY – you can have multiple addresses for one customer	PAY
Name **	The supplier’s name to be paid to	35 character free text field	Defined by the client
Address Code	The unique address identifier given by the WMS	Display only	N/A
Address **	The first three lines of the supplier’s invoice address	3 x 35 character free text field (note, 2nd and 3rd line can be left blank)	Defined by the client
Town **	The town of the invoice address	35 character free text field	Defined by the client
Post Code **	The post code/zip code for the invoice address	10 character free text field	Defined by the client
County	The county /state of the invoice address	15 character free text field or left blank	Defined by the client
Country	The country code of the invoice address	Must have been created in Country codes maintenance or left blank – LOV available	Defined by the client
Phone No	The telephone number of the invoice address	15 character free text field or left blank	Defined by the client
Buttons
New Payment Address	Enables the user to add an additional payment address