Help with Inventory Database

[StephR]

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

[hyperpau]

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?

[StephR]

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

[StephR]

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?

[hyperpau]

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?

[StephR]

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

Thanks anyway.