If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access 2000 inventory template
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? |
#2
|
|||
|
|||
Access 2000 inventory template
Adan,
For 2000 templates, go to http://office.microsoft.com/en-us/te...aspx?av=ZAC000. For 2003 templates, go to http://office.microsoft.com/en-us/te...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 "Adan" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|