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

Consuming Items using FIFO

(6) Share

Report

Posted on by Tris15

400

Hi Experts

I've experienced issues on consuming items on a production Journal, I want to consume 004tops & tails

I Have enough stock on Hand

But when I post, I get the following

But it seems it wants me to consume only whole values from the buckets available

And when I enter that first value of 616 the journal posts

Any recommendations?

Kind regards,

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Ben Baxter 6,575 Super User 2025 Season 2 on at

Like (4)

Report

Verify the other inventory is not reserved for another Production Order. I see your Qty on Consumption Lines is much higher than Inventory, so there is a chance the inventory has been allocated to other orders and unavailable for your consumption.

Another thing to check would be Bins, if you are using them. If your consumption line has a Bin listed, but the inventory is in a different Bin, it won't post. If you are not using Bins, you can skip this check.

You shouldn't have to consume in quantities equal to the ledger. The system will pull from the oldest first, assuming you're using FIFO.

Best Regards,

Ben Baxter

Accent Software Inc

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,600 Super User 2025 Season 2 on at

Like (3)

Report

This is one of those typical cases where we look at the Quantity on Hand and wonder why the system isn’t letting us use that stock. The tricky part is that we often don’t realize the stock might already be used elsewhere — for example, reserved or waiting to be posted. The system only reduces the quantity once it’s posted, so if it’s sitting somewhere unposted or reserved, it still shows as available.

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report

Adding more details

https://learn.microsoft.com/en-us/dynamics365/business-central/design-details-costing-methods

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (2)

Report

It seems that there is still insufficient stock. I hope the information below can give you some hints.

Dynamics 365 Business Central: How to quickly check inventory quantity for locations at Item-Variant level (Variant inventory per location)

https://yzhums.com/54104/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 4,188 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

Based on the message, it appears that there is no stock for the product. I would recommend checking the following points to validate what might be happening:

- Verify that the stock is in the warehouse and location, including product variants.
- Item Tracking
- Direct Put-away & Pick, if applicable.
- If there are active reservations

As a temporary solution in a TEST environment, you could also make a positive adjustment to the product to verify the error.

I hope this helps.

Regards,

Andrés

Was this reply helpful? Yes No
KasparsSemjonovs 4,764 Super User 2025 Season 2 on at

Like (0)

Report

Could be that on other consumption lines You have added the Applies-to Entry No. therefore already reserved this Output entry to a specific consumption?

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,157 Most Valuable Professional on at

Like (1)

Report

Hi, good day

This could be due to active reservations, item tracking, or differences in location or bins; therefore, it's advisable to review actual inventory availability and verify if there are reservations or specific configurations that limit consumption.

Best Regards
Gerardo

Was this reply helpful? Yes No