Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Item values in specifi...
Small and medium business | Business Central, N...
Suggested answer

Item values in specific bin

(1) ShareShare
ReportReport
Posted on by AntonioKD 315
Hello Experts,
I know that this topic has already been discussed several times on the community, but I still haven't found a clear answer.
Is it possible to generate an inventory value for a given bin? Let's say I have an XYZ warehouse with bins XYZ-1, XYZ-2, ( different unit cost for each bin, not average/standard cost for items in bins).
XYZ-1 has item 01 with cost 10 from purchase,
XYZ-2 has item 01 with cost 20 from purchase,
XYZ-1 has item 01 with cost 30 from purchase.
The average cost is  20, but it doesn't fit for bin XYZ-1 when I multiply 1x20 because correct value for this bin is 10. 

Can I check what value I have on a specific bin taking into account the appropriate costs from purchase (value entry)? 
I know that it is really hard because on item ledger entries and value entries I don't have Bin, and on warehouse entries I don't have value and the best choice is to set bins as locations and assign to them specific g/l accounts but maybe one of you had the same problem and found solution without having separete locations for every bin?
If the answer is no - do you have experience with customization in this area? 
 
Thank you in advance!
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,785 Super User 2024 Season 2 on at
    Item values in specific bin
    No, it does not. The report header displays the filters applied, but the lines do not take into consideration the bin. The two quantities you have of 707 and 100 can be in any bin or not even in a bin, and the report will still display them, regardless of your bin filter.

    If you would like, you can transfer your two items to another bin, and run the report with the same settings. You will get the same result. 
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    Item values in specific bin
     
    it works per my testing.
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,785 Super User 2024 Season 2 on at
    Item values in specific bin
    Unfortunately the Warehouse Entries do not display values/amounts for item transactions. 
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,472 Super User 2024 Season 2 on at
    Item values in specific bin
    Hi, I think you could try filtering on the Warehouse Entries page.
     
    Hope this can give you some hints.
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,785 Super User 2024 Season 2 on at
    Item values in specific bin
    The bin filter on the Inventory Valuation report does not work. 
     
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    Item values in specific bin
    you could use the below report, add filters as needed to find your answer
     
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 24,785 Super User 2024 Season 2 on at
    Item values in specific bin
    As far as I know its not possible out of the box. You would have to manually calculate it or create something custom. But what is your item costing method? Is it average, standard, FIFO, etc?
     

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

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans