Landed cost using item charges in Microsoft Dynamics NAV 2015
Today what I’m going to do is demonstrate how to post landed cost using something called Item Charges in NAV.
What we really want to do is take cost from a freight purchase invoice and apply that to the receipt of an item so that we can increase the cost of the item in our inventory. So the cost of goods sold, when we sell it, is reflected accurately.
View Item Charges
So let me go ahead and just take a look at Item Charges.
What we’ve defined in our demo system that ships with NAV shows these item charges. Item Charges serve as an instrument that I can put on a purchase invoice and apply it onto the receipt.
We have purchase allowance in there, freight charge etc., so probably the most appropriate one is to use is the freight one.
Create a Purchase Order
So I go ahead and go into the purchase order.
Click on “New”.
I’ll create a purchase order for a shipping company called “The London Post Master”. So I’m going to look that one up, enter it in.
Inputting the Line
Then I go ahead to “Type” under “Lines” and instead of picking a GL account or something like that, which normally freight would be posted to; I’ll just pick “Charge (item)”.
Then I go ahead and select the item charge from the list I saw before, and that’s going to be “Misc. Freight Charge (Purch.)”.
In the “Description”, I type “Freight from London”.
I don’t have to put in the location, I just put in “1” for the “Quantity”.
Just “1” signifying that I’m going to put the total amount in the “Direct Unit Cost”. So we paid “120.55” for this.
Assign an item charge to a receipt
Now what I’m going to do is go into Line > Item Charge Assignment, and I want to assign this to a certain receipt of a coffee mug. Go ahead and click on that.
The “Edit – Item Charge Assignment (Purch)” screen comes up. I’ll click on “Get Receipt Lines”.
Now I’m in the “Purchase Receipt Lines” screen, so I click on one of the last receipts here, the one for 1000 pcs.
In this new screen, I click on “Suggest Item Charge Assignment”.
That basically means I’m going to spread the freight over the items on the receipt (there’s only one item on the receipt) so if I just do it equally here it will put the entire freight onto that item.
Now I put in the invoice number onto the vendor, which was "abc3456" and now I’m ready to post.
So just keep in mind that it was for those thousand that we got.
Now I hit post.
I make sure “Receive and Invoice” is ticked, click “OK”.
You can see it posts everything.
View Item Ledger Entries
And now when I want to go into that item, clicking on “Items”.
I want to take a look at my coffee mug so I look for it in my Items.
So I go into the entries by clicking on Entries > Ledger Entries.
I can see if I take a look at the first purchase receipt that the “Cost Amount” is “5,120.55”. I click on that.
In the “View – Value Entries” screen, I can see that the freight has been applied.
So I paid “5,000.00” to the vendor, but I paid “120.55” to the freight company.
View the updated COGS
So my total cost is “5120.55”. What you can also see is that all of the transactions to sales have increased. The cost has increased now, so even though the sale happened after I applied the item charge, it has updated the cost of goods sold everywhere where we sold out of this receipt.
And that basically describes the way Item Charges work (or “Landed Cost”, as it’s commonly referred to in the industry) in NAV.