Browse By Tags

Hello, We just upgraded from an older version of MAS 90 / Providex to Sage 2023 100 Premium. It appears that all of the NULL values in our company tables have been converted to empty data, with the exception maybe of the date fields. This is causing…

I am trying to setup Power BI to be able to view data from Sage 50 Canadian Premium. I can access data tables, and specifically tproject using an ODBC connector. dStrExpBal (starting balance) for a project is correct, which is up to and including LAST…

Hello, I am trying to get data about transactions made per account between dates and get information about related documents with transactions. Payable and receivable. So I need Purchase Orders and Sales Orders documents etc. What I know / discovered…

Hi All I have about 42 DB profiles currently in Sage on-prem (Premium license.) I'm trying to add more but seems I have hit a soft limit? Any thoughts on how to overcome?

When using the Sage Estimating Database editor through Remote Desktop / Terminal Server the software is very slow and laggy. When using on our actual office network it does not have this issue. Any ideas why this is happening or how to fix?

Sage 50 is not allowing me to go in new year and shows the message to check the data integrity through Advance database check. While following the message, it shows the message "sage 50 database verification tool has found a problem in your company file…

I've just started supporting a Sage FAS Network install, and am working out how to make cold backups. When I go to the backup utility, I find that we have 20-ish databases, each with only one company. Did my predecessor set things up weird, or is there…

Our business would like to print packing slips before delivery confirmation. In most cases, I can see the lot numbers from screen WK4STD1 but I cannot find the table where that lot is stored. SDELIVERYD seems to only have a lot number for some records…

Hello everyone, I am trying to import items into a database. I have exported them into a CSV file within Sage Estimating, but I can not find out where you can import them. I was trying to merge 2 databases with the database editor, but they have different…

Hi, I am currently trying to work out where the suppliers email address's are stored, if I go to Purchase Ledger > Suppliers List, there is a column here called "Contact Email" and if I double click an entry then click "Account Enquiry" the address…

Unable to connect 2018.1 to existing database in network drive We have a user who has 2017.1 currently installed and needs to upgrade to 2018.1. The new software was installed but we are unable to connect 2018.1 to the existing database. I know it is…

AP_TRANSACTIONS.REF_NO has a 25 character field limit, however the use of this field has been limited in the BusinessVision front end GUI to 10 characters. It appears that this is because the cheque number field in system setup is limited to 10 characters…

Hello, I have a Simply Accounting Premium 2008 version. I have recently added another computer to the network (the 2 computers are connected using an Ethernet cable) and I have access to the company data and back up from the second computer (read/write…

Hi I have restored a client's Sage300People db in SQL (in a new environment) and located the db in Sage300People. However, when I enter my login credentials then the Sage300People application does not accept the credentials. I have ADMIN rights…

Has anyone ever created a Positive File for Sage 50 Quantum version?

Hi all, I store data on tblParameter (in config database) because this data need to be accessed from multiple companies. the problem is, only admin user can access this tblParameter. How can I allow normal user to access (read only) to this tblParameter…

Hi there, hope everyone is well. Quick Question if I may. Is there training or documentation on the SQL table structures and queries for Evolution 200's database? I mean with trail and error and the Database Dictionary one gets to a SQL query that…

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…

Hi all, I was wondering if anyone knew what database fieldname the Status column in AP corresponds to ? Thanks in advance

What kind of database does Sage 50 Accounts UK use for storing data? Is it still a flat file or have they upgraded to Microsoft SQL Server?

Hello Sage Community, I am currently working on an integration project to post transactions into my Sage 300 ERP database via an API. While posting transactions directly from the Sage 300 ERP interface to the GL as a journal entry, everything works correctly…

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…

Hi, City Crew. Hoping someone might be able to shed some light on the Sage 200 database. Specifically, I am trying to find the table/Column (should be binary) that drives the Supplier Transaction indicator (paperclip icon) on whether or not a transaction…

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…

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