• Beginning Balance wrong on GL Detail Report

    It appears that the beginning balance for period 1 is coming into the reports without regard to the beginning period selected. The subordinate transactions come into the report correctly, but the balances are all off because of the incorrect beginning…
  • How do I run a Ledger Activity report by Job

    I'm trying to delete a job. I'm getting a message that there is Ledger Activity but no job cost or committed cost. Is there a way to run a Ledger report by job number?
  • How to find the cause of variance between invoice total and the number on income statement ?

    Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…
  • Need to pull out the user who created a GL Gen Journ entry

    An auditor is asking for a report from G/L that lists all General Journal Entries from 2020 and includes the User Name that created the Entry and the User Name that posted the Entry. Obviously I can link SY_User to GL_DetailPosting and pull a report…
  • Trial Balance - Active Accounts Only

    How can I change my settings in the GL Module to only show Active accounts on my Trial Balance? Currently it is showing deleted and inactive accounts along with the active? Thank you
  • WE WANT TO PRINT/EXPORT TRANSACTION DETAIL FROM ACCOUNT MGMT/INQUIRY

    FormerMember
    FormerMember
    We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…
  • Looking for a Sage100 table for General Ledger with invoices history data.

    Dear experts Using Excel need to pull the data that the general ledger detail report displays but I need to add invoices number, invoice date, comments... what tables in Sage 100 gives me: GL Account Number, description, Date, Journal Comments…
  • Date Range Income Statement

    I need to run an Income Statement for an odd time period for an insurance audit (Mid -Month to Mid- month) for a 6 month time period. Is this possible?
  • List of previous month's activity

    Hello, I have taken over at a small non-profit association and was given zero information by the previous accountant. I have never used this software. I am trying to simply look at all of the journal entries from the previous month so I can see what…
  • MAS90 and Excel 2013

    Can I use Excel 2013 with MAS90 version 4.5? We are upgrading to the current Sage 100 version, but I need to replace my computer before that is scheduled. Thanks for your help!