Category: Inventory

The Adjust Cost – Item Entries batch job adjusts inventory values in value entries so that you use the correct adjusted cost for updating the general ledger and so that sales and profit statistics are up to date. The cost adjustment forwards any cost changes from inbound entries, such as those for purchases or production output, to the related outbound entries, such as sales or transfers.

Basically, it will update your COGS and the Unit Cost on the item card to the correct cost that the item was brought in. Simply put, you HAVE to run this process BEFORE you do any meaningful financial and costing analysis.

It doesn’t matter what your costing method is. Doesn’t matter what your setup is. You HAVE to run this if you want to do inventory costing analysis in Dynamics NAV (Navision).

Here’s what the process looks like in RTC:

Here’s what the process looks like in Classic Client:

Note that the Adjust Cost – Item Entries will look different depending on the what version of Navision you use.

If you do not run this, no analyst in the world can begin to figure out what exactly the cost should be and address any incorrect inventory values you may have.

Side Effects
Note that if your company has never ran this before, or have not ran this in a long time, there may be detrimental affects on your inventory and COGS. Here’s a partial list of what you may encounter:

1. Your COGS on the G/L will go wild. The reason for this is that most companies, when they do not run the adjust cost, will use the general journal to “calculate” what the COGS should be. So when you do decide to let NAV do what it’s suppose to do, you will need to reverse these journal entries.

2. Your Inventory on the G/L will go wild. The reason is the same as above. The journal entries will need to be reversed.

3. Your item unit cost will go wild. The reason, again, is the same as above. A lot of times when you make an inventory journal adjustment to “take out” the inventory with the incorrect cost and positive adjust in the item with the correct cost, you are only doing it on the surface. The way NAV allocates and applies the inventory entries will most likely be different than what you adjusted.

Why Bother Going Though the Trouble?
Looking at the side affects, you may be wondering, why do I want to bother going through this process if I’m running fine as it is? The answer is simple, but it will reduce time and free up your company’s human resources to focus on important things.

Think about the manual spreadsheets and human memories that your salespeople need to figure out what cost the item should be before you can quote a competitive price to your customers. Think about the time it takes your internal accounting staff to figure out what your bottom line should look like on the financial statement. Think about if those times are freed, what other amazing things your employees can come up with to make your business even better.

Conclusion
A lot of companies will give their Trial balance to their CPA and let them make do the calculation. But realize that what they’re doing is just an estimate. It is NOT accurate. The CPA’s priority is to make the number seem reasonable so he/she can do your tax return and having paper trail if there’s an audit. His/her goal is not to get the accurate inventory cost.

Ask any good accountant, reconcilation is one of the most time consuming and useless tasks.

Ask any good salesperson, having a quote rejected because they cannot get the competitive price to the customer is not only a colossal waste of time on the company, but also for the customer. It reflects on the reputation of your company

Ask any good business owner, not having accurate profit and loss for each transaction… Well, you get the idea.

Let Dynamics NAV do its thing so it can help your business can do its thing.

Overview
Dynamics NAV is a ERP software that’s built on best business practice. However, that’s not to say that the users of Navision operates on best business practice.

This post describes what I would like to call Abnormal Item Charges. Again, as with what I’ve described with Abnormal Posting Date, don’t bother looking it up on any GAAP dictionary or NAV website. It’s a term that I made up because I lack the vocabulary to think of a better name. English, afterall, is my second language.

What is Abnormal Item Charge?
Abnormal Item Charge are posted item charges that are applied to the open Purchase Order that has not been received or invoiced.

An Example
A lot of times when a company orders some items from factories, they will buy the finishes of the goods that you want to order, i.e. special metallic paint. Because of the competitiveness of factories, they will sometime offer the company to pay only partial (or no payment at all) until the products are successfully manufacturered. The special finishes they will have to pay now.

So at the time of the PO creation, the company will only have paid for the special metallic paint. The company wants to pay for the paint while allocating the cost of the paint to the inventory that they will possiblity receive in the future. So an item charge line is created on the PO and allocated the cost of the paint ot the purchase lines.

The Effects on G/L
As we discussed previously, this item charge will post to the following G/L accounts:
+ Inventory
– A/P
+ Item Charge G/L Account (Purchases)
– Direct Cost Applied

So the additional cost of the item is correctly accrued to the inventory value.

The Problem
The additional cost components of the item has been allocated and correctly posted to the G/L. The problem is, there’s no inventory for the additional cost to apply to.

This means that the value entries will be created, but it will not reflect on the inventory valuation report until the items are received.

The Solution
In version 6.0 (NAV2009), they put out a fix for this in codeunit 90. Now if you try to post an item charge when there are no item ledger entry, it’ll give an error. However, this solution causes problems for the business case described above.

The solution for this was to comment out the code in NAV2009, then create a report that captures the additional cost posted to the G/L that did not have the corrosponding item ledger. We call this report the Abnormal Item Charge report. It’s a pretty simple report. If your company has the same problem, let me know. I’ll send you the report.

EDIT: One of my colleagues reminded me that we can also use the Prepayment Functionality in the US version to handle this. Basically, we would set the item charge line prepayment percentage to 100. Doing this will post the transaction into the prepayment account instead of the inventory account.

Conclusion
Again, NAV is designed to be best practice. This cause in particular forces us to break that best practice because it makes business sense. Note that I don’t usually like to break NAV’s built in best practices, but in this situation, it was a frequent part of the some of our client’s business, especially when factories are competing for orders in a down economy.

I recently signed up to be a guest columnist on the Microsoft Dynamics NAV community site. I wrote an article with the list of common steps to finding and reconciling the difference between your inventory valuation and the inventory G/L account. The article is posted in the Dynamics NAV Community site hosted by Microsoft.

The article is found here:
https://community.dynamics.com/product/nav/navnontechnical/b/navguestcolumn/archive/2011/09/12/reconciling-inventory-value-to-your-inventory-general-ledger-account.aspx

Again, the focus is to save you time so you can go home on time.

Abnormal posting date entries happens when the Posting Date of the receipt/shipments of inventory is after the Posting Date of the invoice. Why does this happen? You’ll need to ask your CFO or Controller. Typically, I found this more in return orders where the receipt of the product is a certain date, and the accounting department decides to post the credit memo in prior dates.

Either by mistake or intentional, if this happens, your Inventory Valuation will not tie to your G/L.

Here’s a step by step on how to replicate this problem, and how to solve this problem:
1. Create a sales order with posting date of 11/01/08
2. Post the Shipment with a posting date of 11/01/08
3. Change the posting date to 09/01/08
4. Post the invoice
5. Run your inventory valuation report as of 9/30/08
6. Notice that the item is not taken out? But if you look at your G/L, the inventory value is taken out.

This will work for purchase side as well. It doesn’t matter how to do it either using warehouse shipment/receive, the underlying process will net you the same problem.

Usually, problems like this won’t come up until the user is trying to do month end and gets really frustrated on why their inventory doesn’t tie to G/L. Unfortunately, there’s no easy way to reverse this transaction after it’s posted, the only way is to run a report at the end of the period to see what transactions have this “Abnormal Posting Dates”.

Here’s a report that will give you all the transactions that have abnormal posting dates. If you take this amount, add/subtract it to your inventory valuation report, it will be equal to the G/L inventory.

To run this report, just put the period you want to close on the Posting Date field. For example, if you’re trying to close November 2008, then your Posting Date filter should be 11/1/08..11/30/08.

Here’ the link for the report:

http://www.mibuso.com/dlinfo.asp?FileID=920

Here are a couple of reasons why you would get inventory value if you have 0 quantities when you print Inventory Valuation report and Inventory to G/L Reconcile report as of a certain date.

Scenario 1:

If the adjust cost is processed on 7/31/07, and the Allow Posting From was 7/1/07 on General Ledger Setup, the following would occur:

 6/15/07 – Purchase Receipt – $10
6/28/07 – Ship and Invoice – $10
7/15/07 – Purchase Invoice – $12
7/31/07 – Additional Cost for the sale made on 6/28/07 – $2

In this case, when you print the inventory valuation as of 6/30/07, the inventory quantity would be 0 and the inventory value would be 0.

Scenario 2:
If the adjust cost is processed on 7/31/07, and the Allow Posting From was 6/1/07 on General Ledger Setup, the following would occur:

6/15/07 – Purchase Receipt – $10
6/28/07 – Ship and Invoice – $10
7/15/07 – Purchase Invoice – $12
6/28/07 – Additional Cost for the sale made on 6/28/07 – $2

In this case, when you print the inventory valuation as of 6/30/07, the inventory quantity would be 0 and the inventory value would be -$2.00.

Explaination
Navision will automatically post the additional cost to the original invoicing entry because that’s where the cost originally applies to. If Navision detects that the Allow Posting From is before the adjusting date, then it will use whatever the Posting Date is when the adjust cost is ran.

Scenario 3:
If the adjust cost is processed on 8/31/07, and the Allow Posting From was 7/1/07 on General Ledger Setup, the following would occur:

6/15/07 – Purchase Receipt – $10
6/28/07 – Ship and Invoice – $10
7/15/07 – Purchase Invoice – $12
8/31/07 – Additional Cost for the sale made on 6/28/07 – $2

In this case, when you print the inventory valuation as of 6/30/07, the inventory quantity would be 0 and the inventory value would be 0. When you print the inventory valuation as of 7/31/07, the inventory quantity would be 0, but the inventory value would be $2.00.

Explaination
Navision will automatically post the additional cost to the original invoicing entry because that’s where the cost originally applies to. If Navision detects that the Allow Posting From is before the adjusting date, then it will use whatever the Posting Date is when the adjust cost is ran. In this example, since the Adjust Cost process posting date is 8/31/07, it will use this date as the Posting Date for the adjusting entry.