Forcing a Manufacturer Price

Another advanced option in the StreamV Special Pricing System allows you to force the system to use the Manufacturer or Manufacturer Buying Group price for the target price even when the manufacturer based price is not the best price available.  This option is enabled by creating records in the LONGCODE Table.

The format of the Longcode record used for this option is

Field	Description
CodeSet	F054DETL
Code1	{Customer Account Number}
Code2	ForceManuPrice
Code3	Manufacturer Name
Code4	Inventory Product Line (optional)
Code5	Inventory Item Number (optional)
Data_1	Y or N (determines if the system uses the manufacturer or manufacturer buying group price even when it is not the best price available for the customer, item, quantity, date range being processed.

The Special Pricing System will normally calculate all available prices for the current order line (including manufacturer prices) and it will return the best available price.  If this option is used, the system performs the normal price calculations, but it does not normally return the best available price.  The system instead checks for Longcode records with the above format in the following sequence and it uses the first record found.  This behavior allows you to force manufacturer pricing for certain customers, items and product lines.

Check for record for the Company Account/Manufacturer Name/Prodline and Item

Check for record for the Company Account/Manufacturer Name/ and Prodline

Check for record for the Company Account/Manufacturer Name

Check for record for the Company (this allows you to force manufacturer pricing for a specific customer and all manufacturers).

The system then takes the value from the first record it finds and it uses this to set an indicator to determine if the manufacturer price should be forced as the target price.

If the indicator is set, the system compares the Manufacturer Price and the Manufacturer Buying Group prices calculated by the system and it uses the lower of the two prices as the target price.

More:

Treating Standby Records as Active