Russian payables reports

The payables report feature enables you to view the vendor general ledger turnover for finance entries with source type vendor. Also, in the form of a printed report. The following reports are also provided:

  • Vendor General Ledger Turnover (page 12407)
  • Vendor General Ledger Turnover (report 12451)
  • Vendor Accounting Card (report 12445)
  • Vendor Turnover (report 12444)
  • Vendor Posting Group Turnover (report 12443)
  • Vendor Entries Analysis (report 12446)
  • Vendor Reconciliation Act (report 14911)

Vendor general ledger turnover (page 12407)

The Vendor General Ledger Turnover page is an electronic window that shows the vendor turnover for general ledger accounts in the context of vendors.

Search for Vendor G/L Turnover to open the page. It shows vendor turnover amounts in local currency (LCY).

The lines of the window contain the information listed in the following table.

ColumnDescription
No.Select this column to enter the vendor number. This column isn't editable.
NameSelect this column to enter the vendor name. This column isn't editable.
Vendor Posting GroupSelect this column to enter the vendor posting group. This column isn't editable.
Starting Balance LCY, Debit Amount (LCY), Credit Amount (LCY), Ending Balance LCY, Net Change (LCY).Select this column to enter the balance at the beginning and the end of the period, debit amount, credit amount, and net change for the period. All amounts are shown in the local currency. The values of these columns are calculated for all the general ledger entries with the source type Vendor. These columns aren't editable.

The following procedure shows how to access the window with the option for the Vendor action.

Choose the Vendor action, choose the Vendor G/L Turnover action, and then choose the Card action (Shift+F5 keys) to view the vendor card for the selected line.

Vendor general ledger turnover report (report 12451)

The Vendor General Ledger Turnover report is used to analyze turnover and for analysis of the vendor account balances. This report is printed monthly, but can be printed for any given period.

The following procedure shows how to access the Vendor General Ledger Turnover report.

  1. Search for Vendor G/L Turnover, and open the page.
  2. Choose Print > G/L Turnover.

The Options FastTab contains the fields listed in the following table.

FieldDescription
Rounding PrecisionSelect this field to choose the required rounding precision such as 0.001, 0.01, 1, or 1000.
Blank zero valuesSelect this field to replace zero values with blanks during printing.
Skip zero linesSelect this field to exclude lines with zero values.

Vendor accounting card report (Report 12445)

The Vendor Accounting Card report provides the following information for all of a vendor's entries for a specific period:

  • Starting balance
  • Posting date
  • Document number
  • Description
  • Net change debit
  • Net change credit
  • Document type
  • Ending balance

This report is printed monthly and on the date of inventory, but can be printed for any given period.

The following procedure shows how to access the Vendor Accounting Card report.

  1. Search for Vendor G/L Turnover, and open the page.
  2. Choose Print > Accounting Card.

The Vendor FastTab includes vendor, posting group, dimension, agreement, and date filters. On the Options FastTab, select New Page per Vendor to print each vendor on a separate page.

Vendor turnover report (Report 12444)

The Vendor Turnover report is used to print the data about a vendor's entries for a specific period in the context of separate contracts (agreements). The system fills in the following information about the vendor:

  • Starting balance (debit or credit at the start of the period)
  • Net change (debit or credit)
  • Ending balance (debit or credit at the end of the period)

To access the Vendor Turnover report:

Choose the [Tell Me feature] icon, enter Vendor Turnover, and then choose the related link.

The Vendor FastTab of the request page contains the same fields as the Vendor FastTab of the Vendor General Ledger Turnover report. On the Options FastTab, you can specify the same format options as on the Options FastTab of the Vendor General Ledger report.

The Options FastTab contains the fields listed in the following table.

FieldDescription
Rounding PrecisionSelect this field to choose the required rounding precision such as 0.001, 0.01, 1, or 1000.
Replace zero values by blanksSelect this field to replace zero values with blanks during printing.
Skip accounts without net changesSelect this field to exclude lines without net changes within the period.
Skip accounts with zero ending balanceSelect this field to exclude lines with zero ending balances at the end of the period.
Skip zero linesSelect this field to exclude lines with zero values.

Vendor posting group turnover report (report 12443)

The Vendor Posting Group Turnover report is used to print information on the vendor's entries that are accumulated in the vendor posting groups. The printed data contains the following information:

  • Vendor posting group code
  • Vendor posting group name
  • Starting balance (debit or credit)
  • Net change (debit or credit)
  • Ending balance (debit or credit)

To access the Vendor Posting Group Turnover report:

  1. Search for Vendor Posting Group Turnover, and open the report.

  2. On the Vendor Posting Group FastTab of the request page, you can specify the vendor posting group code or a range of vendor posting group codes, depending on whether you want to print the report for one vendor posting group, or for a range of vendor posting groups.

  3. On the Options FastTab, you can specify the same format options as on the Options FastTab of the Vendor General Ledger Turnover report.

Vendor entries analysis report (report 12446)

The Vendor Entries Analysis report shows the vendor's liabilities at the beginning and at the end of the period, entry analysis, and invoice discharging. The printed data contains the following information:

  • Posting date
  • Document number
  • Document name
  • Type (payment, invoice)
  • Amount
  • Amount closed
  • Payment date

This report enables you to determine the invoice and payment interdependence, and it also shows closed entries, due invoices, partially discharged invoices, and vendor prepayment amounts.

To access the Vendor Entries Analysis report:

  1. Search for Vendor Entries Analysis, and open the report.

  2. On the Vendor FastTab of the request page, you can define the vendor number or a range of numbers, depending on whether you want to print the report for one vendor or for many vendors. On the Options FastTab, you can specify the format options listed in the following table.

    ParameterDescription
    Starting DateSelect this option to specify the start date of the period.
    Ending of periodSelect this option to specify the end date of the period.
    Report CurrencySelect LCY or Entry Currency for the report amounts.
    New Page For VendorSelect this option to print the data for each vendor on a separate page.

Vendor Reconciliation Act report (Report 14911)

The Vendor Reconciliation Act report shows the payments or liabilities of the vendor. This report is used for the reconciliation of mutual payments of contractors.

To access the Vendor Reconciliation Act report:

Search for Vendor Reconciliations, and open the report. Before you run it, configure C/V Recon. Act Template Code in General Ledger Setup. Choose OK to export the reconciliation to Excel.

The following levels of details are possible:

  • All
  • Partially
  • None

Full detail

If Show Details is All, the report includes the following data for each document for the current and previous periods:

  • Document number and the numbers of the documents connected with it.
  • The balance on each document (debit or credit)
  • Document date
  • Description

When Print Customer Data is selected, the report also includes the counterparty's corresponding data:

  • Document amount
  • Debit
  • Credit

Partial detail

If Show Details is Partially, the report displays the balance on each document for the current and previous periods, but doesn't display the connections to invoices, credit notes, and payments.

None

If None is selected as the detail level, the report shows the following information for each vendor:

  • The balance at the beginning of the period
  • Net changes for the period
  • The balance at the end of the period
  • Amount of the vendor liabilities
  • General managers' signatures

On the Vendor FastTab of the request page, you can define the vendor number or a range of numbers, depending on whether you want to print a report for one vendor or for many vendors.

Find free e-learning modules for Business Central here