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
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 TimelineWatch the 2020 Release Wave 1 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 | Upcoming TechTalks
When I post a Purchase Shipment Only, whilst the Item Ledger Entry exists showing the reduction in stock nothing is shown on the Inventory Valuation Report.for the reduction and expected cost despite running adjust cost entries and posting inventory to G/L.
This is in standard Cronus with no mods.
Any advice you can offer would be gratefully received.
Thank you for your post on the Microsoft Dynamics NAV Forum.
Please confirm the country version being used. My testing has been completed in the North America Version of Microsoft Dynamics NAV 2016.
In my testing in a North America Version of Microsoft Dynamics NAV 2016 Version, I used Item 80014 and BLUE Location to start with a clean Item. I posted 10 units into stock at $28.00 through an Item Journal. Then, I posted a Purchase order as Received and Invoiced for 20 @ $28.00. From there, I created a Purchase Return Order and posted just the Shipment of the Purchase Return Order. As reflected on the Inventory to G/L Reconcile Report (REP 10138) and Inventory Valuation Report (10139), the Purchase Return is reflected in the Inventory to G/L Reconcile Report and Inventory Valuation as reduced Inventory Value.
In Inventory Setup, Automatic Cost Posting and Expected Cost Posting are enabled by checking the box to enable the postings of all inventory transactions immediately, both Received/Shipped and fully Invoiced inventory value as Cost Amount (Expected) and Cost Amount (Actual).
Thank you for your posting. I trust that the information will help answer your questions.
I am using UK Version on completing the following no reduction in Quantity or value is reported on inventory valuation:
1. Post and invoice purchase order.
2. Pot Purchase Return Shipment.
3. Run Adjust Costs and Post Inventory to G/L despite both being enabled in Inventory Setup.
4. Inventory Valuation Report shows no Decreases.
Any suggestions welcome.
All Purchase Related Transaction shown under "increases " Column including Purchase Return Shipment . Decrease only for Sales Related transaction .
Purchase Return Shipment also belongs to "Purchase" in Item Ledger Entry. Based on Entry Type System do the summation for invoice Quantity filed and display under "Increases" and "decreases" for Purchase" and "Sales".
Hi Rubhashis, Not sure if I understand, surely any inventory valuation repport must detail stock increases and returns as these are reductions ?
Sorry for the delay. However, this was assigned to US Forum Posting. I support the North America Region. The US (aka North America Database) Version reports are Report 10138 and Report 10139 (Inventory to G/L Reconcile Report and Inventory Valuation). As shown, these properly reflect the value reduction for Purchase Return Shipments.
Because this is a UK Version issue, can you submit this as a regular Support Incident so that the Europe based support team can review it? Are you a Partner who has access to Partner Source? If you are a customer, I would recommend communicating the issue to your UK Based Partner for escalation.
Business Applications communities