When importing manual checks, can you import a check as a Payment type and tell it which invoices to apply the amount against, or only as a Cash Invoice type?

I couldn't get a good explanation either from the Help or from the sample import file.

Steve

Steve:

You can define the transaction type (Payment, Prepayment, or Cash Invoice), either in the import file or as a default field.

Is that the field called "Hdr-Transaction Type"? And then do I select the invoice using the field "Det-Document Number"?

If so, what is the two letter code I use to denote Payment?

Steve

Hi Steve,

There is good news and bad news. The good news is that yes, the Det-Document number field is used to specify the invoice number to which you want to specifically apply payment when importing either a Payment or a Prepayment transaction.

Within the help file, there is a page that lists all of the template format requirements for importing manual check batches, but admittedly I had to locate it through the Topic Search process rather than a direct link from the Importing / Exporting page. When I searched for 'import manual checks', the second topic listed with the title 'Import Format Notes - Checks' is the one you want.

The bad news is that although there is also another field in the import manual checks template called 'Det-Document Type' to allow applying payment amount to other transaction types such as credit notes or debit notes, that area currently isn't working. Only invoices can currently be applied to when importing manual check payments.

Hope all of this information helps.