Import - Charging Goods Inwards

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.

 

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
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
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 to

Multipleier1ProductGroups

Informational

 

Tell us which product group this multiplier would apply to

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

Multipleier2ProductGroups

Informational

 

Tell us which product group this multiplier would apply to

 

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.

Copyright Ontech Solutions 2017-2024. All rights reserved, no part may be replicated or distributed without the express permission of the owner.