Solved

Script Cost update for Inventory Part

  • 3 November 2021
  • 1 reply
  • 165 views

Userlevel 6
Badge +17

Hello All, 

I am curious if it is possible to script a cost value update from one site to another? Currently we have a production site and an estimating site. The estimating site has a copy of our component parts, which we use to create customer quotations. The issue we face is that part 12345 in the production site may change from $5 to $7, but the PN 12345 in the estimating site is not updated, unless the user manually updates the cost. 

Is it possible to create a scheduled task to routinely perform an update from the production to estimating to keep the costs identical? Thank you!

icon

Best answer by ShawnBerk 3 November 2021, 18:41

View original

This topic has been closed for comments

1 reply

Userlevel 7
Badge +28

Yes, we do this via migration jobs. 

We do a similar costing update between a main service distribution site and hub sites that are for field inventory.  We have a nightly migration job to look for new parts and costs from the main site, download as an extract then upload via a different migration job to the other sites to the estimated material cost.  Altogether, it is something like 3 migration jobs for down, update to a table, upload to the other site, then several scheduled tasks to kick off the migration jobs and another to do a weekly cost calculation on the hub sites to keep the standard cost updated.

We have other versions that are script driven when a new cost is added and a sales part is created in one site, it sends the parts to sister sites to set them up, cost them and create the sales part info.  That version is more complex but also possible.

Out of the box a single SDT to do what you want however is not really possible, too many parameters to track really.