Browse By Tags

  • Sage 300 People Api Fields not Recognized

    Hi Ive just started a project for a people integration but whenever im trying to create or edit employee data i get the error that fields are mandatory but i already supply those fields and make sure they are not empty, { "success": false, "businessRules…
  • 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…
  • Obtaining invoices PDFs using the API

    Hi Team, Could you advise how to obtain the invoice PDF via API?
  • 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 ?
  • Use ACCPAC.Advantage Browse Order's Detail Record?

    Could someone please post a sample C# code for iterating the detail records ("OE0500") for a specific order? Stephen Smith has instructions to "Set detail key into the detail view." - but not sure how to interpret this. After composing my views, I…
  • Unable to send Test email from Company Profile under Common Services.

    Please i need assistant on the Subject above.I have entered all emailing credentials in the Company Profile under Common services in Sage300 to send a test message.It fails ,when ever i tried.Please i need urgent help,kindly find below screenshot of the…
  • Is is possible to add new column to standard table?

    Is is possible to add new column to standard table like OEORDD? I'm converting the old system to c# and noticed that there are two new columns on OEORDD table based from this site: http://sageaom.kcsvar.com/AOM2019/OE0500.xml New columns named: PDTLNUM…
  • COMAPI for CRM-300 integration. Do these shipped files still work?

    I am looking at the COMAPI for Sage 300 and am impressed that it can do things the web API cannot, such as create an invoice. I notice the COMAPI is configured with the standard integration setup files found at https://support.na.sage.com/selfservice…
  • How to make Web API AR Invoice Batches post-able?

    Am using the Sage300 Web API for the first time. We can create invoices via AR/ARInvoiceBatches, but they end up with a BatchStatus of "Open" and cannot be posted by the /AR/ARPostInvoices('$process') service. It seems the /AR/ARPostInvoices('$process…
  • Issue sending AP/AR Adjustments using SAGE300WebAPI calls ARReceiptAndAdjustmentBatches/APPaymentAndAdjustmentBatches

    I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…
  • API endpoints

    Hi, I am trying to fetch product prices and product inventory, but couldn't find any which does the job. So, can you suggest me the suitable endpoints to fetch Item price and Item inventory?
  • 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…