The following table explains the fields that are used in Tesorio's NetSuite Cash Application integration. Instructions on how to set fields as required are available here.
Field Name | Required? | How it's populated | NetSuite 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. | Customer |
Payment Number | Optional | If not set by the user, a payment number will be assigned by NetSuite during the sync. | Payment # |
Payment Amount | Mandatory | Populated automatically from the transaction record. Can be updated as needed. | Payment 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 |
Rate | Optional | Set manually by user. | Exchange Rate |
Unapplied Amount | Calculated | This field is calculated as the payment amount - applied amount | Unapplied |
Class | Optional | List of Classes from the ERP is available. Populated with Account Level Defaults. Can be updated as needed. | Class |
Department | Optional | List of Departments from the ERP is available. Populated with Account Level Defaults. Can be updated as needed. | Department |
Location | Optional | List of Locations from the ERP is available. Populated with Account Level Defaults. Can be updated as needed. | Location |
Invoices | Calculated | The invoices in this list correspond to the invoices that appear in the 'Apply To' panel on the NetSuite customer payment | Applied To |
Status | Calculated | Payments in a 'Posted' status in Tesorio have been synced to NetSuite. All other payments exist only in Tesorio. For more on statuses, read here. | N/A |
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. | 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 |
Check Number | Optional |
| Check # |
Memo | Optional |
| Memo |
Payment Tags | Optional |
| N/A - Tesorio only field |
Customer Tags | Optional |
| N/A - Tesorio only field |
Notes | Optional |
| N/A - Tesorio only field |