Forum Discussion

Nick34's avatar
Nick34
User
10 months ago

Error 25 - Invalid amount when importing a credit note

Hi there,

I tried importing a credit note into MYOB but I got Error 25. 

I have created the credit note and import it in the same way we always do, so I don't know what's the issue here.

Could someone please help?

Thanks

6 Replies

Sort By
Replies have been turned off for this discussion
  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    10 months ago

    Hi Nick34, 


    Thanks for posting and welcome to the Community Forum. 

     

    I'm sorry to hear about the failed attempt to import a credit note. I would suggest following these steps to fix the issue. 

     

    1. Open Excel and identify the column that causes the issue. 
    2. Select the entire column. 
    3. Right-click and click Format Cells. 
    4. Open the number category and follow the screenshot. 
    6. Click okay, 
    7. While saving the file there might be an error asking, "Do you want to keep using that format?".
    8. Click yes. 

    After following the steps, we try to import the file again. 

     

    Let us know if you require any further help with this. 

     

    Cheers, 
    Genreve

  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    10 months ago

    Hi Nick34 , for the invalid date error, the import program seems to be reading the field names as data. 

     

    I presume this is a service (sale) credit.

     

    Import files for the current version of AccountRight should have a pair of braces in line 1, like {} and nothing else in that line.

     

    However, it looks like your import file is designed for version 19 files, in which case no braces should be added, and AccountRight will use the old format.

     

    The import fields for both versions are available here:

    AccountRight Live (current version) 

    AccountRight v19.x 

     

     

    Would you be able to post the actual file you are importing, which will help us to find the error?

    • Genreve_S's avatar
      Genreve_S
      MYOB Moderator
      10 months ago

      Hi Nick34, 

       

      I hope you are doing well.

       

      You could also follow what Mike_James has suggested if my previously mentioned fix does not work. Also, we would appreciate it if you could post what you did to fix the issue, for other users with a similar issue to read through.

       

      Feel free to post again if you need any other assistance.

       

      Thanks,

      Genreve

      • Nick34's avatar
        Nick34
        User
        10 months ago

        Hi Genreve,

        Thanks for following up on this.

        Unfortunately, both responses didn't solve our problem as our credit note is in PDF not excel, and there was no bracket.

        We import credits from the industry software often and never had any issues before, so don't know what happened there.

        In this instance, we have created a credit manually in MYOB and applied to the invoice.

        Thanks,

        Nick