Inventory Database

[pkfloyd]

I am looking to create a database which will keep track of a warehouse
inventory as well as inventory on sales trucks and track customer sales. Want
to link tables so that totals are linked when inventory is transferred to
trucks the warehouse inventory reflects this transfer. Also truck inventory
to reflect custormer sales. Any suggestions as to what type of tables, forms,
querys and relationships I should create would be helpfull. Thank you in
advance for your help.

[ruralguy via AccessMonster.com]

Re: Inventory Database

Maybe a Microsoft template would be the place to start.

http://office.microsoft.com/en-us/templates/TC010184581033.aspx?pid=CT101426031033

pkfloyd wrote:

>I am looking to create a database which will keep track of a warehouse
>inventory as well as inventory on sales trucks and track customer sales. Want
>to link tables so that totals are linked when inventory is transferred to
>trucks the warehouse inventory reflects this transfer. Also truck inventory
>to reflect custormer sales. Any suggestions as to what type of tables, forms,
>querys and relationships I should create would be helpfull. Thank you in
>advance for your help.

--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200810/1

[Roger]

Re: Inventory Database

On Oct 6, 10:10 am, "pkfloyd" <u46723@uwewrot e:

I am looking to create a database which will keep track of a warehouse
inventory as well as inventory on sales trucks and track customer sales. Want
to link tables so that totals are linked when inventory is transferred to
trucks the warehouse inventory reflects this transfer. Also truck inventory
to reflect custormer sales. Any suggestions as to what type of tables, forms,
querys and relationships I should create would be helpfull. Thank you in
advance for your help.

create tables
tblWarehouse
warehouseId
warehouse

tblInventory
itemId
description
cost
sellPrice
baseQty
etc

tblInventoryDet ail
itemId
warehouseId
qtyOnHand


so tblWarehouse will be
1 main
2 truck 1

tblInventory will be stuff you buy and sell

when you create purchase and sales orders, on the detail table you
need to capture both the warehouseId and the itemId

and when you receive / ship goods, you update the qtyOnHand in
tblInventoryDet ail accordingly

and then you'll need an inventory transfer function to move inventory
between warehouses