130 likes | 616 Views
Help!. Your Accpac manuals are available from Online Documentation, General LedgerUser GuideQuick Reference. Tips and Tricks. Login date defaults as the report periodStatement Designer opens Excel with FR menuWhat are Quik Reports? QUIKBAL1, QUIKINC1Path of Quik reports on local drive
E N D
1. Accpac Financial Report Writer
Presented by Nancy Pearce
or Bob Mahadea
2. Help! Your Accpac manuals are available from Online Documentation, General Ledger
User Guide
Quick Reference
3. Tips and Tricks Login date – defaults as the report period
Statement Designer – opens Excel with FR menu
What are Quik Reports? QUIKBAL1, QUIKINC1
Path of Quik reports on local drive is C:\Program Files\Accpac\GL5x\Eng\
Let’s look at Financial Reporter
4. Print FinancialStatements Run predefined statements
Cannot edit or copy
Separate segments (departments)
5. What is different about Microsoft Excel and Financial Reporter (FR) ?
Columns A to D are reserved for Financial Reporter
Columns E and beyond print on the report
Statement Designer
6. FR Menu FR View – Report generation options
FR Paste – Tool to create formulas
FR Clear – Clear the report range
FR Help – Links to help articles
7. Column A
Top comments area with leading … in the cell
Blank rows print as is
\T will repeat those rows as titles on each page of the report
\\ACCTGROUP tells the report to refer to the Account Group as specified in the GL Account set up: Revenue; Cost & Expenses, etc – used in Quik reports
Custom reports will usually use Column A to list what accounts are reported on each line
8. Column B
Enter criteria to restrict the range of accounts
On custom reports it could be a specific Account Segment
Column C
Z specifies to suppress rows that have zero amounts, this applies to all columns including Budgets or Year End balances
Column D
T indicates consolidating a range of accounts into one amount on the report.
D(ACCT) specifies to print one line per Account number
D would print all accounts on separate lines
9. Account Segments & Structures
Account segments & structures allow for report flexibility
4000 Sales
4000 – 100 Sales - Commercial Division
4000 – 100 - 10 Sales - Commercial Northern
4000 – 100 - 20 Sales - Commercial Southern
4000 – 200 Sales - Retail
4000 – 200 - 10 Sales - Retail Northern
4000 – 200 - 20 Sales - Retail Southern
**Note that ‘Sales’ is the common description – affect in FR
10. Column A
A single account number would be entered as 4000%% - this will print all accounts starting with 4000, including different segments
A range of accounts would be entered as 4000:4999 - this will print all accounts starting with that range of account numbers, including different segments
A mixture of accounts are separated by a comma, such as: 4110:4115,4150%%,4165:4175
11. Formulas =FRTRNA("NETYTD")
=FR indicates a Financial Reporter formula
TRN will return Transaction Details in a drill down feature in version 5.3B
Note that this will only work for Net, not Balance types of codes, or Budgets
AMT is the other common code used in other cases
A will show debits as positive numbers and credits as negative numbers regardless of the Account Type
If A is not used, the Account Type is referred to and Debit balances in Debit accounts report as positives; Credit balances in Credit accounts report as positives
The brackets contain the following information, but not all is mandatory
(field name, account reference, criteria, currency) each of these sections must have “” at the beginning and end
12. Field Names =FRTRNA("NETYTD")
Field name in this case is “NETYTD” asking to report the net changes during the whole year.
Field name prefix is commonly used to indicate Budgets (1) or Provisional (P) or Quantities (Q)
Field name suffix can be used to indicate Last Year (.L1), a specific year (2004)
13. Other examples of field names are:
BALY = Balance of the account for the whole year
BALYTD = Balance year to date
BALY.L1 = Balance of the account for the whole year of last year
1NETP = Budget 1, Net for the current period
NETLP = Net last period
14. Questions?