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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / stock value in purchas...
Small and medium business | Business Central, N...
Suggested Answer

stock value in purchase prices only

(1) ShareShare
ReportReport
Posted on by elusiveferret 135
Hi, 
 
We need to have a report, or somehow to gether information how much stock of each product we have in purchased value only. 
 
We have a lot of transfer orders and item charges in our company. If you use inventory valuation report it will show the value of each item including those item charges. 
 
For example we purchased an item 1 in location A for 1$. After that we transfered it to location B and it costed 1$. If you check the value of the item A in location B it will be 2$, but I need the information that the value without charges is 1$. 
Is it somehow possible to do?
 
Thanks in advance
I have the same question (0)
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 31,586 Super User 2025 Season 2 on at
    Why do you use item charges if you don't want the item charge cost to be added to the item value? Perhaps you can simply use GL Accounts rather than item charges?
     
    There's no out of the box reports that will display the inventory value without item charges as the point of item charges is that their cost gets added to an item's cost, but you can use the following:
     
    Posted Purchase Invoice Lines Page- this will give 
    Value Entries Page - filter for purchase invoices and exclude the item charge entries
    Purchasing Account in the GL - if your purchasing and direct costs applied accounts are two separate accounts rather than 1, you can use the purchasing account to get a list of purchases
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 8,202 Super User 2025 Season 2 on at
    you could filter via value entries per below example to refine your criteria,
    in the example, I excluded item charges.
    but you may also need item ledger entry, you may need to filter only to Open items
    there might be other filters you need. this is only an example.
     
    Jun Wang
     
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 31,586 Super User 2025 Season 2 on at
    Why would you use the item ledger entries and only filter to open items?

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

News and Announcements

Season of Giving Solutions is Here!

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,651

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 808 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 718 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans