Follow

ID99 - Update inventory items Standard Cost with Avgcost.., Overview and Sample

The standard cost field in eAutomate is a field not used within eAutomate except for cases when your creating a PO for an item and you have no Vendors setup for that item, in which case the standard cost field is used. This can be viewed in Eautomate/Inventory/Item record:

Pricing_in_the_inventory__record.png

Many of our clients have requested a routine to update this standard cost field with the current average cost for that item so that the average cost is up front and easily viewed. In Eautomate/Inventory/Item Prices you can view the Standard/LastCost and the Average cost:

Item_pricing_showing_average_cost.png

This alert will run a stored procedure to update the standard cost field for all items assigned to inventory code(s) that have the character string (word) entered in variableW or VariableX above. (no test mode available, so we ask to install first on a test database for your review before running on your live EA database.)

ID99 Sample Output contains Item Number, Item Description, Standard Cost, Average Cost and Inventory Code Description as shown below:

ID99.png

This alert has 2 Variables:

VarW = A Word or string of characters contained in the Inventory Code description..for example if you enter Supply in variableW then the procedure will update all items that are assigned an inventory code with the string supply contained anywhere in the code description

VarX  = Additional character string contained in inventory code description

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk