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

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No
Cam Phung 997 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
MATTGUO 22,349 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Cam Phung 997 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Cam Phung 997 on at

Like (0)

Report

HI Ludwig,

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

Thank you for your support :).

Thanks

Phung Luong

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

Like (1)

Report

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/

Was this reply helpful? Yes No