NetClose - Accrual Field Sourcing

Overview

In NetClose, Accrual Sourcing can be created to pull a value from a transaction field for records included in a Saved Search and store that value in a custom field on a NetClose Accrual. Sourcing enables NetClose Accruals to reflect the same GL impact as the records on which they were created. This sourcing occurs by default for Native NetSuite fields such as Department, Class, Location, Entity, and Subsidiary, but must be created for Custom Segments and Custom Transaction Line fields. 

Accrual Sourcing Record

  1. To create a NetClose Accrual Sourcing Record, navigate to NetClose > Setup > Sourcing.
  2. On the NetClose Sourcing page, click "New+" and select the NetClose Accrual Sourcing Type.

The Accrual Sourcing record has the following fields:

Accrual Field - This is the New Field that a user adds to the NetClose Accrual Record to store the sourced value. 

New Fields can be added to the NetClose Accrual Record by customizing the NetClose Accrual Record and clicking "New Field" on the Fields Subtab. The field that is created on the NetClose Accrual Record should match the Type and List/Record setup of the field you are sourcing from. 

Transaction Field - This is the Transaction Line field on the Journal Entries created by the NetClose Accrual that the value should be sourced to. For example, in the image above, the value stored on the Activity Code field on the NetClose Accrual will be populated in the Activity Code Transaction Line field on Accrual Journal Entries. 

Search Column Label - If creating Accruals from a Saved Search Accrual Automation, this is the column from the Saved Search that NetClose should pull the value from to source into the Accrual Field. This is a text field, and the text must match the Saved Search Column Label exactly. 

Filters - These are optional customization options for NetClose Accrual Sourcing that will limit the situations in which the Sourcing Record is used. 

  • Apply Impact - Sourcing will only apply to the line level, header level, or debit or credit journal entries. If you plan on using Summarized Journal Entries, this must be set to line level, or else journal entries will not be combined. 
  • Account Type - Sourcing will only apply to transaction lines that impact the specific account type.
  • Apply to Type - Sourcing will only apply to selected Accrual types.
  • Apply to Subsidiary - Sourcing will only apply to selected subsidiaries.
  • Apply to Transaction Type - Sourcing will only apply to selected types of Accrual journal entries.
Was this article helpful?