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?

All responses (4)

Answers (0)

MarisolC 338 on at

Like (0)

Report

Bin Location History Report

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!
Suggested answer

DAnny3211 9,264 Super User 2024 Season 1 on at

Like (0)

Report

RE: Bin Location History Report

hi

look this

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

DAniele
Suggested answer

YUN ZHU 71,565 Super User 2024 Season 2 on at

Like (1)

Report

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

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

Hope this helps as well.

Thanks.

ZHU
Suggested answer

JAngle 33,157 on at

Like (1)

Report

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