Implication of Bug 25920841/25913248 - Changes Foreign Key in F4111.JELN

Goal

This document describes the implication of <Bug 25920841> - P4112 IS NOT PROPERLY RECORDING JELN IN F4111 WHEN ISSUING MULTIPLE LINES and <Bug 25913248>: P4112 IS NOT PROPERLY RECORDING JELN IN F4111 WHEN ISSUING MULTIPLE LINES in EnterpriseOne Application Release 9.1 and 9.2.

The application of this Bug will change the way it sets F4111.JELN (Item Ledger. Journal Entry Line Number).

Before this bug: F4111.JELN = the first line of the associated F0911.JELN (i.e., Object of DMAAI 4122, which is Inventory Account)
After this bug: F4111.JELN = the last line of the associated F0911.JELN (i.e., Object of DMAAI 4124, which is Expense/Cost)

DMAAI Settings
Representation in P4112 (Inventory Issue)
Data Representation from F4111
Data representation from F0911 - No change
Reversal Inventory Issue when
Workaround
Summary

Supposing that there is a single line of F4111, the JELN gets assigned as below,

P4112 - Inventory Issue
   |--- F4114EditLine
     |--- F4111EditLine
     |--- 1. Get Account on DMAAI 4122
     |--- 1. F0911FSEditLine > Assign JELN 1.0 for F0911
     |--- 2. Get Account on DMAAI 4124
     |--- 2. F0911FSEditLine > Assign JELN 2.0 for F0911
     |--- 3. Assign JELN for F4111 based on actual JELN assigned to F0911
     * Before this bug: F4111.JELN = 1.0, 3.0, 5.0, and so forth (Odd Numbers).
     * After this bug: F4111.JELN = 2.0, 4.0, 6.0, and so on (Even Numbers).

Note:

Across document, the data dictionary alias JELN is used to describe Journal Entry Line Number. JELN in F0911 is a member of the primary key of F0911, and JELN in F4111 is a member of Foreign Key. This foreign key is used to read data from F0911
The bug in this document, synchronize the account information between F4111 and F0911 where the relationship between F4111 to F0911 is 1 : 2, or 1 : 4
There no standard option to correct F4111.JELN
This bug affects both P4112 and XT4111Z1
- After: P4112 does not add ( F4111.JELN + 1 ) to get corresponding cost object from F0911 and XT4111Z1 assigns F4111.JELN the last JELN of F0911

Solution

Mainly you shall experience two issues below,

P4112 shows the inventory account, not an expense account
Reversal of Inventory issue will cause a mismatch between Inventory and Expense Account

DMAAI settings

DMAAI 4122 Inventory

Co	Do Ty	Description	G/L Cat	Description G/L	Branch Plant	Obj Acct	Sub
00200	II	Inventory Issue	IN30	Manufactured Finished Goods	200	1411

DMAAI 4124 - Expense/COGS

Co	Do Ty	Description	G/L Cat	Description G/L	Branch Plant	Obj Acct	Sub
00200	II	Inventory Issue	IN30	Manufactured Finished Goods		6310

Note that this document assumed a user enter the costing account manually through P4112. However, the outcome described below are same whether you populate account number manually or through master function.

Representation in P4112 (Inventory Issue)

: Transaction was performed before this bug and reviewing data after bug.

The processing option values of P4112|Version,
- (Tab) Process
- Item #2. Account Number = 1 (Required) to enable a user to enter Account Number
In add mode, a user enters GC Account Number M30.6310

Representation of Account Number when the transaction was done before ESU - GC Account Number is Inventory account.

Item Number	Quantity	Extended Amount	Account Number
210	-1	-530.1	200.1411
220	-1	-2271.54	200.1411

: User has entered the account number with M30.6310, but P4112 shows its offset inventory account (not cost account). This issue is related with how to get account information from F0911 (General Ledger) using the primary key of F0911 on the foreign key of F4111. Before applying this bug, P4112 adds 1 (e.g, New JELN = Old JELN + 1)

Representation of Account Number for a newly added transaction with the bug

Item Number	Quantity	Extended Amount	Account Number
210	-1	-530.1	M30.6310
220	-1	-2271.54	M30.6310

: There is no manipulation of JELN in P4112 so Account Numbers shown in the Grid is same account number user has entered.

Data Representation from F4111

Before - Inventory Issue was performed without this bug

2nd Item Number	F T	Doc Co	Document Number	Do Ty	JE Line Number	G/L Date	G/L Cat	Transaction Explanation	Trans Ref
210	F	00200	1500003	II	1.0	01/18/15	IN30	Inventory Issue	1000
220	F	00200	1500003	II	3.0	01/18/15	IN30	Inventory Issue	3000

: F4111.JELN is written based on the first line of F0911.JELN

After - Inventory Issue is performed with this bug

2nd Item Number	F T	Doc Co	Document Number	Do Ty	JE Line Number	G/L Date	G/L Cat	Transaction Explanation	Trans Ref
210	F	00200	1800003	II	2.0	01/18/18	IN30	Inventory Issue	1000
220	F	00200	1800003	II	4.0	01/18/18	IN30	Inventory Issue	3000

: F4111.JELN follows the last F0911.JELN. So P4112 does not need to manipulate JELN to pull cost object for issued inventory.

Data representation from F0911 - No change

: There is no change in writing F0911 with or without this bug.

Before - without having this bug

Doc Co	Do Ty	Document Number	G/L Date	JE Line Number	Account Number
00200	II	1500003	1/18/2015	1	200.1411
00200	II	1500003	1/18/2015	2	M30.6310
00200	II	1500003	1/18/2015	3	200.1411
00200	II	1500003	1/18/2015	4	M30.6310

After - with this bug

Doc Co	Do Ty	Document Number	G/L Date	JE Line Number	Account Number
00200	II	1800003	1/18/2018	1	200.1411
00200	II	1800003	1/18/2018	2	M30.6310
00200	II	1800003	1/18/2018	3	200.1411
00200	II	1800003	1/18/2018	4	M30.6310

Reversal Inventory Issue when

The original transaction was performed without this bug
Its reversal is done with this bug

Before reverse - Representation in P4112 (or, F4111)

Item Number	Account Number	Quantity	UM	Extended Amount
210	200.1411	-1	EA	-266.14

After reverse (F4111 offset the original line - OK)

Item Number	Account Number	Quantity	UM	Extended Amount
210	200.1411	-1	EA	-266.14
210	200.1411	1	EA	266.14

Before reverse - representation in P0911 (or, F0911)

Account Number	JE Line Number	Amount
200.1411	1	-266.14
M30.6310	2	266.14

After reverse - Both debit and credit point inventory account - NOT OK

Account Number	JE Line Number	Amount
200.1411	1	-266.14
M30.6310	2	266.14
200.1411	3	266.14
200.1411	4	-266.14

Workaround

Issue 1 - P4112 shows inventory account which is different from what the user has entered: This is caused by F4111.JELN. There is no standard method to correct this behavior. In case, this behavior disrupts your daily transaction, update F4111.JELN after adding 1 (to point to Cost Account) using query tool. Possibly you may inform the end-users that there is change in functionality of fetching the account number.
Issue 2 - The reversal of II transaction using P4112 not creating reversal entry in GL correctly: Do not make use of the functionality "reversal" when the data from F4111 is created before the bug fix is applied. In case restore the quantity and cost for the issued item, offset it manually by entering negative entry using P4112.

It is important to set the cutoff date (the date you deployed the ESU containing this bug) in case you are planning to apply the ESU for this bug and document it well not to have the issue described in this document.

Summary

Before this <Bug 25920841> P4112 IS NOT PROPERLY RECORDING JELN IN F4111 WHEN ISSUING MULTIPLE LINES:

In XT4111Z1, set F4111.JELN = 1.0
In P4112, add new (JELN = F4111.JELN + 1 ) to reads F0911 on F0911.JELN = F4111.JELN (so, 1st. Read F4111.JELN = 1, 2nd. Add 1, 1 + 1 = 2, 3rd, read F0911 on JELN = 2 )

After this bug:

In XT4111Z1, set F4111.JELN = 2.0
In P4112, read F0911 on F0911.JELN = F4111.JELN