[AccessD] Reorder Level

 Maybe I'm missing the point, but I believe it should be this:


  =IIf([txtOnHand]+[txtOnOrder])<[ReorderLevel],[ReorderLevel]-([txtOnHan
d])+[txtOnOrder],0)

  =     (496 + 500) < 18 ,  18 - (496 + 500) , 0

  so you'd get 0 in this case.

Jim. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis, Virginia
Sent: Tuesday, November 10, 2009 1:22 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Reorder Level

Evidently I am missing something all together. I changed the OnCurrent
to what you mentioned & I still have the same results. It shows the Item
is 18 units below minimum level.

ReorderLevel: 14
txtOnHand: 496
txtOnOrder: 500
txtReorderLevel: 18
=IIf(([txtOnOrder]-[txtOnHand])+[ReorderLevel]>0,([txtOnOrder]-[txtOnHan
d])+[ReorderLevel],0)

 

________________________________

  What you want is to change the check:
 
   If OnHand + OnOrder <  ReorderLevel then
      ' Need to re-order
     <reorder amount> = ReorderLevel - (OnHand + OnOrder)
   Else
     <reorder amount> = 0
   End If
 
Jim
 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> 
[mailto:accessd-bounces at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> ] On Behalf Of
Hollis, Virginia
Sent: Tuesday, November 10, 2009 11:17 AM
To: accessd at databaseadvisors.com
<http://databaseadvisors.com/mailman/listinfo/accessd> 
Subject: [AccessD] Reorder Level
 
Ok, that doesn't seem to work either. It doesn't show the negatives
(which is good). But it shows the minimum level is low when it isn't -
they have too much of this item.
 
I get:
Reorder Level: 14
On Hand: 496
On Order: 500
txtReorderLevel: 18
Message - "Item is 18 units below minimum level". When actually they
have 996 items when the minimum is 14. They are overstocked.

 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com