Import Error: Line 1 does not contain compatible tax information

Hi

I try to import an imp file looking like this

<Version>
    "12001", "1"
</Version>
<SalInvoice>
"Digipoint", "0", , "1050 boul. Hamel", "Québec", "Quebec", , "G1M2S3", "Canada", , , ,
"1", "", "CIT4", "05-11-2017", "0", "", "34,00", "0,00", "PST", "0", "0", "9,975", "3,39", "GST", "0", "0", "5,00", "1,70"
    "Démonstration", "1", "34,00", "34"
</SalInvoice>

...

I received the error : Import Error: Line 1 does not contain compatible tax information

Do you have any idea why ? I tried with the tax codes (G and P) with no success.

Thank you

  • 0

    Simon Georges said:
    "1", "", "CIT4", "05-11-2017", "0", "", "34,00", "0,00", "PST", "0", "0", "9,975", "3,39", "GST", "0", "0", "5,00", "1,70"
        "Démonstration", "1", "34,00", "34"

    I haven't checked all the syntax of your file but one thing just jumps off the page at me and is a common issue posted on this forum.

    See the $0.00 I highlighted in Red?  That's the Freight Amount on this entry.  The rest of the line is the tax applicable on the freight.  So how can you have anything other than zero for the taxes on the freight?

    Move that tax information to the line item itself.

    Then change the total of the invoice I indicated in Green.  Your tax calculation indicates that the taxes are not included in the amounts so an invoice of $34 + $3.39 + $1.70 can't = $34.

    I might also suggest if this file does not import after these changes, that you also change the decimal indicator of a comma to a period.  The import might not accept the French designation because commas separate the fields in this type of file.  I just have never tried French localisation in Windows to see if Sage 50 will translate the information properly.

  • 0 in reply to Richard S. Ridings
    Thank you for this answer I will make changes to the taxes to have something like
    <Version>
    "12001", "1"
    </Version>
    <SalInvoice>
    "Digipoint", "0", , "1050 boul. Hamel", "Québec", "Quebec", , "G1M2S3", "Canada", , , ,
    "1", "", "SF4", "05-11-2017", "0", "", "39.0915", "0,00"
    "Démonstration", "1", "34,00", "34", "PST", "0", "0", "9,975", "3,3915", "GST", "0", "0", "5,00", "1,70"
    </SalInvoice>
  • 0 in reply to Simon Georges
    Quantities and unit prices up to 4 decimals.
    Tax percentage rates up to 3 decimals.
    Total Dollar amounts per invoice or per line are only up to 2 decimals. $3.39 and $39.09
  • 0 in reply to Richard S. Ridings
    I changed my generator but I still have the same error. Did I miss something ? Thank you so much for your help.
    My file is now :
    <Version>
    "12001", "1"
    </Version>
    <SalInvoice>
    "Digipoint", "0", , "1050 boul. Hamel", "Québec", "Quebec", , "G1M2S3", "Canada", , , ,
    "1", "", "CIT4", "05-11-2017", "0", "", "39.09", "0,00"
    "Démonstration", "1", "34.000", "34.00", "PST", "0", "0", "9.975", "3.39", "GST", "0", "0", "5.00", "1.70"
    </SalInvoice>
  • 0 in reply to Simon Georges
    I've rewritten this message three times now and each version just sounds snarky. So I will leave you with the following.

    What are the sales taxes called (PST, QST, GST, TPS, TVQ, BOB)?
    What is the calculation (I mentioned this in my first post)?

    Note there is no tax code used here so you must go back to the tax code calculations.

    I don't know your data file so I can't tell you what is right, only how I would set up a Quebec company for sales tax. I can't give you the correct answer for your file.
  • 0 in reply to Richard S. Ridings
    Sorry if I bothered you.
    I will check the taxes in Sage50 and check again my calculation (which is PST 9.975% and QST 5%).
    Thanks for your help.
  • 0 in reply to Simon Georges

    Simon

    You are not "bothering" me.  Maybe I was just not clear enough for you to take my recommendation to look at the calculations.  And by calculation, I am referring to the setup in Sage 50 (see the image below).  However, if you are charging GST as one of the taxes on an line item total of $100, you can still use $400 as the sales tax amount on that line as long as the total invoice is $500.  I know this is confusing but it works.  The first four fields of each tax just allow the import program to pick the correct tax code (and yes I know it would be easier if they just programmed it to allow the import file to just use GQ as the tax code).

    I have assumed you are charging QST @ 9.975% and GST @ 5%?  Are they both refundable?

    Do you really have your provincial sales tax set up as PST as you have indicated or QST as most people refer to it?

    See the image below (I don't have an image already set up with QST and GST).

    For my file it would be setup as

    "HST", "0", "1", "13.00", "xxx"

    where xxx would be the dollars for the entry line.  For example, if I was selling $200 of something on this line, then the xxx=26 or 26.00.  Note I used HST because that is what the Tax column says in the image below.  I would not use PST in the import file if that Tax column said QST.  But as I mentioned before, if the Tax column said BOB, I would use BOB in my import file.

    If I was selling something with GST and importing into my file it would look like

    "GST", "0", "1", "5.00", "xxx"

    Hope this helps more

  • 0 in reply to Richard S. Ridings
    Thank you so much. I checked on Sage and the taxes were refundable as you expected and the tax names are in french. I did not noticed this configuration first. Now I just have a problem with encoding but I should be ok.
    Thanks again