US - Arizona - Phoenix

 View Only
  • 1.  Units of Measure Question

    Posted Jul 01, 2020 02:40 PM
    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
    ------------------------------


  • 2.  RE: Units of Measure Question

    Posted Jul 02, 2020 09:15 AM
    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
    ------------------------------



  • 3.  RE: Units of Measure Question

    Posted Jul 02, 2020 10:56 AM
    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
    ------------------------------



  • 4.  RE: Units of Measure Question

    Posted Jul 06, 2020 10:52 AM
    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
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role