Käynnissä

Access Inventory Template

I need a Access database template for an inventory control system.

General Description

I have multiple storage locations (3 warehouses) which dispatch items to different areas (about 11) all within the same building and network. The system should work something like this. The different area request the items and amount (must be able to request as eaches or shipper) via Access, the request arrives to the storage location only if it stores that item. After getting the request the storage locations dispatches the items at which time they get subtracted from the system which tracks the quantity available. If the available quantity goes below minimum order amount the item owner (each item has needs primary and secondary owner) should receive an email (we use Outlook) indicating that the item and quantity available. I also want the capabilities to analyze the transactions to see item usage by location/cost and determine slow moving items.

Users

Item Users

Users in the different areas which use and request the items in the database. Must request items in a form which must be able to filter items by usage locations. They need to be able to order in eaches or a shipper (box).

Storage Locations Users

Users who work in the area which holds the items. Must receive item request from item users via access. they dispatch the items wish then must be discounted from the available amount. Must be able to discount in eaches or shipper.

Item Owners Users

Users which are responsible for the ordering the items they own in the database. Each item must have a primary and secondary owner. Owners might own multiple items. It is their responsibility to reorder the items they own. They (both the primary and secondary owners) must be automatically notified by email (outlook) if any of their items has gone below the minimum order quantity. After ordering they must enter ordered amount as in transit.

Logistic User

Analyze transaction history to determine usage by area/cost and determine slow moving items.

The system will not have more than 15 active users at anytime, all within the same network. All users should work through ease to use forms. This should give a good indication of what I am looking for, I will provide additional information.

Taidot: Microsoft Access, Visual Basic

Näytä lisää: access inventory template, inventory template access, inventory access template, inventory template, access inventory, visual basic cost, cost template, inventory access database template, access inventory control template, transaction history, moving storage, inventory database, dispatch, active filter, visual basic ordering system, access order, microsoft template access, inventory control template, access database transaction, database template access, inventory control system access, access control database, order template, inventory forms access database, storage box

About the Employer:
( 0 reviews ) San Juan, United States

Projektin tunnus: #1708190

Myönnetty käyttäjälle:

kulhanekd

I have 15 years exp in access design. I can assist. Donna

250 $ USD 3 päivässä
(30 arvostelua)
5.7

10 freelanceria on tarjonnut keskimäärin 459 $ tähän työhön

Krusche

From our point of view it's a rather complex project with the database running on an external server. Several user roles have to be introduced with different functionality for each role. A certain high level of program Lisää

2400 $ USD 30 päivässä
(26 arvostelua)
5.6
winnet21

I have experience in this project

220 $ USD 13 päivässä
(15 arvostelua)
5.1
infoshree80

Done previouly this type of work.I am interested .Can Send u screenshot.Pls chk Pm

250 $ USD 6 päivässä
(16 arvostelua)
4.9
braghunath

Your requirement can be met with an application developed in MS Access. I have been developing applications in MS Access since the year 2003. I can take up this project immediately. Thanks B.Raghunath

450 $ USD 30 päivässä
(3 arvostelua)
4.1
momo2619

Dear Sir, Please read my PM.

250 $ USD 5 päivässä
(13 arvostelua)
3.4
userlanka

I can provide Template Access database according to requirement details

70 $ USD 1 päivässä
(0 arvostelua)
1.2
LucianoDiego

Tenho uma grande experiencia em Access/vba, com certificação microsoft em office. Mais informações de uma olhada no meu profile. Obrigado

200 $ USD 3 päivässä
(0 arvostelua)
0.0
svdinesh

Hi I am having 8 Plus Years of Experience in the following technologies 1. VB6/VB.NET/C#.Net 2. SQL Server 3. Crystal Reports 4. Access and in the following Domains 1. Inventory - Managing Stocks, Reorder le Lisää

250 $ USD 5 päivässä
(0 arvostelua)
0.0
ShouSoft

HI sir , We already have a database and a complete software for inventory.

250 $ USD 14 päivässä
(0 arvostelua)
0.0