Document Number for a Manual SQL in Cardex

[dhihasa]

Hi List,

We have an issue where we need to pass a manual SQL in the cardex to correct an integrity issue between the cardex and availability. What document number do we use in such cases? What are the options we have?

Thanks in advance.

Regards
Dhihasa

 

[TNDave]

Is this an audit issue where you need to have the transaction in the cardex? If not, and you are just looking to sync the F41021 with the F4111 cardex, then I might suggest updating the F41021 to match the cardex, and then post a PI transaction to match JDE with the physical inventory, which will update both the availability and the cardex.