Overview
The create memorandum revenues extract process involves selecting the invoice payment details that are to be extracted for bank deposit. Mode of extraction allows you to create draft memorandum revenue for all invoice payment details within a specified fiscal year, or a specific range of invoice.
Navigation
Revenue Management ► Revenue Memorandum ► Create Memorandum Revenue Extracts
Create Memorandum Revenue Extract Field Description
| Fields | Description |
| Fiscal Year | Fiscal Year of the voucher, Default current Fiscal Year, where Current Fiscal Year for Budget Execution' is True. |
| Fiscal Period | Default current period of the selected Fiscal Year. Users are allowed to change it. |
| Customer | User can select a specific Customer to extract his unpaid RI payment details. |
| Beneficiary | Beneficiary details. |
| Treasury Bank Account | User can select specific Bank Account to extract RI payment details related to. |
| Payment Method | User can select payment with specific Payment Method using lookup button. |
| Accounting Office | If Selected Accounting Office Code has Children then system will apply the hierarchycal filter so then all RI's related with children institutions are also taken into account. |
| Payment Due from Date | To extract only vouchers due from and include the specified date. |
| Payment Due to Date | To extract only vouchers due up to and including the specified date |
| Financial Institution | Select the financial institution using lookup button. |
| Currency | Select the currency of using drop down list. |
| Payment Mode | User can select payment with specific Payment Mode. |
| Payment Location | User can select payment with specific Payment Location. |
| Amount From | If there are values, then Amount To cannot be lower than Amount From. |
| Amount To | Zero by default. If there are values, then Amount To cannot be lower than Amount From. |
It allows to extract the invoice payment details as per the provided information.
Overview
The system is able to show a list of selection criteria where the user must choose a specific field or some combination of them in order to create a Draft Payment invoice from the scheduled Payments.
Navigation
Revenue Management ► Revenue Memorandum ► Create Memorandum Revenue Extracts
Invoice Extract Field Description
| Fields | Description |
| Id | Classification unique ID can be either system generated or manual. |
| Fiscal Year | Fiscal Year of the voucher, Default current FY where Current Fiscal Year for Budget Execution is True. |
| Fiscal Period | Default current period of the selected Fiscal Year. |
| Active | This is a check box. Default value is ‘checked’. |
| Language | Country specific language used to register the abbreviation and description. |
| Description | Description on the invoice extract. |
| Extract Date | Voucher extract date. |
| Account Office | If Selected Accounting Office Code has Children then system will apply the hierarchycal filter. |
| Number of Created Invoice Extract | It shows all the created invoice extract. |
| Number of Approved Invoices | It shows all the approved invoice. |
| Created Invoice Amount Domestic | It shows the domestic amount for created invoice. |
| Approved Invoices Amount Domestic | It shows the domestic amount for approved invoice. |
| Created By | Shows the user id who created the invoice extract. |
| Created Date | Date of creation. |
Overview
This mode of extraction allows you to create draft payments for all expense vouchers payment details within a specified fiscal year, or a specific range of expenses.
Navigation
Revenue Management ► Revenue Memorandum ► Invoice Extract Payment
| Field | Description |
| Id | Classification unique ID can be either system generated or manual. |
| Workflow Status | It shows the workflow status. Eg. Created, Approved, etc. |
| Document Series Number | Number of the document series. |
| Reference Number | Reference number of the extract payment. |
| Transfer Number | It has a value which is blank. |
| Acounting Office | Selected Accounting Office Code has Children (other institutions related to it downstream) then system applies the hierarchycal filter so then all EV's related with children institutions are also taken into account. |
| Treasury Bank Account | User can select specific Bank Account to extract EV payment details related to. |
| Customer | User can select a specific vendor to extract his unpaid EV payment details. |
| Currency | User can select specific Currency to extract EV payment details related to. |
| Payment Method | User can select payment with specific Payment Method. Only Payments Method type Cheque or Electronic Transfer are allowed. |
| Handling Indicator | The Handling Indicator of the extracted payment. |
| Number of Approved Invoices | It shows all the approved invoice. |
| Payment Domestic Amount | It shows the domestic payment amount. |
| Payment Foreign Amount | It shows the foreign payment amount. |
| Customer payment Domestic Amount | It shows the domestic customer payment amount. |
| Customer payment Foreign Amount | It shows the foreign customer payment amount. |
| Created By | Shows the user id who created the Invoice Extract Payment. |
| Created Date | Date of creation. |
| Approved By | Shows the user id who approved the Invoice Extract Payment. |
| Created Date | Date of approval. |
Overview
This report can be print when the state of the workflow is on request of approval. Report displays the total amount of the selected invoice to create a memorandum.
Navigation
Revenue Management ► Revenue Memorendum ► Revenue Memorendum Reports ► Memorandum Invoice Extract Report
Memorandum Invoice Extract Report Field Description
| Field | Description |
| Fiscal Year | Fiscal year to which Memorandum Invoice Extract relates. Current fiscal year is the default value. |
| Fiscal Period From | User types Fiscal Period. This parameter is mandatory and it shows by default the current fiscal period. Entering only a From value will display data From that value to the end of the dataset. The user is able to enter both From and To values. |
| Fiscal Period To | Entering only a To value will display all data up to the item specified. Entering both From and To values will display the subset of the data defined by the specified range. |
| Period Total | Allows users to decide if sub-totals by period should be included in the report. |
| Extract Date From | The user is able to enter both From and To values. Entering only a From value will display data From that value to the end of the dataset. Entering only a To value will display all data up to the item specified. Entering both From and To values will display the subset of the data defined by the specified range. |
| Extract Date To | Entering only a To value will display all data up to the item specified. Entering both From and To values will display the subset of the data defined by the specified range. |
| Source | Allows user to select a specific voucher source. Sources may be: Manual, Cash Invoice and Other External Source. |
| Posting Status | Allows users to restrict the data in the report by the posting status. Values may be: Saved and Temp Saved. |
| Invoice Extract | Using look up button user can select the filter option for invoice extract. |
| Created By | Using look up button user can select the filter option for invoice extract. |