What is the Bin Content Table in Business Central?
The bin content table in Business Central is a table that sums up the quantities on the warehouse entries.
This is what happens in the video
The bin content table in Business Central shows you the current stock per bin. It sums up the warehouse entries so you get one line per combination of bin code, location code, quantity, and unit of measure code, instead of one line per transaction.
A line appears in the bin content table when the quantity is different from zero or when the bin is marked as a fixed bin. If you empty a bin that is not a fixed bin, the line disappears from the bin content list.
You can have a quantity of zero on a fixed bin. The fixed bin checkmark keeps the line visible even when there is nothing in the bin.
What the bin content table is in Business Central
The bin content table is a table that sums up the quantities on the warehouse entries. The warehouse entries contain one entry per transaction, so that list keeps growing over time. The bin content table is a summary of those warehouse entries, and it only shows lines where the quantity is different from zero, or where you have a checkmark in the fixed bin.
This means you can have a quantity of zero on a fixed bin and still see the line.
How warehouse entries and bin content relate
From the item card you can navigate into the warehouse entries. There you see a list of all the warehouse entries for the item. The older the item gets, the more warehouse entries you accumulate, and the list just gets bigger and bigger. Each entry carries a quantity and a unit of measure code.
The bin content table sums those entries per quantity, unit of measure code, bin code, and location code. So while the warehouse entries hold the full transaction history, the bin content shows you only the combinations of bin code and location code that have an actual quantity, or that have the fixed bin checkmark set.
Fixed bins and empty bins
You can set a fixed bin for an item. That bin stays in the bin content list even with a quantity of zero, because of the fixed bin checkmark.
For bins that are not fixed, the line only stays as long as there is a quantity. For example, if you have one box in bin 36.10 and you use that box, the line disappears from the bin content list once the quantity reaches zero.
Q&A
What is the difference between warehouse entries and the bin content table in Business Central?
Warehouse entries hold one entry per transaction, so the list grows continuously over time. The bin content table is a summary of those entries, showing one line per combination of bin code, location code, quantity, and unit of measure code.
When does a line appear in the bin content table?
A line appears when the quantity is different from zero, or when the bin has a checkmark in the fixed bin field.
Can a bin show a quantity of zero in the bin content table?
Yes. A fixed bin stays visible in the bin content list even with a quantity of zero, because the fixed bin checkmark keeps the line there.
What happens to a non-fixed bin line when the stock runs out?
The line disappears from the bin content list. For example, if you use the last box in bin 36.10, that line is removed once the quantity hits zero.