Distribution - JDE1 (MOSC)

MOSC Banner

IL/AS OF Integrity issue due to company split

edited Aug 22, 2015 10:02AM in Distribution - JDE1 (MOSC) 1 commentAnswered

Hi,

While doing the Historical clean of of IL vs AS OF i have come across a scenario which requires immediate attention.

Issue details:

Earlier we had company 01001(Norway) where we had transaction for Fuel as well as Lubes items. Later on it was decided that there should be a separate company for Lubes so split happend and 01002(Norway- Lubes) was created and then for Lubes items all the transaction have been happening in 01002 company.

Recently i have run the R41760 IL vs AS OF report for 01002(Norway Lubes) company and the report showed below integrity:

AS OF is showing 0 in Quantity and 177.04 in Amount for FY 14/Period 11 but item Ledger is showing -2 Quantity and -5387.06. When i dig deeper into this by checking the item ledger(Item/BP/Location), here is the item ledger screen shot for FY14 period 11

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center