Customer Payment Import

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.