User Manual V1

Download as pdf or txt
Download as pdf or txt
You are on page 1of 10

Electronic Accounting Mexico

Page |1

Contents
1. Introduction:.............................................................................................................................................. 3
2. Prerequisites:............................................................................................................................................. 3
2.1 Guidelines for FSV Creation ................................................................................................................. 3
2.2 File Validation ...................................................................................................................................... 4
3. Report Usage: ............................................................................................................................................ 6
4. Tree output: .............................................................................................................................................. 7
5. File output: ................................................................................................................................................ 8

Page |2

1. Introduction:
The user guide describes the steps to be followed to use the solution for Mexico Electronic Accounting:
The process consists of generating following XML files:
1. Char of Accounts
2. Account Balances

2. Prerequisites:
2.1 Guidelines for FSV Creation
Ensure that you have defined chart of accounts using OB13 and generated a financial statement version
(FSV) based on Primary/country chart of accounts using OB58.
While creating an FSV, ensure the following:

Do not select the Item Keys auto. checkbox since the system automatically assigns an item key to
the FSV item

SAT code is maintained in the Item field (double click on the Item in FSE2)

Page |3

In case of non-assigned nodes, the entry in the Item field should be maintained as NA.

To identify nature of G/L accounts, the item text should start with D (for debit) or C (for credit).

2.2 File Validation


The following logical file names and path have to be created in order to enable the validation of physical
file names.
1> Go to Transaction FILE and maintain new logical file path as FI_RPFIMXEACCT_PATH

Page |4

2> Create Logical File name definition as FI_RPFIMXEACCT_FILE

3> Please refer to note 1497003 for additional information and instructions.

Page |5

3. Report Usage:
To generate the above mentioned XML file, execute Transaction Code FIGLMX_eACCT
With below parameters:

1> Enter Company Code, Fiscal year, FSV, Reporting period (Month).
a. Its possible to execute the report with multiple company codes, provided: VAT Number
and chart of Accounts of all the company codes shall be same.
2> Select the Primary Chart of Accounts radio button if you want to report accounting data on the
basis of primary chart of accounts
Select the Country Chart of Accounts radio button if you want to report accounting data on the
basis of country-specific chart of accounts
3> Account Group is provided as additional/optional field to further filter GL accounts.
4> In the File Selection group box, under File Type,
select either the Chart of Accounts or the Account Balance radio button
Provide Application server file path in File Name Parameter.
5> In case Account Balances is selected, provide ledger information also.

Page |6

a. Field account group will be visible only when Account balance is selected.

Based on your selection criteria, the system generates an appropriate XML file and a corresponding tree
output.

4. Tree output:
The details of respective FSV items appear under FSV Item Details node as shown below:

Note: - You can Expand/Collapse the entire node (using root node FSV Item Details) or
respective Sub-nodes using the expand/collapse buttons as highlighted below:
Report shows total debit / credit of all the GL accounts in FSV Item Details.

Page |7

5. File output:
Once you navigate back from tree output mentioned above, system navigates to the program to
download XML file to Presentation Server.
You can enter below mentioned parameters to download the file or chose to navigate back to
the report:
1. Enter the file name you specified on the selection screen of the Generate XML Files (Mexico)
program in the Source file field.
2. Enter ** (Generic DME Format) in the File Type field.
3. Enter data for the target file as required In the Character Set Conversion group box, select No
Character Set Conversion.

Note: In Character Set Conversion group box, either of the below options will work
Page |8

1. Choose No Character Set Conversion If your system is Unicode active


2. Choose Manual Entry of Code Page and specify Code Page 4110 in Target Code Page If
your system is not Unicode
How to find your system is Unicode?
In Menu Bar Navigate System -> Status, the below popup appears

Unicode System Yes: Choose option No Character Set Conversion


Unicode System No: Choose Manual Entry of Code Page and specify Code Page 4110 in Target
Code Page

Page |9

In case the report is executed in background, you can use the Payment Medium International - Load Data
Medium Exchange File to Disk program to download the generated file as described below:
1. On the SAP Easy Access screen, choose Accounting -> Financial Accounting -> General Ledger ->
Reporting -> EC Sales List -> General -> Payment Medium International - Load Data Medium
Exchange File to Disk.
2. Enter the file name you specified on the selection screen of the Generate XML Files (Mexico)
program in the Source file field.
3. Enter ** (Generic DME Format) in the File Type field.
4. Enter data for the target file as required.
5. In the Character Set Conversion group box, select No Character Set Conversion.

P a g e | 10

You might also like