Transaction is not balanced

Hi All, 

Sometimes, when importing the .IMP files for purchase invoices we receive the "The transaction is not balanced" message.

It is difficult to understand the reason. As for us the Quantity*Price = Amount is well calculated(200*10.5=2100). 

Is there another reason for this message? 

Here's an example of an IMP file(Name, Address, Posta Code,... was changed):

Thanks

  • 0

    The entry is not balanced.  The total $2100 currently equals $0 in your header.

    You have put the $2100 in the header in the Ship Date field.

  • 0 in reply to Richard S. Ridings

    I tried this but indiferrently of the Ship Date value we are receiving an "Invalid total amount" message. 

    When I exported a purchase invoice from Sage to see the IMP file format it did not contain a Ship Date field. 

    So we thought this field was not necessary for purchase invoices

    IMP file with Ship Date:

    Thanks

  • 0 in reply to mapo

    Sorry, I think the problem is that the Ship Date is only required for importing a Purchase Quote and is not used in a Purchase Invoice (don't ask, I don't know why).  Try removing it and the comma, and then leaving the rest the same (9 fields across the header).

    If that doesn't work, copy the text of your *.imp file into a message, not an image so I can copy it into a file here and I will test it when I get a chance.

  • 0 in reply to Richard S. Ridings

    That's what I already did and the message was "The transaction is not balanced". 

    <Version>
    "12001", "1"
    </Version>
    <PurInvoice>
    "AAAAAAA","0", ,"BBBBBBB", ,"CCCCC","DDD","EEEEE", , , ,
    "1","11111","2222","07-09-2019","2100.00","0.00","0","0","0.00"
    "BT","200.0000","10.5000","2100.00"
    </PurInvoice>

    Thanks

  • 0

    Unfortunately this is not still solved Worried

    Everything seems to be correct in the file but the error message still appears. 

  • 0 in reply to mapo

    Update for those members reading along.

    I spoke with mapo today and we went through several things to try and get their file to import.  The short story is that I am seeing no problems with the import file.  The long story is below.  If anyone has any ideas, please jump in.  I failed!

    Today we looked at what might be wrong but each attempt still gave us the unbalanced message.  The file is above posted by mapo two days ago but the one we worked on has the real vendor name and address.

    These are the issues I reviewed today

    1. Client is running in French, so I tried English as well, no resolution
    2. Client is double-clicking the *.imp file to trigger the import.exe utility, so I ran it from the File menu, no resolution
    3. Tried a file in Universl on the client's computer and it imported using the File menu
    4. The import does identify the vendor or imports a vendor not already in the system
    5. The import does identify the item code for selection properly before it stops due to the unbalanced error
    6. The import file does have a blank line after </PurInvoice> with CRLF

    If anyone has any ideas to try, please post.  I've never come across an import that will work in one *.sai file and not another.  This does not appear to be an issue that the import file has excessive decimal places that are not rounded before comparison like you can find the program.

    Thank you

  • 0

    Hi All, 

    Here is a version of the file that doesn't work. 

    Thank you very much.

    <Version>
    "12001", "1"
    </Version>
    <PurInvoice>
    "L�gumes A&B,"0", ,"26 Info Belloel", ,"Sherrington","Quebec","J5L 2N1 ", , , , 
    "1","164206","6710","07-09-2019","2100.00","0.00","0","0","0.00"
    "BT","200.0000","10.5000","2100.00"
    </PurInvoice>
    

  • 0 in reply to mapo

    Could you please share a working file format

  • 0 in reply to afsalammad

    I don't have it anymore and the client has chosen another accounting system.