Discrepancy between OE Open Orders and IC location

[rdingman]

Our system is V5.3 running on DB2.

We noticed that an item in the Location table has an order quantity of 480 but when searching the open order file directly via MS Access, there is no order(s) for this item.

The item in question is a raw material and normally wouldn't be placed on a sales order. We think it has been entered in error and then corrected.

Database integrity was run and it showed this item as an error. "Fix minor errors" was chosen but the problem still exists.

Help please?

 

[ettienne]

Did you run the integrity check on IC or OE?

 

[rdingman]

We ran it for all modules.

 

[ettienne]

OE integrity check will fix those errors, it first removes all SO qty's from IC, then runs through all the SOs and adds the qty on SO back to IC.

 

[rdingman]

Just to confirm, I ran integrity check/fix on all modules, but you are suggesting I should run it for OE only?

 

[ettienne]

I'm just stating a fact...

 

[rdingman]

Ok, we will try rerunning it when the users are off and see what happens.

I was just trying to determine if there is specific procedure (i.e. only run data integrity on one module at a time). Otherwise, it should have done what you stated but didn't.