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

NAV 2018: Inventory to G/L Reconcile Report: There are variances every month: What Are the Typical Reasons This Is Happening That You Have Experienced?

(0) Share

Report

Posted on by Jen McCallister

NAV 2018: Inventory to G/L Reconcile Report: There are variances every month: What Are the Typical Reasons This Is Happening That You Have Experienced? I have been wondering if transactions are being changed after the fact but am wondering what else folks have seen as reasons for this to occur. Thank you!

I have the same question (0)

All responses (6)

Answers (0)

Jeroen Kooi 17 on at

Like (0)

Report

RE: NAV 2018: Inventory to G/L Reconcile Report: There are variances every month: What Are the Typical Reasons This Is Happening That You Have Experienced?

Hi Jen,

Variances on the inventory value are posted to G/L when running the report. You can also have it posted directly, and then you won't have to run the report. It depends on the size of the company if this is wanted. For big companies, it can make posting a little slow.

The behavior of inventory value all depends on the costing methods, the inventory posting groups and general posting groups (this was mentioned before by Greg). But if you have set in on FIFO then it's not very hard to figure out what is causing the changes

Variances on inventory values are, to my knowledge, being done:

-If a receipt is being invoiced

-Production order is finished (value of what's going in + production costs posted on the production order = value of what's going out)

-Item charges are invoiced over receipts or transfers

-Inventory value is changed with the revaluation journal

So you can always check if all receipts are being invoiced and if all production orders are finished before closing and presenting your G/L.

Was this reply helpful? Yes No
Jun Wang 8,182 Super User 2025 Season 2 on at

Like (0)

Report

RE: NAV 2018: Inventory to G/L Reconcile Report: There are variances every month: What Are the Typical Reasons This Is Happening That You Have Experienced?

I like Greg's answer. It opens up more areas to look into. Still user needs to narrow down on what items have the issue and what specific period such issue appear before able to dive in to pinpoint the culprit.

Was this reply helpful? Yes No
Suggested answer

Greg Enns 1,106 on at

Like (1)

Report
RE: NAV 2018: Inventory to G/L Reconcile Report: There are variances every month: What Are the Typical Reasons This Is Happening That You Have Experienced?

If your cost adjustments are all posted and you're still seeing a difference, then here are a few other things that I have seen cause differences between "Inventory Valuation" column and the G/L balance:

Document lines posting directly to the Inventory g/l account.(using a line type of "G/L Account".)

If you have Adjust Cost Automatically turned on, then Posting Date limitations can sometimes cause these adjusting entries to post in a different period than what the user is posting. (They don't respect User Posting limits--but are rather restricted only by date limits in General Ledger Setup.)

If an Item card has the InventoryPostingGroup and/or Gen.Prod.PostingGroup field changed while the item has quantity on hand, then this can cause problems if you filter your inventory valuation by either of those.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,429 Super User 2025 Season 2 on at

Like (0)

Report

RE: NAV 2018: Inventory to G/L Reconcile Report: There are variances every month: What Are the Typical Reasons This Is Happening That You Have Experienced?

Hi, I don't know where the difference you mentioned happened. If you think there is a problem with the amount here, you can click to view the details.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,037 Moderator on at

Like (0)

Report

RE: NAV 2018: Inventory to G/L Reconcile Report: There are variances every month: What Are the Typical Reasons This Is Happening That You Have Experienced?

Are you current with your cost adjustment in the system. It is important that you are up to date with that before you try to reconcile your inventory.

Was this reply helpful? Yes No
Suggested answer

Jun Wang 8,182 Super User 2025 Season 2 on at

Like (1)

Report

RE: NAV 2018: Inventory to G/L Reconcile Report: There are variances every month: What Are the Typical Reasons This Is Happening That You Have Experienced?

Hi without further information, the variance couldn't be accurately pinpointed. but you could check the report if there are amount in the highlighted columns. If yes, run post inventory to GL job

Was this reply helpful? Yes No