• 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…
  • General Ledger Budgets

    Is Creating a Budget in General Ledger a useful tool or is it better to create the budgets in Excel and export the data from GL?
  • 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…
  • Clear History

    Please, how does clear history work. We are having issues with old transaction and we want to delete the old posted transaction.
  • 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…
  • Disabling "Clear History" in G/L Periodic Processing for certain users

    Hi have been trying to figure out how I can disable "Clear History" for certain Users.) (last item in screengrab) Tried unticking "Period End Maintenance" and "History/Budget Maintenance" - both did not work. ( please see list of options for GL ) …
  • Financial Reporter will not Preview

    We have a customer that is having an issue on 1 workstation only with the financial reporter. It will not generate in preview, but they can print to file. The same statement works from other workstations. It is Sage 300 2021 with the latest Produce…
  • 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…
  • Credit Card Receipt Confirmation Report Customization

    Hi, We're running Sage 300 2022. We just got Paya installed and did our first Credit Card transaction. I'm still fairly new to the usage of Sage and Crystal Reports. How do I customize our receipt confirmation report to include Order Number or an Invoice…
  • Chart of Accounts in Web Screens

    I cannot seem to find the "Chart of Accounts" screen in web screens. Is this not available or am I missing something? Thanks, Ubaidullah Nubar.
  • Posting to previous FY

    Hi we have an error batch as the error occurred because the user has posting to a prior year (posting date 22 July 2021and value date 30 June 2021). The posting has to be done to last financial year (2020-2021). We have already done End of Year Processing…
  • Sage 300 2019 Data Conversion to 2021

    During data conversion of one of the three databases, I come across the following error message. The other databases were converted successfully. Description: You cannot upgrade because some of the features you currently use are not available in the…
  • 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…
  • 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.…
  • 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…
  • 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…
  • Is there a way to run a report from Sage 300 that shows ALL unique vendor numbers and transactions for a given period at the G/L level?

    Is there a way to run a report from Sage 300 that shows ALL unique vendor numbers and the G/Ls associated with them for a given period? Essentially I need all vendor transactions with the G/L detail associated with them for a given period across all different…
  • GL posting Error - "Entry for a period before the prior fiscal year"

    FormerMember
    FormerMember
    In AP, I entered a manual ck incorrectly as 4/19/01. When the system tried to post the resulting GL entry, I got this error. I have since voided the manual ck and re-entered it correctly. Now, how to clear this error in the GL posting?
  • G/L Inquiry with Income Statement Year End Income Statement Amounts

    FormerMember
    FormerMember
    Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…
  • how to import into Sage 300 2017 General Ledger ?

    our company have more than 40000 journal entry history data - how to import into Sage 300 2017 General Ledger ? I tried entering manual Journal and export in excel sheet then add 5 journals on headers and details , then import from excelsheet it's…
  • People posting to invalid GL accounts

    Is there a way to prevent people from posting to invalid GL accounts from the subledgers? When people are in AP coding invoices or in Credit Cards they are creating accounts that do not exist in GL resulting in several reclasses each month. Is there a…
  • I need to re-number some G/L Accounts -- Where's the utility to do so?

    I need to re-number some G/L accounts in Sage 300 - 2018 version - running on our server. I understand there is a utility for doing so, but -- even logged in as an administrator -- I can't find it. Where is it hiding please? Or do I need to do something…
  • Trial Balance amount difference from GL transaction listing balance

    Please, need an urgent response. The amount showing the trial balance for a particular account for a specified period is different from the amount showing on the balance in GL transaction listing report. I didn't know this because my trial balance actually…
  • GL Historical data

    Hi Support, i'm setting up Sage for a new client and due to time constraints, the client has asked if it is possible to enter this years data first and enter prior years data at a later stage. Is this possible? how can this be achieved? Priti…
  • AP detail description

    Hi, In AP GL integration, if the detail description option was not selected to be transferred to GL initially, what happens if this setup is done mid way. Will the detail description be transffered for history data? If not, then how can this be retrieved…