• 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
  • How To Export a Single Transfer in Inventory Control and Re-Import Using different Items

    I have been trying to transfer items from one location to another but every time I try, I receive an error with the importation. What I did was try to export a single transfer, however, it exported everything even the ones that are posted from way…
  • Exporting GL transactions gives error "External table is not in expected format"

    We have Sage 300 2020 running on a Windows RDS server with multiple users accessing the application via RemoteApp programs. Everything has been running fine for a couple of years but randomly last month our users cannot export files any more. A user…
  • 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.
  • 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…
  • 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…
  • Find Sage 300 table and field

    I’m trying to determine what table & field name lies behind the field in the yellow box below? Looks like I’ve got to drive some conditional logic with it for a report, but I can’t find it in the database. You get to it by clicking the Item/Tax button…
  • Missing Orders in Quantity on S/O drill down in Location Details

    Hi, We are experiencing an odd situation. When in location details and drilling down on the quantity on S/O we are missing orders. It shows the correct quantity but you are unable to see the list of orders. -Customers allow backorders, are not on…
  • 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
  • RECSTATUS column in BKTRANH

    Hi All, In my table, there is value 3, 4, 5 in RECSTATUS column for BKTRANH table. But there is no entries for 3, 4, 5 in AOM. Can anyone help me on what is the RECSTATUS value for 3, 4, 5 in BKTRANH? Thanks.
  • Sage 300 Database on Azure SQL

    Hi everyone. I'm hoping someone here can answer this, rather than having to jump into the support gauntlet. I work for an IT firm and a client of ours is presently running Sage 300 on a server VM, connecting to an MS SQL database on another VM, which…
  • Sage Intelligence support MS-SQL password length?

    Would you kindly let me know the Max. Length of SQL password Sage Intelligence Acceptable? My customer change SQL Password to 64bits length… After change, all Sage300 feature works fine but only Sage Intelligence caused password invalid.
  • cannot create new System database on Sage 300 v 2023

    Hi all, On my Sage 300 v2023 > Database Setup, I have 2 existing System databases for testing, which is PCISYS and SAMSYS below. I wanted to create another 1 but get this error instead. I have run RVSpy & DBSpy but no error visible. Anyone know…
  • Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name. Now I want to add some fields to it that are not in the set of data tables already in the report. In the "Field Explorer" I right…
  • Any issue with other app databases in same instance as Sage?

    A customer has a third party quoting and bidding software running with SQL Express. They want to move it into the same instance in standard SQL as Sage300 to allow more memory availability. Any issue with this or would a separate instance in standard…
  • Failed to import the ActiveX control. Please ensure it is properly registered.

    Hi all, We are having an issue while adding a SAGE300 component into a Visual Studio form (.NET project). The error we received is: Failed to import the ActiveX control. Please ensure it is properly registered. We have registered the accpacic1500…
  • Payment Batch

    Hello, Could some one please advise where the description would be stored on the sql server please ? Which table would it be under as I am not able to find it. Thank you - Shashank
  • Banking Details Table

    Hello, Could someone please tell me where to find the banking details for a customer - the APVNR table gives the name, REMIT and the address but not banking. I checked the ELVEND and the EFLTLOG files to find the banking details but could not. I have…
  • Database dump fail

    Hi there, I am trying to perform Database Dump but always get the following error message. Then, if I perform database verification, it returns this. Could I know how to fix this issue to be able to dump database? Thank you!
  • Payment Batch Import Into Sage 300

    Hi, Could someone please share what fields are necessary to do a payment import into Sage 300. It keeps giving me the error that 'Invoice Number Cannot Be Blank' but the IDINVC field in the Applied_payments tab is not blank. Could someone share…
  • Are ICPRIC and ICCPUR accessible via the Sage API?

    Are ICPRIC and ICCPUR accessible via the Sage API? If not, is there any other way to access Price Lists, other than by direct SQL Query or middleware such as Realisable IMAN?
  • Finding the best date to use for when an record was last modified

    I have a sync app running and it's exporting out from Sage: Orders, Shipments, Customers, Inventory, and Credit Notes. I want to only grab the records that have changed since the last time I ran the sync. For some of these it seems I can grab the DATELASTMN…
  • Activating Payroll Modules - Historical Data for 3 companies in Sage 300 going back 12 years to current

    As a system administrator, but not familiar with the app Sage 300 app. I wish to activate the Payroll Module for three “Historical Data” companies in Sage 300. Need this in order to access payroll information from 2009-Current Just wish to know how…
  • 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) ------…
  • Job related PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found."

    Project and Job Costing (Job related) PO Receipts getting the error "Damaged data. Receipt. Table PORCPH1 not found.". All other PO receipts have no issues. Please help us to solve this issue. Our Version is Sage 300 ERP 2019 and Database is Sql server…