Export Line Items Summaries Process

1 Enhancement Summary - Release 11.3
- 1.1 Introduction
- 1.2 Database
- 1.3 TABLE LINE_ITEM_SUMMARIES
- 1.4 Menu
- 1.5 Roles
- 1.6 Screen
- 1.7 Process
- 1.8 Reports

Enhancement Summary - Release 11.3

Introduction

Qbyte FM has introduced a new Month End process that will summarize line item transactions for the selected org(s) and accounting periods summarized at the org, cost centre and account for voucher and operating currency of the transactions. The process will update a new line_item_summaries table.

Database

TABLE LINE_ITEM_SUMMARIES

Roles

PWSQL_50_SUPER_USER

Screen

The GELU083 Export Line Items Summary must be submitted using the Job Stream process.

Menu Path: System Admin > Administration > Maintain Job Streams.

IN THIS FIELD...	ENTER THIS INFORMATION...

IN THIS FIELD...	ENTER THIS INFORMATION...
Organization ID	Organization Code. Organization may be a corporation, partnership, joint venture, business unit or division that requires separate financial statements.
Accounting Period (YY/MM)	Enter the required accounting period. Line items will be selected for all posted transactions for the accounting period entered.
Delete Prior Accounting Period (Y/N)	If Y (Yes) is selected, the process will delete the transactions in line item summaries for all prior accounting periods.

Process

The Qbyte user responsible for the month end process will submit a job using the Qbyte job submission via job stream to run the program that will select and summarize all line items for the requested organization and accounting period and insert into the LINE_ITEM_SUMMARIES table with a unique report id. The process will verify that the transactions balance to zero for the report id. Transactions created by the restatement and P&L close processes are not included in the summarization. The process can be run more than once for an accounting period. Subsequent runs will summarize all transactions rather than calculate incremental amounts.