What Sage PFW files are accessed to generate FRx reports?

Entry Type: Informational

Product: FRx

Application: FRx Desktop

Version Reported: All

Subject:

What Sage PFW files are accessed to generate FRx reports?

Possible Resolution:

FRx for Sage PFW ERP:

General Ledger Setup Files:

• NLACCTY - Account Code Types
• NLCHART - Chart of Accounts
• NLJDESC - Journal Keys & Description
• NLONE - Company Information & Account Segment Configuration
• NLPARAMS - Parameters
• NLPDATES - Period dates
• NLSEGMNT - Account Segments Definition
• NLTXTYP - Book Codes

Posted Transactions:

• NLTXBH - GL Transaction Batch Header History
• NLTXDH - GL Transaction Batch Detail History
• NLBAL - GL Period Balance

Unposted Transactions:

• APNLX* - AP Unposted Transactions
• ARNLX* - AR Unposted Transactions
• NLNLX* - GL Current Earnings / Income Summary Provisional files.
• BBNLX* - Bank Book Unposted Transactions
• INNLX* - Inventory Unposted Transactions
• NLTXB1 - GL Transaction Journal Batch Header - Unposted
• NLTXD1 - GL Transaction Journal Batch Detail - Unposted

Notes: 

• The " * " represents a wildcard character.
• These subsidiary module files are created when running the Print and Post Distribution to GL in trial mode and the General Ledger files are created when running the Edit List.