Generating the OECD SAF-T Generic Extractor Report

To generate the OECD SAF-T Generic Extractor Report, from the OECD SAFT Generic Reporting (G7006) menu, select OECD SAF-T Generic Extractor Report (R705001). When you run the OECD SAF-T Generic Extractor report, the system validates and generates the SAFT XML file.

The JD Edwards EnterpriseOne system populates various sections of the OECD SAF-T report:

  1. Header Section

    The header section of the OECD SAF-T report includes company information, audit file information, information about the software company who is producing the file, and the selection criteria.

  2. Master Files Section

    The master files section includes:

    Master File Sections

    Description

    General Ledger Accounts

    This section prints the general ledger accounts details. The R705001 report identifies the transactions from the General Ledger Entries section to print the required details.

    Customers

    This section prints the required details related to the customer. The R705001 report identifies customer-related information from the Source Documents section and the General Ledger Entries section.

    Supplier

    This section prints the required details related to the supplier. The R705001 report identifies supplier-related information from the Source Documents section and the General Ledger Entries section.

    Tax Table

    The R705001 identifies the tax area or tax rate from the Source Documents section and the General Ledger Entries section, and retrieves information from the Work with Tax Area Additional Information program (P704008A) to print the details.

    UOM Table

    This section prints the UOM details. The R705001 report identifies item-related information from the Source Documents section.

    Movement Type Table

    This section prints the movement type details. The R705001 report identifies the transactions from the Movement of Goods section.

    Products

    This section prints the product details. The R705001 report identifies item-related information from the Source Documents section.

    Owners

    The R705001 report identifies company-related information from the processing option to print the details.

    Physical Stock

    This section prints the physical stock details. The R705001 report identifies item-related information from the Source Documents section to print the physical stock details.

    You must set up unit price in primary Unit of Measure (UOM) in the Cost Revisions program (P4105).

    Note: The R705001 report enables the mapping of multiple G/L trade accounts with a single customer/supplier. All the account balances will be accumulated and displayed under the Opening and Closing balances tag.
  3. General Ledger Entries

    The general ledger entries section lists the journal entries for the selected period. The R075001 report identifies the posted transactions from the Account Ledger table (F0911) to print the journal entry details.

    The system prints the tax information of the transaction if the transaction is created using the Journal Entries with VAT program (P09106).

  4. Source Documents Section

    The source documents section includes:

    Source Documents Section

    Description

    Sales Invoices

    This section prints the Sales and A/R transactions. The report retrieves the posted and non-void transactions from the Customer Ledger table (F03B11). The system considers a transaction line in the F03B11 table for printing sales order details if the Document Company (PKCO), Document No (DOCO), Document type (DCTO), and Line ID (LNID) fields are populated.

    Purchase Invoices

    This section prints the purchase and A/P transactions. The report retrieves the posted and non-void transactions from the Accounts Payable Ledger table (F0411). The system considers a transaction line in the F0411 table for printing purchase invoices details if the Document Company (KCOO), Document No (DOCO), Document type (DCTO), and Line ID (LNID) fields are populated.

    Payments

    This section prints the payment details of the posted and non-void transactions. The R075001 report retrieves the posted and non-void transactions from the Accounts Payable Matching Document Detail table (F0414) and the Receipts Header table (F03B13).

    Movement of Goods

    This section prints the movement of goods details of the transactions. The R075001 report retrieves the transactions from the Sales Order Detail table (F4211) or the Sales History table (F42119), and the Purchase Order Receiver table (F43121) to print movement of goods details.

    You must confirm shipment and complete the sales update process to include the sales transactions in the report. You must complete the voucher match process and purchase order receipt to include the purchase transactions in the report.

    See “Shipment Planning" in the JD Edwards EnterpriseOne Applications Transportation Management Implementation Guide to know the process of generating shipment number.

Note:
  • The system prints the details of only sales or purchase transactions for UOM Table, Products, and Physical Stock sections.

  • If the Tax Rate Area is available for the transaction, the system prints the Tax Information Block. The Tax Information Block is applicable to Sales Invoices, Purchase Invoices, General Ledger Entries, and Movement of Goods sections.

    The Tax Information Block is not applicable for the Payments section.