Title: Purchase Price Retrieval
Abstract: An explanation of how the Purchase Order Entry (P4310) program selects the price for an item.
Product / OneWorld®Suite / Distribution
Release / ALL
Document ID / ODS-02-0067
Date Created / 07/18/2002
Date Reviewed / 07/18/2002
Date Revised / 07/18/2002
Table of Contents
Overview
Example
Overview
When entering a Purchase Order, as long at Advanced Procurement Pricing is not active, the program looks at two files in order to locate a price for the item, Supplier Price/Catalog (F41061) and Item Cost (F4105) files.
The program takes the Purchase Price Retrieval UOM setting in the System Constants and uses that unit of measure when looking at the Supplier Price/Catalog (F41061) file. The System Constants is access by going into the Branch/Plant Constants (P41001) off menu G4241, then take the System Constants form exit. If there is no match for that unit of measure, the primary unit of measure is used to locate a price within the Supplier Price/Catalog (F41061) file. If a price is found, the program will take that price an multiply it by the unit of measure conversion. If no matches are found in the Supplier Price/Catalog (F41061), the program then uses the purchasing cost from the Item Cost (F4105) file and multiplies it by the unit of measure conversion.
If a multi-currency environment is used, the Supplier Price/Catalog (F41061) record will have to have a match for not only the unit of measure but also the base company currency.
Back to Top / Submit FeedbackExample
Create an item with a Primary unit of measure of eaches (EA) and a Purchasing unit of measure of case (CA).
Setup the unit of measure conversion to be 1 CA = 12 EA.
Setup the cost of this item to be $100.
Go to the Item/Supplier Relationships (P43090) off menu G43A16 and setup a price for the item as 1 case equals $75. NOTE: The Purchase Price Level for the item must be a 1 or a 2 in order to enter in a cost in the supplier/item relationships.
At this point price breaks can be setup for a specific item and supplier. This information is also stored in the Supplier Price/Catalog (F41061) file.
The System Constants is access by going into the Branch/Plant Constants (P41001) off menu G4241, then take the System Constants form exit. Set the Purchase Price Retrieval UOM to 2 so it will be looking at the Purchasing unit of measure.
The options that you have to choose from for Purchase Price Retrieval UOM are as follows:
Enter a Purchase Order and notice that $75 comes into the order since the program found the price in the correct unit of measure in the Supplier Price/Catalog (F41061) file.
Go back to the System Constants and change the Purchase unit of measure retrieval to a blank so it will be looking at the primary unit of measure. Restart OneWorld to have the change take affect.
Enter a purchase order and notice that the cost now comes in at $100 * 12 (the unit of measure conversion).
This is because the program could not find a price in the Supplier Price/Catalog (F41061) file for eaches (EA).
Back to Top / Submit FeedbackTop of Form 1
Was this document helpful?Very Somewhat Not at all
Comments (500 chars or less)
Bottom of Form 1