Browse By Tags

Is there no field on the sale order tables that displays the total value of the line? I see the field on the line but I cannot find in either the SORDERQ / SORDERP tables. As is now I do a calculation on reports to get the value but wondering if I'm just…

I am currently running Sage Paperless on SQL 2014 ver 12.0.2269.0 (released 7/14/2015). My internal vulnerability scans have flagged this version as unsupported and it likely contains several security vulnerabilities. What is the process for updating…

2019 Advanced - Sales order history detail has extended into a second partition and MS Access now gets the message "Cannot open Database" when trying to link or import the table. It may not be a database that your application recognizes, or the file…

Does Sage prevent creating one vendor with multiple accounts if you enter a duplicate EIN number? I have two companies that have the same name except one is an LLC at the end and one is an INC. They are two different companies, but it brought up the importance…

I'm trying to setup a new Database and License server for our Sage 100 Contractor, I need to test the new server to make sure we can use it on our network but I'm stomped. I Deauthorized the old License server (showed 2 seats) and stopped the Sage Hosting…

In Vendor Pricing Maint. there is field called "Pricing Method" What table is this field in and what is the field name under the covers? Thanks

I'm having an issue with Timeslips 2018. The Firebird server is installed on the same desktop as Timeslips 2018. Typical scenario where "it was working fine yesterday". Error happens when opening a database. I select my "MAIN.FDB" database and the error…

Does anyone know how I can get the Data Dictionary for VM (Service Manager)?

Edit: A subfolder for current employees was added in 2021, which must be connected to why termed employees prior to 2021 no longer have an employee photo in HRMS. Any advice on how to correct this issue so that we don't have go through each termed employee…

Where can I find a listing of all the SQL Tables & their definitions? I use to use this website: http://sageaom.kcsvar.com/AOM2012/Advantage.xml . But, now the site seems to be down. Thanks in advance for your help. -Kartik

After upgrading Sage Business Vision to version 2023 and the subsequent database update from Pervasive V10 to Actian V15, Issues have arisen which affect querying the GL_TRANSACTIONS table. I am currently in contact with both Actian Support and Sage Customer…

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…

hello i had those errors Unexpected Error: An unexpected problem has occurred. Please try again or contact your administrator for assistance. Unexpected Error: Error HRESULT E_FAIL has been returned from a call to a COM component. when i try to…

What is the link between the OESalesOrder table and OELineItem. I'm pulling the data via ODBC and trying to identify the key between the two tables. Any insight or documentation you can direct me towards would be greatly appreciated! (BW 2019)

Posting this to help others in the same situation. The client system had a 3rd party modification to their SQL databases (by FYISoft / Renovo), adding table level SQL triggers that became broken with the migration (since the new SQL instance didn't have…

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…

I am looking for a consultant that can support a client with some data cleanup and tweaks for Sage 50 Quantum. Any help would be greatly appreciated and they would be looking for someone A.S.A.P.

Hello, I'm wondering where i can acquire the latest version of the "BusinessVision Database Structure Reference.chm" help document. The latest I have appears to be from 2018 and it references database fields that no longer exist. In system setup …

We recently moved the Sage database from one server to a newer one and did the drive mappings using DFS. After this the users could not connect to the Connection manager. If we mapped the drives directly to the new server it worked fine. Is there…

We currently have Timeslips 2020 and it's installed on my computer as the "SERVER". Opens and runs perfectly for me without any errors. I am the primary billing person so I use the full version. My boss' workstation has both options full version or Minitimeslips…

Good Day Can anyone tell me why in Sage Data Base editor there a green check mark beside the database file, see below. And how do we remove it ? Using SQL 21.1 Thank you for any answer

When I enter contract values in Job Central and then click 'Finish' I get the attached error. I'm unable to save any changes. Please advise. I'm on Windows 11 if that matters.

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

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…

A general and important question When you insert a item into the estimate from the database the change date is the current date. What I want to know can a column for the data base change date be visible in the estimate file. This would make it easier…