WS: 41: P41052 Batch with Multiple ICLV 1 Items in Multiple Branch Plants Will Not Post due to Error ‘At Least One Document Is Out of Balance‘
Last updated on FEBRUARY 27, 2018
Applies to:JD Edwards World Inventory Management - Version A9.4 and later
Information in this document applies to any platform.
In a situation where there are multiple Inventory Cost Level 1 items that are held in multiple Branch Plants, when running the P41052 to update the current cost with a future cost, the batch is out of balance and will not post. This appears to be due to how the system is writing the journal entries related to the 4172 & 4174 DMAAIs.
You are getting error message "At Least One Document Is Out of Balance" when attempting to post a batch related to the P41052 - Future Cost Update. The P41052 was run over items with Inventory Cost Level 1 that have quantity in multiple branch plants which results in a separate document number for each branch (MCU) being created within this one Batch. The debit created by the 4172 DMAAI is writing to each branch specific document correctly, but the credits created by the 4174 DMAAI are all written to the 3rd document number, as opposed to each document having the 4172 debit and 4174 credit for each branch.
Within each item, it 'breaks' on Branch Plant to create a new document number. However, the first and second documents (1 each for the first 2 BPs) contain only the journal entry for the 4172 AAI. The third document also contains the journal entry for the 4172 AAI for the 3rd Branch Plant but also contains the 4174 AAI journal entries for all 3 Branch Plants (all 3 documents) for this first item. This repeats for each item in the batch.
Note: In prior releases where the new Post program P09870 did not exist, this batch would post without error. Now in a release (A9.4QA) where the P09870 exists, this batch will not post.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms