This is a procedure to update the Retail (Default) Price on parts and/or supply items (using the service code assigned's category) based on formulas you provide
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
This is a procedure to update the Retail (Default) Price on parts and/or supply items (using the service code assigned category) based on formulas you provide (tell us ranges with their multipliers). If you want us to update both 'P'arts and 'S'upplies you must provide us with the different 'cost markup bands' for the two different types.
Run Schedule: Sunday Mornings
Type of Output: Email
* * *
Sample
Sample
* * *
Variables
Variables
Variable W: Indicate if we are to consider Item Records where Service Code Category is Part(P) and/or Supply(S). Enter 'P' for Parts, 'S' for Supplies, or 'P,S' for both.
Also seen via Lists & Codes / Service Codes
* * *
Alert Functionality
Alert Functionality
- This alert will install in TEST mode; in this mode, no items will be updated in e-automate. You'll receive a daily list showing the items that would have been updated.
- This alert is a procedure to update the Retail (Default) Price on inventory item parts records based on formulas you provide. Some clients don't have an easy way to keep parts pricing updated to MSRP so this is an alternative to maintain a certain margin in relation to your current costs.
-
What this alert does is use your LastCost to recalculate the new 'Default' price....
here's a sample of how some clients use to markup from lastcost..a sliding scale.
If Cost between .01 and 2.51 then lastcost * 5
Cost between 2.52 and 8.51 then lastcost * 4.5
Cost between 8.52 and 16.01 then lastcost * 4
Cost between 16.02 and 25.01 then lastcost * 3.5
Cost between 25.02 and 50.01 then lastcost * 3
else lastcost * 2.5 - You tell us the 'ranges' and multiplier and we update the stored procedure as such.
- All of our alerts which either affect your data or send output to third parties have test modes, you'll get an e-mail that shows what would've happened (or see what your customers/vendor partners would've seen) so you have a chance to review and validate the results. This alert is fairly customizable, tell us how you want to arrive at the price inserted and we should be able to make it happen for you.
* * *
Best Practices & Tips
Best Practices & Tips
None at this time
* * *
Related Alerts
Related Alerts
ID99 - Update Inventory Items Standard Cost with Average Cost
* * *
0 Comments