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 / Supply chain | Supply Chain Management, Commerce / Upload item cost price...
Supply chain | Supply Chain Management, Commerce
Answered

Upload item cost prices using excel addins (On Premise)

(0) ShareShare
ReportReport
Posted on by NaveenKumar S 3,475

Hello, 

I need to upload the item active cost prices using excel addins, please let me know which table can be used for this?

I tried with cost statement entry, costing sheet node calculations factors v2 but was not able to do it

thanks in advance 

Regards, 

I have the same question (0)
  • Suggested answer
    Gorminator Profile Picture
    Gorminator 2 on at

    Naveen,

    If you're looking to upload cost prices, look at the InventItemPriceSim table. Once they're active records, they'll be located in InventItemPrice.

    Cost categories will be RouteCostCategoryPrice, indirect cost should be CostSheetCalculationFactor.

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,475 on at

    Hello Ian Gorman,

    thank you for the reply,

    is there a way wherein we can upload the pending prices and then the end-user will activate the prices of all items at once instead of going to each item and activating each item price individually?

    regards,

  • Suggested answer
    Gorminator Profile Picture
    Gorminator 2 on at

    Naveen,

    Once the pending costs are uploading, you can go to Cost management > Predetermined cost policies setup > Costing version, select the costing version record you're working against, go to Price > Item price up top on the action pane.

    From there you'll see all pending prices.

    Select all > Activate pending prices in the action pane.

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,475 on at

    Hello Ian, 

    there is no inventitemprice table in the excel addin dropdown list, please let me know if there is other table name

  • Verified answer
    Gorminator Profile Picture
    Gorminator 2 on at

    Hi Naveen,

    I gave you the raw table names. Open in Excel will look at the data source/entities instead.

    Try searching for pending item prices v2.

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,475 on at

    Thank you for quick response, this solved my issue Ian

  • CCollecutt Profile Picture
    CCollecutt 5 on at

    Hi I am hoping you can help.  I have all the indirect pending costs loaded, went to the Price>Indirect Cost and see a list of all of the *pending prices however when I select more than one record the Activate button gets Grayed out?  I have >1500 records to update.

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 > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 301 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 118 Super User 2025 Season 2

#3
Siv Sagar Profile Picture

Siv Sagar 105 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans