Programme SAP RPCYERK3_MRQ_XML - Year End Reporting, Canada: Magnetic Media - MRQ XML

Title
Year End Reporting, Canada: MRQ Magnetic Media Filing in XML format

Purpose
The Magnetic Media Filing utility allows your enterprise to generatesubmissions of Year End data in XML format for reporting to le Ministèredu Revenu du Québec (MRQ). The resultant XML file(s) can be stored oncustomary storage media, such as diskettes or CD-ROM, which are in turnsubmitted to the appropriate authorities.
Magnetic Media Filing in XML format for original and amended formats issupported for the following two MRQ Year End forms:

  • Relevé 1 - Revenus d'emploi et revenus divers

  • Relevé 2 - Revenus de retraite et rentes
  • Prerequisites
    Before initiating Magnetic Media Filing, your enterprise must fulfillthe following requirements.
    Your enterprise must meet the same requirements that are established asa prerequisite for running the Year End Reportingutility.
    You are required to have generated Run IDs for the selected tax year,Tax Reporting Unit, and Year End form. These Run IDs are generated bythe Year End Reporting utility and subsequently stored in the Year EndReporting History Log. To access that log, select the Show runhistory function button in the Run parameters section of YearEnd Reporting.
    You have downloaded the MRQ XML schema(s) from the MRQ website.

    Activities
    In the Selection section:

    • Specify the tax year for which your enterprise must generate the
    • submission.
      • Specify the Run ID(s) that you wish to use to generate Magnetic Media
      • submissions. It is not possible to generate submissions for differenttax forms - for example, Relevé 1 and Relevé 2 - within the same XMLfile. You must therefore specify a combination of Run IDs that weregenerated for the same tax forms. You should not specify Run IDs thatwere generated for an Original form and for an Amendedform, as you cannot submit data for both Original and Amended formswithin the same file. For this purpose, you must run this utility twice- that is, once for Original submissions, and once for Amendedsubmissions.
        • Specify whether you wish to run the report in Test mode or
        • Production mode. By running the report in the latter mode, youinstruct the utility to set the status of the specified Run IDs to22. (This status code indicates that a Magnetic Media file thatis ready for submission has been generated for the Run ID.) Please notethat you should select only production Run IDs when you run theutility in Production mode. (In other words, do not attempt touse test runs to generate Magnetic Media files that are ready forsubmission.) For additional information, consult documentation for theTest run option.
          In the XML schema upload options section, specify the path fromwhich the system shall read the XML schema file. The following optionsare available; to choose the option you wish, select the correspondingradio button.
          • You can upload the schema from the Presentation server (that is,
          • the front end). With this option, you instruct the system to read theXML schema file either from your own computer or from any other fileserver on your Local Area Network.
            • Alternatively, you can upload the schema from the Application server

            • of your mySAP ERP HCM system.
              In the XML file download options section, specify the path towhich the system shall store the XML files it generates. The followingoptions are available; to choose the option you wish, select thecorresponding radio button.
              • You can download the file to the Presentation server - that is,
              • the front end. With this option, you can store the file either on yourown computer or on any other file server on your Local Area Network
                .
                • Alternatively, you can download the file to the Application server

                • of your mySAP ERP HCM system.
                  In the Type of data section, you specify:
                  • Type of data

                  • In the Transmitter data section, you specify:
                    • Transmitter data

                    • In the Acct. contact Data section, you specify:
                      • Accounting contact

                      • In the Relevé data section, you specify:
                        • Relevé data

                        • Once you have entered this data, we recommend that you save your entriesas a variant by selecting Goto -> Variants -> Save asvariant... By doing so, you will eliminate the need to re-enter thisdata every time your enterprise executes Magnetic Media Filing.

                          Output
                          Upon execution, the utility will generate an XML file using the paththat you specified among the selection parameters above.
                          In addition to XML file generation, this utility also performsvalidation of the XML file(s) generated in relation to the XML schema.

                          • If you run this utility in the foreground, then XML file validation is
                          • performed automatically. For an overview of the validation process,consult the corresponding program documentation
                            .
                            • If you run this utility in the background, then you must subsequently
                            • initiate XML file validation manually. To this end, choose ValidateXML file from the application toolbar, then initiate XML filevalidation as instructed in the programdocumentation.
                              Finally, if you elect to do so, you are at liberty to display a summaryof total reported amounts (at Business Number level) within the reportoutput. (The amounts displayed here are equivalent to the amounts thatare reported within the Summary section of the XML file.) Todisplay this summary, choose Business Number summary from theapplication toolbar of the report output.
                              • Note

                              • For background processing, the same summary will be sent to spool inlist format.

910340YE05: MRQ XML file updated with S/W authorization number
968806YE06: Master Note for Canadian Year End - 2006.
872770YE05: Master Note for Canadian Year End - 2005.
928015YE05: Additional checks added for RPCYERK0
912978YE05: Short dump while generating the XML file.
918070YE05: Errors during val. of XML files w/ spec.chars.
911230YE05: Short dump while generating MRQ XML file
901829YE05: MRQ XML schema revised on November 18, 2005
850816YE05: Mag. Media submissions to MRQ in XML format.