web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Inventory Adjustment / Rounding ? on Item Ledger Entries Application after Consumption

(1) ShareShare
ReportReport
Posted on by 21
Hello All!
 
I've got a weird issue today that I have never seen before.
 
On a consumption posting from a Production Journal, the system came up with an error message complaining that the Invt. Adj. Account is empty in Gen. Posting Setup for the Gen. Bus. Posting Group that is only used for Vendors. 
the screen:
Preview Posting worked fine, so the error actually happened on the application of Item Ledger Entries in the end (from what I understand it's not executed on Preview Posting). I'm running it automatically here.
 
So I was already confused because I've never needed to have that Acc. field for any combinations with Gen. Bus. Posting Groups not empty (so only for Item Journal transactions). But I've filled that G/L account in the setup and posted the journal. 
 
I've got two G/L registers:
the one I would normally expect with reposting of Stock components values to WIP and expected finished product value from WIP to Stock Interim. Screen below:

And the other one was partially unexpected. Some movements between WIP and Inv. Adjustment Account and WIP and STOCK accounts. 
 
The first movement I can see in Value Entries related to consumption of one of components. And I can imagine this is the adjustment after FIFO application with the Positive Adjustment entry.
 
The "rounding" is coming from the Purchase Invoice for another component. I can see nothing about the rounding for Item costs in BC. 
So does anyone know why this "rounding" happened here? Appreciate any reply :) 
thanks in advance!

Sergiy
 
 
 
 
 
I have the same question (0)
  • Valentin Castravet Profile Picture
    31,591 Super User 2025 Season 2 on at
    We would need to see your inbound entries for that component to know exactly why the system booked the rounding entry.
     
    I am guessing your costing method is not average? If its not average, the system calculates rounding when the inventory increase has been fully applied (when your purchase entry of the component has a remaining quantity of 0). So that's why the rounding entry was posted at this point in time. But to know why it calculated the 8 cents is why we would need to see the inbound entry. 
     
    This article should answer most of your questions - Design Details - Rounding - Business Central | Microsoft Learn
     
  • SergiyYakovlev Profile Picture
    21 on at
    hi Valentin,
    thanks a lot! this makes more sense now.
    The only issue with this is that BC is posting those adjustments with the original date of a purchase invoice. And it completely makes sense. But then if purchase invoice was posted in an already closed month we have an issue with Allowed Posting Dates. Of course we can reopen them to allow posting in a closed month "for a moment", but do you aware of any proper workaround for this? 
  • Valentin Castravet Profile Picture
    31,591 Super User 2025 Season 2 on at
    Thy system already has a "workaround" built-in.
     
    It will look at the original invoice date and compare it to the allow posting from in the general ledger setup. If the invoice date is after the allow posting from date then the rounding will be posted on the invoice date.
     
    If the invoice date is before the allow posting from date in the general ledger setup, the rounding will be posting on the allow posting from date. 
     
     
     
  • SergiyYakovlev Profile Picture
    21 on at
    right, but it didn't work for me this time
    shouldn't I use Inventory Periods for this to work? 
  • Valentin Castravet Profile Picture
    31,591 Super User 2025 Season 2 on at
    Can you expand how/why it didn't work?
     
    For example, of your invoice posting date was May 1, and your Allow Posting From in the General Ledger Setup was June 1, the system will make the adjustment on June 1. You don't have to re-open the posting dates or anything like that. 
     
    Inventory Periods will do the same thing as the Allow Posting From in the General Ledger Setup. But regardless if you have inventory periods or not, the system still checks the Allow Posting From in the General Ledger Setup and gives it precedence over the invoice date or over the inventory periods. For this reason I don't suggest Inventory Periods, unless they're required for other reasons, and ensure that the Allow Posting From in the General Ledger Setup is always maintained. This article describes this in more detail - Posting date on value entries - Business Central | Microsoft Learn
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,573

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 773 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 760 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans