• Optional Field Values

    I had set up some optional field values in common services that contained an apostrophe and realized it created issues. I inserted new values but now cannot delete the old ones. The old values are not used or linked to any items. I don't get an error…
  • Sever Backup software for Sage 300 Advance 2021

    Dear All Expert Please advise on the choice of Server 2016 backup software for Sage 300 advance 2021. Many Thanks. Peter
  • 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…
  • Webscreen | Unable to post batch locked by another user

    The client utilizes Sage300 version 2024. The clerk initiates the entry, and another level of authorization is required for posting. Users have encountered difficulties in posting batches because they are locked by another user. Even after the user…
  • Sage 300 SDK

    Hello, I am very new to development with Sage 300 and using the SDK -- in fact I have not started yet, but before I get started I would like to ask a question. First off, I need to clarify that I'm talking about a version of Sage 300 installed on a server…
  • Sage 300 GL Posting with Withholding Tax and Net Payable Adjustment

    How can we achieve the following task: A supplier invoice of $115, with a withholding tax of $15. The objective is to ensure that when posted to the General Ledger (GL), the $115 reflects in the expense account, while also accounting for the fact that…
  • AP Check printing with missing alpha text.

    AP Check printing with missing alpha text. Noticed after upgrades to 2023PU1 and 2024PU1.
  • WebAPI - POReceipts cannot attach to existing PO

    Hi, has anyone here using Sage300 WebAPI managed to create a POReceipt that attaches to a PO? I've seen reports of this not working that are some years old, perhaps this has never been fixed? Including PurchaseOrderNumber / PurchaseOrderSequenceKey…
  • Doing a test and live conversion in Version 2024 and 2023 PU2 and higher

    Before the security enhancements in version 2024 and 2023 PU2, when we do a test conversion to a new Server, I will load the SQL databases and copy the shared data folders to the new server, install the new Sage, run database activation and do the testing…
  • Sage300 Item Pricing Query

    Is it possible to setup pricing with Sage where there would be a discount based on the quantity. We are looking for a way for this to be done in Sage: to setup pricing for the first item to be free and then the next item a price needs to be paid.
  • CPP2 calculating early

    I understand that CPP2 isn't supposed to kick in until the regular maximum is reached, but I have a case where it has already starting taking CPP2 for an employee even though it's only February and he only has ~$12,000 in earnings so far. Other employees…
  • 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
  • New features of Sage300 Canadian Payroll Version 8.0?

    Is there a document that details the new features of Sage300 Canadian Payroll Version 8.0? Or is there a document that shows the differences for Sage 300 Canadian Payroll version 7.3 versus version 8.0?
  • Vendor Search Grid Blank

    I have a single user with an issue in a single company (all other users and all other companies for affected user are OK). The user opens the Vendor lookup and then users the search for a vendor - the subsequent search window with the expected list of…
  • ADDING A CUSTOMER RECORD

    We have just upgraded our client Sage 300 to Version 2022 and we have run update 4. When adding a customer, we are getting the message - Description: Internal error. Customer. Operation not allowed. Has anyone encountered this error? All responses…
  • Setting up Multiple Sage300 Taxes

    I'm seeking a solution for the tax calculation outlined below. Within Sage 300, how can we configure the system to perform the following calculation: Gross amount: $100.00 - T1 @ 5%: $5.00 - T2 @ 2.5%: $2.50 - T3 @ 2.5%: $2.50 - T4 @ 1%: $1.00 Subtotal…
  • Error on Opening the xla macro

    Hi, We have encountered an issue whereby we are receiving the following error messages: 1. PrintReport: Error on opening the xla macro 2. Problem is found in running Financial Reporter Addin We do not have application support in-house and have…
  • Sage 300 Month End Procedures

    Does anyone have a month-end procedure that they follow in Sage 300? Reconciling accounts payable to the balance sheet, etc? I'm looking for something to have everyone follow to ensure that everything is entered correctly.
  • What are the differences between Sage300 and Sage300 CRE

    We have a working integration with clients who use sage300 CRE, but got a request for integration with sage300 which is a separate product. What are the differences between the two? Also, does anyone know what the technical differences are between…
  • How to Disable Notes Popup in Sage300 A/P

    We do not use the Notes popup box that appears every time we look up a vendor. Is there a way to disable this popup box from appearing (either globally or by user)?
  • Transaction Limitations

    Just wondering if anyone has any client that is processing about 10 million transactions per year. We have a client that wants to do that, using iMan to integrate with a huge insurance system. Any responses are appreciated. Thanks
  • Sage300 Web API not returning closed orders

    We are writing an integration with Sage300, and for some reason, the `OEOrders` endpoint does not return closed orders (I assume by default, it excludes closed orders). There is no documentation for to include them either anywhere. Does anyone know how…
  • 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…