Show TOC

Function documentationPurchase Ledger

 

You use this report to prepare a copy of the purchase ledger, which you file with the tax authorities, together with the VAT return.

The purchase ledger lists the vendor invoices that you have paid, together with the payment details, and shows how much VAT was levied on each. It also shows any input VAT that arises as the result of clearing down payments made by your customers; and any accounting documents that you have created manually to correct VAT amounts.

To access the report, on the SAP Easy Access screen, choose Start of the navigation path Accounting Next navigation step Financial Accounting Next navigation step General Ledger Next navigation step Reporting Next navigation step Tax Reports Next navigation step Russia Next navigation step Purchase Ledger. End of the navigation path

Prerequisites

You have:

Features

You can use the report to prepare an ALV list. When you are satisfied that the information in the list is correct, and you want to prepare a copy of the ledger for the tax authorities, you can generate an XML-based output file to include in the VAT return.

You can also print out the form in the old format (use versions per decrees 914 of 2009, 1137 of 2012 or 735 of 2014). When you do so, you must activate the line numbering function.

Selection

To improve performance, we recommend that you execute the report in the background.

On the selection screen, you can choose the version of the ledger. If you choose to prepare the VAT return 2015 version of the ledger, specify the VAT return type, calendar year, tax period and, for corrective VAT returns, correction number.

You can also specify whether you want to create additional sheets for the following purposes:

  • To list all those documents of the current fiscal period that reverse documents posted in the previous fiscal periods

  • To list the invoices that have not been posted in time and the fiscal period in which they should have been posted is already closed

  • To list credit memos that are used to reverse documents posted in a previous closed fiscal period

If you select the Create Additional Sheets indicator on the selection screen, the report creates additional sheets to list these documents as follows:

  • If you do not specify a closed fiscal period, the additional sheets list all the documents of the current fiscal period that reverse documents in any previous fiscal periods

  • If you specify a closed fiscal period, the additional sheets include only those documents that reverse documents in this closed fiscal period

If you have chosen to create a main VAT return, only the main sheet is included in the output. If you have chosen to create a corrective VAT return, only additional sheets are included.

If you want the report to include invoices that have not been posted in time and credit memos in the additional sheets, make sure that:

  • You fill in the Adjustment Document Type field

    In this field you need to enter the same document type that you defined for these types of documents (for more information, see Customizing for Sales and Purchase Ledgers). If you do not fill in this field, these documents will be placed in the basic sheet.

  • The header text of the credit memo contains a reference to the corrected document in the format “NNNNNNNNNNYYYY”, where “NNNNNNNNNN” is the number of the corrected document and “YYYY” is the year when the corrected document was posted.

  • The header text of the invoices, which have not been posted in time, contains a reference to itself in the format “NNNNNNNNNNYYYY”, where “NNNNNNNNNN” is the invoice number and “YYYY” is the year when the invoice should have been posted. In this case the document date of the invoice must fall into a closed fiscal period.

Note that when creating a corrective VAT return of the VAT Return 2015 version, you enter all periods that contained corrective VAT returns (including the current period) in the Posting Period fields of the main return. In the old format version, you only need to enter the current period in the Posting Period field.

If you want to use the drilldown functions in the output list, we recommend that you create an extract.

Extracts

When you run the report, you can choose to save the output into the database by creating an extract, which can be retrieved by the report later. This is especially useful when the report is set to create an extract and is executed in background. You can only generate XML-based output files from extracts.

To create an extract, select the Create Extract option under the Output Control group box and assign a name and a short description to it. To retrieve the extract, select the Read Extract option. To delete an extract, select the Delete Extract option.

When running the report without creating an extract, you can choose to compare the output with an existing extract by entering the name of the extract in the Compare with Extract field. When you run the report, documents that were not previously included in the extract will be highlighted.

Output

The report shows a list of invoices and the related payments, which it determines as described in Determination of Invoices and Payments.

If your accounts clerk made more than one payment for an invoice, the report shows each payment. If he entered two payments for the same invoice on the same day, however, the report only shows one payment.

If there is an alternative payer in the document, the report shows the alternative payer data instead of the vendor master data.

For imports, the list shows the goods' country of origin and the customs declaration number, as stored in the purchase order or FI-AP invoice. The report first checks for this information in the purchase order header, then the relevant purchase order item. Finally, it looks in the material or expense items in the FI-AP invoice. See also “Prerequisites” above.

The report does not show documents that you posted and reversed in the same period. However, it shows documents posted in the current period that reverse documents in the previous periods. The report can display and print these documents on additional sheets and in this case the basic sheet does not include these documents.