• Financial Statements fails to open in MS Office 2019 Pro Plus

    Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…
  • Printing error

    Using Sage 300 2020 with a shipping Macro that worked last week and now when printing packing slips we get the error.... Automation error The object involved has disconnected from its client. This only seems to happen for specific user. When logged…
  • AR Aging Reports in BI are Cutting Off by Doc Date, Possible by Posting Date?

    I have a client wanting to use the free BI reports provided by Sage called the Customer Aged Trial Balance S300-SQL(C4-0-5) or the Detailed AR Aged Trial Balance S300-SQL(C133-0-4) Unfortunately, both aging reports cut off by Doc Date and for…
  • 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 across all entities?

    Report might look like this: Fiscal year: Fiscal period: Due date: Vendor Number: Order no: BS GL code (Header): Expense GL (line): Transaction currency: Gross amount: Tax amount: Net amount:
  • Formulas to pull out First name & Middle Initial separately

    I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…
  • Sage 300 2018 UI Container Error on Print Preview

    Installed sage 2018 Premium with PU2 on a server. migrated a customer from sage accpac v6.0. Data upgraded fine but if i try and print any report to preview the UI container error comes on. Windows Server 2016 with SQL Server 2014.
  • Print Preview not working - Sage 300 2018 PU2

    Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018. When trying to print preview any default sage reports get error message. Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…
  • Sage 300 2017 Business Intelligence - Missing Accounts Tool

    I'm having an issue when running the missing accounts tool. On one report I've built, the tool will only show missing balance sheet accounts even though I know for certain there are missing income statement accounts. I even went so far as to build one…
  • Sage 300 Intelligence Reporting module :- Run-time error '13':Type Mismatch

    We are working on a project where we have installed Sage 300 Intelligence Reporting module. The session date is showing correct format of regional date setting (e.g. South Korea). Also, all transaction screens show correct date format (e.g. YYYY-MM-DD…
  • Print Financial Satements - FrCom Addin

    I have searched the knowledgebase and i have not seen the answer. The Print Financial Statement suddenly stopped working on my workstation. The other workstations are ok. I get this error whenever I click "Print" and when Excel tries to run the report…
  • Inserting a running total from a Formula field to OE Invoice report

    To all Sage300 Report and/or Crystal Report gurus: I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…
  • 65K row limit

    I just attempted a Sales Report and received a warning about exceeding the 65K row limit. I am using Excel 2013 so that is not a limit from Excel. Is there something I need to do to get around this limitation?
  • GL Trial balance

    Hi, Is there a way to print the GL trial balance as at a particular date in Sage 6.0.