• After upgrade from 2021 to 2023 I got Error HRESULT E_FAIL has been returned from a call to a COM component.

    After upgrading sage from 2021 to 2023 I got error Error HRESULT E_FAIL has been returned from a call to a COM component on accessing web screen.

    What would be the reason of this and solution ?

  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance.

    Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer.

    To this end, I would like to build a query in sql views…

  • Sage 300 remote server connection

    Custom designed POS app in MSAccess and VBA that uses ODBC to query/display customer data from SAGE. Need to write changes back thru ACCPAC views. The POS front-ends run as standalone networked PCs. SAGE 300 runs on a VM in the backoffice. Coding is stuck…

  • Update Inventory Worksheet via SDK

    Hi Guys,

    I am having an issue while updating Inventory Counts in SAGE300.

    I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities.

    Has someone successfully updated /C Physical Inventory In SA…

  • SAGE 300 61A SDK HRESULT E_FAIL Error

    Hi Guys,

    I have an issue when attempting to retrieve or insert data into SAGE databases using the SDK 61A.
    I am able to establish connection with the SAGE database and open the Views.
    However, I am getting a HRESULT E_FAIL error when I try to retrieve or…