Status:

This issue is being researched by Engineering.

Subject:

Transaction detail sorts incorrectly when drilling down in FRx reports, if "1 TO BASE" is used in the column format. The detail segregates undistributed subsystem items by module instead of combining all of them by date (regardless of the module).

Steps to Duplicate:

FRx for Sage PFW:

1. In Sage PFW, open Accounts Payable / View / Print and Post / Print and Post Distribution, and print and post the following modules in "Trial" mode:
• General Ledger
• Accounts Receivable
• Inventory
• Bankbook
2. In FRx, open a new row format using a wildcard (for example: ????), and save the row.
3. Open a new column layout with the following information on the column detail type, and save the column:
• Column A:  DESC
• Column B: TAPL (Transaction Apply Date)
• Column C: ACCT
• Column D: GL / A / BASE / 1 TO BASE / CUR
• Column E: GL / A / BASE / BASE / YTD
• Column F: TSID (Source ID)
• Column G: TDOC (Source Document #)
• Column H: TBAT (Batch Code)
4. Open Catalog of Reports, and select the following:
• Detail Level = Financial and Transaction
• Provisional = Posted and Unposted Activity
5. Save and generate report
6. Drill down to the transaction level of an account that has unposted transactions.
7. Note that the results sort in the following order:
• Posted transactions
• APNLXD1 items (by month)
• ARNLXD1
• BBNLXD1
• NLTXD

Expected Behavior:

All of the files used to report unposted transactions should be merged and sorted by date and document number. 

Possible Workaround:

None