Sage 300

Sage 300 Version: 23.1.1.72 I am working on a simple interaction between an Excel spreadsheet that extracts data from specific tables within the Sage 300 database. With my "admin" credentials it works but with a specific user's credentials it fails…

I got login from client pc . This error appeared (cannot access database error 40960 ) .How to fix this?

Our Sage local DB environment was setup in 2017 hosted on a Windows Server 2016. I am attempting to gain access to the data. Currently an active SQL Instance is named SAGESQLGATEWAY and when connected to it, only lists SqlGatewayConfiguration database…

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

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.

Does field: OEORDD.UNITPRICE hold a pre-tax value? If not, is there a field that does?

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…

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…

Upgrading from 2019 to 2022 and for that purpose deploying new virtual server. Server is running Windows 2019 and SQL is running on a separate machine. I am able to convert data but when trying to run SAGE receiving error in OE and IC. PO seems to be…

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…

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

Hi, Does anyone have more specifics in this topic regarding Sage 2022.3 installation and/or setting up? What do we need to do? Buy and install certificate? Just setting ODBC differently? Thank you very much

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…

According to the Sage KB116170 information "In a new implementation like 2023 or in an upgrade where a new DSN using the ODBC Driver 18 for SQL Server to connect, your will require a Server Certificate in place for SQL to connect to the SQL database properly…

Hi, We are in need of an alert on AR cash receipts where customers short pay. We were considering using AROBL and AROBP for this. Are these the best tables for this purpose? Thanks.

I am trying to locate a table from which I could find invoices for all customers that are unpaid.

Hello, We need to pull a list of invoice credits for our auditors. We need the customer key, document number, date and amount. Which tables do we need to use to extract this information? Ty.

Need ODBC consultant to establish / maintain connections to Sage database.

I have a requirement to create a SQL view with a timestamp field for synching purposes. Converting the AUDTDATE to a date is old hat - creating a combined field was not intuitive (for me). After pecking at it for a few days, I have an approach that works…

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…

Hello, We are creating a report of paid AP invoices with the APTCP table. This table does not contain the check number used for the payment. Where can we find that information? Ty.

Hi, Is there a table that contains the latest (current) cost by item/location? We are looking into ICIVAL but it contains all transactions that have been processed for each item. Ty.

Hi, We need to do a mass change in item descriptions. What is the table that contains the items in price lists? Ty.

The error above appeared on one workstation only at a client when posting a Purchase Order. This workstation was fine for several months after the upgrade They were recently upgraded to Sage 300 v2021 PU2. They are also integrated with CRM 2021 if that…

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…