Solved

Can you mass upload estimate material cost?

  • 13 January 2022
  • 3 replies
  • 233 views

Badge +1

We have over 1000 components needing the cost updating in the estimated material cost field- is there a bulk upload for this please?

 

 

icon

Best answer by Tharindu Illangasinghe 14 January 2022, 09:02

View original

This topic has been closed for comments

3 replies

Userlevel 6
Badge +13

Hi @LASICB,

 

You can use Update Estimated Material Cost job for that.

 

There are additional parameters for parts selection. In the Percentage Change filed you have to mention from what percentage  the estimated material cost should get updated. 

 

Userlevel 6
Badge +20

Possibly use the Excel Migration Toolkit with data from the Inventory Part Configurations page, or just manually update them here.

 

Userlevel 7
Badge +28

We do this all the time with a data migration job.