Access 2000 inventory template

[Adan]

I'm working on a project and have very agrewssive time restrains so don't
have time to create from scratch. I need an access 2000 database template
for inventory planning. The data base will have products and Min and Max
levels that vary for each of our warehouses. I need it to lookup available
and in-transit qtys for each product at each warehouse from 2 excel sheets
that will be posted daily, one sheet has the available qty and the other the
in-transit qty for each product at wach warehouse. Based on the available +
in-transit qty, the database will create a re-stocking report to list every
product that is at or below min and the re-order qty to bring it up to max.
I need it to also lookup the available qty at our distribution center from
another excel sheet and identify which replenishments orders can or cannot be
filled. Is there any place where I can find a template that will at least
have some of the ground worj already done for this database?

 

[M.L. Sco Scofield]

Adan,

For 2000 templates, go to
http://office.microsoft.com/en-us/templates/CT102144001033.aspx?av=ZAC000.


For 2003 templates, go to
http://office.microsoft.com/en-us/templates/CT101426031033.aspx?av=ZAC000,


Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, A+, Access MVP 2001 - 2005
Denver Area Access Users Group Past President 2006/2007 www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
This email made with 100% recycled electrons!
Miscellaneous Access "stuff" at www.ScoBiz.com