Forum Discussion

Peter10's avatar
Peter10
Contributing User
4 years ago
Solved

sales invoice with 3 decimal places

I have a sales invoice which was imported from another source years ago but it was imported and calculated the total sales invoice with 3 decimal places. So now I have an amount of $0.003 outstanding...
  • Emily_B's avatar
    Emily_B
    4 years ago

    Hi Peter10 

     

    I just wanted to check in and see how the datafile repair went for you and to ensure that the discrepancies have been corrected in your company file. Please let me know if there is anything else you may need assistance with.

     

    If my assistance has helped solve your problem, please click 'Accept as Solution' to assist other users in finding this information mroe quickly.

Emily_B's avatar
Emily_B
Former Staff

Hello Peter10 

 

If you click on the blue arrow to enter the Tax field, (you'll get an arrow about changing the tax affecting BAS, click OK), in the 'Tax' column on the far right, see if you can edit out the last decimal place. I was able to edit this tax figure manually, changing it from the original $2,108.21 calculated to $2,108.55, so this may be as simple as deleting that .XX3 from the tax calculation which would in turn remove it from the balance owed. I was unable to test this in my own software though, as I couldn't trick it into adding that third decimal place. 

 

Please give this a go and let me know if it works.

Peter10's avatar
Peter10
Contributing User
4 years ago

Hi Emily

 

Thank you for responding, sadly no, this is not a fix, I tried this before without success. The transaction is very old May 2018 and year end processes etc of course been completed. I can't undertstand how MYOB would allow this in the first place

 

Hopefully you or someone else might have a fix for me

 

Thank you once again

  • Emily_B's avatar
    Emily_B
    Former Staff
    4 years ago

    Hello Peter10 

     

    Thanks for letting me know, just to confirm the process of what has happened: this transaction is from May 2018 from another source, it was for $23,190.34 and it was paid for $23,190.34. When you imported this transaction into AccountRight, the GST was calculated as $2,108.213 instead of $2,108.21, resulting in .003 out of balance on this invoice? Additionally, could you let me know what source you imported the transaction from and if there is any chance it was manually edited in error during the import process? As I am not finding any other examples of this happening I will need to investigate further but just want to confirm I understand the timeline of what has happened.

    • Peter10's avatar
      Peter10
      Contributing User
      4 years ago

      Hi Emily

       

      This all happened before I joined the company, I'm assuming they were importing data from Quickbooks. I was thinking about creating some other type of file to import into MYOB to fix up these errors, seeing as though MYOB accepts 3 decimal places when importing data. (the reason I want them fixed is so that the customers statement are correct and not show old invoices as outstaning invoices, they aren't the customer has paid in full apart from this $0.003 cent error)

       

      My other train of thought is perhaps an MYOB technical expert could allow us to temporarilly allow 3 decimal places, once fixed revert back to 2 decimal places

       

      What do you think?

      • Emily_B's avatar
        Emily_B
        Former Staff
        4 years ago

        Hi Peter10 

         

        Thanks for confirming. I've spoken with another team and they'd like to get your file sent in to have it looked at. This has happened occasionally in the past and results from an issue with the import, and it is something that has generally been able to be reconciled with the team working on the file in the backend. Please send me a private message with the following information:

         

        • Serial number of the file
        • Indicate which company file it is if you have more than one on that account
        • Your name and best contact number to use
        • Invoice number of the invoice this is happening on 

        Once I get that information I'll send this through to be looked at. Please click this link to send me a private message.