Microsoft Dynamics AX (Archived)

Zero onhand but financial cost amount still exist

(0) Share

Report

Posted on by Cam Phung

997

Hi all,

I manage cost of product by Site.

However, when I print On-hand by another dimension (WH, Loc, Batch number..), many line have no on hand but financial cost amount still exist.

Can I clear this amount that have no on hand?

5008.14.png

Thanks you.

Phung Luong

*This post is locked for comments

All responses (7)

Answers (1)

Guy Terry 28,695 Super User 2025 Season 1 on at

Like (1)

Report

RE: Zero onhand but financial cost amount still exist

Hi Phung,

If you are running Inventory close each month, and still seeing On-hand with zero quantity but with a financial value (at some level of inventory dimensions), you could try one of the clean-up jobs. In a test environment (ideally with a copy of Live data), I would start by trying On-hand entries aggregation by financial dimensions or Warehouse management on-hand entries cleanup.

https://cloudblogs.microsoft.com/dynamics365/no-audience/2016/05/11/key-clean-up-features-for-inventsum-and-inventdim-tables/

https://cloudblogs.microsoft.com/dynamics365/no-audience/2015/12/28/improve-performance-by-running-the-warehouse-management-on-hand-entries-cleanup-job-for-new-ax-and-for-ax2012-r3-cu10/
Cam Phung 997 on at

Like (0)

Report

RE: Zero onhand but financial cost amount still exist

HI Ludwig,

I understand and I think I should export to excel and solve data there.

Thank you for your support :).

Thanks

Phung Luong
Cam Phung 997 on at

Like (0)

Report

RE: Zero onhand but financial cost amount still exist

Hi Mattguo,

I user weighted avg. cost.

I thank you for your clearly example, however, on hand still exist in another warehouse, if I receive inventory, cost price will be calculation not only base on warehouse that I have just receive inventory but also another warehouse.

I think I should export to excel in resolve data or create a BI report to view cost by warehouse/batch number.

Thanks,

Phung Luong
MATTGUO 22,319 Moderator on at

Like (0)

Report

RE: Zero onhand but financial cost amount still exist

Hi Phung Luong,

What cost model do you use?

It is a very tough process to clear those records which have Positive/negative amount without quantity.

Negative quantity need to be used. I give an example of a very ideal situation as my screenshot shows.
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: Zero onhand but financial cost amount still exist

G5008.14.png"_blank" href="/api/data/v9.1/msdyn_richtextfiles(9DC0382B-C990-47B1-922B-3A58F7BFFA3C)/msdyn_imageblob/$value?size=full">community.dynamics.com/.../5008.14.png)

I can see that you selected the warehouse in the second column.

However, in your storage dimension group, I can see that you do not track financial inventory at the warehouse level.

For that reason, trying to analyze the financial cost amounts at this level does not make sense.

What you can do is opening the on hand form by site only and start your analysis.

Hope you understand what I try to express here :-)

If not, feel free to provide some additional comments.

Best regards,

Ludwig
Cam Phung 997 on at

Like (0)

Report

RE: Zero onhand but financial cost amount still exist

Hi Ludwig,

I thank you for you response.

I run inventory recalculation and closing already.

As I mention, I manage cost by Site.

I know I must run the report to analyze cost by Site, but I wonder I can clear lines that have no on hand?

Thank you

Phung Luong
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Zero onhand but financial cost amount still exist

Hi,

Have you already run an inventory recalculation / close?

If not, I would recommend doing that.

Also, check at which level you track financial costs. THe previous screenshot shows batch number. Do you track financial values at that level?

If this is not the case, then running the form with this selection does not make sense and you would have to analyze the costs at a higher level that is in line with your invent. dimension configuration.

Best regards,

Ludwig