• 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

    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…