Item Journal changed negative to positive at post

(0) Share

Report

Posted on by addision1

323

I need some help!

I did a "rapid start" import into a test company for table 83 of both positive and negative adjustments. I have an inventory of many thousand items, the calculate inventory option will not allow e to copy and paste the changes from an excel spreadsheet, so I had to figure out how to import these changes.

My rapid start import appeared to go just fine. It added lines to the item journal for those amounts both positive and negative. Then when I looked at the item journal I could see that there were both positive and negative adjustments listed. I did a "test report" and it showed positive and negative entries.

However, as soon as I posted those lines, all of the amounts were posted as positive adjustments only. The "type" still showed "Negative Adjust.", but the values were all positive when posted.

What happen here? I am glad I did this in a test company or I would have a lot of trouble on my hands. Why did these all post as positive amounts?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

Suresh Kulla 50,280 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Did you use -ve amount or -qty on those lines ? If so that will cause that issue. You need to use +ve values even though the entry type is Negative Adjustment.

Was this reply helpful? Yes No
Rashed 3,765 on at

Like (0)

Report
Copy link

Link copied!

When you post item journal, Make sure the sign is always positive. You posted the item journal with entry type = Neg adj and quantity sign being negative.

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report
Copy link

Link copied!

Entry Type Negative Adjustment means system will decrease the inventory & value, this is handled by system itself.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report
Copy link

Link copied!

It seems there is problem with your quantity field .

Can you paste entries screenshot here for analysis ?

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report
Copy link

Link copied!

addision1 ,

can you make sure you have entered (-Quantity) at the time you post

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report
Copy link

Link copied!

I would guess that you had entered a quantity with minus sign for negative adjustment lines - can you check that first? You should enter positive figures in the quantity field even for negative adjustment type.

Was this reply helpful? Yes No
addision1 323 on at

Like (0)

Report
Copy link

Link copied!

Thank you everyone for the guidance. Yes, my problem was that I used a (-) symbol in the amount and selected "Negative Adj.", thereby creating a double negative situation leading to a positive adjustment.

Was this reply helpful? Yes No