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 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