• Sage 300 SDK field values not setting ONHOLD and PRIPERCENT

    Setup: C# Framework: .NET Framework 4.8 SDK: ACCPAC.Advantage Code Context: OpenView just initializes a session to the DB, there would be no issues behind this - it works just fine with everything. Important: No errors appear what so ever…
  • Integration between Shopify and Sage

    Hi Everyone, What are people using to integrate between Shopify and Sage? Many Thanks for your help Jessica
  • Where to find Journal Entry Balances

    Hello Sage Community, I am currently working on an integration project to post transactions into my Sage 300 ERP database via an API. While posting transactions directly from the Sage 300 ERP interface to the GL as a journal entry, everything works correctly…
  • 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 ?
  • German Accounting - DATEV

    Hello All~ I was wondering if anyone is exporting out of DATEV and importing into SAGE 300. We use SAGE 300 is our ERP system and are merging with a German company who uses DATEV and will remain using DATEV for a myriad of reasons. I would like to export…
  • Java runtimes for global search

    We're looking to deploy OpenJRE instead of the Oracle java runtime due to the recent licensing changes and associated costs. The only thing we can find in Sage 300 that needs one at all seems to be the global search function. Has anyone had any experiences…
  • Sage 300 + CDATA JDBC Driver for sage 300 + Talend Data integration

    Hello , I'm new with sage 300 and i need to connect my Talend data integration with sage to extract data. To this i installed sage 300 on my machine i created a simple company to do the test , then installed CData JDBS Driver for sage 300 ... …
  • Multiply version of Crystal reports

    Can another version of Crystal reports be installed in an environment running Sage 300 2017 with the CR runtime XI. I have a client whose reports were working fine but then another program was installed using CR 2016 and now the Sage reports won't run…
  • Can not execute macro syntax

    I create a user in ACCPAC. But i can't execute my macro syntax. But if i change the user to Admin, its working fine. Can anyone help me? How to configure the new user, so i can execute the syntax
  • Get user using windows authentication and domain

    i want login using macro. but using windows authentication and specific domain can anyone can help me?
  • Error HRESULT E_FAIL has been returned from a call to a COM component.

    i have some code PORCP1header.Order = 0 PORCP1headerFields.FieldByName("RCPHSEQ").PutWithoutVerification("0") ' Receipt Sequence Key PORCP1header.Init() PORCP1header.Order = 1 temp = PORCP1detail1.Exists PORCP1detail1.RecordClear() PORCP1detail3…
  • get Field value in macro into a variable Vb.net.

    I want to get value from PORCP1detail1Fields.FieldByName("ITEMDESC"). the condition that i have set if PORCP1header.Read how to get the previous data from that field and set into a variable in vb Example: Dim vItemDesc As String = "" vItemDesc…
  • Sage 300 and Shopify

    Has anyone integrated Shopify with Sage 300? If yes, would you recommend it?
  • 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…