• 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 to change subsidiary type in existing GL account

    I forgot to select "departments" as the subsidiary type in a GL direct cost GL account. There has already been activity so it won't let me change the subsidiary type. How to I fix?
  • Check Customer Balance while Backdating

    My company has two departments, the main account dept are doing a process called Backdating. While they do this, another department is doing customer lookups for their current balances. The issue is when the main Account Dept is doing the backdating;…
  • 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?
  • lines in a sales order invoice doubling

    I have seen two unrelated instances of a single random line showing up on my invoice when generating one using the path sales order, main, invoice data entry the GL detail report that I printed early May for our April rebill, as well as the latest…
  • GL Reporting

    Hi Guys, New member here and new to Sage 100. I am trying to custom build a GL Details postings report for beg of the year to present to present to management and want to include my own parameters like: (period, account, account description, p&l category…
  • WIP was turned off and it affected our GL postings. Is there a way to fix these without looking at each S/O Journal?

    Currently we use payroll for expensing the labor expense on our setup. There was an automatic offsetting journal entry that would zero out the expense for the labor transactions added to an S/O. When WIP got turned off the offsetting transaction for the…
  • AR Invoice Adjustment not reflected in GL

    Hello, I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…
  • General Journal File is locked

    A General Ledger General Journal entry batch file has been printed but not posted. It is now frozen and cant be updated. I'm getting a message saying the file is in use and that the file is locked by the user in General Journal. Nothing else can be posted…
  • Incorrect Data on Daily Transaction Register in Paperless

    I have a client on Sage 2021, Product Update 1. When printing the Daily Transaction Register after updating the Daily Sales Journal, the DTR shows incorrect information. It will have the correct Source Journal Number, incorrect Date and the journal postings…
  • 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
  • Reverse posted prepayment and credit memos

    We had a customer use a third party to pay for invoices. They asked for a dummy credit we could send them so they could zero out invoices on their account. To do this, I was instructed to create a prepayment (as a positive amount) and then a credit…
  • PPP Loan Forgiven

    We had our PPP loan forgiven, and our CPA told me to book it in under "Non-taxable income". I spoke with one person that set to setup account 950 to book this as non-taxable revenue. It still shows up on the Income Statement, is this correct?
  • Year End Closing and Bank Reconciliations

    I am helping a company that uses Sage 100 and they never closed the year for 2018 or 2019. The cash balance on my bank rec does not tie to the trial balance. I know I can do a hard close to fix that but should I continue doing bank recs in 2020 or wait…
  • Deposit payment

    How to enter a deposit payment without applying an invoice?
  • Journal Entry Reversal Setting

    We are using Sage 100c 2017, Version 5.40.60. I do not see the reversing journal entry icon. I understand that the option to reverse a journal entry through the account maintenance section became available in 2015. Is there a setting I need to adjust…
  • Mass Update GL_Account table via SQL update query

    We have upgraded to Sage100 Premium (SQL version). We have been using a separate Excel workbook for special coding we like to use. We would now like to get all those special codes into Sage100 into the rollup codes and UDF's. We do not want to manually…
  • General ledger

    General Ledger posting on transaction register but not posted to the gl but posted to bank reconciliation module
  • Report for revenue of all end customers in a certain date range?

    Hello everyone, I'd greatly appreciate help with generating a total revenue report for all customers within a certain date range. I've tried using the "Revenue by Customer" report and wasn't successful. I wasn't allowed to select all. I've tried…
  • Deleting main accounts in G/L

    As I understand it, if I change the "active" status to "delete" on a GL Main account prior to closing the year, the account will be removed once I complete the year end process. If I do that, do I lose the history too? Many of these accounts have not…
  • 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…
  • Already asked this but I believe I posted it in the wrong place: Error message when clicking Integrate with Bank Reconciliation

    I am trying to check the box under GL Options for Integrate with Bank Reconciliation and I get this message: You cannot enable or disable integration to Bank Reconciliation while Transaction Journal Entry is in progress. I do not have any TJE in progress…
  • 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…