Which table shows Item availability per BIN

(0) Share

Report

Posted on by MahGah

15,428

I cannot see Bin in Item Ledger Entry. Which table has information for item per bin?

Thanks

All responses (9)

Answers (5)

MahGah 15,428 on at

Like (0)

Report

RE: Which table shows Item availability per BIN

Thanks Samantha73 This is a really great information
MahGah 15,428 on at

Like (0)

Report

RE: Which table shows Item availability per BIN

Thanks mr Zhu for extra info
Verified answer

Manish Prasad 315 on at

Like (1)

Report

RE: Which table shows Item availability per BIN

Hello MahGah,

If you want see the Item Bin Content for a single item, you can check on Item List page as shown in below image.

And if you need to check all Bin Content availability of all Items at once, you can go to Warehouse Entries as shown below image. Its Page id is 7318 and Table ID is - 7312

You can also check that data on Bin Contents as shown in below image. Its Page id is 7374 and Table ID is - 7302

If my answer helped you, maybe it can help others. Please verify it, so other users know it worked or helped you.
Thank you.
Verified answer

Samantha73 2,437 on at

Like (2)

Report

RE: Which table shows Item availability per BIN

Even with warehouse entry table you cannot get lot information per BIN if you haven't enabled a button in Item Tracking Card "Enable Warehouse tracking" or something which gets locked after item transactions.
Verified answer

YUN ZHU 73,696 Super User 2024 Season 2 on at

Like (1)

Report

RE: Which table shows Item availability per BIN

Hi, just add a complaint about Microsoft.
If the customer needs the inventory list containing Locations, Bins.

The developer needs to find the correspondence from Item Ledger Entries and Warehouse Ledger Entries and combine them into one table or report.
But they don't have direct linked, which is very complicated and again a frequently encountered requirement.

If you search for "link between item ledger entry and warehouse entry", you should find a lot of questions.

Hope this helps as well.

Thanks.

ZHU
MahGah 15,428 on at

Like (0)

Report

RE: Which table shows Item availability per BIN

Thank you so much
Verified answer

ExxelOutdoorsERP 80 on at

Like (1)

Report

RE: Which table shows Item availability per BIN

Yes, Lot No. (field no. 6501) is included in the warehouse entry table.
MahGah 15,428 on at

Like (0)

Report

RE: Which table shows Item availability per BIN

Thanks for your help. Looks like that table has calculated filed that uses Warehouse Entry (7312) to calculate those numbers. Is my assumption correct? Also, I do not see any Lot in 7302. is this also available from 7312?

Thanks
Verified answer

ExxelOutdoorsERP 80 on at

Like (0)

Report

RE: Which table shows Item availability per BIN

Hello,

The table that contains item availability by bin is Bin Content (7302). You will not find bins in the item ledger. Transactions related to item bins occur in warehouse entries.

I hope this answer helps!

Hannah