Small and medium business | Business Central, N...

Bin Location History Report

(0) Share

Report

Posted on by MMiller3304

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?

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Suggested answer

JAngle 157 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,212 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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).

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

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,421 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi

look this

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

DAniele

Was this reply helpful? Yes No
MarisolC 103 on at

Like (0)

Report
Copy link

Link copied!

Yun Zhu, how can I relate warehouse entries with item ledger entries or value entry or Item Ledger Entry, I need a full report by item, location and bin with cost.

None of those tables have whole information so I'm looking somehow to resolve it but it is not clear for me on how to link data....

TIA!

Was this reply helpful? Yes No