Vantage 6.10 PartBin table

Yahoo Archive
1
You can run a trace to see when it gets populated if that's required.
But the on hand quantities are indeed stored in the PartBin and not in
the PartLot table. PartLot only shows a flag as to whether or not the
material is on hand but doesn't keep the quantities. PartTran shows all
the transactions in (PO receipts, job receipts, etc) and out (issue to
job, shipments, etc) of the bin with transaction quantities but again
not the remaining on hand qty. These transactions increase or decrease
the on hand qty in the PartBin table. But overall, PartBin is the main
inventory table and lot number is one of the key fields. Your Stock
Status report is coming from PartBin, if that helps.



What are you trying to get?



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sheehanam21
Sent: Monday, May 21, 2007 6:01 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 6.10 PartBin table



Does anyone know how the on hand quantity column gets populated in
this table. I do not believe it is only the PartLot table or the
PartTran table.

Thanks,
Tony

This is an e-mail from Saab Barracuda LLC. It is for the intended recipient only and may contain confidential and privileged information. No one else may read, print, store, copy, forward or act in reliance on it or its attachments. If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.

###########################################

This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.f-secure.com/

[Non-text portions of this message have been removed]
2
Does anyone know how the on hand quantity column gets populated in
this table. I do not believe it is only the PartLot table or the
PartTran table.

Thanks,
Tony