Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 123
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
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,822 Super User 2024 Season 2 on at
    stock value in purchase prices only
    Why would you use the item ledger entries and only filter to open items?
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    stock value in purchase prices only
    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 24,822 Super User 2024 Season 2 on at
    stock value in purchase prices only
    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
     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans