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

Sale below inventory levels

(1) Share

Report

Posted on by EG-15051518-0

Hello

I have this scenario where we want to track items using lot and package numbers.

Problem is there are some locations where we sell below inventory levels(we know product is incoming).

I am able to post a sales invoice for an item below inventory level when tracking is NOT enabled.

With items that are tracked, i have to input the lot no which i do not have because items are not yet received.

When i try to input a lot number manually(without selecting existing entries) i get the error : Item tracking cannot be fully applied.

Is there any workaround to this scenario?

Thanks

Categories:

Dynamics 365 Business Central

All responses (5)

Answers (0)

Suggested answer

KDallefeldMVP 21 on at

Like (0)

Report

Sale below inventory levels

First, selling below inventory or letting your quantity on hand go negative will create costing issues for you.

Second, with lot tracking, you are specifically telling the system that additions and subtractions from inventory must be done with a lot number. What lot number would you use for the sale that takes inventory negative?
Suggested answer

Valentin Castravet 27,640 Super User 2025 Season 1 on at

Like (0)

Report

Sale below inventory levels

There is no workaround. It sounds like you have the solution in your question, which is to not use lots if your process requires you to have negative inventory.

If you have lot tracking enabled, then you cannot have negative inventory. Every time you sell a lot, you need to select from a lot that you already have in inventory.

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

Jun Wang 7,681 Super User 2025 Season 1 on at

Like (1)

Report

Sale below inventory levels

I don't think you could sell non existing lot tracked items cause BC will check the item ledger entries to reserve those as standard process. It works if you allow negative inventory for non tracked items.

workaround: You may get around this by creating a new item tracking code that doesn't need tracking information for sales. But if there are already transactions posted for that item, you won't be able to do so unless all items have been sold.

Jun Wang
EG-15051518-0 28 on at

Like (1)

Report

Sale below inventory levels

Thanks YUN ZHU for your response
Suggested answer

YUN ZHU 81,365 Super User 2025 Season 1 on at

Like (1)

Report

Sale below inventory levels

You mean, negative inventory is allowed in your system? And you want to ship out when there is no inventory and lot numbers?

Unfortunately, as far as I know this cannot be done. (Even if you create a Lot Number Card first, you cannot select it because there is no inventory)

Hopefully other experts can give you better advice.

Thanks.

ZHU