A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Inventory/Sales/Warehouses



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2010, 06:08 PM posted to microsoft.public.access
dirtrhoads
external usenet poster
 
Posts: 15
Default Inventory/Sales/Warehouses

Hello,

I am creating a shipping and logistics database in Access 2007 to keep track
of sales, inventory, shipping costs, etc.

We have 4 warehouses that handle shipping to distributors. I am probably
making this more complicated than necessary, but this is tripping me up in
designing the query that I want... I have an orders table, order details
table (Lists each product per order individually), a warehouse table that
lists each of our warehouses (this could possibly increase in the future), a
products table which lists each individual product, and a customer table.

I need to track the inventory in and out of each warehouse per order and I
just need help getting started.
  #4  
Old April 30th, 2010, 07:49 PM posted to microsoft.public.access
Fred
external usenet poster
 
Posts: 1,451
Default Inventory/Sales/Warehouses

That's a huge task, and typically 2/3 of the job of doing it is creating and
implementing the business procedures and only 1/3 of it is the databasing.

You best first step is to shut the database off and write down the real word
procedures that will be used to track inventory.

99% of the time when someone says "track" they mean that all transactions
will update the total. If so, start by defining what inventory you want to
track (e.g is each ;location a separate inventory?, are you tracking totals
by part number or individualized items [like individual automobiles] )

Assuming it's transaction based, then the nextg step is to list every typ of
transaction that might modify inventory, and how you intent to capture that
data.

We;;, that's a start.




  #5  
Old April 30th, 2010, 08:01 PM posted to microsoft.public.access
dirtrhoads
external usenet poster
 
Posts: 15
Default Inventory/Sales/Warehouses

I have already done that, however, I think I figured out where to start at
least. I am setting up my order status queries now to reflect inventory on
backorder, allocated, shipped, etc... so I will start there but I may need
future help with the actual calculations but it seems to be falling together
in my head now. I currently have the real world process, just in Excel which
is really a timely process.

Thank you very much for your help.

"Fred" wrote:

That's a huge task, and typically 2/3 of the job of doing it is creating and
implementing the business procedures and only 1/3 of it is the databasing.

You best first step is to shut the database off and write down the real word
procedures that will be used to track inventory.

99% of the time when someone says "track" they mean that all transactions
will update the total. If so, start by defining what inventory you want to
track (e.g is each ;location a separate inventory?, are you tracking totals
by part number or individualized items [like individual automobiles] )

Assuming it's transaction based, then the nextg step is to list every typ of
transaction that might modify inventory, and how you intent to capture that
data.

We;;, that's a start.




  #7  
Old April 30th, 2010, 10:07 PM posted to microsoft.public.access
cardiamo agapimu
external usenet poster
 
Posts: 1
Default Inventory/Sales/Warehouses

Impossibile inviare o ricevere messaggi per l'account Libero (nadia.lici)
(2). Impossibile trovare l'host 'protezione'. Verifica che il nome immesso
per il server sia corretto.

Server: 'protezione'
ID errore di Windows Live Mail: 0x800CCC0D
Protocollo: POP3
Porta: 110
Protezione (SSL): No
Errore socket: 11001

"dirtrhoads" ha scritto nel messaggio
...
Hello,

I am creating a shipping and logistics database in Access 2007 to keep
track
of sales, inventory, shipping costs, etc.

We have 4 warehouses that handle shipping to distributors. I am probably
making this more complicated than necessary, but this is tripping me up in
designing the query that I want... I have an orders table, order details
table (Lists each product per order individually), a warehouse table that
lists each of our warehouses (this could possibly increase in the future),
a
products table which lists each individual product, and a customer table.

I need to track the inventory in and out of each warehouse per order and I
just need help getting started.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:59 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.