Forum Discussion

Clinton_ELA's avatar
Clinton_ELA
Experienced User
2 years ago

Remove extra long decimals

Hello,

 

We do alot of Autobuilds in our inventory and have a few Inventory items with extra long decinal points.

 

How can we get these extra long decinal points rounded down to 3 points?

 

Regards

Clint

  • Isaiah_C's avatar
    Isaiah_C
    MYOB Moderator

    Hi Clinton_ELA,

     

    Thank you for reaching out to us and I'll be glad to assist you with this. We need to run a script to fix the issue. Please send me a Private Message containing the following:

     

    • Serial number
    • Business name
    • Company File ID (Help>>About MYOB AccountRight)

     

    Please let me know if you need further help.
     

    Kind regards,

    Sai

    • Clinton_ELA's avatar
      Clinton_ELA
      Experienced User

      Is there anything I need to check or do in my inventory before you run the scrip to fix the long decimals?

      • Leneth_A's avatar
        Leneth_A
        Former Staff

        Hi Clinton_ELA,  

           

        Apologies for the delay in responding. I understand that this concern is important to get resolved as soon as possible, and we apologize for not getting back to you sooner. We appreciate your patience and understanding on this matter.  

           

        Regarding your question about company files that show unusually long decimal places or N/A inventory values, you may check the following before we do arrange for a script.  

         

        Please note that if you do have any receive item transactions these would need to be converted into Bills before this process.  

        Go to Inventory>>Item List>>Inventoried tab and click to sort by On Hand (select the column heading). Ensure that no items are shown as having a negative on-hand value.  

        Run the Inventory Value Reconciliation report and check to ensure that there are no invalid amounts. Invalid amounts being a negative or an item that has 0 on hand but a value in Inventory  

           

        If those options are fine and you do not have any negative values, we can arrange for the script to be run. For us to do this we need to confirm the following details in a private message:  

        • Product serial number - Setup>>Company Information  
        • Company file ID - Help>>About AccountRight  
        • Business name  

         

         

        Please do let us know how you go, and feel free to post again anytime you require further assistance.  

           

        If my response has answered your enquiry, please click "Accept as Solution" to assist other users find this information.  

           

        Cheers,  

        Leneth