web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / No Financial Quantity ...
Microsoft Dynamics AX (Archived)

No Financial Quantity Exists, but a Financial Amount Does - AX 2009

(0) ShareShare
ReportReport
Posted on by Community Member

Hi all,

I faced with the issue as below:

Company use Weight Average in Site level, so when i check the Item with Site and Warehouse level, some Item have no quantity but the have the financial value.

And, i want to adjust these Item so that the quantity shall correct with financial value.

Does anyone have the same issue as me? Could you please give me some advise?

Thank you so much,

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Thu Ngo,

    Similar questions have already been asked before in this Forum.

    Have you already checked the following threads?

    community.dynamics.com/.../137081

    community.dynamics.com/.../59987

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Thank you for your link, however, please let me explain my case in more details:

    - I have 2 warehouse: Finished Goods Warehouse and On the way warehouse.

    - When the Item is purchased - > will be posted in On the way warehouse, after that, transfer the item into Finished Good Warehouse. Basically, the quantity for on the way warehouse is nil each month end. However, since we using Weight Average in Site level, AX recalculate the financial value for each warehouse and lead to the current situation.

    Is there some way to adjust the financial value for On the way warehouse in my case? We already run the closing for inventory.

    Thank you so much,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    Can you test whether posting a counting journal with a quantity of 0 in the warehouse affected resolved the issue?

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    When i created a counting entry, there is no GL account posted - i guess it will be fine, however, i discovered other issue. One on the way warehouse has the quantity >0, but financial value is negative (let say: quantity is 50 but financial value is -9000).

    I would very appreciate if you could advice the solution for the current cases.

    Thank you so much,

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Thu Ngo,

    Have you tried adjusting the negative value through the inventory closing and adjustment form? Once you have run an inventory close you should be able to select the on-Hand adjustment and then be able to adjust the amount back to zero.

    Best regards,

    Ludwig

  • Suggested answer
    Anton Ivanov Profile Picture
    Anton Ivanov on at

    Hi Thu,

    If you have financial inventory only to SITE level – it is normal situation to have 0 Qty and financial amounts when run inventory value report on Warehouse level. This is related with the logic of inventory value calculation.

    System calculates and corrects inventory cost of shipments only to  the level of financial inventory dimension (site, warehouse, batch etc).

    Best regards,

    Anton Ivanov

  • Community Member Profile Picture
    Community Member on at

    Hi Anton,

    Yes, i think this come from our initial set up (only site) lead to this problem.

    Now, we faced with the issue when listed item in warehouse level:

    - Quantity is nil but financial value >0.

    - Quantity >0 but financial value <0.

    Do you have any suggestion to re-correct the issue?

    Thank you so much,

  • Anton Ivanov Profile Picture
    Anton Ivanov on at

    Hi Thu,

    My proposals are:

    - Explain to the customer the logic behind numbers in the report

    - Make a separate report / modify standard OLAP (if used) to calculates inventory value using cost from SITE level.

    Best regards,

    Anton Ivanov

  • Community Member Profile Picture
    Community Member on at

    Hi Ludwig,

    Sorry i'm not familiar with inventory, could you advise me more detail to adjust the negative amount? In the closing form, i didn't note where to adjust? Did i miss any thing?

    Thank you so much,

  • Community Member Profile Picture
    Community Member on at

    Hi Anton,

    So in short, there is no possible way to adjust the value without customize a new report?

    Best regards,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans