Field Types

Add label

Goods Inwards

Goods Inwards charges or known as RHD are charges applied per line as goods are received into stock. You can use per line charging or you can have per receipt charging on a customer by customer basis.

Example in Excel

the headings show there are 6 mandatory fields where information is required this is followed by optional sections for

Surcharges
Discounts
Using the charge multiplier

As a way to explain the fields

Customer Code is entered, then the charge amount, how are you charging this (by case, by pallet) and is there a minimum charge for this, what products will this apply to and which product groups will it apply to

You can use the table below for reference information for the fields needed in this import.

Here is an example excel file

This has no entried but is what we are looking for with your import file so you can use this and then populate the information

Field Name	Type	Mandatory Or Default to
Customer	Char(8)	MANDATORY	Enter the customer code.
ReducedRate	int	0	We find most customers will offer a standard pack charge and then a discount for a pack half the size or even the other way around. Indicate how this will be used for this customer Options available are 0 - Not in Use 1 - LOL Greater Than 2 - LOL Less Than 3 - Bottles/Case Greater Than 4 - Bottles/Case Less Than
IsPremiumCharge	bit	0	Will you charge a premium charge for expedited receipts Default is 0 which is NO, but if you intend to charge set to 1
PremiumChargePercentage	decimal(18, 2)	0.00	How much is the surcharge for an expedited receipt.
IsRRDiscount	bit	0	Are you applying a reduced rate. Default is 0 which is NO, but if you intend to use then set to 1
RRDiscountQty	decimal(18, 2)	0.00	What is the quantity to achieve the discount e.g. 6.00 litres or less……
RRDiscountPercentage	decimal(18, 2)	0.00	Is you are applying a reduced rate then what is the discount % age e.g. 50.00% discount
Product Types	Information		Does this charge apply to particular product types - see Product Types Seperate with a , or \| (make sure it is not the same as your output seperator)
Product Groups	Information		Does this charge apply to particular product groups - see Product Groups Seperate with a , or \| (make sure it is not the same as your output seperator)
Charge	decimal(19, 5)	0.00
Minimumcharge	decimal(19, 5)	0.00
ReceiptType	int	YES	How is this charge being applied 1 - Case True 2 Pallet True 3 Gross Weight True 4 Container False 5 Container 60ft False 9 Single True
Multiplier	bit	YES 0	Does this rate get used as a multiplier for some products
Multiplier1Qty	Decimal (18,5)	0.00	Enter the value 1.00 means same as existing rate 2.00 would be double
Multiplier1ProductTypes	Informational		Tell us which product types this applies toProduct Types
Multiplier1ProductGroups	Informational		Tell us which product group this multiplier would apply to Product Groups
Multiplier2Qty	Decimal (18,5)	0.00	Enter the value 1.00 means same as existing rate 2.00 would be double
Multiplier2ProductTypes	Informational		Tell us which product types this applies to Product Types
Multiplier2ProductGroups	Informational		Tell us which product group this multiplier would apply to Product Groups

We will use this table to build a standard charging matrix and then that matrix of charges will be applied to the customer accounts which can use a specific charge and then we use this to apply it to the products.

Vision Implementation

Import - Charging Goods Inwards

Field Types

Goods Inwards