Skip to main content

Connecting NetSuite and running syncs

Connect Kolleno to NetSuite, start syncs, check recent syncs and choose your daily sync hours.

The Connection and sync tab of the NetSuite settings page shows the connection to NetSuite. On this tab, you start syncs, see the recent syncs and choose the daily sync hours.


Open the NetSuite settings

  1. Go to Settings > Accounting integrations.

  2. On the NetSuite card, click Connected · Settings.

  3. The NetSuite settings page opens on the Connection and sync tab.

The page has six tabs: Connection and sync, What to pull, Fields, Contacts, Names and references and Invoice PDFs.

Only company admins and the Kolleno team can open this page.

This is an optional setting and is turned off by default. Contact your Customer Success Manager or Kolleno Support to enable it for your account.


The connection

Kolleno uses the Kolleno SuiteApp to read NetSuite data. The Connection card shows the SuiteApp version and the Kolleno time zone of your company.

Open the … menu on the card to change the connection:

If the connection stops working, the page shows Not working and a Reconnect NetSuite button. Before you reconnect, check that the NetSuite role still has the correct permissions.

If the NetSuite role does not have all the permissions, the Fields tab shows the notice Some NetSuite details are hidden. Syncs work without these permissions. See Setting up NetSuite fields in Kolleno.


How syncs work

Most changes reach Kolleno within a few minutes through the Kolleno SuiteApp. The daily sync is a safety net. At the daily sync hours, Kolleno pulls everything that changed in NetSuite since the last daily sync.

The Sync card shows:

  • The state of the sync: Idle, Starting…, Running or Stopping….

  • Changes synced up to: the time of the last change that Kolleno pulled.

  • Next daily sync: the date and time of the next daily sync.

  • Recent syncs: the last syncs and their results.


Start a sync

  1. On the Sync card, click Sync….

  2. Under Record types, select the records to pull.

  3. Under Pull records changed since, choose the start of the time range.

  4. If you added a field, select Overwrite records in Kolleno. Kolleno then also updates records that NetSuite does not show as changed.

  5. Click Start sync.

Option

What it pulls

When you can use it

The last sync

All record types that changed since the last sync.

After the first sync, if the last sync is not more than 7 days old. After a sync ends, wait 5 minutes.

A date and time

The selected record types that changed since that time. Use 1 hour ago, Today 00:00 or 30 days ago to fill in the time.

The time cannot be in the future or more than 2 years ago. To pull older data, contact Kolleno Support.

All history

All the history of the selected record types.

Only the Kolleno team can use this option.

A sync of a long time range can take some hours. It uses the NetSuite API limit of your account. Kolleno pulls long time ranges in parts, one after the other. If the sync runs at a daily sync hour, Kolleno skips that daily sync. The next daily sync pulls the changes.

Only one sync can run at a time. You can start a new sync when the current sync ends. Only the Kolleno team can stop a sync. To stop a sync, contact Kolleno Support.

If NetSuite limits the API of your account, the Sync card shows the time when Kolleno continues.

Each card has an ⓘ hint that tells you more about its settings.


Recent syncs

The Recent syncs table shows the status, the start time, the record types, the user who started the sync and the duration. Kolleno in the Started by column means a daily sync. Click a row to see the details of the sync. Click Show all syncs to see older syncs.

The status of a sync is one of these: Queued, Running, Stopping, Done, Not complete, Failed, Stopped or Stopped responding. Stopped responding means that Kolleno lost contact with the sync. Run the sync again.

Sometimes a sync skips records because their customer or invoice is not in Kolleno. Usually, the filters or the subsidiaries leave that customer or invoice out. See Choosing what Kolleno pulls from NetSuite.


When some changes need a full sync

Some settings apply only to the records that Kolleno pulls after the change. Examples are a new subsidiary, or journal entries or deposits that you turn on. After you save such a change, the banner Some changes need a full sync shows on all tabs of the page. The banner lists each change, the user who made it and the time.

Records in Kolleno do not show these changes until the sync runs.

  1. Click Run a full sync…. The Sync dialog opens with the record types and the time range for these changes.

  2. Check the settings.

  3. Click Start sync.

A full sync pulls only the invoices and other transactions that changed in the last 2 years. Customers come from all of history.

If you click Later, the banner does not show again until you open Kolleno in a new browser session.


Daily sync hours

  1. On the Daily sync card, select one or more hours.

  2. Click Save.

The times are in the time zone of your company. A daily sync starts only in its hour. It does not start while another sync runs. You must select at least one hour.

Did this answer your question?