Steps to Take if Your Sage 100 General Ledger Seems Incomplete

Why is information missing from my Sage 100 General Ledger?

We have received many calls from our clients asking why they cannot see entries in their General Ledger. Below we will go over the most likely reason and how to correct it. We will also cover how to prevent problems like this in the future.

View this Sage 100 step by step software tip with individual screen shots below.

The most likely reason for having missing General Ledger data is that the Daily Transaction Register has not been updated yet.

• Go to General Ledger > Main > Daily Transaction Register.
• Click Print.

• The daily transaction register will be printed if there are any unposted transactions.
• A window will popup asking, “Do you want to update the Daily Transaction Register?” Select Yes
  

• Check if your data is now in the General Ledger.

Note: Printing and updating the Daily Transaction Register from the General Ledger > Main menu will pull data from all modules (Accounts Receivable, Accounts Payable, Purchase Order, etc.).

It is possible to define security settings that allow automatic updates of the daily transaction register from other modules.  Therefore, when information is posted in another module, the General Ledger can be updated as well.

• Go to Library Master > Security > Role Maintenance.
• Select the role(s) to which you want these permissions assigned.
• Go to the Security Options tab.
• Click the “+” to expand Accounts Receivable (or any other module you currently use).
• Check “Allow Automatic Update of Daily Transaction Register”.

Please note, automating the update of the Daily Transaction Register may function inconsistently if you are utilizing 32bit Sage 100.  The automatic update functionality works appropriately if your installation is 64bit.

If you are not sure which version you are running, check this by going to Help > Sage 100 to see if your system is 32bit or 64bit.

If you want to upgrade to 64bit, it is a simple process our consultants can do. If you try to do this with 32bit Sage 100, your automatic updates may hang and not complete properly.

Another way to automate posting that works for both 64bit and 32bit Sage 100 is to automate posting with the Task Scheduler.  Please note, this must be configured AT THE SERVER, and not from a Workstation.

• Go to Library Master > Main > Task Scheduler.
• Enter a Job Name.
• Enter a Description.
• Select the company that you want the task to run on.
• Enter your credentials.
• Set the frequency you want the task to run.
• Select the Task tab.

• Under the tasks tab, Module > Task > Printer you want the tasks to print on.

Now you can see why information may be missing from the General Ledger, including the most likely reason for missing information and how to fix it. We also covered how to prevent problems like this in the future.

If you have questions regarding finding missing data from the General Ledger, please contact our Sage 100 support team at 260.423.2414.

Copyright 2025 DWD Technology Group | All rights reserved. This article content may not be reproduced (in whole or in part), displayed, modified or distributed without express permission from the copyright holder.