Inventory On SO totals on Main and Inquiry - different?

[rainxking]

The numbers on my Main tab in Inventory Inquiry are not matching up with the totals I get on the Inquiry tab (after hitting the ckeck box for on SO)

I know the numbers on the inquiry tab are correct.

I analyzed, relinked, rebuilt and resorted my SO, PO, AR, AP and Inventory header, detail, UDF and few other table types...

Still not matching up.

Anyone know how to fix? What happened? How to stop from happening again?

Thanks

 

[BigLouie]

Normally you will see this with Kits. If you explode the kits then the Kit itself is not counted as being on sales order but if you go to the inquiry tab you will see sales orders listed.

Also if you have any custom modifications it may not be updating the field in IM2 correctly.

 

[rainxking]

I found it. What happened is that there is a VI job that runs in 2 parts. The 2nd part was adding the qty twice to SO 2.

I rebuilt and recalculated SO2 (for some reason I had to do it 3 times - maybe I missed a step, it was late...)

Once I did that, everything lined up again.