News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Adjust cost posted fro...

Microsoft Dynamics NAV (Archived)

Adjust cost posted from a Negative Adjustment.

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi All,

Around November last year, we had an issue where we were spitting lots through bespoke code (unaware of the Whse. Reclass Journal).

As you can see in the first 3 entries we were duplicating quantities. The fix to this was to do Whse. Item Adjustments and Item Adjustments to negative this double quantity. This has however led to a negative value in the Inventory Valuation.

What's the best way to get the value back in without changing inventory/adjustments if there is any.

Thanks.

4478.Capture.JPG

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Adjust cost posted from a Negative Adjustment.

We use FIFO. When I clear the costs it still uses the cost It was bought in at.
Hannes Holst 5,767 on at

Like (0)

Report

RE: Adjust cost posted from a Negative Adjustment.

Which Costing Method do you use?

You could post a negative adjustment of 100 with 0 as Unit Price (to eliminate the two lines with qty 50).

After that, you could post a positive adjustment of 100 with 23.20 as Unit Price.

Make also sure that all related vendor invoices are posted. I've explained here why this could lead to a negative inventory valuation.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans