Functional Description
Purpose
The purpose of this business function is to retrieve a purchase price for the specified Supplier,
Item, Currency, Unit of Measure and quantity.
This function will also convert a domestic price found into foreign if an exchange rate has been
provided. The Unit price is also provided in the purchase unit of measure _ as used by PO Entry.
Setup Notes and Prerequisites
If conversion from domestic to foreign is required, then the exchange rate needs to be provided.
This calculation is only performed when the CurrencyProcessingFlag is not 'N' (No Currency Processing).
If a conversion of the unit price per primary/transaction unit of measure into unit price/pruchase
unit of measure is required then the conversion factors from Transaction to Purchasing and from Primary
to Purchasing should be provided. If these are not provided then the conversion will not take place
and the unit price/purchase unit of measure will be zero.
Technical Specification
D4300040 - Get Purchase Price
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
szBranchPlant | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
mnAddressBookNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szPrimaryUom | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
mnQuantityInTransactionUom | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
szTransactionUom | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szCatalogNumber | CATN | char | NONE | NONE |
This is a grouping of suppliers and items for pricing purposes. | ||||
jdTransactionDate | TRDJ | JDEDATE | NONE | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
szCurrencyPurchaseOrder | CRCD | char | NONE | NONE |
| ||||
szCurrencyDomestic | CRRP | char | NONE | NONE |
A code that indicates the currency that is used by the supplier. The system uses this code as the default currency when you enter vouchers
| ||||
mnUnitPriceInForeign | PRRC | MATH_NUMERIC | NONE | NONE |
The unit cost of one item, as purchased from the supplier, excluding freight,taxes, discounts, and other factors that might modify the actual
| ||||
mnUnitPriceInDomestic | FUP | MATH_NUMERIC | NONE | NONE |
The foreign price per unit. | ||||
cCurrencyConversionFlag | CRYR | char | NONE | NONE |
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use:
Codes are:
N Do not
| ||||
szPurchasingUom | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szUoMOfRowSelected | UOM | char | NONE | NONE |
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box). | ||||
szCurrencyOfRowSelected | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
szErrorMessageID | DTAI | char | NONE | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
cSuppressErrorMessage | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnExchangeRate | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
mnConvFactorTransToPurch | CONV | MATH_NUMERIC | NONE | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
mnConvFactorPurchToPrimary | CONV | MATH_NUMERIC | NONE | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
mnUnitPriceInDomPerPurchUoM | PRRC | MATH_NUMERIC | NONE | NONE |
The unit cost of one item, as purchased from the supplier, excluding freight,taxes, discounts, and other factors that might modify the actual
| ||||
mnUnitPriceInForPerPurchUoM | FUP | MATH_NUMERIC | NONE | NONE |
The foreign price per unit. | ||||
mnShortItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
szLotNumber | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
cPurchaseLevelPrice | PPLV | char | NONE | NONE |
A code that indicates where to retrieve the purchase price for an item when you enter a purchase order. Valid codes are:
1 Use the
| ||||
cInventoryCostlevel | CLEV | char | NONE | NONE |
A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a
| ||||
cCostOverrideCode | CSTO | char | NONE | NONE |
A code that specifies whether the change order is a terms only change. For those organizations that elect to view subcontracts on a
| ||||
mnTriangulationRate1 | TRR1 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate used to convert the From currency code to the Triangulation currency code. | ||||
mnTriangulationRate2 | TRR2 | MATH_NUMERIC | OPT | NONE |
The triangulation currency rate that used to convert from the Triangulation currency code to the To currency code. | ||||
cCurrencyConversionMethod | CRCM | char | OPT | NONE |
A value that specifies which method to use when converting from one currency to another. Valid values are:
Y
Multiplier method. The
| ||||
szSecondaryUOM | UOM2 | char | OPT | NONE |
A user defined code (00/UM) that indicates an alternate unit of measure for the item. | ||||
mnSecondaryQty | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. |
B0000027 CurrencyConvForAndDom | ||||
B4000530 Get Distribution Constants | ||||
XF4105 Item Cost I/O |
F4101 Item Master | ||||
F4105 Item Cost File | ||||
F41061 Supplier Price/Catalog File | ||||
F4209 Held Orders |