Sage 300

Hello Team, We use the following endpoint to receive Invoices - http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARInvoiceBatches But, Sage 300 API doesn't return the Invoice unique identifier. Invoice Batch is not unique due to combining a few invoices…

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, Sage 300 API returns the following fields for TAX: "TaxGroup" : "AGST" , "TaxRegistrationNumber1" : "" , "TaxRegistrationNumber2" : "" , "TaxRegistrationNumber3" : "" , "TaxRegistrationNumber4" : "" , "TaxRegistrationNumber5…

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, Is it possible to export the Invoice in PDF format from Sage 300? If yes, could you provide an example of how to do it? Also, is it possible to receive the Invoice PDF via API from Sage 300?

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…

Can anyone confirm if a Sage 300 user has to be available to view Order Inquiries in Sage CRM? We are encountering an issue where the company does regularly reach their total number of users in Sage 300. It seems that when they do, if a CRM user goes…

Hi guys, I have an issue where I have created an actual vs budgeted financial report in Sage Intelligence however my actual figure is different from what is in the GL when I run the GL transaction listing. How can I fix this or where can I see where…

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…

Dear All, I am unable to do multi select option in all the list box fields in sage crm, this is happened only after installting the sage 300 2019 integration setup. Sage CRM ver 2018 R3. Please refer to the bleow url which is from sage CRM Community…

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…

Questions: 1. Where can we found exactly information about ACCPAC.Advantage > .Init session parameters, their sources and properly case usages? 2. Do [.Init] session parameters affect anything (for example, when reading data)? * eg invalid [programName…

I am having Sage 500 ERP and ACDEV POS integrated with this and working fine. Now I have newer version Sage 300, 2016. Now how can integrate my ACDEV POS with Sage 300

Three related questions regarding Sage 300 2012 and Sage CRM 7.1: 1. When we implemented Sage CRM, we imported all of our Sage 300 customers into CRM. For about six months, some of the Sage 300 users didn't have the Integration piece up and running…

Hi, Does anyone have any recommendations for Online Portal and/or Ecommerce Integration with Sage 300? Requirements: 1. It must integrate with Sage 300. 2. Integrate with Ariba and Ariett 3. Be able to take Credit Card Payments 4. Be able…

Suddenly received error listed below. No changes made to ACCPAC, CRM or servers. CRM installed on separate server 2003R2. ACCPAC 6.0 on 2003 enterprise. Any idea how to fix error? Error Opening the Sage Accpac Company TEST. Name='Error' Message='…

Dear all i wrote a macro in order entry module the macro doing order entry and ship all when post the OE transaction in Macro its make OE, invoice and shipment automatically but the problem sometimes its make order entry only i must restart the server…

i have the below Exception please any help ????