Qty Received Descrepency Formula

Russ At Index

Well-known Member
Joined
Sep 23, 2002
Messages
685
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
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
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

VicRauch

Well-known Member
Joined
Mar 23, 2006
Messages
2,032
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

Well-known Member
Joined
Sep 23, 2002
Messages
685
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
  2. MacOS
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 :confused:

Slightly cvonfused ( its early here in theUK !! )

Many Thanks

Russ
 

VicRauch

Well-known Member
Joined
Mar 23, 2006
Messages
2,032
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.
 

Forum statistics

Threads
1,143,677
Messages
5,720,246
Members
422,272
Latest member
ginkgoVil

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top