SAGE 300 – Seamless data sync between GL and Subledger

Sep 26, 2019

Art of Data Mapping
Generally, you want to keep your accounting system as simple as possible. Modular ERP systems like Sage 300 ERP have a great breadth of functionality, but most importantly General ledger (GL) integration mapping those information’s is crucial in order to get the best result of the system.
General ledger (GL) is the heart and brain of any business accounting software and SAGE 300 ERP system is not an exception. All transactions posted in sub ledgers of Sales, Purchase, Account Receivable/Payable Are ultimately transferred to General Ledger for accounting.

Below is a data flow diagram showing how all the other modules feed G/L. Then G/L has sufficient information to provide a complete audit history of a company as well as all the data to prepare Reports.

Pain of Account Reconciliations

The finance department is most organizations is coming under increasing pressure to transform and streamline the finance close and report functioning while continuing to maintain the integrity of the financial statement and close process. A key part of this process includes the completion of details account reconciliations. Which can be a major bottleneck in the close process. The necessity for understanding and certifying and account balance and its transactions with other modules is prompted by regulatory and audit control requirements.

How many of you struggle to balance your General Ledger to your Account Receivable or Account Payable ?

How many of you aware that SAGE ERP 300 GL transaction listing would show Transitions description , Vendor name, Payment voucher number and Check number for an A/P Payments?

If you not aware It There is a way to do that for future transactions.

Every sub-module in Sage 300 has a program icon called “GL Integration” in the setup area of each module.

This program not only controls and maintains posted transactions to the General Ledger it also defines the source codes, shows the last posting sequences, when and how transactions are posted and lets you control what information is posted to the GL Detail Comment, G/L Description and G/L Reference is listed in the “Transaction” tab as long as you have “Do Not Consolidate” selected in the dropdown for the Consolidated G/L Batches.

Let’s look at an accounts payable Miscellaneous Payment Details to illustrate how this transaction is posted to the G/L Transactions – “Batch List” and then printed on the G/L Reports – “Transaction Listing” report.

GL Integration Mapping on Miscellaneous Payment Details

You can assign one or more pieces of information (segments) to each field, provided that the combined length of the segments and separators does not exceed 60 characters.

Fields exceeding this limit will be truncated when you post general ledger transactions.

1) Miscellaneous Payment Details – G/L Details Reference
Change the dropdown G/L Transaction Field to “G/L Detail Reference”, highlight “Remit To, Document Number and Check Number” , click the button “Include” and then “Save”

2) Miscellaneous Payment Details – G/L Details Description
Change the dropdown G/L Transaction Field to “G/L Detail Description”, highlight “Detail Description and Invoice Number” , click the button “Include” and then “Save”

3) Miscellaneous Payment Details – G/L Details Comment
Change the dropdown G/L Transaction Field to “G/L Detail Comment”, highlight “Detail Reference” , click the button “Include” and then “Save” In order to save this setting everyone has to be out of relevant modules and make sure you have a backup.

Next time when you enter an A/P Miscellaneous Payment as shown below and posted to GL then you will see the result on G/L Journal Entry and GL Transaction Listing Report. While This information also appears on Accounts Payable posting journals.

Benefits of G/L Integration.
So, We have shown the Important of putting G/L Integration in place has provided you with more information which is more accessible for audit history of a company, as well as it may easy for details account reconciliation process between modules while enables analytics tools to produce actionable insights and prepare Reports.

Most of the time you may neglected this excellent function on SAGE 300 and now onward , Let’s move forward.

 

In the News…

More Blogs…

EnviSage 2020

Visual process flow is one of the unique and interactive features which is available in Sage 300 ERP that provides – Navigation Made Easy Inside the ERP By Dulantha Iddamalgoda

Sage 300 CashView

Visual process flow is one of the unique and interactive features which is available in Sage 300 ERP that provides – Navigation Made Easy Inside the ERP By Dulantha Iddamalgoda

Integrate, Manage and Analyze Data with Sage X3

Technology is something that keeps evolving. Businesses want to improve and be up to date in every way. How we use a solution to analyze data with its powerful BI functions plays a significant role in choosing the best ERP solution. Integrate, manage and analyze data with Sage X3

Sage 300 Visual Process Flows: ERP Navigation Made Easy

Visual process flow is one of the unique and interactive features which is available in Sage 300 ERP that provides – Navigation Made Easy Inside the ERP By Dulantha Iddamalgoda

Sage X3 – Enterprise Management Solution

Fast and Flexible Enterprise Management Solution for Modern Businesses – By Kasun C. Badaturuge

ZILLIONe Becomes the First Fully-Sri Lankan-Owned Company to Achieve a ‘Microsoft FastTrack Ready Partner’ Status

ZILLIONe is delighted to announce that it was recently awarded the title of Microsoft’s ‘FastTrack Ready Partner’ for Microsoft 365

What’s New in SAGE 300

This section contains a summary of new features and changes in the 2020 release including Sage 300 cloud web screens improvements, Sage 300 classic screens improvements, CRM integration improvements, technical information, compatibility with other programs, installing Sage 300, removing Sage 300, Sage 300 payroll and Sage 300 intelligence reporting.

DATA PROTECTION – How Secured is Organizational Data?

Over 2.5 quintillion bytes of data are created every single day, and it’s only going to grow further each day. By 2020, it’s estimated that 1.7MB of data will be created every second for every person on earth. As much as today is the time of information, it is also a time with a dire need to protect data – an invaluable resource that can build or destroy corporates and nations, if fallen in the wrong hands.

SAGE 300 – Seamless data sync between GL and Subledger

Generally, you want to keep your accounting system as simple as possible. Modular ERP systems like Sage 300 ERP have a great breadth of functionality, but most importantly General ledger (GL) integration mapping those information’s is crucial in order to get the best result of the system.

Sage Reporting Tools Bring Organizations Closer to its Data

Reporting is undoubtedly considered as the ‘pulse’ of most business organizations as it contributes significantly for its survival & success. Whilst several applications and software are currently in use today by business organizations in order to...

Back-ups are “Priceless”

Your Enterprise Resource Planning (ERP) systems play a big part in bridging your business and IT needs; helping you to run your business more effectively and efficiently. Hence, it makes sense to ensure continual return on your investment by...