Sage 100

Trying to write a crystal report that pulls data from the Sage Fixed Assets 2013 (FAS) database. I am connected just fine but am having trouble locating the Status of the asset. Does anyone know where the data file layouts might be for FAS?

Do you have a PDF of the ""User Guide""? In the 2008.2 version, there is helpful information under the custom import/customer export

@BernieLehman It took me a while to find what I found but I still don't know if it will help you. I looked at the documentation for the desktop version of FAS (what comes with Sage 100) is a way similar to what @Jeff Schwenk did above. Per the help file, if you build the report through the app, they provide a number of views for you to use along with system values. Looking at the documentation, I could not find a 'Status' column as found on the Asset screen in FAS. I don't recall if there is an activity code. If there is, look at that. However, I don't remember seeing one. I then went into a 500 demo VM with FAS 500 vs 2010.1 installed and looked at the underlying tables via SSMS. The table named Assets has a flag column called IsInactive. If the asset has a status of Inactive, this will be set. However, it does not show if the asset has been disposed of. The principle table in FAS (SQL) appears to be 'PartialsInfo'. The primary key into this table is CompanyId, AssetID, SequenceNo. There is one row per asset per set of books in the table. In the PartialsInfo tables is the column ActivityCD. If the value of this column is 'D', the asset is disposed. If the value is 'A', it is active. 'I' is for inactive. If you are attaching to tables manually in Crystal, you will want to pull form the PartialsInfo and Asset tables. If you need valuation and depreciation data, you will need to link to the specific table for that book (example ' TaxBook, ACEBook, AMTBook, InternalBook, etc.). These you would also link to a table PrdClsxxx wher xxx is equal to the name of the depreciation table (example - TaxBook -> PrdClsTax. I have attached an image of visual diagram of the view in case that helps. Probably more than you wanted to know but I'm tardy on contributing so I'm making up some here. Good luck. I hope this helps.

@ShawnSlavin - Am I ever lucky you used your making up time on my question. The information was EXACTLY what I needed to get my report done and it enabled me to enhance two others. I don't do many crystal reports with FAS data on them so I was blindly poking around in the tables trying to find the info I needed. If you're at Summit this year I'll buy you a cold beverage, many thanks for your efforts on this one!