How to create a custom Crystal report using the Reporting module
Description
The default formula for a new report is as follows:
{SFA_Company_Information.Company Name} = "" and (The Company name, which was open when you made the report)
{Depreciation_Asset_Information.Extension} >= 0 and (Prevents Deleted and original asset of a Transfer from appearing on the report)
{SFA_Asset_Selection.Depreciation} and (Excludes assets entered into the Sage Fixed Assets-Tracking)
not ({Depreciation_Asset_Information.Creation Code} in ["V", "U"]) and (Excludes assets you partially transferred as a disposal)
{Depreciation_Asset_Information.Activity Code} <> "J" (Excludes the original asset of a partial disposal)
Note: These criteria will pull the same assets as any non-date sensitive Standard Report. For example, net Book Value or Depreciation Summary. Changing the formula {Depreciation_Asset_Information.Activity Code} <> "J" to {Asset_Information.Activity Code} = "A" will cause the report to show active assets only.
For training on creating a crystal report, contact our sales team at 1-800-368-2405.
Cause
Resolution
Start a new report
In Sage Fixed Assets — Depreciation:
Go to Reports, Reporting, Create New Report.
Enter the Report Title.
Enter a File Name for the report.
Select Create Report.
Crystal Reports for Sage opens on the Preview tab with a default report. The default report shows only the System Number and Extension of every asset in the company.
Add a field from Field Explorer.
NOTE:
If Field Explorer isn't visible, go to View, Field Explorer.
Select the Design tab near the top left of the report window.
In the Field Explorer pane on the right, select the plus sign next to Database Fields.
For Sage Fixed Assets — Depreciation fields, select the plus sign next to Depreciation_Asset_Information.
Drag a field from the list and drop it on the Details line of the design view.