Manage Financial Report Proposal

The financial report proposals are created and managed in 'Financial Report. Open' (RGS300). To trigger the creation of proposals and files for multiple financial reports at once, you must create report groups. See Manage Financial Report Groups.

Creating financial report proposals

On the (RGS300/B) panel, specify the financial report ID that is created in 'Financial Report. Specify' (RGS900) (RGS900) and select the 1='Create' option.
On the (RGS300/E) panel, specify this information:

Name

Specify the name of the proposal.

Description

Provide a description for the proposal.

Accounting date or period range

Select a from and to value for either accounting date or accounting period. The option you selected on the (RGS900/E) panel is used to identify which of the ranges are displayed. For applicable sections, only the records with an accounting date or period within the specified range are selected.

Warehouse

This field is optional and is applicable for stock transaction sections. When you specify a warehouse, only stock transactions that belong to the specified warehouse are selected. When you do not specify a warehouse, stock transactions from all warehouses that belong to the division are selected.

Base country

This field is used as optional information you can use in the report. It is not used as a selection criterion.

External or internal transactions

For general ledger sections, the field is used to select either internal or external transactions, or both.

Inventory round opening balance

This field is required when including the inventory value sections in a report proposal. It is used to calculate the opening stock quantities and values for a period.

Inventory round closing balance

This field is required when including inventory value sections in a report proposal. It is used as the main inventory round retrieved for the proposal. This field is also used to calculate the closing stock quantities and values for a period.

Corrective report

This field is used as optional information to be used in the report. It is not used as a selection criterion.

Report text

This field is used as optional information to be used in the report. It is not used as a selection criterion.

Note: Creation date and creation time are automatically updated with the current date and time when the XML or CSV file is created.
On the (RGS300/B) panel, select the 8='Create proposal' related option. This option is used to submit one batch program per type of section. The batch programs are used to populate each detailed section table and the general section table called FRESEC, which stores one record per section sequence number specified in (RGS901). The header status in (RGS300) is set to 10.
On the (RGS300/B) panel, select the 11='Sections' related option to open 'Financial Report. Open Section' (RGS301).
In (RGS301), the FRESEC table is shown. When the section is created in the proposal, the section status is set to 10. When the section is successfully created in the proposal, the section status is set to 20. When all sections are successfully created, the header status in (RGS300) is also set to 20 to indicate that the proposal is successfully created. If a valid report event trigger is specified on the (RGS900/E) panel, the event is triggered.
On the (RGS301/B) panel, select the 5='Display' option to open the (RGS301/E) panel. On the (RGS301/E) panel, record counters for each section and level are displayed. Accumulated amounts and quantities are also displayed, when applicable. If required, you can use these values in the XML structure. Click NEXT.
On the (RGS301/B) panel, select the 11='Section' related option to specify the program dedicated to the selected type of section. See Available sections in (RGS901).
When the actual value of dynamic key values in all sections is left blank, the key value for alphanumeric key objects is set to '++++++++++' for sorting purposes. If the value you specified does not fill the maximum length of the field, then the key value for numeric fields is filled with zeros before the actual value. For example, if the journal number value is 999, then the applicable key value is stored as 0000999 in the section table because the field length for journal number is 7.
Click exit until you reach (RGS300).
To create a new proposal, you can either modify the necessary information on the (RGS300/E) panel or leave it as is, and repeat the process from step 3 and forward.

Managing stopped or terminated proposal creations

To stop an ongoing proposal creation, select the 14='Stop proposal' related option on the (RGS300/B) panel. By doing so, the active batch jobs are stopped safely. The header status is first set to 12. When none of the sections are still in progress, the header status is set to 13.

If one or more section batch jobs are terminated by the system, the header status is first set to 14. When none of the sections are still in progress, the header status is set to 15.

For report proposals with header status 13 or 15, you can use the 13='Recreate proposal' related option on the (RGS300/B) panel to delete and restart the generation of the sections that are stopped or terminated.

For report proposals with header status 13, 15, 20, or 90, you can use the 12='Reset proposal' related option on the (RGS300/B) panel to empty all the detailed data in a proposal. When the deletion is completed, the header status is set to blank.

Creating an XML or CSV file

To create the XML or CSV file based on a proposal created in (RGS300):

Ensure that you specify a valid printer file ID and service ID on the (RGS900/E) panel.
Ensure that you specify an XML structure for the report. See Configuring the XML structure of the financial report.
Create a report proposal in (RGS300). See Creating financial report proposals.
On the (RGS300/B) panel, select the 9='Create file' related option. When you select the 9='Create file' option:
- The report header status is set to 80 and the file is generated through the generic configurable output functionality. When the report header status is set to 80, a file in format 3='Open' is created that uses the dynamic functions of the generic configurable output functionality such as virtual fields, related tables, and other functions. When the job used to generate the XML or CSV file job is complete, the header status is set to 90. The 90 status means that the file may still be under creation.
- The creation time and creation date are updated on the (RGS300/E) panel and in the FREHED table.
Retrieve the file from the applicable destination according to the selected service ID and its related settings. The file is named using the job number, printer file ID from (RGS900/E), and a sequence number as seen in 'Output. Manage per job' (MNS270).

Available sections in (RGS901)

All sections read a main table and various related tables to retrieve and populate the data in each section table. For each section, the detailed data is stored according to the key objects specified in (RGS901). As previously mentioned, record counters and accumulated data per section is stored in the FRESEC table, and the data in (RGS300) is stored in the FREHED table.

Select the 11='Section' related option on the (RGS301/B) panel to access the main programs. This table shows the key aspects of the sections available in (RGS901), including their dedicated tables and programs.


Section	Table	Programs	Description
Chart of accounts	FRECOA	'Fin Rpt. Open Chart of Accounts' (RGS311)	The FCHACC table is read as the main table for this section according to the accounting date or period selected in (RGS300) and selections made in (RGS901). If you specify a valid account translation scenario on the (RGS901/E) panel, then the accounting dimension value is translated if it exists in a specified range in 'Acc Translation Scenario. Open Details' (GLS031). You can only use the 'Account grouping 1' (&GRO1) and 'Account grouping 2' (&GRO2) key objects in (RGS901) when a scenario is specified.
Customer master table	FRECUS	'Fin Rpt. Open Customer Master Table' (RGS312)	The OCUSMA table and, if local exceptions exist, the CCUDIV table are read as the main tables for this section according to the selections made in (RGS901). To retrieve opening and period balances for this section, you must first specify a user-defined balance key on the (RGS901/E) panel. You must define the balance key in 'GL Balance File Key. Open' (GLS690) with customer as the only key. Ensure to update the balances for the balance key using 'GL Balance File. Analyze' (GLS940).
Supplier master table	FRESUP	'Fin Rpt. Open Supplier Master Table' (RGS313)	The CIDMAS table is read as the main table for this section according to the selections in (RGS901). To retrieve opening and period balances for this section, you must first specify a user-defined balance key on the (RGS901/E) panel. You must define the balance key in (GLS690) with supplier as the only key. Ensure to update the balances for the balance key using (GLS940).
Item master table	FREITM	'Fin Rpt. Open Item Master Table' (RGS314)	The MITMAS table is read as the main table for this section. Specific selections are not available for this section.
Unit of measure	FREUOM	'Fin Rpt. Open Unit of measure' (RGS315)	The CSYTAB table for unit of measure records is read as the main table for this section. If you specify a valid language on the (RGS901/E) panel and a record for the selected language exists in 'Unit of Measure. Enter Names/Language' (CRS052), then the unit of measure value is translated.
VAT codes and percentages	FREVTP	'Fin Rpt. Open VAT Codes and Pct' (RGS316)	The CVATPC table is read as the main table for this section. The only records included are the records with a 'From date' that is before or at the selected 'To accounting date', or last date of the selected 'To accounting period' in (RGS300).
Inventory value	FREIVA	'Fin Rpt. Open Inventory Value' (RGS317)	The MMSVAD table, which is created in 'Inventory Value. Open' (CAS180) is read as the main table for this section according to the selected 'Inventory round CB' in (RGS300). To calculate the opening stock quantity and values for each record, values from the inventory valuation round selected in 'Inventory round OB' in (RGS300) are used.
Fixed assets	FREFAM	'Fin Rpt. Open Fixed Asset Master Table' (RGS318)	The FFASDM table is read as the main table for this section according to the selections in (RGS901). The address type field on the (RGS901/E) panel is used to retrieve the address of the payee connected to the fixed asset.
Bank accounts	FREBNK	'Fin Rpt. Open Bank Accounts' (RGS319)	The CBANAC table is read as the main table for this section. Only the bank accounts with a 20='Definite' status are selected. Note: Only company bank accounts are retrieved in this section. If the customer or the supplier bank accounts are required, then you can retrieve them per customer or supplier by connecting the CBANAC bank account table as a related table in the XML structure for the applicable sections.
General ledger	FREGLD	'Fin Rpt. Open General Ledger' (RGS320)	The FGLEDG table is read as the main table for this section according to the selections in (RGS300) and (RGS901). If you specified a valid account translation scenario on the (RGS901/E) panel, then the accounting dimension value in the selected accounting dimension that exists in a specified range in (GLS031) is translated.
Stock transactions	FRESTK	'Fin Rpt. Open Stock Transactions' (RGS321)	The MITTRA table is read as the main table according to the accounting date or period range, and warehouse selection in (RGS300). For this section, the accounting date or period is used to select the range of transaction dates in MITTRA. If a valid language is specified on the (RGS901/E) panel, then the basic unit of measure value is translated if a record for the selected language exists in (CRS052). Note: The 'Entry date' (&CRDT) and 'Entry time' (&CRTE) key objects in (RGS901) are used to store the entry date and entry time of the original MITTRA record.
Purchase invoices	FREPIH (Header) FREPIL (Lines)	'Fin Rpt. Open Purchase Invoice Header' (RGS322) 'Fin Rpt. Open Purchase Invoice Lines' (RGS307)	The FPLEDG table is read as the main table for this section, selecting invoice records according to the accounting date or period selection in (RGS300). The address type field on the (RGS901/E) panel is used to retrieve the supplier address. This section is always used to update the FREPIH header table. If you select the Create lines field on the (RGS901/F) panel and you specified the key objects and number of key objects per level for lines, then the FREPIL line table is also updated. FREPIL is updated with related records from the general ledger that contains the 41-'Suppl inv – acct entries' transaction code and are not VAT records. Each line is assigned a line number stored in the LINE field. For this purpose, you must use the '&LINE' key object to store data on the correct break level. (RGS307) is used to display the line records in FREPIL that are created in the report proposal. To access the program, select the 11='Lines' related option on a header record on the (RGS322/B) panel. Note: The first key objects used for the line table on the (RGS901/F) panel must match the key objects used for the header table on the (RGS901/E) panel because these tables are directly related.
Payments	FREPAY	'Fin Rpt. Open Payments' (RGS323)	For this section, the FPLEDG table or the FSLEDG table is read as the main table, selecting payment records according to the accounting date or period selection in (RGS300). On the (RGS901/E) panel, select whether to include only supplier or customer payments, or both in the proposal. Each payment record found with the same invoice number is assigned a sequence number stored in the LINE field. If required, you can use the '&LINE' key object on the (RGS901/E) panel to store data on that break level.
Sales invoices	FRESIH (Header) FRESIL (Lines) FRESIC (Charges)	'Fin Rpt. Open Sales Invoices' (RGS324) 'Fin Rpt. Open Sales Invoice Lines' (RGS308)'Fin Rpt. Open Sales Invoice Charges' (RGS309)	The FSLEDG table is read as the main table for this section according to the accounting date or period selection in (RGS300). For each customer invoice in FSLEDG, the invoice BOD header table CINHED is read alongside other tables. The address type field on the (RGS901/E) panel is used to retrieve the customer address. This section is always used to update the FRESIH header table. If you select the Create lines field on the (RGS901/F) panel and you specify the key objects and number of key objects per level for lines, then the FRESIL line table is also updated. FRESIL is updated with related records from the invoice BOD line table CINLIN. If you select the Create charges field on the (RGS901/F) panel and you specify the key objects and number of key objects per level for charges, then the FRESIC charge table is also updated. FRESIC is updated with related records from the invoice BOD charge table CINCRG. (RGS308) is used to display the line records in FRESIL that are created in the report proposal. To reach the program, select the 11='Lines' related option on a header record on the (RGS324/B) panel. (RGS309) is used to display the line records in FRESIC that are created in the report proposal. To reach the program, select the 12='Charges' related option on a header record on the (RGS324/B) panel. Note: You must first create the invoice BOD tables before the financial report proposal because the invoice BOD tables are used for retrieving data for this section. If you use other invoice BOD tables such as tax tables as related tables in the XML structure, then you must create these invoice BOD tables before the XML or CSV file is created. The first key objects used for the line table and charge table on the (RGS901/F) panel must match the key objects used for the header table on the (RGS901/E) panel as these tables are directly related.
Withholding tax transactions	FREWHT	'Fin Rpt. Open Withholding Tax Trans' (RGS325)	The FAPSER table, which is displayed in 'Supplier Tax Report. Display Invoices' (APS425) is read as the main table for this section according to the accounting date or period selection in (RGS300) and the selections made in (RGS901). Note: The 'Payment proposal/order' (&PPPO) key object in (RGS901) is used to store a concatenated value of objects, 'Payment proposal' (SRPRPN) and 'Payment order' (SRPYON). You can use the object in case the number of key objects otherwise exceeds the maximum value of 9.
Fixed asset history	FREFAH	'Fin Rpt. Open Fixed Asset History' (RGS326)	The FFAHIS table is read as the main table for this section according to the accounting date or period selection in (RGS300). The depreciation types selected on (RGS901/E) are in turn used to select which value types to include when reading the table. If corporate accounting is activated in 'Settings – Fixed Asset Acquisition' (FAS900), you must also select the accounting ledger on (RGS901/E) to decide which voucher types are included in the selection. If corporate accounting is activated in (FAS900) and the report proposal is created based on an accounting period range, the records will be selected based on the accounting date range. Since the same proposal can contain sections with different accounting ledgers, the accounting date range is always calculated by converting it from the selected period range based on the local period type in 'Company. Connect Division' (MNS100). You must consider this if non-local accounting ledgers of the division are using an alternative period type in 'Settings – Corporate Accounting' (GLS080). Note: The 'Entry date' (&CRDT), 'Entry time' (&CRTE), and ‘Timestamp’ (&OTSM) key objects in (RGS901) are used to store the entry date, entry time, and timestamp of the original FFAHIS record as key values.