By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,040 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

ms access how to distribute Quantity based on record needs

P: 14
for example: there total of 100 parts in stock
and there 4 orders need this part

order 1 need 50 due on 5/26/2019
order 2 need 30 due on 6/1/2019
order 3 need 40 due on 6/5/2019
order 4 need 60 due on 6/10/2019

what Can I do so I can distribute the total amount in to each order as need, so I can see which order is going to be short and when going to be short.
like below

order 1 need 50 due on 5/26/2019, qty in 50, qty short 0
order 2 need 30 due on 6/1/2019, qty in 30, qty short 0
order 3 need 40 due on 6/5/2019, qty in 20, qty short 20
order 4 need 60 due on 6/10/2019, qty in 0, qty short 60

Thank you in advance
4 Weeks Ago #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,347
Well, the first thing you need to understand is that you can only create a system to reflect your requirements when you have your requirements fully defined.

Before you consider how to design this you need to decide how you want items to be allocated. Do they get allocated once the order is entered onto the system? Do they get allocated only when they become due?

Each of these two (non-exhaustive) example approaches has pros and cons. Your job is to consider those and decide how you want to proceed. When you get to that stage it may be that you need help to make it happen, but I suspect once you've done that necessary work you'll have a much better idea what you're dealing with and probably have enough understanding to implement it without recourse to our assistance.

Obviously, once you get to the stage where it's appropriate to ask for help then feel free to come back with a request if you need.
4 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.