Small and medium business | Business Central, N...

Inventory Valuation Report NAV 2016

(0) Share

Report

Posted on by andrew.atkinson@ing...

Hello,

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.

I have the same question (0)

All responses (5)

Answers (0)

TWBlaisdell on at

Like (0)

Report

Greetings,

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.

Inventory Valuation

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.

Best Regards,

Tom

Was this reply helpful? Yes No
andrew.atkinson@ing... 34 on at

Like (0)

Report

Hi Thomas,

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.

Thanks

Andy

Was this reply helpful? Yes No
Suggested answer

subhashis Das 579 on at

Like (0)

Report

Hi ,

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".

Regards
Subhashis

Was this reply helpful? Yes No
andrew.atkinson@ing... 34 on at

Like (0)

Report

Hi Rubhashis, Not sure if I understand, surely any inventory valuation repport must detail stock increases and returns as these are reductions ?

Thanks

A

Was this reply helpful? Yes No
TWBlaisdell on at

Like (0)

Report

Hello Andrew,

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.

Thank you.

Best Regards,
Tom

Was this reply helpful? Yes No