Automate sales price updates based on raw material increase or decreases to the Sales Price Table

Automate sales price updates based on raw material increase or decreases to the Sales Price Table
Follow
Maria Avery
Maria AveryFeb 16, 2022 02:05 PM
We are looking to automate sales price changes based on raw material cost increase/decreases for our …

1. Automate sales price updates based on raw material increase or decreases to the Sales Price Table

SILVER CONTRIBUTOR
Maria Avery
Posted Feb 16, 2022 02:05 PM

We are looking to automate sales price changes based on raw material cost increase/decreases for our manufactured items.

Our raw material increased/decreased.
Based on the raw material increase/decrease the finished goods item sales price is increase/decrease.
Then the new sales price is updated to the sales price table automatically.

This process can happen monthly.

Is there a manufacturing add-on which will help with this process?

How do you handle raw material price increases/decreases to adjust your customer pricing without a lot of manual updating and calculations?

——————————
Maria Avery
Controller
Compax
Salt Lake City UT
——————————

2. RE: Automate sales price updates based on raw material increase or decreases to the Sales Price Table
NAVUG ALL STAR
Kim Dallefeld
Posted Feb 16, 2022 05:27 PM
Maria, I’ve not seen an automated process. I have used the standard cost worksheet filtering for produced items to get a rolled up cost. This works even when items are NOT standard cost. Then we took the results of the worksheet to excel, added our margin%, calculated new price, formatted columns so we could copy/paste into sales price table….

Not too difficult.

——————————
Kim Dallefeld, Kim@Dallefeld.com, Ft Worth, TX
Dallefeld Consulting, LLC
Member of Dynamics Consulting Group

New View Strategies, – training and consulting.

NAVUG All-Star
NAVUG Programming Committee
——————————

3. RE: Automate sales price updates based on raw material increase or decreases to the Sales Price Table
SILVER CONTRIBUTOR
Maria Avery
Posted Feb 17, 2022 09:28 AM
Thanks Kim! Can rapid start be used to import the new sales prices into the sales price table?

——————————
Maria Avery
Controller
Compax
Salt Lake City UT
——————————

4. RE: Automate sales price updates based on raw material increase or decreases to the Sales Price Table
NAVUG ALL STAR
Kim Dallefeld
Posted Mar 22, 2022 08:58 AM
Andrew’s solution will work, you can also import directly into the Sales Price table.

——————————
Kim Dallefeld, [email protected], Ft Worth, TX
Dallefeld Consulting, LLC
Member of Dynamics Consulting Group

New View Strategies, – training and consulting.

NAVUG All-Star
NAVUG Programming Committee
——————————

5. RE: Automate sales price updates based on raw material increase or decreases to the Sales Price Table
SILVER CONTRIBUTOR
Maria Avery
Posted Mar 21, 2022 04:40 PM
Can rapid start be used to import the new sales prices into the sales price table instead of copy/paste?

——————————
Maria Avery
Controller
Compax
Salt Lake City UT
——————————

6. RE: Automate sales price updates based on raw material increase or decreases to the Sales Price Table
TOP CONTRIBUTOR
Andrew Good
Posted Mar 22, 2022 07:34 AM
You can use Rapid Start to import into the Sales Price Worksheet, then you can review the values prior to importing them. It is always a good idea to bring external data into a staging table where you can review the data and manage any errors.

——————————
Andrew Good
President
Liberty Grove Software
Oakbrook Terrace IL
——————————

7. RE: Automate sales price updates based on raw material increase or decreases to the Sales Price Table
SILVER CONTRIBUTOR
Maria Avery
Posted Mar 22, 2022 09:47 AM
Thank you both!

——————————
Maria Avery
Controller
Compax
Salt Lake City UT
——————————