Error in PartWhse table

Yahoo Archive
1
Thanks, Darren.
Never thought to look in the Conversion Programs.
Thank you!



----- Original Message ----
From: Darren Giordano <scubadoobydootoo@...>
To: vantage@yahoogroups.com
Sent: Monday, June 23, 2008 10:18:54 AM
Subject: Re: [Vantage] Error in PartWhse table


From the Admin tools you should be able to run conversion program
6430 - Recalculate Part Onhand/Allocation summaries to clean that up.

I have run into negative allocation from time to time.

Darren Giordano
PACE Worldwide


----- Original Message ----
From: Tony Hughes <thughes281@yahoo. com>
To: vantage@yahoogroups .com
Sent: Monday, June 23, 2008 9:58:07 AM
Subject: [Vantage] Error in PartWhse table

There is showing a negative in the salesallocqty field of partwhse for a certain part.
Data defs show that field as a sum of partalloc records, but there are no records at all in that table.

Besides wondering how it got there, I need to restore it to zero.
Other than just opening the table and entering 0, is there a "better" way?

Before I report it as a bug, is a negative allocated quantity possible? I can't think of a reason.

Thanks

[Non-text portions of this message have been removed]






[Non-text portions of this message have been removed]
2
There is showing a negative in the salesallocqty field of partwhse for a certain part.
Data defs show that field as a sum of partalloc records, but there are no records at all in that table.

Besides wondering how it got there, I need to restore it to zero.
Other than just opening the table and entering 0, is there a "better" way?

Before I report it as a bug, is a negative allocated quantity possible? I can't think of a reason.


Thanks
3
From the Admin tools you should be able to run conversion program
6430 - Recalculate Part Onhand/Allocation summaries to clean that up.
Â
I have run into negative allocation from time to time.
Â
Darren Giordano
PACE Worldwide
Â



----- Original Message ----
From: Tony Hughes <thughes281@...>
To: vantage@yahoogroups.com
Sent: Monday, June 23, 2008 9:58:07 AM
Subject: [Vantage] Error in PartWhse table


There is showing a negative in the salesallocqty field of partwhse for a certain part.
Data defs show that field as a sum of partalloc records, but there are no records at all in that table.

Besides wondering how it got there, I need to restore it to zero.
Other than just opening the table and entering 0, is there a "better" way?

Before I report it as a bug, is a negative allocated quantity possible? I can't think of a reason.

Thanks






[Non-text portions of this message have been removed]