• 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…
  • Closing the General Ledger Module for 2017, 2018, and 2019?

    Good afternoon, We need to close the General Ledger Module for 2017, 2018, and 2019. What are the steps? Please and thank you!! -Jazmin
  • 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…
  • ERROR " This batch will be retained because deleted entries exist" in General Ledger

    Hello, I tried to delete a batch in General Ledger, but I received this error "This batch will be retained because deleted entries exist". Has anyone had this error before? How to fix it. Thanks a lot! Jun
  • Intracompany transactions

    Hello, I am very familiar on how to post intercompany transactions but not with intracompany. I am hoping someone can assist me. My business for privacy is called ABC. ABC has 3 locations, WV, KY, TN. We utilize the WO module to purchasing, including…
  • Blank Fiscal Year and Period record in GL_PeriodPostingHistory

    Have had 2 clients in the last two weeks come up with mysterious beginning balances on accounts as of the first fiscal year in history. Digging into DFDM, I've found a posting with a BLANK Fiscal Year and Period in both cases. In neither case could I…
  • 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?
  • 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…
  • Cash Receipts Journal: Full amount is posted in General Ledger, but not to accounts?

    Hello, We had a strange event occur a few days ago. For one of our batches, the Cash Receipts Journal processed all of our checks except for the last 4 in the batch. However, the full batch was posted to the General Ledger, and the full amount shows…
  • How to make Cash Receipts hit GL, not just sub-ledger?

    Hello, Our accounting department recently brought to my attention that entering data inside of Cash Receipts Entry only posts to the sub-ledger. They must then go into the daily transaction register in order for this to process to the General Ledger…
  • Select Invoices for Payment

    Hi - new here. Looking for a bit of help. I am trying to use the "Select Invoices for Payment" window that pops up from the "Check Printing and Electronic Payment" function. My understanding is that you can use this window to post A/P to the general…
  • Fiscal Year recalculation utility wrong number 3rd period

    Customer is trying to change from fiscal year to calendar year. New customer so entered Fiscal year data from Quick Books. Using Sage now about 4 months. 2017: Fiscal November 2017 to October 2018. Short period 2018: November 2018 to December 2018; Calendar…
  • Transaction Journal Entry - no warning message when changing offset account

    When you change the Bank Code in Transaction Journal Entry > Format you get a warning message that the GL account does not match the GL Account, but if you change the GL Account you don't get a warning message. It should provide a warning message any…
  • Can I change a comment in the General Ledger in Sage 100 V5.00.8.0?

    I made a mistake in the description in the General Ledger. Can I change the comment or am I stuck with it?
  • What is the overview on adding a separate Warehouse to Sage?

    We have a need to expand to a second location. It has been determined that setting up a secondary Warehouse is the proper route to go. I believe we also need to change the account structure somehow to add to our current 5-digit account #s. Can anyone…
  • my first year end

    Is there anything special that has to be done at year end?
  • Change Account Group

    I need to change which Account Group a couple of GL Accounts are located in. I first went into GL/Setup/Main Account Maintenance to make this change, but I get an error message stating: "This account group has been assigned to a main account used on…