Microsoft Dynamics AX (Archived)

Zero quantity in inventory but having Financial Value

(0) Share

Report

Posted on by nobowan

Dear All,

I have an issue in AX 2012, regarding Inventory. Our Inventory have zero qty but still have financial value.

Configuration

Warehouse

Batch number

Physical date

Financial date

Reference

Number

Receipt

Issue

CW quantity

CW unit

Quantity

Cost amount

DYHR-1

140806-LOT-001571

2014-6-1

2014-6-2

Purchase order

PO000056

Purchased

100

720000

DYHR-1

140806-LOT-001571

2014-6-5

2014-6-6

Sales order

SO000044

Sold

-100

-59042519.65

-58322519.65

Why not in the warehouse and batch dimension costing?

Thanks in advance.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi Nobowan,

Which Inventory costing method are you using? I guess it is not Standard cost or Moving average. If you are using FIFO, LIFO or Average, you have to recalculate and close inventory on a regular base.

Then the real cost will be corrected.

You can read more starting here: technet.microsoft.com/.../gg213716.aspx

You can also download a whitepaper explaining the costing methods: www.microsoft.com/.../details.aspx

It is a document for AX 2009 but still applies for AX 2012.

Was this reply helpful? Yes No
Suggested answer

nobowan 50 on at

Like (0)

Report

hi André Arnaud de Calavon,

Thanks for your help.

I used the inventory model is a Weighted AVG. date and Monthly average cost

I have closed the inventory, and run the recalculation, but cost amount is not adjusted.

kind regards,

Was this reply helpful? Yes No
André Arnaud de Cal... 301,231 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

What date was used for the closing/recalculation? Can you indicate if there are also other transactions for this item?

What are the settings in the Tracking dimension groups for the Batchnumber. I'm curious about the tick boxes "Physical inventory" and "Financial inventory".

If you look at the closing and recalculations it is possible to open a form "Settlements" can you find records related to this item?

Was this reply helpful? Yes No
Kareem_Murad 35 on at

Like (0)

Report

I am facing the same issue with one of my company customers. First it was result of not invoicing the transactions (Purchase order, production order, sales order), after closing these transaction it fix most of our problems, but even after invoicing we still facing the same, cost amount that have value and zero quantity in specific date. if you have any suggestion I could use, i would be grateful.

Was this reply helpful? Yes No
Guy Terry 28,924 Moderator on at

Like (0)

Report

Hi Kareem,

This is a really old thread. Would you mind to start a new one, and give an example of one of the issues you still face?

If you could include the settings of 'Inventory model' and 'Include physical value' from the Item model group', and tell us the lines on the Storage and Tracking dimension groups which are both 'Active' and have 'Financial inventory' ticked, that would be great too.

Was this reply helpful? Yes No

Community site session details

Zero quantity in inventory but having Financial Value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Zero quantity in inventory but having Financial Value

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates