Calculating when to audit parts

You can configure Infor Public Sector to calculate when to audit parts in a stock area using an audit criteria formula. You specify an audit criteria formula for a stock area in the Stock Area InfoViewer. For example, you could write a formula that directs Infor Public Sector to schedule an audit once a month for parts with an average cost over $100. You specify an audit criteria formula when you assign an audit code to a stock area.

Audit criteria formulas use the oStockInfo object (an instance of the Hansen.Inventory.iStockInformation class) and the GenerateThrough object (an instance of the System.DateTime class) to set CanAdd to either True or False. If the formula returns True, Infor Public Sector adds the stock area to the list of stocks areas scheduled for audit. If the formula returns False, Infor Public Sector does not add the stock area. For more information about this object, click the Information tab in the Formula Editor.

Dim difference As System.TimeSpan
difference = GenerateThrough.Subtract(oStockInfo.LastCountDate)

If (difference.TotalDays >= 10)
   CanAdd = true
Else 
   CanAdd = false
End If