About FR Paste

Sage 300 ERP

About FR Paste

When you use the Statement Designer to open a Microsoft Excel worksheet, an Add-Ins tab appears on the Excel ribbon. On this tab, the FR menu displays commands you can use to create and edit financial reports and specifications.

The FR Paste command appears on this menu. You use it to paste formulas into spreadsheet cells to retrieve and display the following General Ledger data:

  • Account numbers. For more information, see About Account Number References.
  • Account selection criteria (query-by-example expressions). For more information, see About Selection Criteria for Filtering Accounts.
  • Financial Reporter functions. For more information, see Financial Reporter Functions.
  • Rolled up amounts.

    Note:
    • On the FR Paste Function screen, use the Rolled Up Amounts option to specify whether or not to paste rolled up balances or quantities into reports for rollup accounts. This option is available for FRAMT, FRAMTA, FRCREDIT, and FRDEBIT only.
    • Take care when creating the rollup group to avoid ending up with doubled amounts in the final report.
    • Select the Rollup Members Account option to include balances or quantities for rollup member accounts whose balances or quantities are also being rolled up to their rollup account in the same paste function in the report.

For information about other menu commands in the Financial Statement Designer, see FR Menu Commands.

Pasting Single Values and Default Column Specifications

The following are typical single values you will paste in a financial report:

  • Company name
  • Period-end date (or today's date)
  • Division or department for which the report is printed
  • A single account balance

For each of the above items, you will paste a complete formula, and you will probably not have to edit the result.

Pasting Column Formulas

If you are pasting a formula to use as a default column specification, do not enter an account reference (because you will be supplying that in column A of each line that uses the default column specification).

For example, the formula for a single cell might be =FRAMT("BALP","1000"), whereas a default column formula would be =FRAMT("BALP").

For instructions on using FR Paste, see Using FR Paste to Insert Information in Financial Reports.

Related Topics