• import csv order entry

    Can someone please help me build a csv for order entry import? I've tried to export an OE Order but it's too large and keep failing. If anyone has a template or a resource or any other guidance I'd really appreciate it. Thanks!
  • Database Setup error after installing Sage 300 2023 PU3

    After installing Sage 300 2023 PU3 I have created 2 new databases and an SQL user as it is explained in the Sage300EnhancedSecurity.pdf document. However, when I log in Database Setup and entered the required fields on the opened Configure Databases pop…
  • Sage ERP Accpac 6.0A export of PO data

    Hello. I'm working on a project where I need to extract the purchase history from the company's Sage Sql database. According to the documentation located at https://sageaom.kcsvar.com/AOM60/POHSTL.xml the TRANSTYPE of 2 is a Purchase Order. I know…
  • 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.
  • Moving Sage 300 2019 Databases only from SQL 2008 R2 to SQL Server 2019

    Hi everyone, We are just moving DBs of some Sage 300 customers to new database servers with SQL Server 2019 (Windows Server 2019). We are not going to upgrade Sage 300 or move applications to new server, just Databases. From SQL Server 2008 R2 to SQL…
  • SQL 2022

    Hi All, Has anyone installed Sage 300 2023 with SQL 2022 yet? Does anyone have it working? I know it isn't in the compatibility guide yet (as of 8th March 2023). I am hoping it is supported in the next Product update or sooner. Regards, Quent…
  • 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…
  • 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…
  • Sage 300 2019 Supports SQL Server 2019?

    Hi everyone, A customer is still running Sage 300 2019 (with SQL Server 2012) and its going to move to Sage 300 2022 in a few months. But before of that its going to invest in a new server and want to upgrade some applications to SQL Server 2019.…
  • Deposit Date from AR Batch is coming from which table?

    Hi all. I am looking for the Column that store the deposit date of AR Receipt Batch. But ARBTA does not have Deposit Date column. Then I go to ARPJH and update the column DATEDEPST (Deposit Date), but the new value does not reflect on the AR Receipt…
  • Deafault loggin users SQL

    We have disabled login user Sa in SSMS and created different user to access Sage 300 databases, Our auditors asked us about the default logging users created when you install SQL. What's the best practice to deal with those users created during SQL installation…
  • 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…
  • Sage freezes sometimes on payment batch list

    Every now and then I have Sage freeze and lock everyone from doing anything. It commonly happens in the payment batch list during heavy usage around month end, but it can happen other times as well. The system during the working day is under heavy usage…
  • REQ's mysteriously being Deleted

    Can anyone think of a reason why random PO Requisitions are randomly getting nuked? I am the only one with a DELETE button so it's not like anyone is able to manual delete them. We created an alert to find them when they are deleted but we just can't…
  • Recommendations for Re-Indexing Sage 300 Databases using Microsoft SQL Server Maintenance Plans

    Are there any best practices or caveats for re-indexing Sage 300 Databases using Microsoft SQL Server's maintenance plans? Thank you in advance for any suggestions!
  • Query for Logged In Users?

    One of our users runs a script in the evening to modify data. Once in awhile, they will receive an error that data is locked by user. I know that we can kick users by going into Help > Current Users, but I was wondering if there is a table containing…
  • Item Number Change crashes

    Changing one item code to another Gets to file 112 (then pauses) of 130 and then crashes out Ran Fixit on IC, OE, PO - no change in behavior Sage300 2022 PU2 SQL Profiler says last batch completed was table APOBLJ changing Resource field if needed…
  • Encounter error during Database load

    Hi all, During a database load, I have encounter this error. No clear message so I don't know what is the cause and how to solve it. Below is the screenshot. Can anyone help me please? Thank you.
  • Database audit product

    Hello, Can someone recommend a product to audit the update process for transactions? We need to know who does modifications. Ty.
  • The Currency Rates was deleted by mistake

    Hi, I'm an IT Manager of my company. My user deleted the Currency Rates by mistake and I already restored the data back to the table (CSCRD). But the Currency Rates still do not show the data that I restored back. How I can fix the screen Currency…
  • Can the SYS DB be a Different Collation Method than the Company DB?

    Sage 300 2021 PU5 - SQL 2016 I think I know the answer to this (no) but can the System DB be a different collation method than the company DB? I ask since a new company is being brought onboard from an old Sage version environment where the company…
  • DBDUMP vs SQL backup / restore

    I'm performing another test upgrade of Sage 300 to a new application and database server. (going from SAGE 2017 to 2022 and SQL2012 to SQL2019) Is there any reason to use DBdump and load to move data to a new server versus just restoring a fresh database…
  • ASERRRPT Error Code

    While uploading a CSV of employees to sage, I got an error code 3.3978.0 I have attached the error report here. I cannot find anything under that error code and the report does not give any direction to fix the issue.
  • Migrate from MS-SQL 2014 to MS-SQL 2019

    My customer is replacing their server which is running Sage 300 relatively current version with MS SQL 2014. As long as we are moving we want to upgrade to MS SQL 2019. The customer purchased MS SQL CALs on subscription from Sage with the original purchase…