• 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…
  • Need support for quarterly and year end closings. Sage 100 with Job Cost

    We are network cabling contractors using Sage 100 with Job Cost and lost our Sage 100 support person. We have a CPA, but need someone for quarterly/year end closings. Located in Orange County, CA near John Wayne Airport. Any referrals would be appreciated…
  • 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…
  • 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…
  • General ledger

    General Ledger posting on transaction register but not posted to the gl but posted to bank reconciliation module
  • 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…
  • How do you record a merchant account chargeback?

    I tried searching for answers to this issue, but was surprised to find that nothing addressed this not uncommon issue. We had a customer that was invoiced for a purchase and paid with a credit card. It turns out it was a fraudulent credit card. Recently…
  • Miscellaneous Item cost posts to wrong GL code

    Has anyone seen this before? I'd like to pass it off as just a little hiccup in our system, but if truly random it makes me wonder how many other little random hiccups are not caught... and if not random what was done wrong to cause it... so we prevent…
  • Finished goods on Balance sheet

    The finished goods on my balance sheet is way to high. where does Mas 90 get this number?
  • finished goods on balance sheet

    Our finished goods number is badly out of sync with our valuation report under inventory management. I understand the two are not connected but they should be in the same ball park. my finished goods number is much higher on the balance sheet. we actually…
  • Error while merging GL Accounts

    I am trying to merge two accounts together but I get the following errors. Any ideas on possible solutions?
  • Bank Rec adjusted bank balance vs. GL Balance

    Hello, The new company I work for has several cash accounts that the adjusted bank balance per the bank rec are not matching up to the GL amounts that hit the balance sheet even though the out of balance amount is zero on the bank recs. 2 of the accounts…