• AP Check printing with missing alpha text.

    AP Check printing with missing alpha text. Noticed after upgrades to 2023PU1 and 2024PU1.
  • Emailing 1000's of invoices out or Sage in error

    I had a customer that wanted to email out invoice in Sage 300 but before she selected the range of invoices, she selected delivery method of customer and clicked print. OOOHHH NNNOOO!! Panic!!. over 4000 invoices were going to either be printed or emailed…
  • HOW TO GENERATE A PREVIOUS BANK RECONCILIATION REPORT?

    Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023. I am in January 2024 and I am unable to go back to that specific date (November 31, 2023) Is there an alternative way to retrieve this report? My error…
  • List of Open Batches VIA WEB API

    Hi Is it possible to get a list of Open AR Invoice Batches via WEB API\ Or provide an endpoint through which we can query to find list of open AR Invoices batches in Sage 300 Regards
  • Error on Opening the xla macro

    Hi, We have encountered an issue whereby we are receiving the following error messages: 1. PrintReport: Error on opening the xla macro 2. Problem is found in running Financial Reporter Addin We do not have application support in-house and have…
  • Multicontact emailing using Gmail giving error

    Why are Multi-contact emails not sending out when using GMAIL settings, however when selecting single email setting in AR it works?
  • How to enter a project expected billings/invoices for cash flow forecast

    Hello, Does anyone know how to enter in Sage expected billings/ invoices for projects ? Goal - cashflow forecast And also where to find a report for this filtered by project. Thank you!
  • User Activity Report

    sage300 v7 (2023) sp1 fresh install. I can't get user activity to show any details. it comes out blank. running it as admin the company has had users using it for a month now
  • Does anybody know what table and field the Notes module stores the note status? (Active, Future, Expired, Dismissed)

    I see there are 4 tables for KN module. KNNOTEH is the main one. KNNTDIS is apparently to make a list of notes that have been dismissed, however, these records remain if you restore the note so this cannot be where Sage records the note status. KNSEQ…
  • Is Sage 300 2022 PU2 Compatible with MS Office 2021 32bit?

    Hi, One of our client upgraded their Microsoft Office version to Office 2021 MSO (Version 2205 Build 16.0.15225.20028) 32-bit. Does it compatible with Sage 300 2022 PU2? They need to run FR, but encounters the following errors: Description: PrintReport…
  • Printing Multiple Invoices

    Hello everyone, this there a way to print multiple invoices under a customer number at once? (I use Sage300) Example: A customer sends me a list of multiple invoices that they need. I don't want to search each invoice individually and save as a pdf…
  • 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?
  • Mismatch between I/C quantity and Lot/Serial quantity of an item

    How to fix mismatch between I/C quantity and Lot/Serial quantity of an item if there is a variance on the I/C Serial/Lot Number Quantity on Hand Report? Below is an example in our sample data for this item, A1-405/0 at location 1. As you can see the…
  • System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at AccpacCOMAPI.IAccpacSession.GetPrintSetup(String menuID, String ProgramID)

    accpacPrintSetup = accpacSession.GetPrintSetup(" "," "); on reaching this line application crashed
  • FINANCIAL REPORTS IN DETAILS

    I have chart of accounts with two segments i.e MAIN & MAIN SUB 1234 Repair and maintenance 1234-01 Repair and Maintenance - HQ 1234-02 Repair and Maintenance - TZ 1234-03 Repair and Maintenance - ZM On printing financial reports only Main…
  • 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…
  • SIRC: Sage300c 2020 reporting cloud- won't load

    Using Sage300c for the first time. browser stucked on https://[IP.ADDRESS]:9113/#/Welcome Web/ WepAPI already set to allow admin access Any other suggestions ?
  • 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…
  • unable to load report

    I have a report written over a Single View. The tables used include: GLAFS, ARCUS, OEINVH, OEINVD, OECRDH, OECRDD, ICITEM. When I run my report in Crystal it runs fine. When I attempt to add it to the ACCPAC SAGE300 Reports menu I receive a popup warning…
  • 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…