The following table explains the fields that are used in Tesorio's Zuora Cash Application integration. Instructions on how to set fields as required are available here.
Field Name | Required? | How it's populated | Zuora Field |
Customer Name | Mandatory | Suggested if Tesorio's matching algorithm finds a candidate. Recommended match must be accepted or a customer name manually set by the user. | Account (as identified by its accountId)
|
Payment Number | Optional | If not set by the user, a payment number will be assigned by Zuora during the sync. | Number |
Payment Amount | Mandatory | Populated automatically from the transaction record. Can be updated as needed. | Amount |
Currency | Mandatory | Populated automatically from the transaction record. List of currencies available from the ERP. Can be updated as needed. | Currency |
Applied Amount | Calculated | This field is calculated as the amount of the payment that is applied to an invoice. | Applied Amount |
Rate | Optional | Set manually by user. | N/A - Tesorio only field |
Unapplied Amount | Calculated | This field is calculated as the payment amount - applied amount | Unapplied Amount |
Invoices | Calculated | The invoices in this list correspond to the invoices that appear in the 'Payment Application' panel on the Zuora customer payment | N/A |
Status | Calculated | Payments in a 'Posted' status in Tesorio have been synced to Zuora. All other payments exist only in Tesorio. For more on statuses, read here. | Status |
GL Account | Mandatory | Populated automatically if you have configured a default GL Account for the bank account in Administration > Integrations > Bank Accounts. Can be set manually. | Account |
AR Account | Mandatory | Populated automatically when a payment is applied to an invoice. Can be set manually | A/R Account |
Payment Date | Mandatory | Populated automatically from the transaction record. | Created Date |
Payment Method | Optional | Populated with Payment Method Mapping Rules. Can be updated as needed. List of payment methods from the ERP is available. | Payment Method Id |
Memo | Optional |
| Comment |
Payment Tags | Optional |
| N/A - Tesorio only field |
Customer Tags | Optional |
| N/A - Tesorio only field |
Notes | Optional |
| N/A - Tesorio only field |