How to change quantity in Item ledger

[ica]

Hi

we found a deviation for Quantity between Item ledger(P4111) and an order created in Sales Order (P4210)

Additionally, the order also completed Ship confirm process in JDE.

However the qty in P4111 and P4210 aren't same. the qty of P4111 has wrong qty values.

how can we change the qty values of P4111 without any modification of Database?

Thank you

Regards

Ica

 

[RHandDW]

For audit purposes the cardex (item ledger) is not allowed to be edited. First though I have to make sure you are comparing "SDSOQS" from the F4211 for records "that have shipped AND relieved inventory" which means the SDADDJ field has a date and the SDSO02 has a "1". In that case, the SDSOQS should match the ILTRQT. This also assumes someone did not change the Unit of Measure at shipping. The cardex always records in the transaction UOM (ILTRUM) and not always in the order UOM.

If all the above is OK then you will have to decide on a process to add (I would not update the existing record) an adjustment record to the cardex usually via SQL. This should not be a regular process so you should not create an custom application since that will impact your audit control.

Again, this should not normally happen and if it is you have to figure out why.