2 min read

Sage 100 ERP (MAS 90): Fix a General Ledger Posting to a Wrong Period

Sage 100 ERP (MAS 90): Fix a General Ledger Posting to a Wrong Period

Written By Sage 100 ERP Consultant Oasis Solutions Group Louisville, KY

Sage 100 ERP GL resized 600It happens.  Sometimes a General Journal Entry is posted to an incorrect general ledger period.  Obviously a correcting General Journal Entry must be accomplished to fix the error for accurate financial statement presentation.  To avoid the lengthy process of re-entering the General Ledger accounts and amounts in a new journal entry, a few shortcuts can be done to correct the mistake very quickly. 

New call-to-action

Prior to making the entry, you must know the source journal, journal number and date of the incorrect entry.  To fix, in the MAS90/200 menu system, go to the General Ledger Module, Main, General Journal Entry feature.  If option to use batch entry for journal entries is turned on, create a new General Journal Entry Batch.  Once the General Journal Entry screen appears, enter the same source journal code used on the invalid entry.  Click this button to assign the next journal number or enter a journal number you wish to use. Sage 100 ERP (MAS 90) General Ledger posting 1 resized 600

In the Posting Date field, enter the correct date the entry should have posted to.  In Reversing Date field, enter the same date the incorrect entry was posted to.  DO NOT enter a comment yet.  The next step will override the comment section.  Select the Sage 100 ERP (MAS 90) General Ledger posting 2 resized 600 button located in the upper right corner of the form.  Select the Journal History option on the Copy From form and click the Sage 100 ERP (MAS 90) General Ledger posting 3 resized 600 button.

   Sage 100 ERP (MAS 90) General Ledger posting 4 resized 600

Once the OK button is chosen, the GL Source Journal History List Screen opens.  In the list find the incorrect posting and either highlight the item and click the Sage 100 ERP (MAS 90) General Ledger posting 5 resized 600 button, or double-click on the item to copy it to the current entry. 

Sage 100 ERP (MAS 90) General Ledger posting 6 resized 600          After choosing the incorrect item, the comments and line distribution detail is copied to the new journal entry.

Sage 100 ERP (MAS 90) General Ledger posting 7 resized 600 

At this point the Journal Comment can be modified to reflect this is a correcting entry.   

Sage 100 ERP (MAS 90) General Ledger posting 8 resized 600 

Unfortunately the changes to the journal comment will not update the comments on the line detail.  The comments on the distribution lines will need to be changed individually. 


Sage 100 ERP (MAS 90) General Ledger posting 10 

Once complete with changes, print and post the General Ledger, General Journal.  Two journal entries will be posted in the one step.  An entry will post the correct debit and credit amounts to the appropriate date entered in the Posting Date field of the General Journal Entry “Header” tab.  Since the original incorrect date was entered into the Reversing Date field of the General Journal Entry “Header” tab, the incorrect entry will automatically be reversed on the bad date.

To confirm the correction either, review a General Ledger Detail Report from the General Ledger module, Reports menu, or review one of the affected accounts in Account Maintenance feature in the General Ledger, Main menu.  The original incorrect date should include both a debit a credit entry; one reversing the other.  The correct posting date should only include one entry. 

Sage 100 ERP (MAS 90) General Ledger posting 11 

The same copy feature from “Journal History” can be a time saver when posting very similar entries to journals posted in the past.  Unlike the copy from “Standard Journal” feature, the debit and credit values are transferred during the copy process; perhaps only needing to only change a few values in lieu of entering all the debit and credit values.     

If you have any questions or need help with the above recommendations, please call tech support at 502-429-6902 x227.

Blog contribution by Oasis Solutions Group

Oasis Solutions Group provides consulting, implementation, support and project management services for Sage ERP 100 & 500 (F/K/A MAS 90 & 200), CRM (Customer Relationship Management) and HRMS software. Oasis provides and supports on-premise and cloud-based software products. 

Located in Louisville, Ky, Lexington, KY and Nashville, TN, we cover the Mid-West and New England areas as well as other locations.

We provide telephone, remote and on-premise support. In addition, we work with companies who purchased the system and need a higher level of expertise and support than they are receiving.

Sage 100 ERP (MAS 90): How to Install Workstation Setup Windows 7 and XP

Sage 100 ERP (MAS 90): How to Install Workstation Setup Windows 7 and XP

Written By Sage 100 ERP Consultant Oasis Solutions Group Louisville, KY Question: How do I run Workstation set-up in Sage 100 ERP (formerly MAS...

Read More
Time-Sensitive Sage 100 Updates in 2022 with Big Impacts on Your Business

Time-Sensitive Sage 100 Updates in 2022 with Big Impacts on Your Business

Don't Miss Important Sage 100 Updates in 2022! Sage 100 users who don’t take action by the end of 2022 face potential disruption when Sage ends...

Read More
Sage 100 ERP (MAS 90): How to Import ADP Payroll to Sage 100 GL

Sage 100 ERP (MAS 90): How to Import ADP Payroll to Sage 100 GL

Question: Mike, we own Sage 100 ERP (formerly Sage MAS90); we also use ADP for our Payroll. How can we import the ADP Payroll information into the ...

Read More