So, after a bit of investigating, it was not a UoM issue. Come to find out, a sales person manually entered a huge cost amount on the Unit Cost ($) field in a sales order. I did a sales return and credit. Everything looks good in both Item and G\L Ledger Entry Journals. But it is still showing the inflation on the Chart of Accounts. But correctly on a Partner created report we run.
My new question: Where does the Cost of Goods Return live in Chart of Accounts?
Thanks for the help!
------------------------------
Michael Turner
Arizona Industrial Hardware
Chandler AZ
------------------------------
Original Message:
Sent: Jul 02, 2020 09:14 AM
From: Erin Neely
Subject: Units of Measure Question
Michael,
NAV does allow users to buy and sell in different units of measure. On the item card there is a Purchase Unit of Measure field and a Sales Unit of Measure field that allows you to default what unit of measure you are buying and selling in (which can be manually changed at the document level if needed)
Can you confirm if the Adjust Cost - Item Entries and Post Cost to G/L Reports have been run? The first report forwards the cost from the inbound item ledger entry to its outbound item ledger entry and the second posts those adjustments to the G/L. There is a checkbox on the first report to automatically run the second when it's finished.
You can drill down on the Cost Amount (Actual) field to see the costing entries posted against the item ledger entries
Could you post a screenshot of how the pricing portion of the item card is setup?
------------------------------
Erin Neely
Silverware
[email protected] | 480-423-8324
Original Message:
Sent: Jul 01, 2020 02:40 PM
From: Michael Turner
Subject: Units of Measure Question
Greetings,
I have an item with a base UoM of Inches. There are three UoM conversions.
------------------------------
Michael Turner
Arizona Industrial Hardware
Chandler AZ
------------------------------