• error with decimals when doing bulk upload

    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…
  • Asset Database

    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…
  • Every company has its own database?

    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…
  • Import data from another Sage Fixed Asset company license into a new company license

    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…
  • Custom import not picking up the correct number format

    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…
  • Custom Import

    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.
  • ODBC Connection to FAS 100?

    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…
  • What is the template I need to use for uploading a bunch of assets from excel to Sage?

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

    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…
  • Upgrading application SQL Server to 2014

    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…
  • Combining Fixed Asset Databases

    FormerMember
    FormerMember
    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…
  • Oops, skipped a database conversion!

    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…
  • Sage FAS server compatibility

    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…
  • Database pointing to incorrect SQL Server

    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…
  • Working with Database Versions - BDB vs BBK

    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…