Sage 300

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…

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 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 ?

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…

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…

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…

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…