Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Inventory Adjustment /...
Small and medium business | Business Central, N...
Unanswered

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

(1) ShareShare
ReportReport
Posted on by SergiyYakovlev 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
 
 
 
 
 
  • Valentin Castravet Profile Picture
    Valentin Castravet 24,824 Super User 2024 Season 2 on at
    Inventory Adjustment / Rounding ? on Item Ledger Entries Application after Consumption
    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
     
  • SergiyYakovlev Profile Picture
    SergiyYakovlev 21 on at
    Inventory Adjustment / Rounding ? on Item Ledger Entries Application after Consumption
    right, but it didn't work for me this time
    shouldn't I use Inventory Periods for this to work? 
  • Valentin Castravet Profile Picture
    Valentin Castravet 24,824 Super User 2024 Season 2 on at
    Inventory Adjustment / Rounding ? on Item Ledger Entries Application after Consumption
    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
    SergiyYakovlev 21 on at
    Inventory Adjustment / Rounding ? on Item Ledger Entries Application after Consumption
    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
    Valentin Castravet 24,824 Super User 2024 Season 2 on at
    Inventory Adjustment / Rounding ? on Item Ledger Entries Application after Consumption
    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
     

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans