Sage Partners
Connect on Twitter
  • Home
  • Find a Reseller
    • By Location >
      • U.S. Partners
      • Canada Partners
    • By Sage Product >
      • Sage ERP Partners >
        • Sage 50 Partners
        • Sage 100 Partners
        • Sage 300 Partners
        • Sage 500 Partners
        • Sage X3 Partners
        • Sage Intacct Partners
      • Sage Construction Partners >
        • Sage 100 Contractor (Partners)
        • Sage 300 Construction (Partners)
      • Other >
        • Sage CRM Partners
        • Sage HRMS Partners
        • MIP Fund Accounting
  • Sage Product Info
    • Sage 50
    • Sage 100 >
      • Sage 100 Tips & Tricks
      • Sage 100 System Requirements
    • Sage 300 >
      • Sage 300 Installation Guides
    • Sage Intacct
    • Sage 500
    • Sage X3
    • Sage Construction >
      • Sage 100 Contractor
      • Sage 300 Construction
      • Sage Estimating
    • Other Sage Products >
      • Sage Fixed Assets >
        • Sage Fixed Assets User Guides
      • Sage CRM
      • Sage HRMS >
        • Sage HRMS System Requirements
  • Sage Add Ons
  • Resources
    • Blog
    • Popular Articles
    • Buying Guides >
      • Inventory Management Tips
      • ERP Implementation Failure
  • Contact Us

How to Use Expense Distribution Tables in Sage 100

2/10/2014

0 Comments

 
In this article we'll take a closer look at the Expense Distribution Tables feature in Sage 100. You'll learn how to setup your company to use Expense Distribution Tables and how to correspond percentage amounts with general ledger accounts. Let’s take a closer look …

What is a Distribution Table?

The Expense Distribution Table feature in Sage 100 allows you to pre-define your General Ledger account distribution and their corresponding percentages. Expense Distribution Tables streamline the entry of standard invoices by removing the extra step of manually keying in amounts each time an invoice needs to be paid. For example, monthly rent payments can be set up to automatically allocate percentages to various departments and GL codes.

You can access Expense Distribution Tables for new invoices in Invoice Data Entry, Repetitive Invoice Entry, and Manual Check and Payment Entry. 


Getting Started with Distribution Tables

You can enable Expense Distribution Tables by selecting the Enable Distribution Tables Checkbox on the Entry Tab in Accounts Payable Options. 
Picture
Please note that when you enable Expense Distribution Tables in Accounts Payable Options no transactions can be in process in Invoice Data Entry, Repetitive Invoice Entry, or Manual Check and Payment Entry.

After enabling this feature, select the Allow Total Distribution to be Less Than 100 Percent checkbox to allow the total distribution amount for all accounts in each table to be less than 100 percent. 

Picture
If you select this option and the distribution percentage total is less than 100 percent in the data entry task, you must manually distribute the remaining balance. 

Defining Distribution Tables

Now that you have enabled Expense Distribution Tables in your Sage 100 system, let's define the Expense Distribution Table. You can set up the Expense Distribution Tables using Expense Distribution Table Maintenance.

Once you are in Expense Distribution Table Maintenance, enter an easily identifiable code in the Table Code field. For example: rent, insurance or utilities. 

Picture
Next, select the General Ledger account numbers and percent amounts you wish to distribute to each account. You can select as many accounts as you need depending on whether or not you checked the Allow Total Distribution to be Less Than 100% checkbox in Accounts Payable Options.

A message dialog box will then appear to let you know whether the percentage distribution amount has exceeded - or is less than – 100%.

Clicking the Applied Balance button will allow you to apply any balance to the current line and existing accounts to total 100%. Click Accept.

Picture
To view a listing of all defined distribution tables at one time, click the Print button.

And that’s all there is to it! Now you know how to set up and use Expense Distribution Tables for simplified invoicing.


If you need assistance or are have other Sage 100 (MAS 90) support needs, please contact one of the Top Sage Resellers in our directory and they'd be happy to help.

Need Sage 100 Support or Training?

Find a Sage Authorized Reseller in Your Area >>>

Related Articles
Sage 100: How to Enter Credit Card Information in Customer Maintenance

Sage 100 Version 2013 - New Accounts Payable Features

How to Generate a 'Quick Print' Check in AP

Like this Article?
Please feel free to share it with your friends and colleagues!

0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    ARE YOU A SAGE PARTNER?

    Get Your Business Listed Here!

    Click below if you're interested in having your business listed in this online directory of Sage Partners.
    Get Started
    Sage Warehouse Management
    Scanforce WMS for Sage
    Sage Cloud Hosting
    Picture

    Popular Articles

    Big Bang Implementation vs Phased Approach
    (Pros, Cons)

    ---
    What's New in
    Sage 100 2022

    ---
    What's New in
    Sage 300 2023

    ---
    New Release:
    Sage Intacct 2022

    ---
    What Does ERP Stand For?
    ---
    Sage 100 System Requirements and installation Guide
    ---
    Sage 300 Installation Guide
    ---
    Sage 100 Tips & Tricks

©2023 Top-Sage-Resellers.com. All rights reserved. This material and content on this website may not be reproduced, displayed, modified or distributed without the express prior written permission of the copyright holder. This website is not owned, operated, affiliated with, or endorsed by Sage Software, Inc. or Sage Intacct, Inc. Sage, Sage logos, and Sage product names mentioned herein are registered trademarks or trademarks of Sage Software, Inc. and/or its affiliates. Other product names mentioned are trademarks of their respective owners.
Privacy Policy