Browse By Tags

  • 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…
  • 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 a list of payment allocations by payment number using API

    Hi Team, Could you advise on this question. To receive payment or credit memo allocations, Sage 300 API suggests using this API method ARReceiptAndAdjustmentBatches. I tried to use the API method to obtain a list of allocations by payment number. Example…
  • Obtaining invoices PDFs using the API

    Hi Team, Could you advise how to obtain the invoice PDF via API?
  • Obtaining a list of customers using the API

    Hi Team, Could you advise how to obtain a list of Customers via API? Now I use the GET request https://{{HOST}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers('customer_name') But if I should receive a few customers, I should a single request for each Customer…
  • Is the BOI going to stick around for awhile? Is there a better way to communicate with Sage 100

    I've been working with the Sage 100 BOI for some time now and have done a lot of C# applications that interact with the BOI for all sorts of Sage 100 integrations. As we all know the "API" is pretty clunky. I thought about creating a class Library that…
  • Looking for consultant to help in installation of Sage API into our sage 100 2020

    Hi, We are looking for consultant to help in installation of Sage API into our sage 100 2020. Please check below link for understanding: www.sagecity.com/.../getting-started-with-the-sage-100cloud-custom-connector-for-the-microsoft-power-…
  • How to pass data to a CLOB type parameter by API?

    Hi, I have a field of type ACRTF added to a representation and its class. I followed the online documentation, looking for: "How to add a clob text to a representation class". When I test with postman, I have problems with the ACRTF type field. I…
  • Web API OE Order Post - How to approve Order when Credit Limit has been exceeded?

    Hi, I'm currently creating OE Orders using the Web API and have hit an issue where a Customer will exceed the Credit Limit if the Order is created, and so get back the following from the API call: "Credit limit exceeded for customer x. The order will…
  • Sage Pay and Sage X3

    Hi everyone, I have a client that used Sage Pay to process transactions externally to Sage X3. They now want to create these transactions as receipts in Sage X3, have you done this? Looking at the Sage Pay API specs, they only allow the retrieve of…
  • 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…
  • AccpacCOMAPI

    Hi there, I have a client on Sage 300 5.6 and have upgraded them to 2020. There was some legacy code written to connect an external program through the AccpacCOMAPI but it is now broken. Specifically, when I try to run this, it fails when trying to…
  • Integration with SAGE 500 2013

    FormerMember
    FormerMember
    Hello all, First post here. I have a customer who would like to integrate SAGE 500 2013 via API and I wanted to check if it would be possible with the documentation you offer. Thank you!
  • 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?
  • Retrieving all product stock quantities through REST API

    Hello there, I'm attempting to export product and matching quantity data from X3 using the REST API. I am successfully pulling generic product information using the default ITMMASTER representation, however I can't seem to find the representation which…
  • CRM & Sage 300 integration stops working for no reason (reboot to get it to work again)

    cCRM V7.3 / S300 V2014 / SQL 2008 R2 / Win 2008 R2 A couple of times a month the integration between CRM & Sage 300 stops working. We get the message (session could not be opened) with number (2147221230) I have checked the services and IIS and…
  • Payroll Link

    Can anyone point me in the right direction. Client is using Sage HRMS 2014 and 300 ERP 2014. I am setting up Payroll Link and everything is working fine except for the Accruals Tab. I can't see the Accpac Accrual Code/Description fields or the HRMS…
  • an error message when trying to create an employee record in Sage 100 Contractor using the SDK.

    <api:MBXML xmlns:api=" sage100contractor.com/api"> <MBXMLSessionRq> <Company>Sample Company</Company> <User>Angela</User> </MBXMLSessionRq> <MBXMLMsgsRq messageSetID="1" onError="continueOnError"> <EmployeeAddRq requestID="1"> <ObjectRef> <ObjectID> 42…