Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
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 TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming 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