In my old job, we did something called "allocation" -- we would "allocate" certain units from Location A, certain units from Location B, Location C, etc., then ship all the allocated units to one or more orders.  Our users would see what units was ordered, allocated (or not), shipped (or not) to check progress.  Allocation is a totally different process that should be designed and set up separately from the order process because it can be quite complicated.  For instance, if Location A has 100 units of Product 1, Location B has 300 units of it, Location C has 50 units of it, and you need to allocate and ship 160 units of it, then obviously you need to take all the units from A and B to make space instead of shipping 160 units only from B.  So you need to put in some logic if you need it done automatically and efficiently.  Or you can allocate manually: have your users decide what units to allocate every time, which would be like placing orders.

My case is sampler than allocate products from one to another depot. I just need to know locations A stock enough for an order if yes there is no problem. If not I'll transfer the remaining quantity from another location. As I transfer the products completely sales and account and stock and everything related to the product.
I need to monitor all locations and all products as I've more than 74 products. The 74 products sale with the same options at all locations with same price. But I'm  adding pacific extra charges for each location in the invoice level only.
At this moment I have only 2 locations but I used to have 5 different locations one of those will be back to work shortly.

The process may be simple but it could become complicated as your goods go in and out of your locations.  For instance, if goods will come in on 11/15/2023, 11/30/2023, and 12/15/2023, and your customers place orders for delivery on 11/20/23, 12/20/23, 1/15/24, etc., how many units will still be available in your locations to sell on 12/25 or 12/31?  How much on-hand stock and incoming stock will you have on any given day?  Customers who want to plan ahead may ask you not what stock you have now, but what you will have 3 or 6 months from now.  It's tough to calculate all these in your head even in a simple scenario like that.  You really need an allocation system to keep track of all the comings and goings of your goods.

I still need to know to make a transaction table and monitor 2 or more warehouses

What have you done or tried?

If you are having a specific problem we can usually help out but it isn't possible for us to design your database for you.

Here are some things to think about:
I would start out by having each warehouse being identified in the product record for your inventory. It's current location.

Doing a transfer would be much like selling a product to a customer.  You make an order and the product comes out of inventory, then it is shipped or whatever...

Same thing with transferring only you are moving the product internally.  The seller side is the warehouse it is at.  The customer side is the warehouse it is going to.   A negative xx units for the first a positive xx units for the second.
How are you currently adding inventory from an outside vendor?  Just make yourself a vendor and treat it like you are getting inventory.
What are there costs involved you need to account for, if any?

You would need to set up your tables to show all warehouses and be hooked together so if one sells or ships a product the other warehouses are up to date as well.

Dear Scott,
My question is completely general question didn't covered in any lesson.

And I'm not asking anyone to buold my own database. Even I give you all the required data to build it you won't be able to build it better than my build as I have around 18 years experience in my field and two years experience with Access and building databases.

Anyhow I am interested in one topic is completely uncovered in Richard's lessons.

Sorry Mohei I must have misread the post.
You are correct, there isn't any one specific video or course covering this type of topic.  That said, Richard has provided the tools to help in designing something custom to your needs through out many different videos.

When you give it a try I'd love to see what you come up with.  It would indeed be an interesting issue to solve.

Best
Scott

Thanks Scott for your reply...
I hardly trying to collect data from Developer 13, 19, 23, 27 and 42 and somehow I also bought the POS developer lessons in case I find something interesting to apply in my specific needs in my own data base.
But I completely get lost in all of those lessons.
Richard promised us with HelpTech video about products with multi options. (in one of my specific questions trying to get help with a special case of mine) >>> And I'm still waiting for it. Maybe this HelpTech video will give me another scope on this topic helping me to finish a perfect database.

I think it will be great if Richard decided to do an upgrade to this lesson and any other lessons under the topic of inventory to cover more than one location of warehouses.

Many thanks.
Best Regards,
Mohei Eldin

Hi Mohei, an inventory system is not just about knowing what is in stock and transferring N units from location A to B.  Stock figures by themselves are meaningless.  The actual meaningful numbers are: stock that is available to sell, stock ordered by customers (on order) but not yet shipped, stock your warehouse will receive in near future (projected stock), projected stock available to sell, already ordered by customers, etc.  If you don't know these numbers, how do you know what units to send from warehouse A to B?  You need a system to know all that, because you can't track all these comings and goings of goods in your head all the time.  And you need an allocation system like the one I described to be able to transfer units between warehouses, among other needs.  This could be a consultant-level job, and may not be covered by Richard's videos.  His videos are mainly for showcasing Access features.  They cannot cover every possible business needs.  And here I am trying to give you some business perspectives because I actually did this sort of thing in my old job.

Hello Kevin ,

Thank you for your advice.
But I think most of Access lessons showing how to manage the stock and how to manage multi locations warehouses. It's completely not a special request or special need for me.
I think it is one of fundamentals in Access lessons. Too much videos talk about this. But I prefer Richard ways to solve such issues.



Also, after too long watching Richard's lessons I have here a very big question.. I don't know if he covers it somewhere or not.

In order entry system Richard using AutoNumber as OrderID while this might be an order or quotation.
Let's say it was a quotation then goes to order there is no problem in this case....
But if the customer didn't buy after this quotation the order number will be completely wrong as there is order 1,2,3,5,8,12
assume the missing numbers 4,6,7,9,10 and 11 was only quotations and customer(s) didn't buy.
I think Richard must think about it to build a quotation table and once it is be an order just click button in the form to append this quotation to the order table....
In fact I watched too much videos over here but didn't see Richard talk about this issue in deep. Maybe in one of expert levels he just mentioned something like that but didn't solve it through out all expert levels or till developer 42 he using same method until developer lesson 42.. Correct me if I'm wrong and mention the video talks about or solve this issue.

Initially the Autonumber is used for the ID as well as Order / Quote number.
It is simplified because Richard didn't want to confuse new students with more advanced topics.

See the AutoNumbers Are NOT For You video.
Instead there are a couple of numbering videos if you need to have special numbers that mean something.

Automatic Record Numbering
Sequential Numbers

Basically many of the questions are covered through out the courses.  There isn't one specific course that covers everything like you seem to be looking for.  That course doesn't exist.

Richard often says, "Access is like playing with Lego pieces." He shows us how to use the pieces. It is up to us to put the pieces together to accomplish what you need to do.
That is one of the reasons that Richard advises starting with the beginning and follow in order through the classes.

In fact in my real database I use autonumber on my own and make then viable is no and put an internal order number and dmax it.
I'm lot give the end users anyhint about the autonumber and what they are for and the can not see them at all.