Good morning Intuit

Thanks for a good article describing importing invoices from a 3rd party system. 

After some testing, we ran into some issues, I hope you can help us with a few answers: 

At the start of the article, you say: 

• You can’t add discounts, credit notes, or negative amounts in general.

Question 1: 

Let's say you would like to import an invoice with two lines, a product of 1.000,- and an advance payment of 800,-  (an invoice line with -800 as the amount) with an invoice sum of 200,- as the total amount, for example: 

   Product A                   1.000,-

   Advance payment        -800,- 

   TOTAL                           200,- 

How can we do this if the import does not support negative numbers? 

Question 2: 

Let's say you import an invoice with one line, a product of 1.000,- which works fine. 

Then, you need to make a credit note of -1.000,- to make the first one in a zero balance. 

Finally, a new invoice with the correct amount 900,- is created and imported successfully. 

How can we do this credit note of -1000 automatically using the import function when you say that "Credit notes" are not supported?  

Question 3:

A separate invoice number is generated from the 3rd party system generating the invoices to be imported to Quickbooks. For example, the 3rd party system uses "[removed]", "[removed]" ... as invoice numbers. When importing these invoices, QB overrides these invoice numbers and assigns its own numbers "1435", "1436", .... To be able to keep the original invoice numbers, we add this number to the Memo field so we can see both numbers in QB. 

But, is there a way to keep the initial invoice number from the 3rd party system after importing data? (Instead of getting a new number from QB?)

Question 4: 

Each time you do an import, you must step through the wizard to select data format, tax options, tax code mapping, etc. 
The files we receive from the 3rd party system will always have the same date format, tax options, tax codes, etc., so there is a risk of manual errors because these data need to be set each time a file is imported. 

Is there a way that these options can be "hardcoded" so that the wizard does not ask for these settings every time a file is imported?