File import settings in Cash Application Manager

Tom Santiago

Updated March 19, 2024 06:53

Directory path: Enter the path of the directory on the SFTP server where the files are stored. This field isn’t available if the Enable Manual Upload mode checkbox is checked on the General tab of the Integration App.
File name starts with: Enter the first few characters of the file name that the connector should read. This field isn’t available if the Enable Manual Upload mode checkbox is checked on the General tab of the Integration App.
File name ends with: Enter the last few characters of the file name that the connector should read. This field isn’t available if the Enable Manual Upload mode checkbox is checked on the General tab of the Integration App.
Browse to zip file: Click Choose File to upload a sample file at the time of implementation. This setting is typically only used once. Only use this if the bank file changes. This file sets the row delimiter and content in the file enables the parser settings set work as expected. If the bank changes the row delimiter in the file later, set this to the latest file to make sure the Integration App can read the updated file.
Leave file on server: Check this checkbox if the Integration App should leave the files on the SFTP server after reading. If unchecked, CAM deletes the file from the SFTP server after reading. This field is important to alert the Integration App to ignore duplicate files while reading the directory path in the bank server. Most banks automatically delete the files on their server once they are read. In cases like this, check this checkbox to prevent the file from being deleted.
Use Credit Memos: Check this checkbox to search for credit memos in the bank file (along with the invoices and with negative amounts) under a transaction. CAM uses that data to create the Celigo cash app credit memo.
Ignore Following Customers: In some cases, the bank file contains customer information for whom payments should not be created in NetSuite. Use this field to add customers to a comma-separated list of customers to be excluded when importing the bank file into NetSuite. The Celigo cash app transaction record uses the bank file customer field to compare the values provided in this setting to ignore the transactions. Transactions from customers in this list are not imported to NetSuite and can not be retrieved later.
NetSuite Invoice Prefix: By default, all invoices are created in NetSuite with prefix “INV”. It becomes difficult for the Integration App to identify an invoice number in the bank file if you use has any other prefix to store invoices in NetSuite. Use this field to add a list of comma-separated prefixes used to store invoices in NetSuite for the connector to match and identify the invoice number in the bank file. If you have prefixes based on the subsidiary, use the invoice prefix option in the multi-subsidiary settings section instead. This setting sequentially attaches the prefix to the invoice number from the bank file and searches in NetSuite until it finds a match.
NetSuite Invoice Identifier: Use this multi-select field to select the NetSuite invoice field (standard or custom) that you use to store the invoice number. By default, the invoice number in NetSuite is stored in the Invoice # field. Select the fields required by the data you get in the bank file for the invoice. You can select at least one (and at most three) fields to search and identify the invoice in NetSuite.
Column Delimiter: This field defines the column delimiter in the file provided by the bank. By default, this field contains a random string with special characters. This field value changes based on the file format. Do not update unless instructed to by a member of the Celigo Product Team.
Archive File: If checked, this setting archives the bank file in your NetSuite file cabinet for auditing purposes. Uncheck this checkbox if you do not wish to archive the file.
NetSuite Archive Folder: Enter the path to the folder directory in your NetSuite account where you want to store archived files. This field is only available if the Archive File checkbox is checked. Use the following format to provide the folder location:
```
Folder1 > Folder2 > Folder3
```
Use the greater-than character (>) as the delimiter between the folder names. This is similar to how NetSuite displays: