NOTE:  Connected Import(s) accept only tab delimited text files only.


Customer payments can be imported as Miscellaneous type receipts.  


This means that the payment is imported as "unapplied" and will need to be matched against  customer invoice(s) in a separate application entry.  


The Customer Payments Import uses CONNECTED’s modern import framework which supports custom field mapping and import preview.

 

To access the Customer Payment Import, select Import from the File menu and choose Customer Payments.  The following screen will appear:

 


To see a template of the import file format, export a sample, as shown in the following screen:


 

 

The import file needs to contain the following information (in default field mapping order):

 

  1. Customer Code - required; must be a valid customer code
  2. Bank Code - must be a valid bank code; if blank in the import file, the customer's default bank is used
  3. Date - receipt date; must be in an open accounting period; if blank in the import file, the current date is used
  4. Receipt No - required; 10 characters max
  5. Order No - 10 characters max; should be the sales order number if applicable
  6. Invoice No - 10 characters max; should be the invoice number if applicable
  7. Payment Method - required; must be a valid payment method
  8. Amount - required; must be a positive number
  9. Charge Amount - credit card charge amount; must be a positive number
  10. Transaction ID - credit card charge transaction ID; 20 characters max
  11. Authorization Code - credit card charge authorization code; 20 characters max
  12. Custom Sales Field 1: Custom Alpha - 40 characters max
  13. Custom Sales Field 2: Custom Alpha - 40 characters max
  14. Custom Sales Field 3: Custom Alpha - 40 characters max
  15. Custom Sales Field 4: Custom Alpha - 40 characters max
  16. Custom Sales Field 5: Custom Alpha - 40 characters max
  17. Custom Sales Field 6: Custom Alpha - 40 characters max
  18. Custom Sales Field 7: Custom Num - floating-point number
  19. Custom Sales Field 8: Custom Num - floating-point number
  20. Custom Sales Field 9: Custom Date - date
  21. Custom Sales Field 10: Custom Date - date
  22. Custom Sales Field 11: Custom Text - 1024 characters max
  23. Custom Sales Field 12: Custom Alpha - 40 characters max
  24. Custom Sales Field 13: Custom Alpha - 40 characters max
  25. Custom Sales Field 14: Custom Alpha - 40 characters max
  26. Custom Sales Field 15: Custom Alpha - 40 characters max
  27. Custom Sales Field 16: Custom Alpha - 40 characters max
  28. Custom Sales Field 17: Custom Alpha - 40 characters max
  29. Custom Sales Field 18: Custom Alpha - 40 characters max
  30. Custom Sales Field 19: Custom Alpha - 40 characters max
  31. Custom Sales Field 20: Custom Alpha - 40 characters max
  32. Custom Sales Field 21: Custom Alpha - 40 characters max


NOTE:  Custom Sales Fields that are not in use cannot have values imported into them.  Each customer payment imported creates an unposted, miscellaneous type receipt.

 

SPECIAL CHARACTER HANDLING:

 

Import values containing single and double quote characters and carriage returns cannot be directly imported. Using a text editor application, these characters must be removed and substituted with the following strings prior to importing. During the import process, the substitute strings will then be replaced with the original characters. Substitute /dqt/ for double quotes, /sqt/ for single quotes and /rtn/ for carriage returns. The forward slashes must be included.