How to set up a column format using statistical data in FRx for Sage PFW

Entry Type: Informational

Product: FRx for Sage PFW

Application: FRx Desktop

Version Reported: All

Subject:

How to set up a column format using statistical data in FRx for Sage PFW

Possible Resolution:

FRX for Sage PFW ERP:

In Sage PFW:

1. Open GL / Transaction Processing / Journal Batch Entry.
2. Click the 'Header' tab, and change the 'Transaction Type' to "S" (for Statistical).
3. Click the 'Line Item' tab, enter all the information for the statistical data, and click 'Save'.

In FRx:

1. Create or open a Column Layout, and add a new column for 'GL' types.
2. Under the Column Detail / Book Code and Attribute Category, change the default from 'A' to 'S'.
3. Save the column, and use it in the Catalog of Reports to generate the report.