retail and wholsale in a ms access 2007 database

[damie]

good day
please is it possible to have a store inventory, retail inventory ,wholesale inventory separately in ms access database?
the sale point will be one it will just reflect where the item is coming from.


for example someone comes to buy from wholesale, it deducts from the inventory in wholesale, if the person comes to buy from retail it deducts from the inventory in retail
at the end of the year if we want the stock taking, it does the individual inventory and totals all the inventory together
would be glad if any help is rendered
thanks

[RuralGuy]

I would say the answer is almost certainly YES but you treble the issues with all of your forms and reports. Is the inventory really segregated this way?

[SteveF]

good day
please is it possible to have a store inventory, retail inventory ,wholesale inventory separately in ms access database?
the sale point will be one it will just reflect where the item is coming from.
for example someone comes to buy from wholesale, it deducts from the inventory in wholesale, if the person comes to buy from retail it deducts from the inventory in retail
at the end of the year if we want the stock taking, it does the individual inventory and totals all the inventory together
would be glad if any help is rendered
thanks

I strongly agree with RuralGuy: unless your physical inventory is separated in this way, you're asking for big headaches.

If your wholesale/retail inventory is all kept in one area, but you need to track wholesale vs. retail transactions, then have a data field in one of your tables that logs the transaction type. Also keep separate wholesale & retail prices for each item, and use the relevant price based on transaction type.

Steve

[damie]

Thanks for your reply and help
the wholesale and retail is kept in different stores, their quantities are taken differently
thanks

[RuralGuy]

Well the answer is still yes. How you do it is up to you. Depending in the complexity of the inventory items you could have both inventories in one table or in separate tables. The decision is yours.

[SteveF]

OK, there are still some questions that need to be asked:

1. How many people will be using this application simultaneously? Access starts to get R E A L slow once you start to exceed about 10 simultaneous users (unless you use a few advanced tricks to work around this). If a lot of folks will have this running at the same time, you need a more robust database engine for data storage.

2. Much as I like Access, is there a particular reason you feel you need to roll-your-own? Inventory management is such a common task that there must be packages to handle this available commercially. You need to balance the cost of such a package against the cost of your time & labor spent building your own that would otherwise be available for other tasks.

Steve

[RuralGuy]

SteveF has some really good points there!

[damie]

thanks for your replies