Item Cost and Price Update using XT4111Z1

Purpose of Document

In EnterpriseOne, some applications which are related with inventory transaction may update Cost and Price information. Unlike writing Average Cost, this type of transaction may take place. So this document is to explain what are the list of applications which may (or may not) write Cost and Price information.

Q1> What are the list of application which are applied to this routine and metrics for update of cost and price?

Action	Application	Write Cost	Write Price	Update Cost	Others
1	P4114 - Inventory Adjustment	Y	Y	Y
2	P4112 - Inventory Issue	Y	Y	Y
3	P4113 - Inventory Transfer	Y	Y	Y
12	P4116 - Item Reclassification	Y	Y	Y
4	P4312 - PO Receipts	Y	Y		In Receipt
4	P43214 - PO Receipt Reversal	Y	Y		In Receipt
4	P43253 - Routing Disposition	Y	Y		In Receipt
4	P43250 - Receipt Routing Movement and Disposition	Y	Y		In Receipt
15	P4312 - PO Receipts	Y	Y		In Routing
15	P43214 - PO Receipt Reversal	Y	Y		In Routing
15	P43253 - Routing Disposition	Y	Y		In Routing
15	P43250 - Receipt Routing Movement and Disposition	Y	Y		In Routing
5	P4205 - Shipment Confirmation
13	R42800 - Sales Update
6	R41413 - Cycle Count Update	Y	Y	Y
7	R41610 - Tag Inventory Update	Y	Y	Y
8	P4242 - Transfer Order	Y	Y
10	P31113 - Work Order Inventory Issue	Y	Y		Issue
11	P31114 - Work Order Completion	Y	Y		Completion
14	P4205 - Shipment Confirmation				Serial Processing
14	R42800 - Sales Update				Serial Processing
17	Transportation Compartment Based Load
19	Manufacturing Accounting Records				Update F4111 only
20	DFM - Completion	Y	Y		Demand Flow Manufacturing
21	DFM - Issue	Y	Y		Demand Flow Manufacturing

Note:

Integer value at column Action has 1 to 1 relationship with application for easier grouping of applications
Column for Write Price is not implemented yet
To write price file in calling XT4111Z1 - F4111EditLine flag F41UI001.ITAPRI (AddBasePriceRecord - Add Base Price Record) has to be set '1 - Add Base Price Record)
In running above applications, this flag is not be set '1' so based price may not be added let alone some of above transactions do not deal with item price

Q2> What is the Business Function which handles Cost and Price Add/Update?

Above routine is handled by XT4111Z1 - F4111EditLine

Q3> Does it add cost information so long as above listed applications are running?

No. It is working conditionally,

Condition 1: F4105 - Item Cost does not have data meet Item/Branch/(Location/Lot) (F4105 does not have a record for combination of item/branch (and location/lot) depending on cost level defined in item master)
Condition 2: Costing Method Method (F4105.LEDG) is not 07 - Standard Cost

Condition 3 - F4101.CLEV (Cost Level is 1 - Item Only or 2 - Item/Branch Only)

F4101.SRCE - Lot Process Type is 'Space' or 'Blank' or NULL
OR (Input Lot Number is Not Blank AND Lot Number is Not Blank)
OR Lot Process Type is 2 - Lots Assigned with Next Number

Condition 4 - F4101.CLEV (Cost Level is 3 - Item/Branch/Location/Lo )

F4101.CLEV (Cost Level) is 3 - Item/Branch/Location/Lot
AND (F4101.SRCE is Not Blank AND Input Lot Number is Blank)

Only when "Write Cost" is 'Y' and meets above condition(s) then it write a new record into F4105 - Item Cost File

Q4> When does it Write Price (F4106 - Item Base Price File)?

Only when it meets below condition it write a new record into F4106 - Item Base Price File,

Condition 1 - In calling F4111EditLine (F4111 Edit Line) Flag F41UI001.ITAPRI has to be '1' but there is no implementation for this yet
Condition 2 - F4101.PLEV (Sales Price Level) is 2 - Item/Branch Only OR 3 - Item/Branch/Location/Lot
Condition 3 - F4106 does not have Price Information for input Item/Branch/(Location/Lot) combination
Condition 4 - Application ID meets above metrics

Q5> Then when does it update item cost into F4105 - Item Cost File?

When it meets below conditions,

Application ID meets above metrics
F4105.LEDG (Costing Method) is "06 - Lot"
cUpdateUnitCost Flag in calling F4111EditLine is '1 - Update Cost'

Q6> In copying existing application P4112 into P554112 will same functionality retained?

Yes it will retain same functionality as it determined by how BSFN F4111EditLine gets called

Q7> What are the list of applications which add/update Average Cost?

List of applications defined in UDC(40|AV) or UDC (40/AV) - Average Cost Calculation. So long as Description 02 (F0005.DL02) is defined 'y' or 'Y' it shall update Average Cost. On Average Cost refer <Document 625564.1> E1: 41: Weighted Average Cost.

For easier comparison here repeats list of applications,

Codes	Description 01	Description 02
ND3N4113	DSI Inventory Transfers	Y
ND3N4114	DSI Inventory Issues/Adj.	Y
ND3N4205	DSI Ship Confirmation	Y
ND3N4309	DSI Receipt Routing	Y
ND3N4312	DSI PO Receipts	Y
P31114	Completions	Y
P41014	Speed Item Setup	Y
P4112	Inventory Issues	Y
P4113	Inventory Transfers	Y
P4114	Inventory Adjustments	Y
P4116	Item Reclassifications	Y
P41801	Future Cost/Price Update	Y
P41810	Recompute Average Cost	Y
P4205	Shipment Confirmation	Y
P42800	Sales Update	Y
P4312	Purchase Order Receipts	Y
P4314	Purchase Order Match	Y
P43214	Reverse Purchase Order Receipt	Y
P43250	Receipt Routing Movement	Y
P43253	Receipt Routing Disposition	Y
P43291	Landed Cost Selection	Y
R30837	WIP Revaluation	Y
R31804	Manufacturing Variances	Y
R41413	Cycle Count Update	Y
R43092Z1I	Routing Interoperability	Y
R47071	EDI-Rec Advise Purchasing	Y
R47121	EDI Product Activity Data	Y
R4981	Freight Update	Y
R76B804	Process Taxes in Receipt File	Y
X4617	WMS Confirmation Server	Y

Note:

Do not add additional application as it may not update average cost a certain application is not calling XT4111Z1 - F4111EditLine. For example, though you add P4210 in the list, which won't update Average Cost
There is no validation logic for Description 01
Average Cost will get update only when cUpdateAverageCost paramter is '1' in calling F4111EditLine. So in case there is issue in updating average cost, capture jdedebug.log and look into this flag

Disclaimer: Oracle will not be responsible for the changes made based on this document and contents may be changed without having prior notice

To discuss information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the JDE1 Distribution Community.

To look at upcoming or archived Advisor Webcasts please see Advisor Webcast Details (Doc ID 548764.1) if your topic is not currently scheduled please suggest it.