web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Inventory subledger no...
Microsoft Dynamics NAV (Archived)

Inventory subledger not balancing with general ledger

(0) ShareShare
ReportReport
Posted on by alison 25

We have been using NAV for almost two years and somehow our inventory subledger is out of balance with the general ledger. To temporarily correct this problem we have been posting an adjusting entry directly to the GL to bring it in line with the inventory subledger's valuation. This typically needs to be done on a daily basis.

 Has anyone else experienced this type of problem?

 We are reconciling the transactions affecting inventory accounts on a daily basis in order to try and pinpoint what is causing this variance. So far we have been able to match all entries in the item value entry table with the general ledger yet we are still out of balance.

Any suggestions would be greatly appreciated!

 Thanks!

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Alison,

    Are you using expected cost posting and showing the expect cost when running the inventory valuation report?

    Also you will need to review your costing setup  for example are you running the adjust cost routine?

     

  • alison Profile Picture
    alison 25 on at

    Thanks for your response!

    We do have "Expected Cost Posting to G/L" selected (on the Inventory Setup screen). The Expected Cost field is displayed on the Inventory to G/L Reconcile report however it is not part of the Inventory Valuation report. We are using the original Inventory Valuation report that came with Navision and it uses Unit Cost * Remaining Qty.

     We are running the adjust cost routine daily.

    Any further thoughts?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans