AR Customer and Invoice Upload Process

Customer Upload:

  1. For new customers only (duplicate checking overridden)
  2. Batch process for new customers only
  3. Online for new customers or existing customers
  4. Mass edits cannot be done via batch
  5. .xml format only, if using batch


Customer invoices:

  1. For batch process, must process at least one day following batch customer upload
  2. If customer were entered online, can process invoices same day
  3. Credit memos need KFS invoice number (so usually done via screens)
  4. .csv or .xml format (.csv is most popular)
  5. Remove 1st two lines from .csv template (title line must remain)

Step-by-step guide


See attachments to this subject as they contain detailed descriptions of the upload files (Customer and Invoice), templates for layout of those files, and further processing notes.



Related content

Customer Test Files and Templates
Customer Test Files and Templates
Read with this
Account Receivable Upload Process
Account Receivable Upload Process
More like this
Customer .csv File Format
Customer .csv File Format
Read with this
Creating a Customer Invoice
Creating a Customer Invoice
More like this
How to Automate Billing (Collector) File Upload
How to Automate Billing (Collector) File Upload
More like this
List of Uploads
More like this