AutoMinGpm

The Automingpm option allows you to force the price for each order line to meet the minimum gpm percentage that is specified for each inventory item.  If a qualifying Longcode record is found for the item being processed, the system will check the price and cost for the order line and it will adjust the price of the order line to meet the minimum margin specified for the item in the Catalog File.

When the Automingpm option is used, the price of each order line is adjusted to the minimum gross profit margin defined for the item in all price calculations (all valid pricing options will use the minimum margin logic).

There are two different types of Longcode records used to enable this option

The format of the first Longcode record used for this option is

Field

Description

CodeSet

F108DETL

Code1

Inventory Item Number (optional)

Code2

AutoMinGpm

Code3

 Customer Account Number (optional)

Code4

 

Code5

 

Data_1

Y or N (determines if the system adjusts the prices calculated by the system to meet the minimum margin defined in the Inventory Item record.

The Target price calculation defaults to not use the minimum margin logic.  It then checks for the above records during order entry in the following sequence and it uses the first record found.  This behavior allows you to include or exclude certain customers and items from the minimum margin adjustment.

Check for Global record (code 1 and 3 are left blank) – this record turns the automingpm logic on or off for all pricing calculations, customers and items.

Check for Item Specific record (code 1 is set to the item number, code 3 is left blank) – this record turns the automingpm logic on or off for the specific inventory item specified in the Longcode record.

Check for Company/Item Specific record (code 1 is set to the item, code 3 is set to the customer account number) – this record turns the automingpm logic on or off for a specific inventory item and customer combination.

The second Longcode record used for this option allows you to set the AutoMinGpm option for a specific company and all items.

The format of the Longcode record used for this option is

Field

Description

CodeSet

F054DETL

Code1

Company Account Number

Code2

AutoMinGpm

Code3

 

Code4

 

Code5

 

Data_1

Y or N (determines if the system adjusts the prices calculated by the system to meet the minimum margin defined in the Inventory Item record.

Check for Company Specific record (code 1 is set to the Company Account Number, code 3 is left blank) – this record turns the automingpm logic on or off for a specific customer and all items.

More:

ManuPriceMinGPMForce