Finance | Project Operations, Human Resources, ...

Inventory value

(1) Share

Report

Posted on by CU09100936-0

Hi guys, i have an aging report in finance and operations which is showing a positive on hand and a negative average unit cost and inventory value, how do i correct that because the user

1. posted 11 purchase transactions without a cost(movement journals)

2.reversed them with a negative quantity without a value

3.post again a purchase movement journal with costs for the same item on the same date

so when you run the aging report for that month it shows the negative average cost and negative inventory value...what would be the problem and how do i rectify that

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Sort by

André Arnaud de Cal... 306,132 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Can you tell us what inventory costing method is selected on the item model group? Were these the only transactions for this item or are there many more?

Was this reply helpful? Yes No
CU09100936-0 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Its using weighted average costing

Was this reply helpful? Yes No
André Arnaud de Cal... 306,132 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your reply. Can you also answer my second question, please?

Was this reply helpful? Yes No
Suggested answer

BillurSamdancioglu 21,285 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Even depends on the parameters you select on inventory , you can mark the incorrect and correct transactions and run the inventory reval.

Was this reply helpful? Yes No