The What to pull tab of the NetSuite settings page controls which NetSuite records Kolleno pulls. The tab has three cards: Subsidiaries, Records to pull and Filters.
To open the tab, go to the NetSuite settings page and click What to pull. See Connecting NetSuite and running syncs.
Only company admins and the Kolleno team can open the NetSuite settings page. It is turned off by default. Contact your Customer Success Manager or Kolleno Support to enable it for your account.
Subsidiaries
Kolleno pulls only the customers and transactions of the selected subsidiaries.
Under Which subsidiaries to pull, choose All subsidiaries or Only the subsidiaries I select.
If you choose Only the subsidiaries I select, select the subsidiaries in the list. Use the search, Select all and Clear to make the selection faster.
Click Save.
Main subsidiary only: a customer can trade in more than one subsidiary. If you select Pull only customers whose main subsidiary is selected, Kolleno pulls the customer only when its main subsidiary is selected. Kolleno then also does not pull the invoices of a customer that it skips.
Records of customers that Kolleno stops pulling stay in Kolleno, but they no longer update.
After you add a subsidiary, run a full sync to pull its history. Kolleno shows a banner that reminds you.
Records to pull
Kolleno always pulls customers, invoices, credit memos and payments. You can also pull two more record types:
Record type | Why to pull it | If you turn it off |
Journal entries | Journal entries that post to a customer change its balance. If you do not pull them, Kolleno shows a different balance from NetSuite. | Entries that are already in Kolleno stay, but they do not update. Balances can differ from NetSuite. |
Deposits | Kolleno can show unapplied cash. | Deposits that are already in Kolleno stay, but they no longer update. |
When you turn on a record type and save, Kolleno reminds you to run a full sync to pull its history.
Filters
A filter tells Kolleno to pull only the records that match it. There is one filter for each of these record types: Customers, Invoices, Credit memos and Payments. Each row shows the current filter, or No filter. Kolleno pulls all records.
To stop a few specific customers from syncing and remove their data from Kolleno, see Exclude Customers from NetSuite Sync instead.
If a row shows Not used: custom query, Kolleno pulls that record type with a query that the Kolleno team set up for your company. Filters and subsidiaries do not apply to it. To change what the query pulls, contact Kolleno Support.
Build a filter
On the row of the record type, click Edit.
Click Add condition.
Choose the Field, the Condition and the Value.
To add more conditions, click Add condition again. Kolleno pulls a record only when it matches all conditions.
Click Test in NetSuite. Kolleno checks the filter in NetSuite and counts the records that match.
If the test shows The filter works, click Save filter.
The field list shows common fields first, then the NetSuite fields of the record. An invoice filter can also use customer fields.
The conditions depend on the type of field:
Numbers: is more than, is at least, is less than, is at most, is.
Dates: is on or after, is on or before.
Text: is, contains, starts with, does not contain, does not start with, is one of, is not one of.
Check boxes: is checked, is not checked.
The test counts up to 100,000 records. You cannot save a filter until the test passes. If NetSuite rejects the filter, the test shows the reason. Fix the filter, then test it again.
A filter applies from the next sync. Records that are already in Kolleno stay when they stop matching. If you remove a condition, run a full sync to pull the records that it kept out.
Some filters were set up by the Kolleno team and Kolleno cannot show them as conditions. You can see these filters but you cannot edit them. Click Replace with conditions to build a new filter, or contact Kolleno Support.






