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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

Item journal not balancing as expected

(0) ShareShare
ReportReport
Posted on by 70

The history of this posting is as follows:

  1. An incorrect part was bought into business central (965106SA1A)
  2. The item has freight and duty, item charged to it
  3. The mistake was realized, and an item journal was posted to adjust the wrong part negatively and positively adjust the correct part (965106SA7A)

However, when we look at the actual cost amount of each adjustment there is a difference:

pastedimage1668694862075v1.png

This difference seems to be these postings in the attached excel:

pastedimage1668694982932v2.png

The issue is that when this item the item journal is posted, the item which we are negatively adjusting (removing) has freight/duty item charges against it which are also moved to 710.3 stock adjustment.

 

Then on the other side of the journal the positive adjustment which brings the correct part into stock does not bring any freight/duty item charge with it so the freight/duty cost is left in 710.3

 

Please can you confirm this is what is happening? And if so, is there a better way for us to process situations like these?

 

Thank you

I have the same question (0)
  • Suggested answer
    Dallefeld Profile Picture
    235 User Group Leader on at

    Positive adjustments use the last direct cost field from the item cost whereas negative adjustments use the unit cost field.

    You can control this by use the applies-to and applies-from fields in the item journal.

    You could also try a Transfer.

  • Sam L Profile Picture
    70 on at

    Hi,

    Thanks, Kim,

    But the transaction has already been processed. How do I adjust 10870 which is my cost amount actual and shouldn't reflect.

  • Suggested answer
    Dallefeld Profile Picture
    235 User Group Leader on at

    Do you want inventory at the 67 cost or at 79?

    If 67 if what you want, the system has already accounted for the difference inventory adjustment account.

    If 79 is what you want, negative adjust the 67 and make sure you apply this new entry to the previously posted entry. Then positive adjust, making sure your cost equals the 79.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 566 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 347 Super User 2026 Season 2

#3
Grigorios Mavrogeorgis Profile Picture

Grigorios Mavrogeorgis 327 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans