Skip Headers

Oracle Receivables: Golden Tax Adaptor for Mainland China User's Guide
Release 12.1
Part Number E13436-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Reports

This chapter covers the following topics:

Reports Overview

Golden Tax Adaptor provides XML Publisher-based analysis reports for reconciliation purposes. These reports are available:

Golden Tax Discrepancy Report

When you use the Golden Tax Adaptor, the application creates these types of data for invoices, credit memos, and debit memos:

You must identify discrepancies because VAT invoices are legal documents and the data in Oracle Receivables, especially VAT calculations, should match the data in the Aisino Golden Tax system. You can use the Golden Tax Discrepancy Report to identify the discrepancies between these two systems. This report identifies discrepancies between data in receivables, receivables data transferred into the Golden Tax Adaptor, and VAT invoice data imported from the Aisino Golden Tax system. Report output is an XML Publisher report that displays the discrepancies in separate headers and lines. You can use this report to reconcile the data and make adjustments.

In case of a discrepancy, the report displays the values from Oracle Receivables, the Golden Tax Adaptor, and the Golden Tax System in separate columns. The values in the Golden Tax system represent the VAT invoice data imported from the Aisino Golden Tax System into the Adaptor. If the invoice has been consolidated, in case of a discrepancy, the report separately displays the values from Oracle Receivables invoice and consolidation Golden Tax Adaptor invoice, consolidated Golden Tax Adaptor invoice and VAT invoice.

Parameters

Parameter Required Default Value List of Values
Export Batch Number From No - All existing export batch numbers
Export Batch Number To No - All existing export batch numbers greater than Export Batch Number From
Transaction Type No - Transaction types under classes Invoice, Debit Memo, and Credit Memo
Customer Number From No - AR Customer number in customer table (Type of Organization)
Customer Number To No Customer Number From AR Customer number in customer table (Type of Organization)
Customer Name No - AR Customer name in customer table (Type of Organization)
GL Period No - GL period without unopened status
GL Date From No - -
GL Date To No GL Date From -
Transaction Batch From No - Transaction Batch
Transaction Batch To No Transaction Batch From Transaction Batch
Transaction Number From No - AR transaction number
Transaction Number To No Transaction Number From AR transaction number
Transaction Date From No - -
Transaction Date To No Transaction Date From -
Document Number From No - AR document number
Document Number To No Document Number From AR document number
Original Currency No Functional currency Currency in GL
Primary Sales Person No - Sales Person Name from Sales Person definition

To run the Golden Tax Discrepancy Report

  1. From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Analysis Reports window.

  2. In the Name field, select Golden Tax Discrepancy Report from the list of values. The Parameter window appears.

    the picture is described in the document text

  3. Enter report parameters and click OK.

  4. Enter report settings and click Submit.

    the picture is described in the document text

    the picture is described in the document text

    The report displays the discrepancies within different sections for each receivables invoice:

Golden Tax Invoice Mapping Report

The Golden Tax Invoice Mapping Report prints the receivables invoice information and the corresponding VAT invoice information. This report groups all of the VAT invoices issued for a single receivables invoice and displays the amounts.

Parameters

Parameter Required Default Value List of Values
Tax Registration Number No - All tax registration numbers defined on the System Options window under the current Operating Unit
Transaction Source No - All AR transaction sources
AR Customer Name No - All customer names
Golden Tax Invoice Number From No - All GT invoice numbers stored in GTA
Golden Tax Invoice Number To No - All GT invoice numbers stored in GTA
Golden Tax Invoice Date From No Current date Calendar
Golden Tax Invoice Date To No Current date Calendar
AR Transaction Number From No - All AR transaction numbers stored in GTA
AR Transaction Number To No - All AR transaction numbers stored in GTA
AR Transaction Date From No Current date Calendar
AR Transaction Date To No Current date Calendar

To run the Golden Tax Invoice Mapping Report

  1. From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Analysis Reports window.

  2. In the Name field, select Golden Tax Invoice Mapping Report from the list of values. The Parameter window appears.

    the picture is described in the document text

  3. Enter report parameters and click OK.

  4. Enter report settings and click Submit.

    the picture is described in the document text

Golden Tax Invoice Consolidation Mapping Report

The Golden Tax Invoice Consolidation Mapping report provides the mappings between consolidation Golden Tax Adaptor invoices and consolidated Golden Tax Adaptor invoice. The report groups all of the consolidation Golden Tax Adaptor invoices for a single consolidated Golden Tax Adaptor invoice.

Parameter Required List of Values
GL Period Yes GL period excluding period in unopened status for ledger of the current Operating Unit
Customer Number from No All customer number
Customer Number To No All customer number
Customer Name From No All customer name
Customer Name To No All customer name
Consolidated Invoice Number From No All consolidated invoice number
Consolidated Invoice Number To No All consolidated invoice number
Invoice Type Yes Invoice Type

To Run the Golden Tax Invoice Consolidation Mapping

  1. From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Analysis Reports window.

  2. In the Name field, select Golden Tax Invoice Consolidation Mapping Report from the list of values. The Parameter window appears.

  3. Enter report parameters and click OK.

  4. Enter report settings and click Submit.

    the picture is described in the document text