Skip to main content

Notifications

Business Central forum
Suggested answer

Item journal not balancing as expected

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

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Item journal not balancing as expected

    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.

  • Sam L Profile Picture
    Sam L 70 on at
    RE: Item journal not balancing as expected

    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
    Dallefeld 11,423 User Group Leader on at
    RE: Item journal not balancing as expected

    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.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans