Browse By Tags

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

Brand new install of Sage 300 2024 and PU1 on 2019 Server and 2019 SQL Server - not new workstations. Always have problems with the same 2 out of 6 workstations (all within 1-4yo) when it comes to Sage 300 workstation installs. I'm putting this out here…

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

This weekend i upgraded our systems from BW 2021sp14 to BW 2023 sp2. But how long did it take? My system is network of 15 desktops running Win 10 and Win11, on Server 2016 ( Dell T550 with RAIDed SSD drives ) all gigabit network connections Our…

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…

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

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

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…

Hello, We are purchasing new hardware to replace our outdated server. Does anyone know if the latest version of Sage 500 will be compatible with SQL Server 2022. I like to believe that there won't be any issues but you never know. Has anyone been running…

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…

I have a Synology DS220+ which I would like to use as a file server and store the live Sage data files as well. Is it possible to store the company files on a NAS (Network Attach Storage) device and access such files normally from a computer with the…

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, I want to read and write data in sage100 database, so after some research I found out this course for reference. But just need to validate that is this course really guides on how to read and write back data to Sage100 database or not? This…

I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

As seen in the subject, I am looking to join the STOJOU table to the SINVOICED table without the use of the ITMREF column. Data models show a one way arrow from STOJOU to SINVOICED with VCRNUM;VCRLIN. I am unsure of what to do with that, with VCRNUM only…

Hello, There is error message on the Sage100 as shown below. How to fix the error? Thank you in advance for your help!

We are working with a company using Sage 300 on a Pervasive SQL database. They are interested in exporting data such as GL, AR, and AP transactions and other table information, such as accounts, customers, and vendors. I'd like to know if there are…

the following error message appeared unprovoked today: firebird database error cannot attach to password database class: EIBNativeException code: 335544653 i can't even open the database. the minute i double click the icon, the error appears…

Please I cannot start my Simply Accounting Set up. It keep telling me cannot connect to Connection Manager. What should I do. Will Need an URGENT ASSISTANCE

Has anyone had experience with archiving the PO module? According to KB articles, moving POs and COs to history is the first step in improving performance in the PO module. Clean out all those old records. I have done this in a test environment and can…

Sage 2019 on Windows 10 32 or 64 Bit - having issues running accpac (not as administartor) - not even getting a Sage accpac login screen the splashscreen comes up and then disappears. Does not work in Win7 Comaptibility mode unless you are troubleshooting…

can any one help i had to update my sage accounts 50 because i moved my computer and all of a sudden the sage couldnt recognise the computer. so i was advised to cahnge and upgrade to v25 of which once i had done that my main computer worked. what i…

Hi, I am working with a client using Sage 300 version 9.5(?). When I open PCC I am unable to see the PRM tables. After some research I think that the reason the PRM tables (among others) do not show up is because the DDF files do not contain the schema…

I recall reading articles years ago about BV and its reliance on Pervasive 10 which reached its end of life a few years ago, and crystal reports which i think is no longer a thing? I recall there being a limitation with BV that all database access would…

I am an IT tech and quick question regarding Timeslips 19 as I am new to installing and setting it up. I created a Hyper-V server which has a C drive for programs and D drive for Data. I created this way to seperate files from programs. My question…