In addition to the three tabs of options available with Transaction Pro Importer 5.0 for QuickBooks (“TPI”) there are also many more options/features available via our advanced command line parameters. These are very easy to enable and you can read more about all of the command line parameters available on our support forum.
We will just highlight five of these advanced command lines parameters available but we suggest that you take a minute to review the article on our support forum so you can see all the command lines that are available.
Command Line Parameter #1: /AUTORUN
Once you have a valid import setting the /AUTORUN parameter will allow you to just launch the application and then TPI will initiate the whole process. So essentially one click will go through the whole import into QuickBooks from start to finish. At a minimum you will also need to indicate where the import file will be located and there is another command line parameter available for this.
Developers will often use this command line so they can schedule the import through windows scheduler. However, a non developer type might use this to set up multiple shortcuts on the users desktop each being its own import type. So they might have one TPI icon for checks and another TPI icon for invoices.
Command Line Parameter #2: /RECPAY3
What if you are importing receive payment transactions into QuickBooks and your import file only contains the invoice number that the payment needs to be applied to and does not contain the customer name. If you enable the /RECPAY3 command line parameter TPI just looks for a match of the invoice number on all open invoices. You can read more about this in another blog post.
Command Line Parameter #3: /JE_NAME
If you are importing journal entry transactions into QuickBooks that have data mapped to the QuickBooks field, Name, if the name does not exist in QuickBooks TPI can add the name on the fly if you enable the command line parameter /JE_NAME. This can often time be helpful when importing data from a point of sale system that uses Accounts Receivable account as QuickBooks requires a name on journal entry lines that contain an accounts receivable account.
Command Line Parameter #4: /INVOICECREDITMEMO
If you have both invoices and credit memos in the same import file if you enable the command line parameter /INVOICECREDITMEMO you can import these in one import into QuickBooks instead of two separate imports. There are some formatting rules however. Invoices and credit memos must be all expressed as positive number and lines that are invoice transactions need to have the letter I on the same row and credit memos need to have the letter C on the same row. You can read more about this in another blog post.
Command Line Parameter #5: /INVOICESO=1
Adds new transaction type “Invoice Link Sales Order”. With this transaction imported invoices can be linked to existing sales orders in QuickBooks. A valid sales order RefNumber is required. You can read more about this in another blog post.
This is just an overview of what is available. You can download a free demo of Transaction Pro Importer for QuickBooks to test any of these out here. If you have any questions please post a comment below.