Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) RECONCILING INVENTORY ...

RECONCILING INVENTORY TO GL IN NAV 2018

(0) Share

Report

Posted on by CBC

Hello, we have a customer that we are reconciling the inventory with the GL account in NAV 2018. The inventory value are different from the amount in the G/L Account, and on the expected cost NAV present the different bettwen the invetory value and the G/L Account. This customer do international purchases, we realized that they receipt the item with the arrived date and then Invoice the purchase with invoice date. For example the Posting Date for the invoice are Nov. 2018, but the Receipt Date are Febrery 2019. When they want to reconcile the G/L account until Dec 2018 the present a expected cost that unbalance the inventory Value with the G/L account.

Is there any option to reconcile this using this escanerio?

Thank you for the help.

Regards,

Carlos

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

TeddyH 12,868 Super User 2024 Season 1 on at

Like (0)

Report

RE: RECONCILING INVENTORY TO GL IN NAV 2018

There should be an option to show Expected Cost on Inventory Valuation report.

If that does not match, check if there is any direct posting to the GL account that cause the issue. (GL Entry filtered with System-Created Entry = FALSE)