Paste Command in Financial Reporter of Sage 300 ERP

By | June 12, 2013

Financial statements are Excel worksheets with special Sage 300 functions that let us display account balance, currency exchange rates and company financials in wide variety of formats. Each financial statement is defined in a report specification.

The specification tells the Financial Reporter what data is to be included in the statement and how it should be formatted. Hence, to print Financial Reports in Sage 300 ERP, navigate to General Ledger >> Financial Reporter >> Print Financial Statements/Statement Designer

Also Read: Greytrix Extended Report Pack for Sage 300 ERP

Financial Reporter form contains two Financial Reporter icons:

  • Print Financial Statements – Lets you select and print financial statements using a large variety of print options. General Ledger uses Microsoft Excel to generate and print Financial Statements
  • Statement Designer – Lets you create, edit and test financial statement specifications using Microsoft Excel.
    The statement designer has the following FR menu commands that make it easier to create and edit the Financial Reporter specifications:

    • FR Paste: Inserts Financial Reporter functions, account numbers, and selection criteria.
    • FR View: Generates financial statements from report specifications.
    • FR Clear: Clears a previously generated financial statement.
    • FR Options: Lets us specify whether the statement carries forward opening balances for budgets and quantities.
    • FR Drilldown: Allows to drill down to the associated transaction.

Let us have a look on FR Paste Command in detail.

In statement designer, FR Paste lets you paste the following items in the spreadsheet cells: Account Numbers, Account selection criteria, Financial Reporter Functions (FRACCT, FRAMT, FRDEBIT, FRCREDIT, etc.)

In FR Paste form, choose a function, account reference or expression from the Function list.
The details of each function individually are as follows:

1. FR – The FR function provides information stored by the Common Services Company form, the Calendar form, and the G/L Options form.

2. FRACCT – It includes account data including account optional fields data
3. FRAMT, FRAMTA, FRDEBIT, FRCREDIT – Includes fiscal set data, balances and net changes
4. FRPOST – Retrieves transaction records including transaction optional field data from posted transactions and account optional fields data from the specified account in the transaction record
5. FRTRN, FRTRNA – Retrieves data from transaction details
6. FRTRNDR, FRTRNCR – Retrieves transaction data for stated fiscal period
7. FRFISCAL – Retrieves fiscal calendar dates
8. FRRATE – Retrieves exchange rate
9. FRSDESC – Retrieves segment code descriptions

Hence, the FR Paste command inserts a function in the current cell, and prompts for each parameter of the function so that the parameters don’t have to be memorized.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrixDocument AttachmentDocument NumberingAuto-Bank ReconciliationPurchase Approval SystemThree way PO matchingBill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at We will be glad to assist you.