F41112 -ASOF 1 Item with 2 GL class

Hi All,
In my ASOF Table F41112 for 1 item it have 2 GL class one of the GL class is the wrong one. SO isn't any thing that I can do in order to solve this problem? Thanks in advance...

Eric,

The F41112 table is built from the F4111.
If you have a record in there for an item that has a GL Class that is incorrect, there will be a transaction in the F4111 table with the incorrect GL Class.

Two options potentially:
1) Reverse out the incorrect inventory transaction(s) using the old incorrect GL Class and value, then re-enter using the correct GL Class & value. This should zero out the wrong GL Class quantity and the F41112 table, after being rebuilt, will only have a zero quantity / cost for the wrong GL Class.

2) Consider using SQL to change the GL Class value in the F4111 record(s). Need to analyse any impact on accounting or other reports that may use the GL Class. After changing the value you will need to rebuild the F41112.

Regards,

Adrian