End of mainstream support for Microsoft Dynamics AX 2009, 2012, and 2012Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended Oct. 9, 2018. After that date, only security hotfixes will be provided for these three versions through the extended support period that until Oct. 12, 2021. Read more
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
I would like to ask about the AX Inventory value report.
First of all, i am running my inventory cost at weighted average and financial cost at Site only.
How come i am getting a inventory value report with no physical stock but with inventory value?
My simulation as below:
1. Posted a PO00001 with financial qty of 10 and financial value of 1,000
2. Posted a PO00002 with physical qty of 10 and physical value of 1,200 (Not invoice yet)
3. Posted a Sales order SO00001 with financial qty of -10 and financial value of -1,100 (1,000 + 1,200)/20
4. Posted a Sales order SO00002 with financial qty of -10 and financial value of -1,100 (1,000 + 1,200)/20
All these happened in the same month. When i run inventory closing on 31/7/19, i can see the cost for SO00001 adjusted to 1,000 but not my SO00002
End up when i generate my inventory value report, i am getting no physical cost but with inventory value.
Wonder is there a good explanation on this or how to eliminate this?
I assume that this is a demo/test environment, right?
Can you try invoicing all PO's and run a new inventory recalculation. Once that is done, run the report again.
That is the exactly the result after i ran the inventory closing.
The issue here is i have received 10pcs physical value of 1,200 with invoice and the goods was sold off
What I understand is that you bought 20 and sold 20 so you have no physical stock.
You have however only financially invoiced 10, so only 10 can be settled with inventory close.
The rest of the settlement is awaiting financial update. If you post the receipt invoice this month and close, then then the SO2 will settle. Over two months the total inventory value issued will be correct.
Yes, you are right!
But for client, they said since there is not physical inventory shouldn't have any inventory value.
Wonder is there is setting or parameter to set
Are all items sold and invoice updated?
Thanks for confirmation Dexin. Please select 'Yes' against the answers that helped you to close this thread. This will help verify the answer as well.
Can you try invoicing everything and then run the report again?
Things should add up to zero then.
What you see is regular behavior of the system. You need customer to help understand that Physical and Financial inventory components. What you can also demonstrate is that financial inventory works on the basis of invoices (PO + SO), if they are not balanced they there will be discrepancies reported by the system. In addition, if customer doesn't post PO invoices regularly (which they can't control), they have to start getting used to these.
Whenever the PO invoices are posted, the inventory close will balance the numbers.
From an audit standpoint - Our system shows value of financial inventory balances if we haven't received and processed the corresponding purchase order invoice from the vendor. Once the invoice is received and processed, inventory closing will be performed and it will balance the inventory issues and receipts financially.
As a backup to this if asked, you can also print your 'Received not invoiced' report, it will have same item number as it's reflected on the inventory value report.
It can have same behavior. However production is internal order and with proper procedure in place, this inventory related issue can easily be avoided. Why not end if already finished.
I don't think you want to prevent sales from invoicing, if you do check item model group parameters.
Hi Dexin and Satish,
Please wait a minute to get this clarified.
You mentioned that 20 pcs were sold but only for 10 pcs of them - that is for sales order no 1 - the invoice was generated.
Don't you post the sales order packing slip in ledger?
If you post the packing slip in ledger then I wonder why the report still shows a physical inventory value of $1200.
Sales order no 2 has already been shipped if I understood you correctly and if you post the packing slip in ledger I would not expect a physical inventory value of $1200 because physically nothing should be in stock, right?
As I understand it there is no physical value.
20 pieces were sold at the average cost in the system but with only 10 financially accounted so it left a negative amount.
If you allow financial negative then that is what happens.
If not then don't allow it and hold shipment until invoicing is updated.
(where would you expect the negative value of 10 pieces of inventory shipped at no cost to sit if not in inventory?
If it ships with a cost then where does that cost come from if not set off against a vendor liability?)
This is how average costing works.
Business Applications communities