Qty Received Descrepency Formula

[Russ At Index]

Hi,

Newbie to Access i am afraid, but so far so good !

I need to know if this is possible:

I have a receiving form which an operator will key the
total number of units received against the purchase order.
We do have a "buffer" when receiving of 10% + or - the shipment total.

I would like to have a flag to state whether the keyed received qty meets the
buffer criteria !!!!

Is this possible ??

Thanks In Advance

Russ

 

[VicRauch]

Yes. Because you can go 10% under or 10% over the requested quantity, then find the 10% amount (multiple .1 times the requested amount) and add that amount to the requested amount, save that as HighEnd, subtrate that amount from the requested amount, save that as LowEnd. Then compare with the amount received. If lower than the LowEnd, or higher than the HighEnd, give the operator a MsgBox with the message you want the operator to see.
HTH,

 

[Russ At Index]

Hi Vic,

Thanks for the insight as to how i can acheive my target
regarding qty descrepancies.

As a newbie to Access and its intricate workings, could
elaborate on HighEnd / LowEnd please

Slightly cvonfused ( its early here in theUK !! )

Many Thanks

Russ

 

[VicRauch]

Russ,
I understand confusion, as I don't know where you want this flag of Over/Under, or what you plan on doing with it once you have it. You asked for some elaboration, but my answer fit the amount of information you have provided.
So far we know that you have a form for receiving material against a PO, you can accept a 10% + or - amount, and you want a flag if the amount received is outside this range.
So, if the PO ordered 1,000 units, my suggestion says to multiply 1,000 by .1. The answer will be 100. Then add 100 to 1,000. The answer is 1,100. So this is the HighEnd. The subtract 100 from the 1,000. The answer is 900. So this is the LowEnd. Then you compare these to values (HighEnd and LowEnd) to the received quantity. If the received quantity is lower than the LowEnd, or the received quantity is higher than the HighEnd, you set a flag (ReceivedQuantityOutOfRange) to True. Then you use this flag how ever you need to.