Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Bin Location History Report

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,186 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 64,622 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,139 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

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,768 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,985 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans