• Sage 300 Web Api - Ready To Post

    I'm working on the Sage 300 Web API to pass Customer Receipt to Sage 300 version 2021.

    In the Github documentation, it mentioned that we could set the Batch Status as Ready To Post on the POST request.

    A separate PATCH request is not required as the…

  • Sage 300 2022 API


    Does Sage 2022 allow API calls via COM?  We use Sage 2014 where we utilize A4WCOM.dll as a COM object.  Can't seem to do the same with Sage 2022.  I read somewhere that it's now a web API call

    Thanks for any info

  • CS0120 data to accpac finder in COM API

    Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement.

    mDBLinkCmpRW.OpenView("CS0120", out csQry);
    sSQL = "Select Name, Description from MYDB.dbo.Table";
    csQry.Browse(sSQL, true);

  • Banking Details Table


    Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…

  • crystal report error

    Hello, I am using SAGE/ACCPAC on a local computer and trying to run a "A/R Aged Trial Balance Report" but I am getting the following error after clicking the print button.

    A window with the heading " Crystal REports Windows Forms Viewer"…

  • Payment Batch Import Into Sage 300


    Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank.

    Could someone share…

  • Sage 300 GL batch posting freezes

    Sage 300 Premium (Version 2022)

    SQL 2019 on Windows Server 2019

    GL batch posting freezes during month end closing periods and Sage 300 becomes inaccessible for anyone who wants to further login. Other logged in users won't be able to post from GL batch…

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

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

  • Automatic Shipping and invoice Order Entry

    Here is our scenario. We give a customer a qoutation  in Order entry. The customer then goes to the cashier to pay or payonline. Then the receipt is taken back to our sales team to ship and create invoice. Isnt there away that at the time of paying the…

  • Database error (operation=REV-POST, error=229)

    We are using AccPacc to work with Sage 300.

    When we call View.Insert the error message appeared:


    Timecard Detail.

    Database error (operation=REV-POST, error=229)


  • Sage .NET API Errors

    In the Session.Init method, I'm getting an error that just shows 1.4197.5

    I have no idea what this means and don't see documentation anywhere that explains it. Can anyone help on what this means?

  • Statetement designer - not updating current year figures


    I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs as…

  • Failed to import the ActiveX control. Please ensure it is properly registered.

    Hi all,

    We are having an issue while adding a SAGE300 component into a Visual Studio form (.NET project).

    The error we received is: Failed to import the ActiveX control. Please ensure it is properly registered.

    We have registered the accpacic1500.ocx…

  • Accpac Plus conversion to Sage 300 (5.4) OE Error: The Price List is not in use for this item and specified customer. How do I fix this?

    I have all modules converted (OE Tax, GL, AP, AR, IC), but have error when trying to convert OE. There is nothing that indicates what Price List, Item or customer. This is Multicurrency data (CAD, USD, EUR). IC has 6 Price List (3 CAD, 3 USD), ALB, ALBX…

  • 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

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

  • Importing Transactions into Project and Job Costing


    I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error  - Could someone…

  • System.AccessViolationException with ACCPAC.

    Hello Experts,

    Facing the below error while accessing the ACCPAC API.

    at AccpacCOMSVR.AccpacSvrViewClass.Process()
    at ACCPAC.Advantage.Server.View.Process(FieldValue[], Int32[])

    We have a .Net based windows service that…

  • Extender

    Hi, is there anyone using the Orchid's Extender module in Accpac 2019?

    I want to display a message box when the next button is clicked.

  • Black & White Printouts from the Clint system

    Hi Team, Just wondering if anyone can assist me on how i can get black & White Printouts from my client system when printing Quotation, Invoices, etc. I did change the printer preferences to both monochrome and grayscale and tried but still receiving…

  • Macro PO Order

    how to retrieve vendor number values ​​on the PO Order screen using macros


  • Setting paper orientation in VBA

    I have a macro that prints out some reports but I need to set the paper orientation to landscape.

    Is there a way to set that in the macro?  The Crystal Report is designed to be landscape but when I send it to the printer in the macro it prints portrait…

  • I/C Transfer Suppress Print Transfer Slip Confirmation Dialog box


    Is there a way to block the Print Transfer Slip Confirmation Dialog box from appearing for IC Transfer.
    We have created a custom Print form and wish to suppress the standard Print confirmation alert box which appears after Saving or Posting a Transfer…

  • AccpacPrintSetup crashing after upgrading to SAGE 2020 PU2

    In previous version, SAGE 2017. This code works fine. But after upgrading, it crashes.

    Dim oRpt As AccpacCOMAPI.AccpacReport
    oRpt = oSession.ReportSelect("APWMSSOFTRMT[APWMSSOFTRMT.RPT]", " ", " ")

    Dim oRptPrintSetup As AccpacCOMAPI…