• Error when create project of Sage UI Customization Wizard on Visual Studio

    Hi all,

    My Sage 300 version is 2023.1.0. I already have the web screen running & working fine.

    My Visual studio version and info below:

    Microsoft Visual Studio Community 2017 
    Version 15.9.52
    Microsoft …

  • T5018 (CPRS) Print Form Option No Longer Available To User.

    Hi Everyone,

    We seem to be having an issue with our A/P Vendor Reports. One of our users was able to run a T5018 form from the "Print T5018 (CPRS) Forms" icon on Feb 10th. Now when she goes to run the report the icon is no longer shown, along…

  • Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name.

    Now I want to add some fields to it that are not in the set of data tables already in the report. 

    In the "Field Explorer" I right…

  • Received not Invoiced report?

    Is there a standard report that will show me POs received but for which an AP Vendor Invoice has not been entered into the system?

  • Sage Alerts and Workflows with 2 Factor Authentication

    Our IT company has turned on 2 factor authentication and now Sage Alerts and Workflows is not able to send out e-mail notifications.  Has anyone figured out a way around this?


  • Are ICPRIC and ICCPUR accessible via the Sage API?

    Are ICPRIC and ICCPUR accessible via the Sage API?

    If not, is there any other way to access Price Lists, other than by direct SQL Query or middleware such as Realisable IMAN?

  • How to make OE CN on account and reference an OE Invoice

    on OE/CN screen you fill in OE/Invoice number and Sage loads details

    I have certain customers where all OE/CN are on account, trouble is once you erase the OE Invoice# the screen details erase (can we stop this from happening?)

    I did not want to manually…

  • Credit Card Receipt Confirmation Report Customization


    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…

  • Inventory transfer macro is failing when negative levels allowed

    I have a client who needs to run their inventory with negative levels allowed. We are running Sage 300 2021 with update 2

    I recorded a macro of doing an inventory transfer from location 1 to 2 with a qty=5.

    Location 1 had zero of these items and so it…

  • Adding AR Invoice Number to E-mail Template

    Hi all,

    A client wants to add the A/R invoice number to the email template. I've tried to search from F1 Help -> E-mail Message Variables, but there's no such variables named AR Invoice Number. Does anyone has any idea?

    Thank you.

    Yours Faithfully…

  • Sage 300 Web SDK - Error occur when build solution after using wizard to generate screen

    Hi all, I tried to use Visual Studio 2019 with Sage 300 Solution Wizard to generate a simple screen. Right after the solution was auto generated, I use Sage 300 Code Generation Wizard to create a payment code screen. I tried to build the solution but the…

  • Web API - Sage 300 2020 - ARReceiptAndAdjustmentBatches

    I may not be processing this correctly. Send the request below creates a new batch everytime.

    POST: http://localhost/Sage300WebApi/v1.0/-/TESTCOM/AR/ARReceiptAndAdjustmentBatches

  • How do we make fields required when setting up a new job in the Project Management Module?

    We are rolling out the Project Management module and want to require certain fields so our Project Managers are required to enter the information before they can create the new job.

    Is this possible?

  • AP entry - How to deny continuation of entry if year is wrong?

    Sometimes clerk uses the wrong year, or month, when entering AP invoice. We post automaticall;y to GL

    She doesn't check her report for errors and then controller needs to investigate when it is denied posting at GL level.

    Does anyone know of a way…

  • What is the syntax to add a budget column of a specific year?

    What is the syntax to add a budget colunm of a specific year?  How to specify 2020 budget column to the report?

  • sage 300 sdk with node js

    can we integrate sage 300 SDK with node js? 

  • Error during API call ARCustomers

    Hello Team,

    When I try to call ARCustomers via API using a filter that designated in the Sage 300 specification, I received an error.

    Example of the request:
    http://{IP Adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$filter=DateLastMaintained le datetime…

  • Crystal Report Error

    I made a report with crystal report on my local, it all went well but when running on the client pc the following message appears

  • class not registered C62A69F0-160C11CE-9E98-00AA00574A4F

    Good Day, our client upgraded there office from 32bit to 64bit.

    But now we are getting a class not registered error when trying to open macro to display user form.

    We have tried to reg edit the fm20.dll file and that also gave us an error.

    How else…

  • Error: Class does not support Automation or does not support expected interface VBA

    Having an error on my VBA "Class does not support Automation or does not support expected interface" when assigning 

    Set dsGLJEH = AccpacGL2100UICtrl1.UIDSControls("dsGLJEH")

    On "OnUIAppOpened()"

    Public WithEvents dsGLJEH As…

  • Is there a way to build a Purchase Order Report to include the "Ship to" name?

    We need to retrieve Purchase Order details to include the PO # and "Ship to" name.   Can this be done with canned reports in Sage 300?  My searches have come up empty.

    We have intelligence but not Connector.  The Purchases Master report doesn't appear…

  • Failed to import the ActiveX Control

    Having problem with my SAGE 2020 (300 Premium) (Build 0)

    When I tried to add COM Components for example AP2100 (AccpacAP2100.AccpacAP2100UICtrl)

    and drag that to my Empty Project .NET (VB), it show's the error below (Failed to import the ActiveX Control…

  • Am getting an error when am printing customized crystal reports on web (Sage 300 2020 PU3)

  • Report Designer - custom date formula

    Hi there,

    This is my first post in Sage 300 online Community, woohoo. I find myself in uncharted waters.

    I am putting together a custom date formula, where the date has DDD field, which means 3 digits for "day in year".

    Example would be that…

  • 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…