• 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
  • Error message via API - Property 'ReceiptsAdjustments' on type 'Sage.CA.SBS.ERP.Sage300.AR.WebApi.Models.ReceiptAndAdjustmentBatch' is not a navigation property. Only navigation properties can be expanded.

    Team, I need your help. I would like to use the following request to receive payment: {{BASE_URL}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches?$expand=ReceiptsAdjustments($filter=DocumentNumber eq 'PY00000000000000000133') But Sage 300…
  • 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 ?
  • Payment Batch Import Into Sage 300

    Hi, 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…
  • 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…
  • Windows Server 2019 automatically close connection for HTTPS after 30 days?

    We built a custom app to access Sage service. We installed a SSL certificate so that our external app can access Sage securely. We encountered some weird issues relating to HTTPS / SSL certificate. 1) First we installed a self-signed SSL certificate…
  • 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…
  • Sage300 Integration with C#. Error Occurred While Opening ODBC Connection on Sage 300 Application using C#.

    ERROR [08001] [Simba][SimbaEngine ODBC Driver][DRM File Library]Invalid account name.ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version…
  • ESS database connection 3 characters - does this mean the MSSQL database name or just the Sage Database ID?

    For Payroll Employee self service to see Paystubs.
  • 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…
  • Sage v5.5 or 5.6 with Windows 7 or Windows 10

    Hi, Anyone running and old Accpac v5.5 or 5.6 with Windows 10 or 7? Or not at all? Best regards
  • Sage 300 and Shopify

    Has anyone integrated Shopify with Sage 300? If yes, would you recommend it?
  • Sage 300 2017 in the cloud

    Any one any comment deploying Sage 300 in the cloud through a vendor of Virtualization? Any recommendation? I though I see an Amazon Web Services recommendation but not sure what vendor can help with that. Thank you
  • Programming Sage 300

    I need to start programming in sage 300. Typically programs that import etc. What software do I need and where can I get a good tutorial on this? I have no starting point.
  • Sage Accpac 5.6

    Good afternoon!! Sorry Sage Accpac 500 ERP version (5.6A) is compatible with Windows 10 ?? Greeting
  • Update Inventory Counts via SDK

    Hi Guys, I am having an issue while updating Inventory Counts in SAGE. I have created the Macro but while processing the Inventory Worksheet, it returns following error: Method Process of the 'lAccPacView' failed Has someone sucessfully updated…

    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…
  • Job Costing Module Not Responding

    Anyone have an idea why my job costing module would not open, it just spins and then says "not responding". All of my other modules work fine, so it doesn't seem like a network or computer issue. This just started happening, it used to work fine.