Gross Margin Report

The Gross Margin report is used for building financial statements that combine balance sheet and income/expense information on one print line and calculates both vertically and horizontally. This report is defined in General Ledger. Once the set up is complete no changes will need to be made unless a new account number is set up for a new product category or a new commodity is added. The components necessary for creating this type of report format are as follows:
1. Define Summary Accounts:
The summary accounts are used to group balance sheet and income statement G/L accounts whose amount and quantity values are to be printed on the same line. To begin setting up these accounts go to (>) Maintenance options, > Summary Accounts, > Add New Summary Account. These accounts are defined by summary level. The summary level is an alpha character from A to Z. The code works from Z to A, meaning that a summary level G can be further summarized into level D and D into level A, but level G can not be summarized into level J. This is shown in Exhibit A. Then choose a Summary Code for the Summary Account you are defining. Do this for each product that you want to see a gross margin on and then you can further define the summary level by like families. Example, Find the gross margin for each commodity and then find the gross margin for commodities as a whole. Again refer to Exhibit A. It is recommended starting in the middle of the alphabet. Be sure to leave room to maneuver for future changes.
2. Define Financial Form:
The financial form is used by the user defined financial report to determine the report format. The sample form (GMEX) contains a series of summary accounts that are built using G/L accounts from the Agris default chart of accounts. To define this form
> Financial Reporting, > Form Definition. Give the form a four (4) character alpha/numeric code and a description. The report type will be a 2 (income statement). Then begin entering the accounts in the sequence that they are to appear on the Gross Margins Statement (see Exhibit B). At the bottom of the screen there are options to edit, add, delete and save the entries. Again, leave room to make changes in the future.

Define Report:

To define the report > Financial Reporting, > Financial Reports, > Report Writer Features. In user defined reports select the report entitled "Gross Margin Report - Current Period." Redefine the print field if necessary. This is performed on the Define Print Fields screen. This screen appears before the Define calculation Fields screen. On a later screen you will be asked which form to use, choose 3, Custom Financial Forms. Redefine print fields if necessary.