Functional Description
Purpose
To determine if a record being written to the Item Cost file should be written with an I in the
inventory cost selection field and/or a P in the purchasing cost selection field.
Technical Specification
Retrievals:
1.) Check for Inventory Costing Method Record
Call the business function GetItemCost (B4000440.C) to retrieve the cost for the location
passing
the following as parameters:
CostingSeleciton = I
ItemNumber= the ItemNumber passed to this function
Branch= the Branch passed to this function
Location= the location passed to this function
Lot= the lot passed to this function
CostLevel= the Level Inventory Cost field form the Item
Master (F4101) recrod passed to this function
You will need to keep track of the fact of whether GetItemCost found a F4105 record or not.
2.) Check for Purchasing Costing Method Record.
Call the business function GetItemCost (B4000440.C) to retrieve the cost for the location
passing
the following as parameters:
CostingSeleciton = P
ItemNumber= the ItemNumber passed to this function
Branch= the Branch passed to this function
Location= the location passed to this function
Lot= the lot passed to this function
CostLevel= the Level Inventory Cost field form the Item
Master (F4101) record passed to this function
You will need to keep track of the fact of whether GetItemCost found a F4105 record or not.
3.) If CostingLevel from the Item Master record is a 1 -
If the Inventory Costing Method Record was not found
AND the CostMethod passed into this function is equal to the Data Dictionary Default
Inventory Cost Method****
Move an I to InvCostSelection
If the Purchasing Costing Method Record was not found
AND the CosMethod passed into this function is equal to the Data Dictionary Default
Purchasing Cost Method***
Move a P to PurchCostSelection
ELSE (meaning the cost level was a 2 or a 3 )
If the Inventory Costing Method Record OR the Purchasing Costing Method Record was not found
Retrieve the Branch/Plant Constants (F41001) record for the Branch passed in.
If the Inventory Costing Method Record was not found
AND the CostMethod passed into this function is equal to the Inventory Cost Method from
the Branch/Plant record
Move an I to InvCostSelection
If the Purchasing Costing Method Record was not found
AND the CosMethod passed into this function is equal to the Purchasing Cost Method from the
Branch/Plant record
Move a P to PurchCostSelection
*** You will need to retrieve the data dictionary records for these data dictionary items. There are
API's to do this in JDEDDAPI.H
Returns:
1.) The InvCostSelection and the PurchCostSelection
^
D4000480 - Determine Cost Selection
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
idItemRecord | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
mnItemNumber | 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
| ||||
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
| ||||
szLocation | LOCN | char | NONE | NONE |
The storage location from which goods will be moved. | ||||
szLot | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
szCostMethod | LEDG | char | NONE | NONE |
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards
| ||||
cInvCostSelection | CSIN | char | NONE | NONE |
Internal field used to indicate that a cost record is the inventory costing method selected. For example, if the inventory costing method is
| ||||
cPurchCostSelection | CSPO | char | NONE | NONE |
Internal field used to indicate that a cost record is the purchasing costing method selected. For example, if the purchasing costing method
|
B4000150 Get Branch Constants | ||||
XF4105 Item Cost I/O |
F4101 Item Master |