• 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…
  • 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…
  • 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…