Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Hello Team, We use the following endpoint to receive Customers from Sage 300: http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers But, if the Customer is deleted in Sage 300, this endpoint doesn't return Customers. How we can receive deleted…
In Sage 300 the Customer has three balances:
But via API Sage 300 returns only the Outstanding A/R Balance. How to receive A/R Pending Balance and Total Outstanding Balance via API?
Hello Team, I found that I can add contacts only at the Customer level in Sage 300. But I cannot find how to add contacts at the Invoice level. Could you clarify, is it possible or not?
Team, Is it possible via API to receive Invoices and Customers statuses? If yes, could you provide the name of the endpoint? Where on UI in Sage 300 I will be able to find the list of Invoices and Customers statuses?
Hello Team, In Sage 300 the Customer has a few balances As I understand, the main Customer Balance is the Total Outstanding Balance . Is it correct? Or we should use as the main Customer Balance this field -> Outstanding A/R Balance ?
Hello Team, Does Sage 300 allow receiving Customer and Invoice notes via API? If yes, could you provide the endpoint on how to receive notes? Thank you!
Hello Team, According to the Sage 300 specification, we can use the following filter 'allpages' For example: http://{ip adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$inlinecount=allpages But, we cannot receive the number of customers in the response…
Hello Team, When I try to call ARCustomers via API using a filter that designated in the Sage 300 specification, I received an error. Example of the request: http://{IP Adress}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$filter=DateLastMaintained le datetime…
Not a normal question for the forum but still related to CRM.
Client is not using SageCrm anymore due to several reasons. We have set the integration to "Suspend all Integration" with CRM in the Sage CRM setup. Now we are having an issue using the Customer…
Hi, I am trying to build a solution that should integrate with Sage 300 cloud to sync customers, projects, work orders, etc...
I have looked around but could not find any documentation about Sage 300 cloud API. Could you please point me to Sage 300…
Client in Canada has an entity that resides in the UK. They received a letter saying that they are 'required' to use MTD (Making Tax Digital) software to file their VAT returns. It seems that Sage 300 Cloud is not on their supported software list. Has…
Hello,
I need to do a customer search using the Sage 300 Web API, but it needs to be case insensitive as some customer names are proper and some are in all caps. According to the OData documentation I should be able to use the tolower function, but…
I'm trying to run the HRMS and Sage Link Automatically by setting it up in the Schedule Profile Configuration and Schedule User Login Configuration under Sage Payroll Link- Sage HRMS Setup. I'm following the steps provided to me in the user guide (attached…
Does anyone knows of a web-based Payables Workflow that is able to process and approve job-related PJC invoices with retainage?
Both Pacific Technologies and Norming's solutions do not handle PJC retainage.
Thanks.
I have created a C# web service suing the Sage 300 objects, and all is working well except when I try to add another line to an existing order I get:
"Order Detail. Attempt to modify a different record than was retrieved."
This occurs on the code…
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 ...
…
Hello,
Is there any method/setting, that can ‘Restrict’ certain Customers (with specific Group code) that are created within Sage 300 from getting into CRM as company record?
I know that if we tick the suspend A/R integration to CRM checkbox from…
Hello,
We have a Sage 300 On Premise (non-cloud) version. We are looking to integrate it with our e-commerce website (PHP). We want to do two-way integration.
1) : From Sage 300 to website Customer invoice, order history, tracking information from…
I am using the Accpac.Advantage dlls to communicate from a third party .net app into Sage 300. The processes we are doing are simply to open a connection and then return various pieces of information from view calls (I use the CS query view through an…
Hi all,
We have an issue where if you log into the Sage 300 web screens and the date is in the correct format (dd/mm/yyyy) due to the fix in the A4W.ini file (adding en-GB in Locale)
When we log into Sage 300 screens through CRM - the date is still…
Client is using Sage CRM 7.3 sp3 and Sage 300 2016. They have started entering Leads for their salespeople and then adding them as a Company but not promoting them to Sage 300 at this point. They are creating quotes for these companies which sets the…
How can we restrict or reserve one LANPAK from one IP address.
We have a web store where we selling items . a customer purchases item on web store and it goes and creates an order and an invoice in sage.. The service is configured to use a sage LANPAK…