Pricing Unit of Measure (Branch or ECS) Basic and Advanced Preference Profiles (P40347, P4070, P4071, P4072)

Purpose
Details

Purpose

The Pricing Unit of Measure by Branch preference is for use with Bulk Stock Items functionality only.

Details

The two fields which are unique to this preference are Price At and Based on Date.

1

Additional Information: The Price At field identifies the price extension calculation method. Valid Values are:

A

Unit Price x Delivered Volume at Ambient Temperature

S

Unit Price x Delivered Volume at Standard Temperature

W

Unit Price x Delivered Weight

The system is hard-coded to price at ambient UOM unless the preference profiles are setup otherwise. If set to price at standard UOM, the extended price in the sales order will change if the standard UOM is different from the ambient volume.

If the invoice is printed prior to delivery, the price extension calculation uses the order quantity in the pricing unit of measure. This means that the ambient and standard quantity will be the same.

The Based on Date field is a value that determines how the system updates the Price Effective Date in the Sales Order Header (F4201) and Detail (F4211) files. In Sales Order Management, the system uses the Price Effective Date (PEFJ) to retrieve the base price from F4106 and price adjustments from F4072. Options for the Based on Date are:

Transaction/Order Date
Requested date
Promised Ship Date
Original Ship Date
Actual Ship Date
System Date
Invoice Date
Preferred Date

Note: If both Advanced Preference and Basic preference has been set up within the system, Advanced Preference will take precedence over Basic Preference. If a customer sets up an Advanced Preference and a Basic Preference that have the same available fields, the system will only apply the Advanced Preference and ignore the Basic Preference.


For example: Advanced Preference Type 02 (Order Detail Defaults) and Basic Preference Type 47 (Pricing Unit of Measure by Branch) has been activated for a specific customer. The Advanced Preference 02 (Order Detail Defaults) has been set up to use the Pricing Unit of Measure (UOM) for EA (Each) and the Basic Preference type 47 (Pricing Unit of Measure) has been set up to bring in CA (Cases) by a specific branch plant for the same customer. The system will only apply the Advanced Preference, it will not apply the Basic preference this is per the design of the software.

2

Note: Advanced Preference does not include a Based On Date as part of the preferences, so to use Base On Date in conjunction with Price At funtionality use Basic Preferences.

The extended price for bulk items are calculated in the business function 'Calculate Extended Price for Bulk Orders' N41B0460. This function requires that the values for Quantity in Primary Unit of Measure (UOM) (STUM), Ambient volume (AMBR), and Weight result (WGTR) fields in the Sales Order Tag (F49211) file are populated with a value other than 'zero'.

If the pricing is set up in weight unit of measure, then the WGTR value is multiplied by the unit price to retrieve the extended price. If the pricing is in a volume unit of measure, then either STUM, if pricing at standard volume (PRAS flag is 'S') or AMBR, if pricing at ambient volume (PRAS flag is 'A') is multiplied by the unit price to retrieve the extended price. These three values are not added to the Sales Order Tag (F49211) file until the order is run through shipment confirmation. Therefore, if the order is not run through ship confirm before printing the sales invoice, then the extended price will not be printed correctly.


NOTE: If trying to use kits with this preference, the UOM will only change for the Kit Parent, UOM for components come from the bill of material.