Bogus pending orders

[Steve Cookinham]

Some of my Items show various quantities in the grayed-out (uneditable) "on
order" section of the Inventory tab. I can find no open purchase orders
from whence this information should be coming. I did a "show all" in
Purchase Orders and went back to the day in May 2006 when we first turned on
the system and no joy. So far I have tried:

- Editing an old PO and attempting to place a negative quantity in the order
field. The best it will do is change to zero.

- Reindexing

- Running the check database utility. This produced the singularly
unhelpful message that if it showed any errors (Where? Under what filename?)
I should contact my system administrator.

How could the system get into such a state - and how can I get out of it?

Thanks
Steve

 

[Jeff]

Steve,

Here's a KB article on how to fix it;
http://tinyurl.com/hftcu

Backup First !!!


Must have access to CustomerSource



Some of my Items show various quantities in the grayed-out (uneditable) "on
order" section of the Inventory tab. I can find no open purchase orders
from whence this information should be coming. I did a "show all" in
Purchase Orders and went back to the day in May 2006 when we first turned on
the system and no joy. So far I have tried:

- Editing an old PO and attempting to place a negative quantity in the order
field. The best it will do is change to zero.

- Reindexing

- Running the check database utility. This produced the singularly
unhelpful message that if it showed any errors (Where? Under what filename?)
I should contact my system administrator.

How could the system get into such a state - and how can I get out of it?

Thanks
Steve

 

[Steve Cookinham]

Great, that looks like my issue exactly. I'll try it tonight after hours.
Thanks for the information.