Good day,
I am looking for some advice and directions or suggest on how to automate the updating the Item last cost with the tariff %. It is important the salesperson realize that the cost of the item now includes a tariff amount/percent that needs to be included in the sales quotes pricing to customers.
Any thoughts or questions. The company management is discussing it. The current environment seems to expect this not to change any time soon; we order from Canada, and China mostly. Our vendors are starting to pass on the tariff on the purchase order/freight, etc.
Logic.
- Add a checkbox on the stock item profile to identify the specific items. ( We will need to identify the specific Canadian items or other countries.)
- Write the script to update the last cost with the tariff percentage after it the product is received into inventory. (Last cost is updated after each purchase order/purchase receipt is released)
- The script updates the last cost plus the 25 percent tariff. (Temporary changes so the salesperson sees the cost-plus tariff percentage)
- When the salesperson checks the item, it will include the Last cost-plus 25 percent.
- Have the last cost-plus tariff show on the sales quote as well. (Gross Margins will be in sync on the quote)
Thank you.
Evan