Sage 300 ERP – Tips, Tricks and Components
Greytrix is one of the oldest Sage Development Partner of two decades and Reseller of Sage 300 ERP (formerly known as Sage Accpac ERP) and has been awarded "Sage Partner of the Year" multiple times for rendering quality services for Sage product lines both as developers and resellers. Greytrix has accumulated hundreds of man years of experience in Sage 300 ERP. In these blogs, Greytrix will endeavour to share its knowledge with regards to implementation, training, customisation, components, current technology trends and help users to understand in depth techno – functional aspects of Sage 300 ERP! Contact our team at accpac@greytrix.com
Follow us on LinkedIn Follow us on Twitter Follow us on Facebook Follow us on YouTube
Skip to content
  • Home

GL Auto Allocation of Account Balances in Sage 300 ERP

By Greytrix | September 17, 2012
0 Comment

Case: To ascertain if a particular department is running in profit or loss there should be proper allocation of overhead expenses or incomes across all the departments in a firm. Sage 300 ERP has made this allocation very simple with “Auto Allocation” functionality.
In our below example, we have created new general ledger accounts and have taken Electricity Expenses for auto allocation process.  There are few simple steps to be followed for this;

1) Navigate to General Ledger>>G/L Accounts, set the account number for which we have to assign allocation. Select the checkbox “Auto Allocation”

2) After selecting Auto Allocation check box, you will find a new tab “Allocation” on the Account screen tab. Assign source code and select the related accounts and assign percentage for each account to distribute the amount proportionately.

3) As there are no transactions for the newly created G/L accounts, we would create a transaction in GL Journal Entry.

4) Now navigate to G/L periodic processing >>Create Allocation batch; create a batch using the same G/L account and click on Process tab.

5) On successful completion of the above steps, we will notice that a new batch has been created in G/L journal entry with the funds allocated proportionally.

In similar manner, Users could analyse the distribution of expenses/income within the organisation and then can regularly allocate it according to a percentage based on analysis.

Related Posts

  • Auto Revise Quote Number in Sage 300 ERP
  • Auto-Reverse General Ledger Entries in Sage 300 ERP
  • Auto Bank Reconciliation in Sage 300 ERP
Category: Sage 300 Tags: account, Auto Allocation, General Ledger, Sage 100 ERP, Sage Accpac ERP
Post navigation
← Greytrix TDS with PJC Integration GUMU™ – A Sage Certified migration solution by Greytrix →

Greytrix Websites and Blogs

  • Greytrix
  • Greytrix Africa
  • Greytrix Australia
  • Sage X3 – Tips, Tricks and Components
  • Sage 100 & 500 ERP Tips and Tricks
  • Sage CRM – Tips, Tricks and Components
  • Salesforce.com Tips and Tricks by Greytrix
  • Sage Business Cloud – Tips, Tricks and Components
sage crm and sage 300 integration

Categories

  • Sage 300
    • ACCPAC SDK
  • Sage 50 US
  • Sage Business Cloud
  • TDS
  • Uncategorized

Recent Posts

  • Adding current fiscal year to avoid unwanted errors.
  • Disable Maximize Box in OCX
  • Localized resources aren’t available
  • Maintaining Item specific notes for IC Item for Transactions Use
  • Stronger Default Security for Login Password in Sage 300 v2021

Archives

Awards

Greytrix Top ISV Partner
Greytrix Revenue Growth Enterprise Business
Greytrix Africa Highest Revenue
Greytrix Prtner of the Year
Greytrix Partner Award
Copyright 2019
Sage 300 ERP – Tips, Tricks and Components
Iconic One Theme | Powered by Wordpress