How to import Standard Cost when manufacturing is installed

(0) Share

Report

Posted on by Tami Farrelly

5,080

We are going live with the GP Manufacturing module...and I need to update the standard cost on all purchased items the roll up and revalue our inventory.

What is the best way to update the Standard cost of the items with manufacturing installed??

Tami

*This post is locked for comments

All responses (3)

Answers (1)

Tami Farrelly 5,080 on at

Like (0)

Report

RE: How to import Standard Cost when manufacturing is installed

I have tried the macro and get errors....some parts are already on a BOM and some arent...so some parts have and error stating this item is not on a BOM blah blah...causing the macro to fail. There has to be some way to update the cost of items?? without manually typing it in? And how come these macros are not available for customers to use?

Tami
Dan Liebl 7,320 on at

Like (0)

Report

RE: How to import Standard Cost when manufacturing is installed

With Mfg installed, you would need to populate the Std Item Material Cost window. I find the best way is to use a Mail Merge Macro. Record the steps manually on the window to populate an item, open in MS Word, and then mail merge an excel file in and run as a macro. You can use Import Utility in to the std cost tables, but I have had more luck with the macro.

Dan Liebl, CMA CPIM | Senior Consultant | OTT, Inc.| DLiebl@OTT-inc.com
Verified answer

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to import Standard Cost when manufacturing is installed

Youcan update the standard cost field with the Items Integration in Integration Manager.