• Excel Button Greyed Out

    Anyone come across the excel button in GL Transaction being greyed out? All of the other exports work, but the GL screen is greyed out, even when i have a transaction highlighted.
  • 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?
  • Transfer history in a GL Code to a new GL.

    In the General Ledger, I would like to transfer history in a GL Code to a new GL. The new account will not have been used before, just trying to clean up the books. Is there a way to do this?I have looked at Utilities/Change accounts, but am not sure…
  • Opening Balances of GL

    Hi Team Please help to locate the Opening Balance column/field in the GL table list. Or how can we get the Opening Balance/Closing Balance data from Sage 100 ERP. Thanks Thulasi.
  • 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?
  • Chart of Accounts issue

    When I want to add new account, this message showing that, account 11111111 my AccID does not match the format of the Structure Code ACC selected. This message why showing, my accounts length is 8.Can anybody know about this type problem.
  • 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…
  • Old Transactions Suddenly Appearing on Daily Transaction Register

    Our AP / Inventory person yesterday ran into this issue...old transactions suddenly appearing the the Daily Transaction Register. She alerted me of the issue and I have searched here and KB but not finding any answers: Also odd that the 10-31-22 transaction…
  • 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…
  • Missing "updated by" GL Journal Drill down

    Sage 100 2020 Premium (6.20.1) After deleting old users off a system, the GL drill down from Transaction tab "Updated By" is blank for the deleted users. The deleted user keys are listed in SY_UserHistory. Short of 'reactivating' the deleted users…
  • 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…
  • Updating Batches via BOI

    Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…