Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Project Item Journal Cost price not getting updated

(1) ShareShare
ReportReport
Posted on by 8
If i update an line through Excel add-in then the cost price of item is not getting updated whereas if the line is manually updated then its updating as expected. 
Is this a bug needs to be reported to MS or am i missing some setup?
 
In the below screenshot, I added first 2 lines manually but published the 3rd line from excel add-in where cost price is empty  
 
  • KD_10 Profile Picture
    8 on at
    Project Item Journal Cost price not getting updated
    HI, 
     
    Thank you for sharing the related issue. But, if we observe that is the cost price not sales price in the Inventory item journal after the posting it becomes the Selling price for the organization. I was just expecting the cost price to get updated after publishing the item numbers. But anyways, if MS has decided to not provide the option to auto-populate the price.
     
    Thanks,
    RD
  • Verified answer
    Hana Xue Profile Picture
    Microsoft Employee on at
    Project Item Journal Cost price not getting updated
    Hi,
    I found similar issues when searching in LCS known issues. It mentioned: Project item journal does not populate the sales price via Open in Excel.  You can take a look at: Details of the issue 792457 (dynamics.com) Hope this will be helpful.
    Best Regards,
    Hana
     
  • KD_10 Profile Picture
    8 on at
    Project Item Journal Cost price not getting updated
     
    Thank you for your reply. I don't think I am missing any setups; I uploaded the transfer orders where it got updated the cost price correctly but the same is not happening for "Project Item journals" 
  • Suggested answer
    Hana Xue Profile Picture
    Microsoft Employee on at
    Project Item Journal Cost price not getting updated
    Hi,
    Please first check the steps for updating data using Excel add-in according to this document. View and update entity data with Excel - Finance & Operations | Dynamics 365 | Microsoft Learn
    Best Regards,
    Hana

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans