• Sage 300 2024 Encountered Error Code: 5 during FR Financial Statements Printing

    Hi, Did anyone encountered the same error code when print Financial Statements in Sage 300 2024? After clicked OK button, the report still works fine. Why is there an error code shown after click Preview button? Client is using Microsoft Excel…
  • Sage 300 2023.1.0 - Web Screen Print Destination> Preview | Print to Email

    Utilizing Sage 300 2023.1 to access Sage300. How can the print destination be modified using Web screens? Currently, whenever we print any report, a new tab is opened with a file format menu [PDF, Excel, Word, etc.]. In addition, how email functionality…
  • Financial report and Microsoft 365

    Hi all, its 2023, can we generate the Financial report with Microsoft Excel 365 now? I remembered last time, it only works on Office 2010. Thank you
  • Does Sage Business Intelligence in Sage 300 Require Excel to be 32-bit?

    Does Sage Business Intelligence in Sage 300 Require Excel to be 32-bit? Sage 300 v2022
  • 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…
  • OECOINI comments

    Using OEINVD and OECOINI tables for report and trying to get item/miscellaneous comments. Somehow I am not able to get comments to match. Any tips?
  • Financial Report UI is different between Microsoft 365 and older version of Office Excel

    Hi all, my customer is generating financial report from Sage 300 web app as excel file and open it on Microsoft 365. However, the alignment is wrong. All the debit values in red color appears in Credit column. When opening it on old version of Office…
  • 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…
  • Invoice Details (ARIBD): what is "Extended Amount w/ TIP" ?

    Good morning, I think this is the correct forum, but please advise me if not: Looking at the data dictionary for table ARIBD (that is, the "Invoice Details" table which lives in the ( AR ) module) - every row represents an "invoice line item". Now…
  • 2019 Print Financial Statement - Statement Name

    My client has 3 databases on their Terminal Server, they also use Customisation Directories. \COMPANY-A\CUSTOM\GL66A\ENG \COMPANY-B\CUSTOM\GL66A\ENG \COMPANY-C\CUSTOM\GL66A\ENG When Printing Financial Statement using Print Financial Statement…
  • Problem with Printing in Sage 300

    Hello, I am new to using Sage 300 and I have a problem with printing. When I select any of the Print Destination options and check Data Integrity, a log file should be printed (or opened in another window for Print Preview). However, the check is performed…
  • Sage300c Webscreen report display but wont export or print

    We are using Sage300c 2020 web screen, when we print a report we are able to see it on-screen {Preview}. But, unable to print to printer or export
  • Commitment Count - Total & Unique

    Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time? We're trying to determine: 1) How many commitments were…
  • Macro to print/save Open G/L batches at month end

    I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…
  • 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 Financial Reporter - Income statement

    Sage 300 Financial Reporter - Income statement is not populating but balance sheet does. Has anyone else seen this and how do we fix?
  • 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…
  • runtime error 1004 cannot run the macro Remove AutoStart Files

    Sage2018 SP2 new server. office 2010, when you launch statement designer comes up with error "cmdStart : Error on opening the xla macro.", if you click close says "cannot run macro RemoveAutoStartFiles" excel macros are enabled and VBA enabled too.…
  • Report window exits on clicking Print button

    When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines. Appreciate if anyone has seen this before and has a solution…
  • 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…
  • Sage 300 2017.2 - Financial Reporter, Excel 2016 32 bit

    Hi, I am unable to run any report: I get a message box that says: Initialising FR Error (12): Fail in starting Print Financial Statements and when I push OK, another box, pops up: Error: PrintReport:Error on running StartGL9100 in macro …
  • Accounting and financial statements

    If you're looking for an easy introduction to Accounting and Financial statements, take a look at the following set of videos provided by Khan Academy: www.khanacademy.org/.../accounting-and-financial-stateme Then if you'd like to see how this is…
  • GL Trial Balance and AP Aged Payables report totals do not match

    Hi. I am having a problem getting my GL balance and my AP Aged Payables report totals to match. No matter what combination I enter, due date, document date, period end date; they will not equal. I searched for help on this board with related questions…
  • Old Print Error in 5.6

    Hi ...... when my user tried to print he see's this : KUSHAL ERROR.docx