Function documentationSales Ledger

 

You use this report to prepare a copy of the sales ledger, which you file with the tax authorities, together with the VAT return. The sales ledger lists the following documents:

  • Either all customer invoices issued or paid customer invoices only, depending on when you calculate the VAT liability

  • Down payments received

  • Zero-rated exports (see Exports)

  • Invoices in Sales and Distribution (SD) if you posted VAT from SD for goods in transit

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 Sales 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).

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 or adjust 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 or adjust documents in any previous fiscal periods

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

For documents of the current fiscal period that adjust invoices posted in the previous fiscal periods to be included in the additional sheets, make sure that the header text of the adjustment document 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.

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 a customer made more than one payment for an invoice, the report shows each payment. If your accounts clerk entered two payments for the same invoice on the same day, however, the report only shows one payment.

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 adjust or 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.