Browse By Tags

  • 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…
  • Data error. Sage 50 Canadian Edition 2021.1 Advanced Check & Repair tool cannot adress the issue. data table TBRTR

    I am using Sage 50 Canadian Edition 2021.1 I used "open as an admin" to open the sage program. I am in the single-user mode and logged in as a system admin. I have some issue that cannot post into a future date. cannot add departments in payroll. when…
  • 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?
  • Changing the default Item Inquiry Transaction Dates to the current month rather than General Ledger Period

    My users are experiencing an issue where the accounting department is still performing month end closing processes for the previous month after start of the next month so the current General Ledger period is still last month and does not match the current…
  • How do change the fiscal year without adding Historical transactions?

    Hi. Just setting up a new company from Dynamics. Their year-end is May 31st. In order to have historical transactions, I started the company as of 2019. Entered the GL historical amounts, then entered each month's adjustments for the year 2019~2020…
  • 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…
  • Sage 300 people - Sage 100c GL Integration Layout

    Hello All, I would like to have a seamless integration from Sage 300 People to Sage 100c. First of all is the seamless integration possible , If yes , which of the layout below should I use?
  • 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): -…
  • Is it possible to sort Transaction Description on General Ledger report?

    Is it possible to sort Transaction Description on General Ledger report?
  • Print line comments in the general ledger

    When entering a JE there is the individual line comment; is there any way to print that individual comment per line when printing a GL (or an individual account in the GL)?
  • 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.…
  • My Reports / General Ledger / Adit trail report has no data to show

    Hi All, Suddenly my My Reports / General Ledger / Adit trail report that I use to keep a record of journals posted is suddenly coming up with a message stating that there are no records to print. This is part of our month-end process and they printed…
  • Items Group - Override Transaction Type GL Accounts

    Hi I am creating a Group of service items in order to override Transaction Type IN (invoice) default general accounts for Debit/Credit. I did the following: - created the Group "Service CEB Utility" - created a service item "ELEC001" - Put ELEC001…
  • Cashbook Import Error - Object Was Open Error

    Has anyone ever seen this error before when importing a cashbook batch. I have tried the solutions in this knowledge base article with no joy. KB Article - Object was open.pdf
  • 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…
  • GL Account Code without Delimiters

    A client has a need for a General Ledger Account Code made up of more than one segment, but with the option of not using delimiters. Is there a way to do this in Sage 300? For example, Segment #1 = Cost Centre, XXXX; Segment #2 = Account, XXXXXX Instead…
  • GL Cashbook entry

    Hi I have to do some cashbook entries for transactions over a 6 months period. Needing some best practices concerning: 1) Do I need to create and separate each type of transaction (BankA_CASH, BankB_CASH, BankA_DEP, BankB_DEP) in separate batches…
  • GL transaction file in use error at login

    We have a frustrating situation where, if someone prints a GL report to screen and leaves it open, another user cannot login to the GL application. They receive an error message, "GL transaction file in use." If the user in the system closes that report…
  • Delete transaction

    when deleting a transaction Is the data updated in the GL? I am asked to delete some transactions from the previous year and I am not sure if the Ending Balance will be updated Thank You
  • 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…
  • New Chart of Accounts for an existing Company

    I created our registered charity in SAGE but I skipped the step to import or use the default chart of accounts when using the Wizard. Now it appears that I have to create every account individually or create a new company to be able to use the Wizard…
  • Chart of Accounts design

    Hi I need to create following structure of accounts: Revenue -> Audit -> Local Revenue -> Audit -> Offshore Revenue -> Advisory -> Local Revenue -> Advisory -> Offshore etc.. I decided to go with segmented COA and created Segments like:…
  • Customize forms using Crystal report.

    Hi Guys, Does anyone know how to customize Sage 50 CA reports using crystal report? Version 2020
  • General Ledger Best Practice

    Hi I am new to using Sage 200. I am trying to insert some transactions (purchases) from supplierA. As shown below, all transactions will go under Purchases. 1) How can I make it go under Purchases --- SupplierA account? 2) Do I need to create…