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

Qty not showing up on item tracking lines as available to select.

(3) Share

Report

Posted on by LB-23010004-0

101

UPDATE:

I believe I have found something that could be the issue. When I check this item's availability by location, I see one line with a proper location code, and another line with the qty of 40 I want placed into a blank location. I only have one location set up which is SLC.

When I try to create a transfer order, I cannot select the blank location as it is not a real location. Is there another way to transfer inventory from a 'blank' location to a proper one?

__________________________________________________________________________________________________________________________________________________________________________________________________

I am creating a production order for a certain item. This item has many components. The line highlighted is the one giving me problems.

Below is the item ledger entries for the above item, totaling to an on hand quantity of 41:

I go to Related -> Other ->Item Tracking Lines to select lot numbers to allocate to this order. I then go to Select Entries and here I have a list of the available lot #s to choose from. Here I only see two lot #s with a total quantity of 1, but the item has an on hand quantity of 41. I am missing the available 40.

If I go to the item ledger entry for the line referring to the output of the 40, I see that it was a production order and I have an untracked quantity of 40.

Also, that quantity of 40, was from the below finished production order.

And when I go to the item tracking lines in this finished order, I see that it does have an assigned lot?

How can I make this qty of 40 be available to me to select in the above production order? Is the problem that I just don't have a lot assigned to those 40 quantities? If so, what is the proper way to assign a lot and if I cannot, what else should one do in this situation? The item is lot tracked, but it does not have a Lot No. Series attached. Will creating one and adding it to the item also help prevent this in the future?

Let me know if you need any more information and I can add it in an edit.

Thank you very much.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

YUN ZHU 90,557 Super User 2025 Season 2 on at

Like (0)

Report

Qty not showing up on item tracking lines as available to select.

If you just want to adjust the location, Item Reclassification Journals would be better.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 28,469 Super User 2025 Season 2 on at

Like (0)

Report

Qty not showing up on item tracking lines as available to select.

When I try to create a transfer order, I cannot select the blank location as it is not a real location. Is there another way to transfer inventory from a 'blank' location to a proper one?

You can use the item journal to do a negative/positive adjustment. If the items are in a different location that would explain why you don't see them in the item tracking lines.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,152 Super User 2025 Season 2 on at

Like (0)

Report

Qty not showing up on item tracking lines as available to select.

You could go to the production order, assuming it hasn't been finished, then use the below function to assign a lot number to the output. Depending on the location setup, you might need to do an internal movement to make the output available for use. If you have simple location, the movement is not needed.

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,503 Super User 2025 Season 2 on at

Like (0)

Report

Qty not showing up on item tracking lines as available to select.

Interesting issue

Have you checked if there are any sales orders for that particular item and whether the available quantity is already allocated to another order? I also recommend verifying if there are any open purchase orders pending receipt.

Was this reply helpful? Yes No