Sage Fixed Assets

I have been importing fixed assets monthly for 2024 and have now been asked to include additional columns of data for reporting purposes. How can I import additional columns of data to assets already in SAGE without affecting the data previously imported…

Will inactivating or deleting assets help make the program run smoother/faster? Our database has a significant number of fixed/intangible assets and running reports sometime takes a long time and I am sometimes booted out of the program. Our program…

Hi all, do you ever get an error when doing a bulk upload where it tells you an asset is invalid because there is no dollar amount listed (but there is)? When I get this, I just go back into the excel and remove the decimals and reupload and then it works…

Hello. I am new to using Sage and have next to no notes left from my predecessor and no one else on my team seems to have much info, if at all, on the software. I have noticed in some areas (although now I can't find it of course) where it mentions "Asset23…

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…

We had our STC fixed asset data on another Sage Fixed Asset license along with their WSH company fixed asset data (we had two locations... WSH and STC ). We sold the WSH location, so WSH kept their Sage Fixed Asset system/license. Since we needed our…

We've updated to version 2024.0. The custom import isn't picking up the correct cell format in the cost fields on some lines resulting in an 'unable to convert to number' error. I've double checked the formatting in the template to ensure it's formatted…

I am not able to import into our primary database through the custom import feature. It was working last week but is no longer working. I can import to other test databases but not the one I need.

Hi, I can see an ODBC connection available (default name WINFAS32) but can't connect to it. I'd like to automate some spreadsheets that can verify VIN#s on our insurance policies. I've tried integrated security and specified user names, but neither…

Group, is there a specific upload template I need to use to get my excel spreadsheet assets into Sage? Thanks Sam

Sorry if this is stated somewhere, but wanted to know how to configure the Sage Fixed Asset - Premier Depreciation up for SQL Server database mirroring. With most applications this is configured within the DataSource Connection String like this: data…

Hi, My group has been task with updating our SQL Server to 2014. This is were the application and config databases are stored. What are the best practices for performing such a task? We are also using crystal reports but based off the system requirements…

I am trying to combine two fixed asset databases in the Sage fixed asset system. Currently, we have two databases, one of which contains a total of close to 18,000 fixed assets, and the second one contains a subset of around 7,000 of the fixed assets…

We've skipped a database conversion during multiple upgrades (2017 to 2021), and now the database shows as "incompatible" and cannot be converted. The recommended solution is to get Professional Services involved. I'm wondering if I could start over with…

Good afternoon, all! I've started managing the Sage FAS server at a client site. The current installation is version 18.1 on a Windows 2012 R2 server. We're starting a project to upgrade our Win2012 fleet to Server 2019 or better. I'm looking for…

Hello, We have two CITRIX servers in which we installed SAGE Premier Client. One of them points to the Production database server and users are able to work ok. However the other one maybe by mistake was installed and poinitng to the Development…

What are the differences between backing up a database using the Backup Utility that creates a .bbk file and saving a copy of the .bdb file? The use case in this scenario is we would want to create a version of the database after any large action has…

Your data is vulnerable to various risks, such as hardware failures, cyberattacks, and natural disasters. Backing up your data and having those backups easily accessible is often the quickest, most affordable way to recover. In fact, backups may be your…