Follow

ID495 - Inventory Adjustment Made Over Certain $ Amount Overview & Sample:

ID495 will advise when an inventory adjustment is made over a certain dollar amount.

Jump to a specific section by clicking a link

Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts

 

Click to Subscribe

 

Overview

Overview

This alert triggers for inventory adjustments that are over a set dollar amount. The alert emails the details of the transfer for you to review. This alert looks at the entire adjustment to trigger on, and does not trigger based on individual line items on the adjustment.

 

Run Schedule:  Hourly

Type of Output: Email

*  *  *

Sample

Sample

ID495_Screenshot.png

*  *  *

Variables

Variables

495_variables.png

Variable W: Amount - Enter the amount to trigger the alert. Whole numbers only, the default value is 250.

Variable X: True or False - Enter True to use the Absolute Value Method or False for the Net Method.

 

*  *  *

Alert Functionality

Alert Functionality

1. There are two different methods used by the alert to calculate the inventory adjustment:

Net value: will advise when an overall adjustment exceeds the amount in Variable W, can be either negative or positive. For example, someone decreases two items @ $30 each and increases one item for $40, the net change is -$20.

This would be done through an inventory adjustment (Choose Inventory drop-down, adjustments):

ID__Screen_shot_of_inventory_adjustment.png

Now choose new and pick the type of adjustment (Cost, Increase or Decrease Qty):

ID495_Screen_shot_of_inventory_adjustment.jpg

Now that the adjustments have been made, it's good to have a way to audit what happened, and the intention of ID495 is to keep you informed of such adjustments.

Absolute value: two items decreased @ $30 each and one item increased by $40, is $100 worth of change. If using this setting, we recommend setting Variable W low to start, and gradually increasing until you get a feel for what your adjustments normally run.

Note: this alert looks at total Adjustments, not individual items on adjustments.

Variable W = The Default is $250. Set a dollar amount to trigger on or above

Variable X = Default is True  (False = Net value, and True = Absolute value).

*  *  *

 

Best Practices & Tips

Best Practices & Tips

None at this time.

 

*  *  *

Related Alerts

Related Alerts

None at this time.

*  *  * 

 

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