- General Ledger
- Accounts Payable Previous Years
- Closing Accounting Year
- Consolidation Of Financial Statements and Accounting Institutions
- Differential Exchange Other Account
- Foreign Debt Exchange Differential
- Receivable Account Previous Years
- Statement Of Changes In Equity
- Sub Ledgers
- Support Entities
- Journal Entry Voucher
- Account Inquiry
- Reports
- Standalone General Ledger Rollover
FreeBalance Accountability Suite
Search
User login
English
Français
монгол
Português
EspañolStores and Commercial Advances Detail Report
Wed, 2019-07-24 07:13 — santoshkumar
Overview
This report shows the original amount for advance, required recovery and balance. Users can use report filters to generate the report as per their requirement.
A screenshot of the Stores and Commercial Advances Detail Report is available here. Image is shown as reference material; position and names for labels, fields and buttons are subject to the parameter, rendering control configuration and the installed revision.
Users access Stores and Commercial Advances Detail Report from within the menu through this navigation path: General Ledger ► Sub Ledgers ► Accountable Advances ► Reports ► Sri Lanka Reports ► Stores and Commercial Advances Detail Report.
Filters
The following table lists and describe all filter fields for the Stores and Commercial Advances Detail Report in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.
| Field | Description |
|---|---|
| Fiscal Year | It lists the fiscal years and allows users to select a fiscal year as a report filter. The current fiscal year is set as the default value. It is a mandatory field. |
| Period From | It lists the fiscal periods and allows users to select a fiscal period as a report filter. It is a mandatory field. |
| Period To | It lists the fiscal periods and allows users to select a fiscal period as a report filter. It is a mandatory field. |
| Workflow Status | It lists the workflow status and allows users to select it as a report filter. The values are restricted to:
|
| Advance Status | It lists and allows users to select the advance status from the list as a report filter. It has two value open and close. |
| Holder Name | It allows to browse and select the holder name using the lookup button. |
| Accounting Office | It allows to browse and select the accounting office using the lookup button. |
Visible Fields
A sample of the report is available here.The following table lists and describes all visible fields for the Stores and Commercial Advances Detail Report, in their default order. Note that some fields depend on Filters selection and the language of the report depends on the configuration of the system.
| Field | Description |
|---|---|
| Accountable Advance | |
| Code | Based on the filter criteria the accountable advance id shows in the report. |
| Holder Name | The account holder name to whom the advance has been issued. |
| Workflow | Workflow stage of the accountable advance. |
| Status | The advance status either open or close. |
| Amount | Domestic advance limit amount. |
| Advance Payments | |
| Voucher Date | Date of the voucher. |
| Advance Payments | Advance amount payment detail. |
| Status | The advance payment status. |
| Amount | The total domestic amount from expense voucher. |
| Total expenses against advances | |
| Voucher Date | Voucher date. |
| Total Expense against Advances | The total expense against the advance. |
| Amount | The total domestic credit amount. |
| Unutilized Advance Amount | The actual unutilized advance amount. |
Buttons
The following table describes actions associated with the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Stores And Commercial Advances Detail Report feature.
| Button Image | Description |
|---|---|
 | The pdf button allows users to generate the report in the pdf format. |
 | The Excel button allows users to generate the report in the excel format. This format is compatible with Microsoft Office 97-2003 or higher version. |
 | The Excel button allows users to generate the report in the excel format. This format is compatible with Microsoft Office 2003 or higher version software. |
 | This ODS button allows users to generate the report in ODS format. This format is compatible with spreadsheet software such as Microsoft Office, Open Office or Libre Office. |
 | This RTF button allows users to generate the report in RTF format. |
 | The Word button allows the users to generate the report in word format. This format is compatible with Microsoft Office 97-2003 or higher version. |
 | This ODT button allows users to generate the report in ODT format. This format is compatible with word processing software such as Microsoft Office, Open Office or Libre Office. |
 | The Lookup tool allows users to browse and select existing items. |