SAP Program RFUMSVHU - Add.List for Adv.Return for Tax on Sales/Purch.: Tax on Open Invoices

Purpose
Special procedure for the advance return for tax on sales/purchases inHungary. The report is also used in the United Kingdom.
As of 2008 in Hungary, companies can perform a VAT group which meansthat several companies can do their consolidated additional list foradvance return. The report enables the companies to create theconsolidated additional list for advance return with a VAT group ID andgenerates one form or file per VAT group instead of one for each companycode in the group.
This program creates a list of all open vendor invoices and displays thefollowing information for these invoices:

  • Invoice amount

  • Cleared portion of the invoice amount

  • Tax amount per tax on sales/purchases code or tax group

  • Cleared portion of tax amount per tax on sales/purchases code or tax
  • group
    Law in United Kingdom
    In report RFUMSVHU, the parameter Due Date for Net Paymentcomplies with the law effective in the United Kingdom since 01/01/2003.The following applies exclusively for the United Kingdom: The input taxmust be repaid to the tax authorities if the invoice has not been paidafter six months. The decisive date is the due date for net payment.
    If you enter the Due Date for Net Payment, the system displaysall documents whose due date for net payment is before this date.
    Example:
    You have made the following entries on the selection screen:
    Key Date:,,,,,,,,,,,,,,,,,,10/31/2002
    Due Date for Net Payment (for example, key date minus six months):,,04/30/2002
    Result: The system selects all documents where the due date for netpayment is before 04/30/2002.

    Prerequisites
    You have:

    • Created an advance return for tax on sales/ purchases


      • Implemented SAP Note 1038448: VAT Due Date: Reporting if you want
      • to use the VAT due date functionality
        If you want to create the additional list for advance return accordingto your VAT group(s), you make settings in Customizing, by choosingFinancial Accounting (New) -> General Ledger Accounting (New) ->Periodic Processing -> Report -> Sales/Purchases Tax Return ->
        • Define Tax on Sales/Purchases Groups, and enter your domestic VAT
        • group identifier
          You can additionally choose a leading company code and enter it in theOrgT/BKRS (Dominant Enterprise/Company Code) field. If youdo not define a leading company code, the system considers the firstcompany code you have entered in the VAT group as a leading companycode.
          • Assign Company Codes to Tax on Sales/Purchases Groups, and assign
          • a tax group to all your company codes in the Tax Group column
            If your company owns plants abroad, you make settings in Customizing, bychoosing Financial Accounting (New) -> Financial Accounting GlobalSettings (New) -> Tax on Sales/Purchases -> Basic Settings -> PlantsAbroad -> Activate Plants Abroad, and select the Plants abroadactivated? checkbox.

            Features

            Selection
            The program selects the documents for processing as a result of theiropen vendor items. The following selection criteria can be entered:

            • Vendor's account number

            • Company code

            • Search indicator/string

            • Key date for the open items

            • Fiscal year

            • Posting period

            • Posting date

            • Document date

            • Document type

            • Document number

            • Tax code, tax group

            • Special G/L indicator

            • Date of tax return

            • Time of tax return

            • Parameters for dynamic selections

            • You need to enter either the company code or the tax group and not bothat the same time. If you do not enter any of them, the report lists thedata for all the company codes.
              If you have selected the Plants abroad activated? checkbox asdescribed in Customizing, the following additional fields appear on theselection screen:
              • Country of Tax Return

              • If you enter an invalid country code, the system sends you an errormessage, and the execution of the report is not successful.
                The system lists all the items to which the same country code isassigned.
                • National Currency Instead of Local Currency

                • If you select this checkbox and you specified the country, the systemlists all the items in the national currency of the country to which thesame country code is assigned.
                  If you do not specify the country and you select the National CrcyInstead of Local Crcy checkbox, the report lists the open vendorinvoices in HUF (Hungarian forints).
                  If you want the invoices to be selected by the due date of VAT payments,enter the required date in the Tax Reporting Date field in theOther Selections group box. If you enter a tax reporting date,you must not specify a fiscal year in the Fiscal Year field.
                  Note:
                  After executing the report, you should manually set the ALV layout tolist either data for company codes or tax groups as follows:
                  • Execute the report

                  • Choose Change Layout and select the aggregate value(s) of the
                  • data according to which you want to list your data
                    • Choose Define Sort Order and select the corresponding data type

                    • Save your layout settings
                    • Standard_variants
                      This program is delivered with the list variant 1SAP.

                      Output
                      The program creates a basic list and an exception list of

                      • the open vendor items whose documents meet the selection criteria

                      • the relevant items for tax on sales/purchases in these invoices

                      • The basic list lists the documents
                        • that contain open or partially-cleared vendor credit items and

                        • that do not contain any vendor debit items

                        • The basic list includes the following data, per document:
                          • Company code

                          • Vendor credit items (payables)

                          • Partial payments

                          • Document number

                          • Reference

                          • Vendor's account number

                          • Vendor's name

                          • Information for each tax on sales/purchases code

                          • Name of tax
                            Tax base
                            Tax amount (open tax)
                            Partially-paid tax (cleared portion of tax which corresponds to therelationship between the invoice amount and the relevant partialpayment)
                            Local/national currency
                            No vendor information is provided for documents with different vendors.
                            You can configure the output lists to meet yourrequirements using ABAP List Viewer functions.
                            At the end of the list, a totals list shows the tax amounts and"partially-paid tax" in summarized form, by company code and tax code.This totals list cannot be changed using the ABAP List Viewer.
                            The exception list lists the documents
                            • that contain open or partially-cleared vendor credit items and

                            • also contain vendor debit items

                            • The program only produces an exception list if an exception occurs.
                              The exception list contains the following data:
                              • Company code

                              • Fiscal year

                              • Document number

                              • Document type

                              • Vendor's account number

                              • Vendor's name

                              • Tax code

                              • Name of tax

                              • Vendor items

                              • Partial payments

                              • Tax

                              • Local currency

                              • You can display documents from this list simply by double-clicking toselect. You can also use the ABAP List Viewer to configure the exceptionlist.

1601077Hungary: acquisition tax and reverse charge VAT (ESA-ESE)
1434776Hungary - EC Sales List and file format (10A60) - VAT 2010
1533216Documentation Updates - Tax Date
1038448VAT due date: Country specific Reporting + Migration Tool
1128047VAT law change in Hungary from 01.01.2008
1174467Adding full payment flag to sel. screen of RFUMSVHU report
1157727RFUMSVHU sign correction (LWSTE, LWBAS)
835685RFUMSVHU: Tax Base with Tax Exchange Rate (Hungary)
549037FAQ: Deferred tax on sales and purchases