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.
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…
After upgrading Sage 300 from 2019 to 2022 Orchid Notes are not working properly on Order Entry. Any notes related to Items will not display in OE, all other notes, like from AR, working fine. Any tips?
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, Could you help me with the following question? I created an Invoice. On UI I see the following balances: The Document Total is $2.55. Amount Due is $2.51
But, when I receive this Invoice from post documents via API, Sage returns the Invoice…
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?