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

Help with Inventory Database

P: 18
Hello!

I'm not very good in making code work for me, so I thought I would put it on here and ask for some suggestions. Here is some back ground. I have an inventory database that I can log what is on order, in stock, allocated, and shinkage. By entering each transaction, I can tell what I have on hand vs. what is "avaliable". Now. As I'm entering a new job, some of my available stocks are going into the negative and I will have to order more of these. I have adjusted my report to only show the items in the negative.

Is there a way I can make an expression to

while available stock / cartonqty <0
then add carton qty

end while


I would like the database to become more functional so I do not have to go through all the items to determine what I need.

Once I get this out of the way, I would take the qty * price to print out a complete report to tell my boss how much we are ordering.

Any ideas or suggestions would be helpful.


Thank you
Stephanie
Aug 18 '08 #1
Share this Question
Share on Google+
5 Replies


hyperpau
Expert 100+
P: 184
while available stock / cartonqty <0
then add carton qty
I would like to understand what it is really you want to do here.

is
available stock / cartonqty
pertaining to available stock 'divided by' carton qty?
what is the
then add carton qty
gonna do?
Aug 18 '08 #2

P: 18
By adding a carton qty, I was hoping to get the order qty.... Now that you say something I guess that doesn't really make any sence...

Here is what I was thinking...

Let's say item 1 is less 12 of available stock. My carton qty is 15.

So I would order 15....

Let me rethink the formula and post back. Thank you for your help


Thank you,
Stephanie
Aug 19 '08 #3

P: 18
What about this:

Variables - *work through example*

Available qty (in stock - allocated) *-51*
Carton qty - Qty the item comes in *50*
Order qty - How much I will need to order *?*
Case - How many cartons I will need to order *?*


While Available qty is less than 0
then add integers from Available qty to 0 *order qty = 51*


Divide Order qty by carton qty *51/50 = 1.02*

While Case is not a whole number
then add one to carton qty *52/50 = 1.04*
*53/50 = 1.06*
repeat
*100/50 = 2*


So this would tell me I would order 100 for a case of 2


What do you think?
Aug 20 '08 #4

hyperpau
Expert 100+
P: 184
I'm sorry. I really want to help you out on here.
But I just can't understand what you're trying to tell me... :(

What about this:

Variables - *work through example*

Available qty (in stock - allocated) *-51*
Carton qty - Qty the item comes in *50*
Order qty - How much I will need to order *?*
Case - How many cartons I will need to order *?*


While Available qty is less than 0
then add integers from Available qty to 0 *order qty = 51*


Divide Order qty by carton qty *51/50 = 1.02*

While Case is not a whole number
then add one to carton qty *52/50 = 1.04*
*53/50 = 1.06*
repeat
*100/50 = 2*


So this would tell me I would order 100 for a case of 2


What do you think?
Aug 22 '08 #5

P: 18
It's ok. Turns out, my neighbor is a programmer and he said he would help me out.

Thanks anyway.
Aug 25 '08 #6

Post your reply

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