After you set up a financial statement layout, you need to assign a specification to it. A specification tells the system what kind of detail you want to print about your accounts on the financial statement. You can print any or all of the following:
Information for specific or all financial entities
Actual amounts from the current year
Comparative amounts from past years (depending upon how many past years' information you have on your system)
Budgeted amounts for the current year, past years, or future years
Ratios (if any)
Variances between actual and budget amounts (if any)
Click Add. The Add window displays.
In the Specification No box, enter a number to associate with the specification (up to 3 digits).
In the Layout No box, select a layout number to associate with the specification by clicking on the arrow to the right of the box and selecting a layout from the drop-down list.
In the Entity box, select an entity to associate with the specification by clicking on the arrow to the right of the box and selecting an entity number from the drop-down list. If you do not use entities, leave this field blank.
In the Show Ratios box, enter Y or N, depending upon whether or not you coded the layout (when you created it in the Financial Statement Layout Maintenance window) with SR (start ratio) and ER (end ratio).
Note: ratios will print only on Profit and Loss statements.
In the Print Next Run box, enter a Y if you want to print this statement the next time you print financial statements. Enter an N if you do not.
Note: The grid in the bottom portion of the screen looks different depending upon whether you are creating a specification for a balance sheet or a profit and loss layout. All the possible fields in the grid are described below. Simply skip any fields that do not apply.
Under Data Type, click the arrow in the first box . In the dialog box that displays, click on either Actual, Budget, Variance, or Leave Blank. Repeat this process for the other boxes in this column.
If you choose Actual, the current year's actual amounts or comparatives print.
If you choose Budget, current, past, or future year's budget amounts print.
If you choose Variance, the difference between the amounts in the other two columns prints.
Under Current/YTD, enter a C if you want to print net change amounts for the current period, or enter a Y if you want to print net change amounts for year-to-date. Repeat this process for the other boxes in this column.
Under Year (+ or -), one of the following in each box:
If you want to print amounts for the current fiscal year, enter a 0 (zero).
If you want to print amounts from a previous fiscal year, enter -1 for last fiscal year, -2 for the fiscal year before that, and so on (the number of past years' information you have on your Epicor determines how far back you can go).
If you want to print amounts for next year, enter +1 (provided you have budgets set up).
Under Budget Code, click the arrow to select a budget code (only if you entered B in the Data Type column).