NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Accounts Payable Payment Reconcile Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Cash Account |
29 |
Character |
No |
Enter a valid cash account for the payment reconciliation. If this is blank, it defaults to the default cash account. |
B |
2 |
Payment ID |
20 |
Character |
Yes |
Enter a valid payment ID you want to reconcile. |
C |
3 |
Cleared Date |
10 |
99/99/9999 |
No |
Enter the date the payment cleared. If this is blank, it defaults to the current date. |
D |
4 |
Payment Amount |
18 |
>>>,>>>,>>>,>>9.99 |
Yes |
Enter the payment amount for the payment ID entered in the Payment ID field. |
Before using this import, the following must be set up:
payments