[Alan Hyde]

My Inventory Valuation Report normally equals the G/L balance.  But in the past 2 months, the Report for a certain Inventory Posting Group is showing an increasingly higher total value than the G/L account associated with that posting group.  We haven’t added any new items to that posting group, so I am baffled.  I looked at the long list of transactions in the G/L account, but didn’t spot any odd entries.  Any suggestions on where to look for the problem?  We are still on version 5 (scheduled to upgrade soon).

——————————
Alan Hyde
Controller
National Azon
Troy MI
——————————

[Felix Albrecht]

Hi Alan,

How are your cost posting settings set, are you posting inventory cost automatically or by report? Are you using expected cost? If inventory posting is set to automatically, I could set a filter on the inventory account on “System-generated Entry” = FALSE to determine whether there are manual entries.

If it is not set to automatically, I would check whether the reports “Adjust Cost – Item Entries” and “Post Inventory Cost to G/L” have been ran.

Best regards,
Felix

——————————
Felix Albrecht
Albrecht Solutions Inc.
San Francisco CA
——————————
——————————————-

[Paul Turner]

Felix likely hit on the solution.  If on the off chance it was not one of those things, you could also check whether you have any Received not Invoice or Shipped not Invoiced lines.

——————————
Paul Turner
Liberty Mountain
Sandy UT
——————————
——————————————-

[Alan Hyde]

We are set up for both Automatic Cost Posting and Expected Cost Posting.  I run the Adjust Cost – Item Entries and Post Inventory Cost to G/L when I close inventory for the month, but they don’t appear to have any effect.  I have reviewed the transactions in the inventory G/L accounts in question, and there are no manual entries causing any problems.

In my reconciliations, I do take into consideration the Received Not Invoiced and Shipped Not Invoiced, and I am still stumped.

——————————
Alan Hyde
Controller
National Azon
Troy MI
——————————
——————————————-

[Dave Cintron]

Check your Value Entry table for Adjustments that are larger than they “should be”. Adjustments are normally very small unless your expected and actual costs are more than a little different.

——————————
Dave Cintron
Dynamics West
Ventura CA
——————————
——————————————-

[Ian Ray]

Hi Alan,

This may be a longshot…

1. Run Post Inventory Cost to G/L
2. Open Value Entries window
3. Filter by
   Cost Amount (Actual) <> 0
   Cost Posted to G/L = 0

Are there any entries? There should not be.

Do the same for Cost Amount (Expected) and Expected Cost Posted to G/L if you have expected cost turned on.

If there are any entries, fixing it may be a matter of using SQL to populate the Post Value Entry to G_L table and running Post Inventory Cost to G/L. Trying this in a test company/database first, of course.

——————————
Ian Ray
Cypress Grove
Arcata CA
——————————
——————————————-

[Paul Turner]

Ian’s suggestion triggered another thought.  Do you post any production or Kit BOMs?  If so try this:

1. Similar to Ian’s filters but looking at ILE instead of VE (so that it is easier to navigate to Prod Order Line records): filter ILE to the items that have a Kit BOM assigned (or use a function or report if you have a lot of these types of items).
2. Filter where “Cost Amount (Expected)” <> 0. (If using a function or report for this, remember to CALCFIELDS here as this comes from Value Entries)
   1. If this filter returns a ton of records you could narrow it down with a report that finds any where “Invoiced Quantity” <> Quantity
3. Navigate to the related Prod Order Line record from any ILE you find with these filters.
4. If that record’s Kitting and “Cost is Adjusted” fields are TRUE, then modify that Prod Order Line record’s “Allow Online Adjustment” and “Cost Is Adjusted” fields to FALSE.  Will need the requisite table mod permission for this, or can carefully use SQL.
5. Run the adjust cost report again and see if that helped.

Basically looking for any records where NAV thinks the prod order line costs were adjusted but these costs did not flow through to the Value Entries, and NAV won’t try again until we put that record back into the queue.

——————————
Paul Turner
Liberty Mountain
Sandy UT
——————————
——————————————-

[Kim Dallefeld]

Looks like you checked the basics but…

Is direct posting turned off for your GL account. If not filter gl entries for source code <>INVTPCOST.  Sounds like you’ve already done this. Check your inventory posting and general posting setup, did someone accidentally make a change causing your issue?

If you re-run for the last time the report was in balance, is it still in balance? Can you work forward to a specific day where the GL and the inventory went out of balance.  Now can you navigate to find the problem transaction.

Are you doing assembly orders or production orders? 

As you can see there are several things that can happen and we can ask lots of questions to get to the answer! Good Luck!

——————————
Kim Dallefeld
NAV Consultant
Past NAVUG Chair
NAVUG Programming Committee
Ft Worth, TX
Kim@Dallefeld.com
——————————
——————————————-

[Alan Hyde]

Thanks for your suggestions, everyone.  I’ve been working through them, but haven’t found the cause of the problem yet.  I appreciate your input.

——————————
Alan Hyde
Controller
National Azon
Troy MI
——————————
——————————————-