US - Arizona - Phoenix

Greetings,

I have an item with a base UoM of Inches. There are three UoM conversions.



------------------------------
Michael Turner
Arizona Industrial Hardware
Chandler AZ
------------------------------

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.

The default is showing IN.
Then there is FT and SP (spool) This is for a wire.

My question is, when not using the default UoM. Do you have to sell it in the same UoM as it was bought? I am showing a huge despondency on money from what we bought, and what we sold. The quantities are correct, the cost and price seem to be thrown off as it was purchased in spools, and sold in FT.

------------------------------
Michael Turner
Arizona Industrial Hardware
Chandler AZ
------------------------------

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.

The default is showing IN.
Then there is FT and SP (spool) This is for a wire.

My question is, when not using the default UoM. Do you have to sell it in the same UoM as it was bought? I am showing a huge despondency on money from what we bought, and what we sold. The quantities are correct, the cost and price seem to be thrown off as it was purchased in spools, and sold in FT.

------------------------------
Michael Turner
Arizona Industrial Hardware
Chandler AZ
------------------------------

Greetings,

This is a closed case. Come to find out, routine Adjust Costs was taken down a couple years ago, and someone used to do it manually. But, it had not been ran in a very long time. So, working through all that.

------------------------------
Michael Turner
Arizona Industrial Hardware
Chandler AZ
------------------------------

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.

The default is showing IN.
Then there is FT and SP (spool) This is for a wire.

My question is, when not using the default UoM. Do you have to sell it in the same UoM as it was bought? I am showing a huge despondency on money from what we bought, and what we sold. The quantities are correct, the cost and price seem to be thrown off as it was purchased in spools, and sold in FT.

------------------------------
Michael Turner
Arizona Industrial Hardware
Chandler AZ
------------------------------