[GNC] Import invoices ~ tax table

[R. Victor Klassen]

I’m wondering whether I left out the “Tax Included” column, and whether there are no important columns after that so it just (almost) works.

I’ll have another chance to try it out this morning, as we have an importable invoice twice a week.  Something to try.

> On Mar 4, 2021, at 8:10 PM, Nelson Handcock <nelson.handcock at gmail.com> wrote:
> 
> In your original email you say your GST Tax table is in column P - mine is in column Q. So perhaps that's the problem?
> 
> Thanks & Regards,
> 
> Nelson Handcock
> 0409 149919
> 
> http://www.linkedin.com/in/nelsonhandcockaustralia <http://www.linkedin.com/in/nelsonhandcockaustralia>
> 
> On Fri, Mar 5, 2021 at 11:09 AM Nelson Handcock <nelson.handcock at gmail.com <mailto:nelson.handcock at gmail.com>> wrote:
> Hello,
> 
> Ahh yes - I mis-read your original email!
> 
> Here's a snapshot of my recent loadfile:
> <image.png>
> 
> And here's a snapshot of my tax tables:
> <image.png>
> 
> The loaded invoice looks fine in GN - the GST amount is correct and is showing in the liabilities account as defined.
> 
> 
> Thanks & Regards,
> 
> Nelson Handcock
> 
> 
> 
> On Thu, Mar 4, 2021 at 10:29 AM R. Victor Klassen <rvklassen at gmail.com <mailto:rvklassen at gmail.com>> wrote:
> When I said the x in the “Taxable?” column is correctly showing which items are taxable, I was referring to the column in the invoice after import.
> 
> I do have a Y in the appropriate column of the csv file being imported - else I wouldn’t get the x in the “Taxable?” column.
> 
> 
>> On Mar 2, 2021, at 2:50 PM, Nelson Handcock <nelson.handcock at gmail.com <mailto:nelson.handcock at gmail.com>> wrote:
>> 
>> Hello,
>> 
>> Try using "Y" in the Taxable column instead of "X"
>> 
>> Regards, etc
>> 
>> On Wed., 3 Mar. 2021, 02:40 R. Victor Klassen, <rvklassen at gmail.com <mailto:rvklassen at gmail.com>> wrote:
>> The documentation I’ve read has me specify the tax table in column 15 (counting from 0) aka column P when the csv file is opened as a spreadsheet.  
>> 
>> When I put the three letters “HST” or the phrase “Harmonized Sales Tax”, both of which name sales tax tables, in that column, it is ignored. 
>> 
>> The x in the “Taxable?” Column is correctly showing which items are taxable. 
>> 
>> Is there a trick I am missing?
>> 
>> 
>> Gnucash v 3.11 MacOS 10.13.6 if it matters.  
>> 
>> Sent from my iPhone
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>> To update your subscription preferences or to unsubscribe:
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user <https://lists.gnucash.org/mailman/listinfo/gnucash-user>
>> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists <https://wiki.gnucash.org/wiki/Mailing_Lists> for more information.
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
>