• Understanding SOC Reports and Why They Do Not Apply to Sage 300

    At this time of year, we typically receive several requests for SOC-related certifications relating to Sage 300. To help clarify these requests, it is useful to understand what SOC reports are, when they apply, and why they are generally not applicable to Sage 300.

    What Are SOC Reports?

    SOC (System and Organization Controls) reports are independent assurance reports developed by the American Institute of Certified Public…

  • Printing issue in Sage 300 2026 where selecting a specific page to print from the preview results in printing the focused page instead.

    Thought I'd share an overview of a recent issue encountered with Sage 300 2026 regarding printing selected pages from the print preview, along with the identified root cause and recommended solutions.

     Background 

    A client reported that when attempting to print a specific page (e.g. page 3) from a multi-page report via print preview, the system would instead print the currently focused page rather than the selected…

  • Managing the Information Center in Sage 300 Desktop

    Starting from the following versions:

    • Sage 300 2026 PU2
    • Sage 300 2025 PU5
    • Sage 300 2024 PU9 and later

    The Information Center will automatically launch at the center of the Sage 300 desktop before a company is opened.

    As shown in the screenshot below, if your organization prefers not to display this feature, it can be easily disabled.

    How to Disable the Information Center

    You can disable the Information Center by…

  • The impact of Read-only mode on Sage 300 Intelligence Reporting upon the expiration of the Subscription Licenses

    Following on from an earlier post about Sage 300 Subscription Expiration messages, we have subsequently received a number of questions related to what the effect of read-only mode entails. As we have been unable to obtain anything documented in this regard, we did some internal testing in support and will be posting our findings for each module.

    Herewith our findings for the Intelligence Reporting Module.

    1. At the time…
  • Sage 300 E-invoicing Malaysia Module - PU3 - Audit table

    In Sage 300 EI module PU3, there is a EIOAUD table which contain the audit trail of the E-invoice transaction.

    In EIODOC table, we can find out the current status of the invoice. However, if user perform refresh/send in EI Outgoing processing screen, there will be status change of the invoice. In EIOAUD table, we are able to trace the status change.

    To explain, i will start with create and posting an invoice. After posting…

  • The impact of Read-only mode on Sage 300 General Ledger upon the expiration of the Subscription Licenses

    Following on from an earlier post about Sage 300 Subscription Expiration messages, we have subsequently received a number of questions related to what the effect of read-only mode entails. As we have been unable to obtain anything documented in this regard, we did some internal testing in support and will be posting our findings for each module.

    Herewith our findings for General Ledger.

    1. In read-only mode the G\L Periodic…
  • The impact of Read-only mode on Sage 300 Common Services upon the expiration of the Subscription Licenses

    Following on from an earlier post about Sage 300 Subscription Expiration messages, we have subsequently received a number of questions related to what the effect of read-only mode entails. As we have been unable to obtain anything documented in this regard, we did some internal testing in support and will be posting our findings for each module.

    Herewith our findings for Common Services.

    1. In read-only mode the following…
  • The impact of Read-only mode on Sage 300 Admin Services upon the expiration of the Subscription Licenses

    Following on from an earlier post about Sage 300 Subscription Expiration messages, we have subsequently received a number of questions related to what the effect of read-only mode entails. As we have been unable to obtain anything documented in this regard, we did some internal testing in support and will be posting our findings for each module.

    Herewith our findings for the Administrative Services Module.

    1. In read-only…
  • Sage 300 Malaysia E-Invoicing - Missing Information in AP Vendor/AR Customer during submission

    In Sage 300 Malaysia E-Invoicing,  posted transaction in Account Receivable, Account Payable and Order Entry will be available in EI Outgoing processing screen for submission purpose.

    *If client does not have Order Entry module , Account Receivable module will be used instead.

    According to Inland Revenue Board Malaysia requirement on E-Invoicing, there is a series of guidelines and requirement that we need to comply. We…

  • Sage 300 Web Screen - Undefined error during login

    in Sage 300 Web Screens

     

    The message, “Please correct the following issue(s): Undefined”, may appear when signing into Sage 300.

     

    In many cases this is caused by a DNS name resolution issue. Also, for installations that use SSL certificates (HTTPS) the error may be attributed to improper application of the certificate on the server.

     

    Steps to resolution:

    First verify if the same error occurs on the server…

  • Setting up Sage 300 for to display and capture data with Chinese characters

    Part 1 : How to setup Chinese language User Interface:

    1. Ensure you have install the Chinese language packs via the Sage 300 installer.

    2. System locale and Region settings.

    3. Login as the Users which language is set as Chinese in the Users setup.

    Part 2 : How to capture data with Chinese Character:

    1. Database collation has to support Chinese characters , you may use Chinese_PRC_CI_AS

    This collation support multiple…

  • Sage 300 Malaysia E-Invoicing/Singapore InvoiceNow - Network Connection Error/Operation Timeout Error

    Sage 300 Malaysia E-Invoicing (EI), and Singapore Invoice Now (VV) module is a 4 corner model that Sage 300 EI/VV module is the Corner 1, and Corner 2 is Peppol access point provider.

    Which mean Sage 300 need to be able to establish connection with Corner 2 to perform E-Invoicing seamlessly via PEPPOL network.

    Often user encounter Network Connection error as below. 

    Screenshot of error message:

    Assuming the environment…

  • The impact of Read-only mode on Sage 300 upon the expiration of the Subscription Licenses - AR Module

    Following on from an earlier post about Sage 300 Subscription Expiration messages, we have subsequently received a number of questions related to what the effect of read-only mode entails. As we have been unable to obtain anything documented in this regard, we did some internal testing in support and will be posting our findings for each module. Herewith our findings for the Accounts Receivable Module.

    1. In read-only mode…
  • Unlocking Growth: The Sage CRM Opportunity for Sage 300 Partners


    TPAC South Africa 2025 (Feb 20-22) brought together Sage 300 partners, ISVs, and industry leaders to explore the latest innovations and opportunities in the Sage ecosystem. It was great to join Richard Jang in the keynote and have John Thomas join us virtually for one of the sessions.  One theme from the event was the power of Sage CRM when integrated with Sage 300—and the massive revenue potential this unlocks for partners…

  • The impact of Read-only mode on Sage 300 upon the expiration of the Subscription Licenses - AP Module

    Following on from an earlier post about Sage 300 Subscription Expiration messages, we have subsequently received a number of questions related to what the effect of read-only mode entails. As we have been unable to obtain anything documented in this regard, we did some internal testing in support and will be posting our findings for the various modules.

    Herewith our findings when testing functionality in the the Accounts…

  • Sage 300 Subscription Expiration messages.

    We recently had a case where a customer complained that their subscription licenses expired, resulting in their system going into read-only mode during a rather busy period prior to year-end however they received no warning messages prior to the system becoming read-only.

    This prompted an investigation during which we confirmed what is supposed happen, as well as tested that this does indeed occur, and I thought to share…

  • Error Code: -2147467259 - Unknown error 0x80040200 when printing reports in Sage 300

    We recently had a case where a customer got the below error whenever they tried printing any reports. 

    Often when cases are first logged with support, not all the relevant detail is supplied and, as a result, the complete picture often only becomes clear after several interactions. So, to make this easier to read, I have summarised all the information gathered in the next paragraph.

    In this specific instance, the issue…

  • How LanPaks work with 3rd Party Integrations

    We recently were requested on some clarification on how LanPaks are consummed for Sage 300 integrations with 3rd parties.

    Where the 3rd party was advising the client that Sage had changed our Lanpak policies so therefore the integration would no longer work with the lanpak count that they originally had. This occurred after they upgraded the environment from Sage 300 2019 to 2024.

    They believed that they could no longer…

  • Sage 300 2023 License Manager and Version 8.8

    We have updated our licensing version for Sage 300 Subscription customers. In the License Manager you will now see Version 8.8 for most modules and 8.0 or 7.3 for Payroll. In March 2024, Payroll will be exclusively 8.0. This simplifies your upgrade process by not having to update your Subscription licenses for every new release.

    You can find out what version of Sage 300 you are using from the Help menu. Choose About…

  • Troubleshooting event viewer error codes.

    A customer recently encountered the error “Cannot connect to Sage 300 Signon Manager” and, when checking the event viewer, the error code 2147943660 was displayed.

    To get the relevant error message description, firstly convert the error code 2147943660 to hex: 800704EC.

    This can be done using e.g. Google or Windows calculator in Programmer mode.

    Next, take the last 4 digits (04EC) and convert to decimal…

  • Tracking Employee Vacation Time

    Employers in different Provinces in Canada and different States in the US have their own offerings when it comes to vacation time but all offerings are within the regulations in each employee’s jurisdiction. A couple of commonly used methods with setup steps based on certain scenarios are referenced below:

    • Lump Sum method – the employee gets a lump sum at the beginning and not accrue any hours or amount for the…
  • How do I get more information into my General Ledger from modules.

    A wildly unused feature of Sage 300 is General Ledger Integration.  This feature will increase the level of details that populate GL entries from the subledgers.

    How to:

    GL Integration is specific to each modules.

    • Open module, Select Setup, then G/L Integration, Transaction tab.
    • Each Transaction Type is specific to each function.  If you double click on each column you can define what additional information to include…
  • How do I diagnose an error in web screens

    The most common error in web screens appears during login. 

    This error is an Unexpected error:

    An unexpected problem has occurred. Please try again or contact your administrator for assistance.

    What to look for:

    1.  Check <Sage Programs>\Online\Web\Logs\trace.log
      1. This debug file is populated with errors during startup and login. Note the timestamp is GMT time
      2. Each section will give some feedback to what is occurring…
  • My Financial Reporter report does not have the correct numbers.

    Financial reporter derives values from specification defined in Column A and B in the spreadsheet.

    The most common use is to define an account group to a section in the sheet. When troubleshooting issues with FR the first level is to verify accounts associated with groups.

    How to verify accounts to groups:

    • Select G/L Reports, Chart of Accounts
    • Select Report Format Detail - Long Form
    • Do not change default
    • Print report…
  • Intermittent performance issue when posting Accounts Payable batches

    After diagnosing issue with SQL Profiler, determine a long query against PMPROJS table and then single record fetches to PMPROJT table. 

    The behavour is intermittent as not all AP Batches are Project Job Cost entries so only occurs when particular projects are referenced in AP entry. 

    Sage 300 PJC was not optimized to work with large open project data set, and does not filter by a particular project or phase, but queries…