ERP Tips and Tricks Lean Efficient General Ledger

Posted by Gerry Poe

erp General Ledger Lean Efficient
One more reason to upgrade to SYSPRO 6.1: Fewer touch-points for GL transactions.
AR Cash Receipts:
Let’s take a case in point: Pre-6.1 AR Cash Receipts in Figure 1. –

Process and touch-point reductions from six to two steps, plus less secondary processes such as printing journals, and distribution reports.  It all gets done "automatically" so no one must remember either how or why to do all of those little tasks. Streamlining accounting procedures and simplifying day-to-day processes enables general ledger accuracies and financial reliability.

Processes are shown here for the Accounts Receivable Cash Receipts in Figure 1.

Recently, I received a support call from a customer, indicating their Work In Process journals and GL Distribution were not posted. These process errors were due to operators not printing these reports. Realizing the error, they printed all reports, and the data successfully posted to the GL.

Figure 1 - Cash Receipts GL Integration in SYSPRO 6.0 and earlier versions (6-steps, 3-printing cycles)

gl integration before 61 

History: Historicaly, computer processing power and RAM were very expensive. The transaction processing features of SQL database management systems did not exist at the time. This necessitated the writing of data back to disk (i.e. data files or database tables) at points during this overall integration process to ensure data integrity.

For SYSPRO 6.1, it was decided to address these issues. Different forms of GL Integration are available for 6.1 to allow for those who don't like giving up the perceived control of a multi-step integration process to a full real-time operation. However, all this integration is performed by a single set of logic ensuring consistent integration. The two extremes of integration allowed in 6.1 are depicted in Figures 2 and 3 respectively.

Figure 2 - Cash Receipts GL Integration in SYSPRO 6.1 without Real-time GL enabled (5-steps, no mandatory printing cycles)

gl integration after 61 without 

With writing to disk being an expensive, time-consuming exercise compared to in-memory processing in modern hardware. Using the normalized data model (Wikipedia), in line with relational database theory we can process all sides of the transaction concurrently. The Accounts Receivable module data are updated, transactions and journals are posted and General Ledger accounting, balance sheet and income statements are updated in real-time.

Figure 3 - Cash Receipts GL Integration in SYSPRO 6.1 with Real-time GL enabled (2-steps, no mandatory printing cycles)

gl integration after 61 automatic 

SYSPRO 6.1 upgrade results: Accounts Receivable module data are updated, transactions and journals are posted and General Ledger accounting; balance sheet and income statement are updated real-time.  Accounting and processes are now concurrent, requiring only transaction initiation rendering decision support and analysis of meaningful data for increased value, relevance and ROI.

Our hat's off to SYSPO for their vision and dedication spanning 30+ years an ERP product, today, which is more relevant and valuable than the competition. 

Did you know that SYSPRO continues to receive awards for its ERP software?

SYSPRO was in the news which said they had recently received another award.  

SYSPRO Wins Golden Bridge Award for Software Innovation: SYSPRO Honored in Global Competition for SYSPRO STARS FastTrack Implementation Methodology




Tags: ERP, Lean, Accounting, General Ledger

Please share!

Visual Planner
for SYSPRO Factsheet:

visual planner

Recent Posts

The Compete
Enterprise ERP Assessment:

enterprise erp assessment