• Unable to add 6th Company Database in Sage 300 2022 Advanced Edition Database Setup

    Hi friends, I have a strange issue at a site operating Sage 300 2022 Advanced with Product Update 7 installed. I am receiving the "Cannot create the database profile." error when attempting to add a 6th company database into Database Setup - irrespective…
  • Emailing 1000's of invoices out or Sage in error

    I had a customer that wanted to email out invoice in Sage 300 but before she selected the range of invoices, she selected delivery method of customer and clicked print. OOOHHH NNNOOO!! Panic!!. over 4000 invoices were going to either be printed or emailed…
  • HOW TO GENERATE A PREVIOUS BANK RECONCILIATION REPORT?

    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…
  • List of Open Batches VIA WEB API

    Hi Is it possible to get a list of Open AR Invoice Batches via WEB API\ Or provide an endpoint through which we can query to find list of open AR Invoices batches in Sage 300 Regards
  • Web API Bug in POReceipts with Additional Costs

    While the new ability to add a PO Receipt referencing an existing PO is a long awaited for feature of the Web API, the 2023 release has a bug that makes it impossible for us to use this feature. PO Receipts with additional costs incorrectly assigns…
  • Sage 300 crashes on company when sql database was restored from production to test

    We restored a backup of one of our companies to test and now when we enter sage login info it just crashes with no error. Other companies work so it has to be the database but it is the same as in production. I change the database setup to go straight…
  • Receiving Multiple Contacts via API

    Hi Team, Could you provide the endpoint to receive multiple contacts via API from Sage 300? I used this documentation https://cdn.na.sage.com/docs/en/customer/300erp/2017/open/Sage300_WebAPI_EndpointReference.pdf and didn't find the endpoint.
  • Sage 300 Web screen - Password change no prompt or warning displayed on web screens.

    The user password for our Sage users (Sage 300 web screens 2023 advance security) has expired. On the desktop version, there is a prompt to change your password; however, there is no prompt or warning displayed on web screens. Is there a different way…
  • Sage300 Node js API

    Hello, we built a web Point of sales app and we want to integrate some api from sage300 (sales api, inventory, customer info api). we only want some of our api to integrate with sage300. please how do i start ?
  • How to reverse an AR Refund Entry that do not have Bank Code?

    Hi All, I posted an AR Refund Entry that is using Cash Payment, No Bank Code, use Cash Account instead. It does not have a Bank Code so I cannot use the Reverse Transaction from Bank Transaction. Any other way to reverse this refund? Thank …
  • sage 300 2022 product update 4

    Hi Everyone, Does anyone has Sage 300 2022 Product Update 4 release notes or what's new in release ? Your response will be greatly appreciated.
  • Deactivating tax authorities

    Hi everyone, I started using an AP automotation software by Beanworks which is tied to our Sage 300 system. When I view our tax authorities within the Beanworks environment, it shows some tax authorities as inactive but when I go to the tax authorities…
  • Lot number and Serial Number in IC not found

    Hi all, On a Server, we have install a Sage 300, and have the Serialized Inventory and Lot Tracking 2022 checked during the installation. However, the module does not appears on the License manager or data activation. Please guide be how to solve…
  • SAGE 300 Web API | EFT Customer

    Hello, I have a customer that has the SAGE 300 Web API setup. One of the requirements from the customer is to get data from a web form and update the AR Customer and also update the EFT Customer. I wanted to do everything via Web API but apparently…
  • Financial Statements fails to open in MS Office 2019 Pro Plus

    Hi everyone, Does anyone know a solution to this error when running G/L Financial Reporter to Print Financial Statements? We are using Sage 300 2022 and 32-bit MS Office 2019 Pro Plus on 64-bit Windows 10 Pro. I've enabled all macros and did a repair…
  • SAGE 300 TEMPLATE FOR AP INVOICES AND BATCH

    Does someone have a template that I can use for importing invoices into SAGE 300 AP using Excel? I tried an export but the arrangement of the output doesn't make sense for a template. Also, I cannot locate the function to import. So I am not sure that…
  • Extending Demo Access

    I have a sage 300 I'm using locally for just testing. Is there a way to extend the demo license?
  • Idle time out in Sage 300

    Is there a way in which Sage 300 ERP can log out users after a period of inactivity? If there is kindly assist.
  • BUDGET ON OPTIONAL FIELDS

    As per my understanding Sage 300 budget linked to Account code (on GL). How can I handle objective based budget? Objectives are like optional fields: Eg: Acccount 1010 : Allowances Objective 1: budget $100k Objective 2: budget $200k
  • System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component. at AccpacCOMAPI.IAccpacSession.GetPrintSetup(String menuID, String ProgramID)

    accpacPrintSetup = accpacSession.GetPrintSetup(" "," "); on reaching this line application crashed
  • Refund payments

    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…
  • How to receive the adjustment unique identifier

    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?
  • Invoices Type -> Retainage Invoice, Retainage Credit Note, Retainage Debit Note.

    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…
  • Invoice close date

    Hello Team, Does Invoice have the Invoice close date? If yes, what is the name of this field on UI? And what is the name of this field in the response for method ARInvoiceBatches?
  • MISC PAYMENT IMPORTATION DUPLICATE AMOUNT

    Am trying to import misc payment in AP Payment batch but all misc payment amount is duplicated Am using Sage 300 Standard 2020 PU 5