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…

Hello, Can someone recommend a product to audit the update process for transactions? We need to know who does modifications. Ty.

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…

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…

Hi All. I have error when i want connect new PC from sql. Cannot Access Database 49153, it means the PC cannot read the sql server. No issued with another PC, only problem from this PC. But if i create ODBC, connection is sucsessfull, and change…

Hi, Everyone How Can I check or clarify SQL server is runtime edition version. Please help me. Thank you so much

Hello, I am new to the forum and need some help. Please where can I find the Sage 300 2104 data dictionary?

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…

A data dump was made and restored on Sage 300 ERP. At the point of opening sage the below error message were gotten with the list of modules which are already installed. sage 300 has detected module update inconsistencies that requires activation. The…

Hi When I imported one transaction to see how reconciliation works, i got the below error. It says 1 updated but It does not reconcile that transaction, please could someone throw some light ?

Hi, I want to import bank statements into Sage 300 - I am not sure what the below fields do and what their exact column name would be for my import file. Could someone please help ? Cleared Y/N - Integer (Column Name ?) Used Y/N - Boolean (Column…

Hello there I have noticed that for a given invoice in my SalesHistory table (OESHDT) the QtySold=110. But then when I go to my PostingJournal (OEAUDD) for that invoice I only have a QtyShipped = 98. So am I correct in thinking: 1. When I sell something…

Good afternoon, I'd really appreciate it if someone who knows the Sage300 database well could help me on this. If you look at the screenshot below, I'm trying to find the database table where my accounts could possibly map to the ORANGE "Account Type…

Hi, I am getting the below error message when i try and Import transactions into Costs under the PJC transactions. The Error mentions PM0420 which either has to do with Document Number or Line Number, but I am not able to resolve this error - Could…

Hi, Is Sage 300 ERP 2014 version supported in SQL 2019? Currently 2014 SQL is in use. As per the compatibility guide we cant get this details. Before upgrading SQL from 2014 to 2019 version we need to confirm client if it will work without any issues…

Is anyone using Power Bi to access and display data from the SQL replicator DB? Thanks! Patty

Objective: Reduce recovery point objective in case of a server failure to within 1 or 2 hours. Has anyone been successful at doing backups more frequently than once a day? for example, VM snapshots, or other SQL backups ? every hour for instance?…

Hello guys, I'm trying to create a new database in sage 300 demo away form the sample companies provided in the demo, is it possible to create a new DB.and modify my own setup away from the sample data in sage 300 erp demo and how.... Thanks

We were thinking to move our DB to SQL 2019. We ran the SQL migration assistant to check for compatibility issues from coming from 2008. We got one note back from the tool on the DATADICT table with column TABLEDATA type 'image' Anyone know how we…

We are implementing Sage 300 ERP on premises. Due to current situation, implementation taking longer than planned. The simple question is, how can we migrate current FY data back to January from our legacy Peachtree Quantum system to sage 300? Comments…

Good day all. Today, when I was trying to troubleshoot an issue with a vendorcode in Sage300 2019, I noticed that the audittime for this record in the APVEN table was not correct. I made a small change to the vendor's name, and noticed the differenc…

I never used update statistics as a part of the SQL Server maintenance and wondering is there any benefit from running it?

Hello Smart people! The last company I worked for used to have Sage100. I did an Saved an Excel query and I know that with Sage 100 the data base connection's name is SOMATAMAS90... What is the name of the database to connect with Sage 300? Thank…

Dear, I am facing a problem in sage 300, I already have two companies in sage 300, but when I open a new company one old one company disconnected from data base, now my old company doesn't show any thing, but in sql server all data is avail able. kindly…

Following on from my previous question and rather obvious answer... is there a massive ERD showing the relationships between all the tables in the Sage 300 DB? Many thanks