• Sage 300 2024 w/PU1 Sage 300 Cannot Connect to Signon Manager - Resolution

    Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…
  • I upgraded from 2023 to 2024 SAGE 300 but when I tried to login on the web screen, it gave me below error

    when i try to logging via http locally, any help please
  • Order Confirmation Creation Time

    Where can I find the time an order was created? I can only seem to find the day in the ORDDATE field in the OEORDH table. Does Sage store this somewhere in the database tables? Thank you
  • Vault and Store changes

    When making changes to a production system such as updating SQL passwords, changing SQL servers, or using a different SQL account, how do we get to the edit screen for the Vault and Store databases configurations? Alternatively, is there a way to make…
  • Unable to complete Database Load - Error 59104

    Hi all, I keep on encountering the error below while trying to do my database setup on Sage 7.0 Can anyone help with this please? Thank you.
  • Error message via API - Property 'ReceiptsAdjustments' on type 'Sage.CA.SBS.ERP.Sage300.AR.WebApi.Models.ReceiptAndAdjustmentBatch' is not a navigation property. Only navigation properties can be expanded.

    Team, I need your help. I would like to use the following request to receive payment: {{BASE_URL}}/Sage300WebApi/v1.0/-/SAMLTD/AR/ARReceiptAndAdjustmentBatches?$expand=ReceiptsAdjustments($filter=DocumentNumber eq 'PY00000000000000000133') But Sage 300…
  • Running Sage 300 (2019) off cloud paging. Error=100 during Database Loading

    Hello all, I've come across an issue that I can't seem to find a solution for. My PC at home is Windows 11, all drivers and OS is fully updated. Even have a 64bit adobe reader installed as per another post similar to this. I'm a student, using cloudpaging…
  • Where to find Journal Entry Balances

    Hello Sage Community, I am currently working on an integration project to post transactions into my Sage 300 ERP database via an API. While posting transactions directly from the Sage 300 ERP interface to the GL as a journal entry, everything works correctly…
  • Where to Find General Ledger Account Balances in Sage 300 ERP?

    Hi Sage City community, I am currently working with Sage 300 ERP 2023 and trying to access general ledger account balances programmatically. I need to retrieve this data for a custom integration that I am doing. Could anyone guide me on which specific…
  • CANNOT ACTIVATE COMMON SERVICE DATA - SAGE 300 2023 PU1

    I have active companies on this version, but I want to activate new company profile. I got an error The user Input E-mail Password cannot be blank.
  • Sage 300 Order entry CSV file import

    Is it possible to import updated unit price in order details using excel file, I import data using excel but unit price can't be updated , it automatically pick the price from the finder.
  • Sage 300 - Database is locked

    Hi I installed Sage 300 ERP software on a client machine. The installation is complete and successful. But when I run the sage software, this error message "Database is locked". The client is a windows 10 64 bit. I need your help ? THANKS
  • Multiple Outgoing Email Accounts

    Hi We are getting more inquiries about setting up multiple outgoing email accounts per document type. Eg Email order confirmations from [email protected] Email invoices and statements from [email protected] Just wondering if…
  • Tables and Fields for Manufacturing

    I cannot find the Tables names and field description for the Manufacturing module in Sage300. Anyone knows where to get it Something similar to this Thanks
  • Adding a large amount of new inventory

    We are adding a large number of new products to our Inventory Master list which requires new part numbers, adding each part to the Pricing list, entering the quantities for each part and its location. What is the most efficient method to add this information…
  • Performance on Windows Server 2019 vs Windows Server 2016

    Ever since 2019 version of Sage 300 ERP I have to run application servers on Windows 2016 because Sage is running much slower on Windows 2019, plus we experiencing frequent application hang in 2019. Did anybody else noticed same thing? For example it…
  • AATRIX errors: AatrisForms.exe - Entry Point Not Found after tax update and product updates

    I am getting the following error when trying to run any government report: The procedure entry point ?selectNodes@CAXMLNode@@QAE?$shared-ptr@VXCAMLNodeList@@std@@PBD_N@Z could not be located in the dynamic link library d:\Sage Accpac\Taxfiling\aatrixforms…
  • After upgrade from 2021 to 2023 I got Error HRESULT E_FAIL has been returned from a call to a COM component.

    After upgrading sage from 2021 to 2023 I got error Error HRESULT E_FAIL has been returned from a call to a COM component on accessing web screen. What would be the reason of this and solution ?
  • cannot access database (error=40960) sage 300 2020

    Hi, i am experiencing error 40960 when i tried to login into sage 300 database on 3 separate workstations while other two workstations connected successfully. I have checked the DSN, redirected it and ensure everything is right BUT the issue still persist…
  • Does sage Sage 300API allows concurrent post requests?

    Am trying to send post request to sage API concurrently where by many requests are sent at once. I got an error 'Record Conflict {en-us I/C Options. Record has been modified by another program' and debug .Net debug pop up Everything work fine…
  • Querying SQL server Invoices vs Sales History discrepancy

    I am trying to validate some data for our team and am stuck trying understand the data layout. My boss is using stonefield reports to generate a monthly sales report and he has 2 versions generating different #s. There seems to be confusion on what date…
  • German Accounting - DATEV

    Hello All~ I was wondering if anyone is exporting out of DATEV and importing into SAGE 300. We use SAGE 300 is our ERP system and are merging with a German company who uses DATEV and will remain using DATEV for a myriad of reasons. I would like to export…
  • Sage 300 Web screens - You do not have a license to use this product. Ask your system administrator for help.

    Hi I have a client who is running Sage 2018 Pu 2 windows server 2019 I have installed the web screens, and run the portal. As soon as I access the web screens I get this. I can confirm the web licence is activated. I am wondering if the…
  • ERROR CODE: -2147417848

    Hi All, I did an AP vendor number change. I now receive this error 2147417848 Automation error The object invoked has disconnected from its clients. How do I fix this as we no longer can access this vendor? I did a AP vendor number chan…
  • Database error (operation=REV-POST, error=229)

    We are using AccPacc to work with Sage 300. When we call View.Insert the error message appeared: ------------------------------------------------------------------------ Timecard Detail. Database error (operation=REV-POST, error=229) ------…