Sage 300

Good day community, I am trying to retrieve a bank reconciliation report as of November 31, 2023. I am in January 2024 and I am unable to go back to that specific date (November 31, 2023) Is there an alternative way to retrieve this report? My error…

Hi, One of our client is using mailpac NM63A (version PU 2019) and Sage 300 2019 (6.6) (No PU). This client intends to upgrade Sage 300 2019 (No PU) to Sage 300 2023. May I know is it compatible? Where can I find mailpac installer? Many thanks. …

Hi Im getting the below error when i try to post back to the API using postman

In the state of Colorado there is now a Retail Delivery Fee. It is a fixed fee of $.27 per invoice whenever any of the items on an invoice are sales taxable. I have been unable to find a way to accommodate this fee in the Sage 300. Taxes could work except…

I recently joined a company using Sage 300, and I've been trying to get their system working. In the past, they used generic item numbers on purchase orders (i.e. BATHHARDWARE1), so their inventory counts were useless because many items shared the same…

Hello Everyone, I am currently learning Sage 300 2019. I did install all the software and setup the database as seen on the textbook Using Sage 300 by 2017 Christine A. Heaney. After I setup the database in SQL Server Management Studio, for two database…

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 City Fellows, I encountered an intriguing issue but first some background details: I have SAGE 2012 running on a Windows Server 2008 R2 with SQL Server 2008. On a new server which is Azure virtual machine I got Windows Server 2019 Datacenter…

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, 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…

Hello Team, I have some questions about how to integrate currencies from Sage 300. We use the following endpoint: http://{Base_URL}/Sage300WebApi/v1.0/-/SAMLTD/CS/CSCurrencyRates 1. API returns the RateTypes. How they influence of the choice which record…

Hello Team, I want to apply a payment to the Invoice. To do it I use the following endpoint: POST ARPostReceiptsAndAdjustments Example of the request: { "BatchRecordType" : "CA" , "BatchNumber" : 77 , "BatchDate" : "2021-06-27" , "Description…

Our company started using item structures and segment codes around 3 years ago and it is simply not working for the type of business we do. Currently we use the hyphen as a segment separator. We would like to go back to using the vendors item number as…

after v2019, pu7, unable to print w2, get error, no specifed records found.

Hello Experts, Facing the below error while accessing the ACCPAC API. System.AccessViolationException at AccpacCOMSVR.AccpacSvrViewClass.Process() at ACCPAC.Advantage.Server.View.Process(FieldValue[], Int32[]) We have a .Net based windows service…