web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How to import Standard...
Microsoft Dynamics GP (Archived)

How to import Standard Cost when manufacturing is installed

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Verified answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

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

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at

    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

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans