NetCash Custom Sourcing for Segments and Custom Records

Overview

The Custom Sourcing feature in NetCash allows users to assign specific values to customer records and segments—such as department, class, location, and custom segments—on journal entries created by NetCash. When performing manual or automatic bank transaction matches, this feature ensures that segment values are correctly applied to journal entry lines. The instructions below reference segments, but sourcing can be created for custom records as well. 

Prerequisites

  • Custom Segments Predefined: Any custom segments (like activity codes) should be set up in NetSuite beforehand.
  • Custom Segments Enabled: Ensure the custom segments to be used (e.g., department, location, activity code) are activated and visible in NetSuite’s Transaction Forms.

Step-by-Step Process

1. Navigate to Sourcing Setup in NetCash

  • Go to NetCash > Setup > Sourcing.
  • This section lists all configurable segments available for sourcing in NetCash. Each sourcing record allows custom values to be specified for bank transaction matches.
  • Users can add new sourcing by clicking the + button in the top.
  • Any record or segment here will show in the GL transaction side of the manual match page, so if a user doesn’t want to see a segment on the manual match page, then they should inactivate the sourcing.

2. Define Sourcing Details for Each Record or Segment

  • For each segment you set up, define the following fields:
    • Name: Enter a clear, descriptive name for the sourcing configuration, e.g., "Activity Code Sourcing".
    • Source: Choose the record type for this sourcing setup, such as the segment you want to setup sourcing for.
    • Transaction Line Column: Specify the transaction line column on the journal entry where the segment value should be populated. This column ensures the sourcing is accurately mapped to the journal entry line.
    • Transaction Template Field: Set a default value in the transaction template field. This value will be used by automation rules for specific activity codes or other custom values in transactions.
    • Bank Account Line Type and Bank Offset Line Type: Specify the value for both the bank and offset lines of the journal entries based on manual or automatic matches.
      • Bank Account Line Type: Defines the segment value to populate on the bank line of the journal entry.
      • Bank Offset Line Type: Sets the segment value to source on the offset line of the journal entry.

3. Enable Custom Segment Visibility on Journal Entries

  • Navigate to Customization > List, Records & Fields > Custom Segments.
  • Select your custom segment, such as Activity Code, and open its configuration.
  • In the Application & Sourcing tab, locate Custom Record Types and ensure that NetCash Rule Transaction Line Template is set to Yes. This setting allows NetCash to access and apply the segment on journal entries.

4. Verify Segment Display on Transaction Forms

  • Go to Customization > Forms > Transaction Forms and search for Journal Entry.
  • Select the journal entry form that is used by the company and click Edit to modify the form layout.
  • Under Screen Fields > Lines, ensure that the relevant segment (e.g., Activity Code) is checked. This action ensures that the custom segment appears on journal entries, allowing NetCash to apply the segment values during sourcing.

5. Configure Custom Sourcing on Bank Accounts

  • Search NetCash Bank Account and select any bank account.
  • Click Edit to open the bank account’s customization options.
  • Under Customization select Customize Form and navigate to Fields > New Field.
  • Define fields with clear, descriptive names such as Activity Code Bankline and Activity Code Offset to avoid confusion.
  • For each field:
    • Field Name: Enter a descriptive name for the field, e.g., Activity Code Bankline.
    • ID: Follow your organization’s custom field ID conventions.

6. Set Up Custom Sourcing in Automation Rules

  • Go to Automation Rule setup in NetCash.
  • After custom sourcing is set up, the configured segments (e.g., Activity Code) should now appear as options in the Transaction Template tab of your automation rule.
  • Define sourcing for the rule using the following options:
    • From Account Record: Pulls values from the bank account’s record settings.
    • Specify Value: Manually assign a default value that will apply whenever the rule is triggered.
      • Important: Avoid selecting “None” for any values, as the system requires an integer. Choosing “None” will cause errors.

7. Configure Sourcing on Bank Account Records

  • To set sourcing on a bank account, go to NetCash > Bank Accounts.
  • Open a bank account and scroll down to the Segment section.
  • Assign default values (e.g., Activity Code B for the bank line, Activity Code C for the offset line) for auto or manual matching.
  • Default segment values can be set to populate for each bank transaction processed through NetCash. These defaults can be overridden at the rule level or manually adjusted during transaction processing.

8. Run automation rules or create manual matches/transactions

  • Once the setup is complete, any transaction created by an automation rule will use the custom sourcing for those segments.
  • When manually creating a transaction from the manual match fields, the segment defaults that were established will appear in the transaction creation form, but can also be overridden from that form.

Below is a walkthrough of setting up and using custom sourcing in NetCash

Click here to view this walkthrough in Full Screen

 

Was this article helpful?