Client need an automation.
Every time when we change the “Item defined cost” (costestimate), we want to update the “Employee Price”.
The “Employee Price” should be 20% on top of “Item defined cost” rounded off to the next full Dollar amount.Example: New “Item defined cost” is $6.52, the “Employee Price” should be CEIL({costestimate}*1.2) = $8.
Proposal
Proposal Summary
This proposal outlines the implementation of a feature that enhances the user experience
when working with Item Record. The proposed enhancement will allow for the Automation
of Employee Price while changing the Item Defined Cost.
Requirement
• The system shall update the Employee price based on Item Defined Cost field.
• The “Employee Price” should be 20% on top of “Item defined cost” rounded off to the
next full Dollar amount.
Deliverables
• We will create a User Event Script to automate employee price while changing ‘Item
Defined Cost’.
• When editing the existing item record, if there is any change in ‘Item Defined Cost’
field then the script will trigger and update the ‘Employee price’.
• The employee price will change based on the given equation
CEIL({costestimate}*1.2)
• For example, if “Item defined cost” is $6.52, then “Employee Price” should be $8.
Assumptions and Limitations
• This feature is applicable only for “Inventory Item” and “Assembly/Bill of Materials”.
• The Update will take place only when we click on ‘save’ button after changing the
‘Item Defined Cost’.
• If we leave the ‘Item Defined Cost’ field, then no change will happen in ‘Employee
Price’.
• We will not consider the multiple currency scenario
• The script will consider only in edit context of item record.
Estimated Effort
12 Hour