Hi Team, Please, help me with the following question.
Is it possible to create a few Entities or Subsidiaries at the Company level in Sage 300?
For example, I have a company SAMLTD.
In the company SAMLTD, I want to add a few Subsidiaries.
AR1…
Hello Team, In Sage 300, I created the adjustment and allocated it to the invoice. Then, I posted the adjustment. But, I cannot find adjustment by Adjustment Number on the Document Injury page. Also, endpoint ARPostedReceipts doesn't return this adjustment…
Hello Team, Could you clarify does Sage 300 includes the Multi-Currencies feature? I found how to add currencies in Sage 300, but, for example, I cannot change the Customer currency. How I can do it? If I should install the Multi-currencies module, how…
Hello Team, I applied a payment to the Invoice. But inside the Invoice, I cannot see the link to the applied payment. How I can detect inside the Invoice that the Invoice is related to payment?
Hello Team, I need your help with the following question.
I applied a payment for the Invoice, but the Invoice doesn't change the Amount Due. Could you please clarify why Sage 300 doesn't change the amount once the user paid the invoice using a payment…
Hello Team, Could you help me with the following question. I cannot filter Customers by date and time. Example: http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARCustomers?$top=1000&$filter=DateLastMaintained gt 2000-01-01T01:08:35 or DateOfLastActivity…
In Sage 300 when the user creates a Receipt payment, the user can select a few types of payment. For example: Receipt Prepayment What is the difference between these types? I found one difference. If the type is Receipt , the user applies a payment for…
Hello Team, I want to receive the Sage 300 account currency via API. The account currency is CAD. To receive the currency I use the following endpoint - CSCurrencyRates And I expected that Sage 300 should return me one row with the Account currency. But…
Hello Team, Is it possible to receive the Currency ISO-CODE via API? I tried to use the following endpoints: CSCurrencyCodes
CSCurrencyRates But Sage 300 doesn't return the Currency ISO-CODE. Also, I cannot find the Currency ISO-CODE on UI. Could you…
Team, Could you help me with the following question. In Sage 300 the user can create a Refund payment. Thus, I can create an Income payment (receipt) and then refund it using refund payment. What type of documents should this payment be attributed to…
Team, We use the following endpoint to receive adjustments -> http://{BASE_URL}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches What field I can use from the API response as the adjustment unique identifier?
Hello Team, Once I create an Invoice, I can select the following Invoice types: - Retainage Invoice - Retainage Credit Note - Retainage Debit Note In which cases the user should select the following type to create an Invoice? Do these Invoice types influence…
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, 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, 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…
