Skip to the main content.

2 min read

GL Posting and Segment Substitution

GL Posting and Segment Substitution

In Sage 100, you can use General Ledger segments to slice and dice your data for financial reporting.  Here’s how you use Sage 100 to automatically post data into these segments.  You can post by warehouse, Customer or Product Line (but you can’t substitute all three at the same time).  Sage 100cloud Manufacturing provides more sophisticated segment substitution, but we’re not going to cover manufacturing here.  Let’s go through the Sage 100 setup screens and run through an example.

General Ledger Setup

Account Structure Maintenance

  • First, define the segments in your Chart of Accounts in General Ledger > Setup > Account Structure Maintenance
  • This sample company has 4 segments:
    • Core – Customer – Location – Product Line
    • These are all segments that can be substituted
    • BUT you can’t substitute both Customer and Location – You must pick one
  • Additional segments can be added BUT CANNOT BE REMOVED. Use caution when adding segments.

1. general ledger setup

Sub-Account Maintenance

  • In General Ledger > Setup > Sub Account Maintenance, you define valid codes for each segment
  • For example, the Location segment has East, West and Central

2. Subaccount maintenance

Account Maintenance

  • Once the pieces are defined, you can put them together to create the accounts.
  • Use caution if you use the General Ledger > Utilities > Generate Accounts:
    • Use caution as your chart of accounts quickly become get very large
    • You may not need segments repeated for all accounts

 3. Account maintenance

Inventory

Product Line Maintenance

  • Go to Inventory > Setup > Product Line Maintenance
  • The Post by Warehouse checkbox will substitute the warehouse segment (defined below) with the code per warehouse (also defined below)
  • If you want to use a Core/Main Sales account for the product line, you may define it here.

4. Inventory

Warehouse Code Maintenance

  • You need to define the code to substitute for each warehouse.
  • Go to Inventory > Setup > Warehouse Code Maintenance
    • The segment code does not have to match the warehouse code

5. Warehouse

Sales Order Options

  • Post sales to GL by Warehouse
    • Must pick EITHER Division(Customer) or Warehouse (Location)
      • Can’t do both
    • Most people don’t use Divisions
      • (In this example, the product line is specific to this customer division)

6. sales order

A/R

If you did want to post by Division, you would set it up in Accounts Receivable > Setup > Division Maintenance

7. ar

Sales Order Invoice Data Entry

  • In this example, Revenue posts to Sales account 400-01-01-1 for:
    • Sales segment (400) is determined in Product Line Maintenance
    • Customer Segment (01) comes from Product Line Maintenance. It is not substituted because the setting in Sales Order Options is by “warehouse” not “Yes.” 
    • Location (01) was substituted in because the posting is by Warehouse
    • Product Lines (1) is defined in Production Line Maintenance.

 

Announcing New Employee, Sage Intacct Practice Manager, Denise Romanak

Announcing New Employee, Sage Intacct Practice Manager, Denise Romanak

Vrakas/Blum Computer Consulting, LLC (VBCC) is excited to announce the addition of Denise Romanak as Sage Intacct Cloud Financial Practice Manager to...

Read More
Vrakas/Blum Adds Partner and Sage Intacct Practice Leader, Joe Bisaha

Vrakas/Blum Adds Partner and Sage Intacct Practice Leader, Joe Bisaha

Vrakas/Blum Computer Consulting, LLC (VBCC) is excited to announce the addition of Joseph (Joe) Bisaha as Partner and Sage Intacct Practice Leader.

Read More
Vrakas/Blum Adds New Product Line, Sage Intacct

Vrakas/Blum Adds New Product Line, Sage Intacct

Vrakas/Blum Computer Consulting, LLC (VBCC) has added Sage Intacct to our product offerings. Intacct is a powerful cloud-based solution that will...

Read More