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

Item journal not balancing as expected

(0) Share

Report

Posted on by Sam L

The history of this posting is as follows:

An incorrect part was bought into business central (965106SA1A)
The item has freight and duty, item charged to it
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:

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

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

All responses (3)

Answers (0)

Suggested answer

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

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 70 on at

Like (0)

Report

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 11,425 User Group Leader on at

Like (1)

Report

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.