Advance holders reports

The following reports are available for advance holders in Russia.

• Advance holder balance report
• Advance holder transactions report
• Transaction settlements report
• Advance report
• Advance holder turnover register

These reports can be accessed by going to Accounts payable > Inquiries and reports > Advance holders inquiries and reports.

Advance holder balance report

The Advance holder balance report displays the balances of the amounts that are paid to or received from advance holders in an organization. Accountants generate this report periodically or daily to review and monitor the debts of an advance holder.

When you generate this report, the following parameters are displayed. You can use these parameters to filter the data that will be displayed on the report.

FastTab | Field	Description
Parameters | To date	Select the date on which to generate the advance holder amount balance report.
Parameters | Currency distribution	Select this check box to display the advance holder amount balance grouped by currency code.
Records to include | Worker ID	The identification number of the employee for whom the advance holder amount balance is displayed. If no employee is selected, then the report will include all employees.

Advance holder transactions report

The Advance holder transactions report displays the expense transactions of an employee and the amounts that are paid in advance to that employee. Accountants generate this report periodically or daily to review and monitor the advance transactions.

When you generate this report, the following parameters are displayed. You can use these parameters to filter the data that will be displayed on the report.

FastTab | Field	Description
Parameters | Main accounts only	Select this check box to display only main accounts in the report.
Records to include | Employee	The identification number of the employee for whom the transaction report is generated.
Records to include | Advance holder	The identification number of the advance holder for whom the transactions are posted.

Transaction settlements report

The Transaction settlements report displays cash refunds and advance amounts that are paid to an employee by the legal entity. Accountants generate this report periodically or daily to analyze transactions that occur in multiple currencies between an employee and the legal entity to calculate the debt balance of the employee.

When you generate this report, the following parameters are displayed. You can use these parameters to filter the data that will be displayed on the report.

Field	Description
Worker ID	Select the identification number of the employee for whom the transaction settlements report is generated.
To date	Select a date up to which the transactions are included on the report.
Real-time settlement	Select this check box to include real-time settlement transactions to the report.

Advance report

To print an advance report in a form that is legally required in Russia, you need to print the report after an advance invoice that is issued to an advance holder is settled. You need to select a particular advance report number to be included in the report.

Note

The amounts on the Advance report page are recalculated on the date when the payment journal for the advance holder is posted.

The Advance report will be print in Microsoft Excel format.

Advance holder turnover register

An additional report, Advance holder turnover register is available in General ledger > Inquiries and reports > Turnover balance statement.

When you generate this report, the following parameters are displayed. You can use these parameters to filter the data that will be displayed on the report.

Field	Description
Date interval code	Select the value of the period from the table of date intervals.
From date	Enter the start date of the period for generating the report. Manually select or insert from the selected code of interval dates.
To date	Enter the end date for the period for generating the report. Manually select or insert from the selected code of interval dates.
Currency type	Select the transaction's currency type from the list. These values can be used: Standard currency, Secondary currency, and Stated currency.
Currency	Enter the secondary currency of the transaction. This field is available if the currency type is Stated currency.
Main account	Enter the accounting record of employee advances for which the report will be generated.
Financial dimensions	Provide the dimensions codes if it is necessary to choose transactions with specific codes for the report. If the dimensions are not populated, the system will select transactions for the report having any dimension codes.
Print ranges	Set the option to display request conditions when printing the report.
Delete zero line	Set the option to not print zero lines or columns.
Total accounts	Set the option to print total accounts.
Show transactions	Set the option to display the transactions of advance holders.

In the Details and sorting parameters section, select the available fields to be included into the report. On the Records to include tab, define additional filtering conditions, if needed.

Additional resources

SQL Server Reporting Services Reports report