E1: 42: 49: Ship Confirm P4025 with In-Transit Entries Active Causes Imbalance Between Cardex F4111 and General Ledger F0911 (Doc ID 3062029.1)

Last updated on DECEMBER 04, 2024

Applies to:

Symptoms

When P4205 (Ship Confirm ) application is set to write In-Transit journal entries (type TI), and multi-location (P42053) selection is used to change the inventory commitment location and quantity shipped, P4205/P42053 creates additional journal entry records with incorrect values resulting in imbalance in the Cardex (P4111) and General Ledger (P0911) transactions.
 
STEPS TO REPRODUCE: 

1. A lot controlled item is used in a sales order line for 10 EA. P4205 is configured to use the In-Transit JEs, found on options 12 and 13 of the Process tab.
2. Ship Confirm P4205 is launched and the user opts to do a Multiple Location confirm. By default, the P42053 Multi Location form populates the 10 EA against the first lot it finds.
3. A second lot/location is also available, and the client selects this, manually changing the qty to 1 EA in the 'Quantity' field. Ship confirm is completed.
4. An In-transit document (type TI) is created; this shows records with 10 / -10 as the quantity in the UNITS field. This entry is unexpected as only 1 EA was confirmed (validated by the Cardex record for the TI doc). Records do also exist for the 1 EA actually confirmed.
   
   

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.