Skip to main content
Business Central forum
Suggested answer

Bin Location History Report

editSubscribe (0) ShareShare
ReportReport
Posted on by 5

Hi All

Currently our WH is scanning barcoded inventory and performing bin moves while 2nd person does a blind count on paper to complete inventory. 

once all inventory has been scanned, reconciliation is done by verifying a bin move has been completed on specific day inventory was completed. A piece inventory is pulled prior to scanning  

My question is - is there a report I can tweak (which one?) that will allow me to pull in data from the Piece Ledger so I am not spending so much time tinkering with the data? 

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,180 Super User on at
    RE: Bin Location History Report

    hi

    look this

    learn.microsoft.com/.../inventory-wms-reports

    DAniele

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 59,978 Super User on at
    RE: Bin Location History Report

    Hi, Josh is right, in BC, if you want to collect transfer data between Locations, you only need to extract it from Item Ledger Entries, but if you need it between Bins, you must get it from Warehouse Entry (7312).

    pastedimage1670198544441v1.png

    Or you can refer to the logic of the following page.

    pastedimage1670199168666v2.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,131 on at
    RE: Bin Location History Report

    Warehouse entry table is a good place to start. Will have all manner of movements made between all bin types

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,068 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,591 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans