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

Parents Reply Children
  • 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