Browse By Tags

  • Cannot post an account code in our General Journal - that we have been able to in past.

    Since the latest 2024.1 update, We cannot enter a Ledger Code into the General Journal that we used to be able to all the time. Does anyone know how to fix this? I have read previous QAs on this subject, but none of them answer my question, as it was…
  • Navigating between GL, AP and AR

    I am wondering if it is possible to navigate directly between the A/P ledger or A/R ledger and the General Ledger. For example, if I'm looking at an A/P transaction in the A/P ledger, is there a quick way to navigate to the resulting G/L posting? And…
  • GL base accounts setup error

    While setting up the base accounts during 'generating' an error was made including some accounts tied to entities that should not have been. Is there a way to remove these accounts from those entities?
  • 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 Trial Balance Missing Figures

    Sage 300 2023 After posting a Take-on Opening Balances, a Trial Balance was printed, and the total appears to be far less that the posted batch totals. There is no error reported during posting of the batch and all entries in the batch have been posted…
  • Businessworks 2023 transaction posted to AR but not to GL

    I didn't think this could happen but our program must have glitched while posting this transaction. Posted an invoice in AR. It appears in all AR reports run to verify it exists. However, transaction did not post in GL. I ran account detail reports for…
  • Saved General journal not showing on list but shows in report

    Created a journal entry and I can see the transaction on the general ledger for accounts included. But the general journal is nowhere to be found on the list.
  • On Journal Entry, Rate value is different from the other item line

    Hi all, my customer is making a journal entry when this happen. Please refer to the Rate column and the cell value in red rectangle. The value of the rates on this column are prefill accordingly. But the value for the last item line is different from…
  • G/L Journal Entry Error - Please Help

    Has anyone experienced this error before when processing G/L Journal Entry? Not sure where to even begin but processing a few transactions / posting banking transactions and then doing G/L Journal Entry and we get this error. We are running Sage 300 2022…
  • Correcting the period on a posted invoice batch

    A batch of about 200 Invoices was posted to a previous year (period) and the checks were posted in the current period. How do we get the invoices corrected into the current period?
  • Inventory Count Issues

    Hello, We were performing an inventory count however one of our employees made a stock transfer from one location (being counted) to another. When we look at the part number through the inquiry function, we see the appropraite quantity in each location…
  • Incorrect GL account type Balance Sheet > Income Statement

    Our client has a few GL account configured as Balance Sheet account instead of Income Statement account. The account was incorrectly created as a balance sheet account. We need to change the account type to income statement but firstly, correct the…
  • Rental Property

    Hi, Our company has built a rental property. The property will have one unit as a rental and the lower unit will be used for staff traveling at no expense to them. My question is how do I set up the accounts to keep track of the expenses for both the…
  • 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?
  • Help Please with Sage BW 2019 General Ledger

    All, I am new to the product. We are running BW2019 as a Cash Accounting system. We have entered Cash Disbursement Journals for the checks we wrote, but we did not put a description so that we know who we wrote them to. How do you go back and correct…
  • Actual AP vs. AP on the <Standard> BS is Extremely Out of Balance

    Hello! I've been looking through the forums for some time trying to find some assistance to our reports being out of balance, some posts and responses have helped me track down unusual information, but nothing conclusive to help fix the issue(s): -…
  • Recurring Batch Entries

    Hello Team, I was trying to create a new RECURRING BATCH ENTRIES through the GL Setup >>> Recurring Entries >>> Filling the GL Recurring Entries screen and click Add. After clicking "Add button", this error comes up " Sequence Number Dispenser.…
  • 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…
  • The Header Journal Source Code AR must match the Batch Journal Source of GL

    Sage 300 2020 PU 2. A customer receives the error message, 'The Header Journal Source Code AR must match the Batch Journal Source of GL' when importing a batch from AR (Create G/L Batch). The batch contains AR-IN and AR-PY transactions. Source Codes are…
  • Payroll not posting

    I discovered today that last pay period did not post to GL even though all steps were completed per usual. Now when I try to post, it tells me there are no records to post, The records remain computed. Has anyone experienced this and how did you fix…