Primary bin for a warehouse, what table is this stored in?

Yahoo Archive
1
PartBin

--- On Thu, 4/23/09, Tony Hughes <thughes281@...> wrote:

From: Tony Hughes <thughes281@...>
Subject: [Vantage] Primary bin for a warehouse, what table is this stored in?
To: vantage@yahoogroups.com
Date: Thursday, April 23, 2009, 10:37 AM









on Part master, Plants tab, Warehouses tab, Detail tab, you see the drop down for the Primary Bin for the part.
If you customize the form, the PrimBinNum is part of the PartWhse dataset, but I dont' see any fields in PartWhse table that have bin numbers in them.

Where is the data stored? thank you!
2
on Part master, Plants tab, Warehouses tab, Detail tab, you see the drop down for the Primary Bin for the part.
If you customize the form, the PrimBinNum is part of the PartWhse dataset, but I dont' see any fields in PartWhse table that have bin numbers in them.

Where is the data stored? thank you!
3
PlantWhse



Rob Bucek

Manufacturing Engineer

PH: 715-284-5376 ext 311

FAX: 715-284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site)



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Tony Hughes
Sent: Thursday, April 23, 2009 9:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Primary bin for a warehouse, what table is this
stored in?






on Part master, Plants tab, Warehouses tab, Detail tab, you see the drop
down for the Primary Bin for the part.
If you customize the form, the PrimBinNum is part of the PartWhse
dataset, but I dont' see any fields in PartWhse table that have bin
numbers in them.

Where is the data stored? thank you!





[Non-text portions of this message have been removed]
1 Like
4
> on Part master, Plants tab, Warehouses tab, Detail tab, you see the drop
> down for the Primary Bin for the part.
> If you customize the form, the PrimBinNum is part of the PartWhse dataset,
> but I dont' see any fields in PartWhse table that have bin numbers in
> them.
>
> Where is the data stored? thank you!

It is stored in PlantWhse. The reason being, each plant could have a
different default bin for a particular part number.

Mark W.