Reports

Revenue Invoices Listing By Voucher Report

Overview

This report essentially serves as a log of all Invoices within a specified numerical range that have been posted over a given period of time.

Navigation

Revenue Management ► Reports ►  Revenue Invoices Listing By Voucher Report

 

Revenue Invoices Listing by Voucher Report Field Description

FieldsDescription
Fiscal YearFiscal year to which Revenue Invoice relates. Current fiscal year is the default value.
Fiscal Period FromUser 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 ToEntering 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 the user to decide if sub-totals by period should be included in the report.
Voucher Date FromThe 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.
Voucher Date ToEntering 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.
Invoice TypeIf this field is specified it will display the data based on the select criteria (if cash is selected then all the cash invoice will be displayed . If credit is selected then all the credit invoice will be displayed). If none is selected both type will be displayed on the report.
SourceAllows user to select a specific voucher source. Sources may be: Manual, Cash Invoice and Other External Source.
Posting StatusAllows the user to restrict the data in the report by the posting status. Values may be: Saved and Temp Saved.
Workflow StatusAllows the user to select an specific workflow status o restrict the data displayed in the report.
TempAllows the user to select an specific temporary number or a range of temporary number to view in the report.
Batch NumberAllows the user to select an specific batch or a range of batches to view in the report.
Created ByAllow the user to restrict the data based on the creation user.
VoucherAllows the user to select specific voucher Id or range of Id.
CommentComment on the report is made in this field.

 

Sales Transaction Listing By Customer Report

Overview

The report displays all Cash and Credit Sales vouchers, receipt vouchers and credit/debit notes, it will display all data as a list including important information regarding the each type of document and related customer.

Navigation

Revenue Management ► Reports ►  Sales Transaction Listing By Customer Report

 

Sales Transaction Listing by Customer Report Field Desription

FieldsDescription
Fiscal YearThis parameter will be populated automatically by the system based on current fiscal year.
Fiscal Period FromAllow the user enter From and To Fiscal Period.  By default both values (From and To) will have the Current Fiscal Period.  No future fiscal periods are allowed and if From and To are different, then the value in To must be equal or higher than From.
Fiscal Period ToAllow the user enter From and To Fiscal Period.  By default both values (From and To) will have the Current Fiscal Period.  No future fiscal periods are allowed and if From and To are different, then the value in To must be equal or higher than From.
Posting StatusDisplay as a list all values for referenced,  if none is selected all status must be displayed by the report.
Workflow StatusDisplay as a list all values for referenced, if none is selected all status is displayed by the report.
Document TypeDocument type may be: Invoice, Receipt Voucher, Credit Note and Debit Note. None, means all types must be displayed when generating the report.
Include Customer Without Customer TypeDisplay to the user as a checkbox element to indicate whether customer type is included or not.
Customer TypeCustomer type is to be selected for report purpose.
Voucher Date FromAllow the user indicate a single date or a range (From and To) of dates.
Voucher Date ToAllow the user indicate a single date or a range (From and To) of dates.
CommentComment on the report which is optional.
Sort ByThe system should allow the user sorting (ascending/descending) by the attributes from this table.

 

Aged Receivable Report

Overview

Report on Accounts Receivable which have not been realised from the debtors and have aged in the due time are generated from 'Aged Receivable Report'.

 

Navigation

Revenue Management ► Reports ► Aged Receivable Report

 

Aged Receivable Report screen Fields

Field

Description

Fiscal Year

Fiscal Year to which the Accounts Receivable records relate, is selected from drop down box.

Period From

Starting period (month) of Accounts Receivable taken into consideration for records filtering purpose, is selected from drop down box.

Period To

Closing period (month) of Accounts Receivable taken into consideration for records filtering purpose, is selected from drop down box.

Type

Whether the records is represented in Invoice, Receipt Voucher, Debit Note or Credit Note, is selected from drop down box.

Include From Aging

Whether to include from aging, is mentioned in the check box for this field.

Include All Voucher Details

Whether to include all voucher details, is mentioned in the check box for this field.

Include Customer With Zero Balance

Whether to include customers with zero balance, is mentioned in the check box for this field.

Include Customer With Negative Balance

Whether to include customers with negative balance, is mentioned in the check box for this field.

Run Date

Run Date of the report generation, generated by the system.

Aging Period

Aging period is mentioned in this field. Default value is 30 days.

Customer

Customer regarding whom the report is generated, is selected from the lookup button.

Offset Code

Offset Code is selected from the lookup button available for this field.

Comment

Comment on the report is entered in this field.

 

Bank Deposit Statement Report

Overview
 
This Report lists all Payment for a specific Bank Deposit Number. If it is a collection of Bank Deposits, it should be separated by a page break.
 
Navigation
 
Revenue Management ► Reports ►  Bank Deposit Statement Report
 
 
 
Bank Deposit Statement Report Field Description
 
FieldDescription
Treasury Bank AccountRelevant Treasury Bank Account related to Bank deposit form is selected in this field.
Deposit Number FromStarting number of the range of Bank deposit form number.
Deposit Number ToEnd number of the range of Bank deposit form number.
Deposit Date FromDate from when deposit shall be filtered for report generation purpose.
Deposit Date ToDate up to when deposit shall be filtered for report generation purpose.
 

Cash Sales Details Report

Overview

This report prints out a detailed listing of all cash sales that were created during a specified period of time. Sales are printed in numerical sequence and display information to help users maintain accurate control over every cash sale that was created in the system, report will allow to filter the information based in the most relevant columns of the report.

Navigation

Revenue Management ► Reports ►  Cash Sales Details Report

 

Cash Sales Details Report Field Description

FieldsDescription
Fiscal YearThis field refers to fiscal year to which cash sales relates. It is mandatory to be filled up by user.
Fiscal Period FromAllows the user to enter a single value or a range (from and to) of values based on fiscal year selection.
Fiscal Period ToAllows the user to enter a single value or a range (from and to) of values based on fiscal year selection.
Transaction typeCash Sales is the default value and is in read only mode.
Workflow statusWorkflow status is shown. Available status: Created, Approval Requested, Approved, Rejected, Cancelled and All.
Posting StatusPosting Status is selected. It may be Saved, Temp Saved or All.
Temp Number FromStarting range of values for Temporary Voucher number.
Temp Number ToLast range of values for Temporary Voucher number.
Include customer without Customer TypeDisplays whether the filter is kept active or not.
Voucher Date FromStart date of range from when Voucher date shall be filtered for report generation.
Voucher Date ToEnd date of range from when Voucher date shall be filtered for report generation.
Customer TypeCustomer type is to be selected from lookup button.
Journal VoucherJournal Voucher to be selected from lookup button. 
Approved ByUser by whom the cash sales is approved.
Created ByUser by whom the cash sales is created.
CommentComment on the Cash details report.
Sort ByTeh system will allow the user to sort in ascending or descending order by attributes.

 

Official Cash Receipt Report

Overview
 
This report can be print when the state of the workflow is on request of approval, approved and the revenue voucher type = credit. Reports display the selected revenue voucher.
 
Navigation
 
Revenue Management ► Reports ► Official Cash Receipt Report
 
Official Cash Receipt Report Field Description
 
FieldDescription
Fiscal YearSelect Fiscal Year from the drop down menu. This is a mandatory field.
Fiscal Period FromSelect Fiscal Period From the drop down menu. This is a mandatory field.
Fiscal Period ToSelect Fiscal Period To the drop down menu. This is a mandatory field.
Invoice Date FromDate from when cash report shall be filtered for report generation purpose.
Invoice Date ToDate up to when cash report shall be filtered for report generation purpose.
Is Period TotalCheckbox is by default.
Workflow StatusDrop down menu shows the status of the workflow.
Posting StatusDrop down menu shows the Posting status. 
SourceDrop down menu shows the source like External source or Manual.
Created By:Lookup button to select the user.
DocumentLookup button to filter report by document. 
 
 

Philippines Reports

Sales Transaction Detail Report

Overview

This report lists all cash sales that were created during a specified period of time. Sales are printed in numerical sequence and display information to help users maintain accurate control over every cash sale that was created in the system, the report will allow filtering the information based in the most relevant columns of the report.

Navigation

Revenue Management ► Reports ►  Sales Transaction Detail Report

 

Sales Transaction Detail Report Field Description

FieldDescription
Fiscal YearThis field refers to fiscal year to which cash sales relates. It is mandatory to be filled up by user.
Fiscal Period FromAllows users to enter a single value or a range (from and to) of values based on fiscal year selection.
Fiscal Period ToAllows users to enter a single value or a range (from and to) of values based on fiscal year selection.
Transaction typeCash Sales is the default value and is in read only mode.
Workflow statusWorkflow status is shown. Available status: Created, Approval Requested, Approved, Rejected, Cancelled and All.
Posting StatusPosting Status is selected. It may be Saved, Temp Saved or All.
Temp Number FromStarting range of values for Temporary Voucher number.
Temp Number ToLast range of values for Temporary Voucher number.
Include customer without Customer TypeDisplays whether the filter is kept active or not.
Voucher Date FromStart date of range from when Voucher date shall be filtered for report generation.
Voucher Date ToEnd date of range from when Voucher date shall be filtered for report generation.
Customer TypeCustomer type is to be selected from lookup button.
Journal VoucherJournal Voucher to be selected from lookup button. 
Approved ByUser by whom the cash sales is approved.
Created ByUser by whom the cash sales is created.
CommentComment on the Cash details report.
CustomerCustomer is to be selected from lookup button.
Sort ByThe system will allow users to sort in ascending or descending order by attributes.

 

 

Customer Analysis Report

Overview

Customer Analysis Report allows user to analyze the amount of business organization has done with particular customers at the Chart of Accounts Table level. Report will display all the transaction related to Invoice, Debit Note and Credit Note.

Navigation

Revenue Management ► Reports ►  Customer Analysis Report

 

Customer Analysis Report Field Description

FieldsDescription
Fiscal YearFiscal Year, to which customer data relates, is selected.
Period FromUser selects Fiscal Period. Start date of the range for fiscal period for report generation purpose.
Period ToUser selects Fiscal Period. Start date of the range for fiscal period for report generation purpose.
CustomerUser selects Fiscal Period. End date of the range for fiscal period for report generation purpose.
StatusThis parameter is mandatory. Approved is the default value. Possible values are: Created, Approved, Rejected, Cancelled,Approval Requested and All.
CurrencyDomestic value is the default value. If General Parameter, System Acept Multi-currency transactions is False then this Currency will be Domestic and this report parameter will remain disabled (read only). Totals will be displayed only for Domestic Amounts.
ConceptDisplay a List of Concepts for the Current Chart of Accounts.
Period TotalsDisplays the period totals on the report.
Report TypeThe report may be in Summary or Detail mode. Summary would suppress the individual lines and only show the sub-totals for each grouping.
CommentComment on the report.

 

Bank Deposit Form Report

Overview

Report regarding Bank Deposit Form Report is generated from this screen.

Navigation

Revenue Management ► Reports ►  Bank Deposit Form Report

 

Bank Deposit Form Report Field Description

FieldsDescription
Treasury Bank AccountRelevant Treasury Bank Account related to Bank deposit form is selected in this field.
Deposit Number FromStarting number of the range of Bank deposit form number.
Deposit Number ToEnd number of the range of Bank deposit form number.
Deposit Date FromDate from when deposit shall be filtered for report generation purpose.
Deposit Date ToDate up to when deposit shall be filtered for report generation purpose.

 

Inadeh Report

Revenue Voucher Report

Overview

Report regarding Revenue Voucher is generated through this screen.

Navigation

Revenue Management  Reports  Inadeh Reports  Revenue Voucher Report

 

Revenue Voucher Report Field Description

FieldsDescription
Fiscal YearFiscal year to which revenue voucher relates.
Period LevelPeriod level relating to which report for revenue invoice to be generated.
Fiscal Period FromStart date of the fiscal period.
Fiscal Period ToEnd date of the fiscal period.
Bank Depositbank deposit Id to be entered in this field.
Is Revenue Invoice RangeWhether revenue invoice range is applicable for report generation purpose, gets mentioned.
Revenue Invoice FromStart Id number of the revenue invoice range.
Revenue Invoice ToEnd Id number of the revenue invoice range.
Voucher Date- From DateStart date of revenue voucher from when report for voucher to be generated.
Voucher Date- To DateEnd date of revenue voucher up to when report for voucher to be generated.
Workflow StatusWorkflow status of revenue voucher to be used for filtering data for report generation.
Voucher SourceVoucher Source to be selected. May be either External source, Manual or both.
Invoice TypeInvoice type to be selected for data filtering for report generation. It may be credit, cash or both.
Sort ByIn the way the data of the report is to be sorted, is to be selected here. It may be: Fiscal period, workflow status, etc.
Bank AccountBank Account for the revenue vouchers to be selected from lookup button.
CustomerCustomers to which the revenue voucher relates, is selected from the lookup button.