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

Golden Tax Process

This chapter covers the following topics:

Overview

This flowchart shows the key processes of the Golden Tax system:

the picture is described in the document text

The key processes for a typical workflow are:

Receivables Invoices

You can manually create receivables invoices, debit memos, and credit memos, or you can create them using auto-invoice in Oracle Order Management. Invoices must be in a Complete status before you can transfer them to the Golden Tax Adaptor.

the picture is described in the document text

After accounts receivable (AR) invoices are created, you can run the Receivable Transfer to Golden Tax Adaptor concurrent request.

Transferring Receivables Invoices to the Golden Tax Adaptor

The Receivables Transfer to Golden Tax Adaptor concurrent request transfers the receivables invoices, debit memos, and credit memos that are in Complete status to the Golden Tax Adaptor. You can set up transfer rules that identify specific invoices so that only the desired invoices are transferred. Transfer rules eliminate the need to specify different parameters each time you run the transfer program.

The Receivables Transfer to Golden Tax Adaptor concurrent program:

Parameters

Parameter Required Default Value List of Values
Transfer Rule Yes Primary Rule Name Transfer Rules LOV
Customer Number From No - Customer number in customer table (organization type)
Customer Number To No Customer Number From Customer number in customer table (organization type)
Customer Name From No - Customer name in customer table (organization type)
Customer Name To No Customer Name From Customer name in customer table (organization type)
GL Period Yes - 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

To transfer receivables invoices to the Golden Tax Adaptor

  1. From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Interface Programs window.

  2. In the Name field, select Receivables Transfer to Golden Tax Adaptor from the list of values, and click OK. The Parameter window appears.

    the picture is described in the document text

  3. Enter request parameters and click OK.

    the picture is described in the document text

To view output of the Receivable Transfer to Golden Tax Adaptor request

You can view summary and detailed output of the receivables invoices that were successfully transferred or invoices that failed to transfer. In case of failure, the reason for the failure appears.

  1. From the Golden Tax Adaptor responsibility, navigate to the Requests window. The Find Requests window appears.

    the picture is described in the document text

  2. Enter find request parameters and click Find. The Requests window appears and displays a list of requests.

    the picture is described in the document text

  3. Select the request that you want to view, and click View Output. The Receivable to Golden Tax Invoice Transfer XML Publisher report displays summary and detailed transfer information.

    the picture is described in the document text

    the picture is described in the document text

    Exception Messages

    The Receivables Transfer to Golden Tax Adaptor program identifies and reports these exceptions:

Golden Tax Invoice Workbench

You can use the Golden Tax Invoice Workbench to review the receivables invoices transferred from Oracle Receivables, and to make slight modifications to the data before exporting. You can also use the Golden Tax Invoice Workbench to track the VAT invoices and to manage invoice status. Folder functionality is enabled for the workbench, and you can set up the workbench columns according to your specific requirements.

To use the Golden Tax Invoice Workbench

  1. From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Invoice Workbench window. The Find Invoices window appears.

    the picture is described in the document text

  2. Enter search parameters and click Find. The system displays the Invoices window (Workbench). If you enter consolidated invoice number in Find Invoice window, the consolidation invoices that are consolidated to the consolidated invoice are retrieved.

    the picture is described in the document text

  3. The Golden Tax Adaptor creates a unique number, called the Transaction Number, for each split child invoice of the receivables invoice. When a single receivables invoice is split into multiple child invoices, each child invoice has a unique transaction number, although all of the child invoices belong to the same receivables invoice. In the Aisino Golden Tax System, separate VAT invoices are created for each invoice in the Golden Tax Adaptor.

  4. Invoice Status control is enabled for the invoices in the Adaptor to ensure better control of data modifications. Invoices can have the following statuses:

  5. the Consolidation Flag is used to indicate whether the Golden Tax Adaptor invoice is consolidated or is generated by consolidating other invoices. Consolidation is for Consolidation Golden Tax Adaptor invoices, and Consolidated is for Consolidated Golden Tax Adaptor invoices.

  6. The Bank Account Number appears in full or partially masked, depending on the setting of the profile option CE: Mask Internal Bank Account Numbers.

  7. Define the following actions on the workbench:

  8. View invoice lines by selecting a transaction and clicking Lines. The Lines window appears and displays the line details.

    the picture is described in the document text

  9. You can consolidate multiple invoices to a consolidated invoice based on a variety of consolidation rules. The selected invoices with same Tax Registration Number, Customer, Address and Telephone Number, Bank Name, Bank Account Number, and Invoice Type will be consolidated into one consolidated GTA invoice. Only lines with the same Item, Description, Model, UOM, Tax Code, and Tax Rate are eligible to be combined. The consolidated invoice cannot exceed the limits defined on System Options.

    Only one consolidated GTA invoice for the same Tax Registration Number, Customer, Address and Telephone Number, Bank Name, Bank Account Number, Invoice Type will be generated. For example, if the amount and the memo lines of the selected GTA invoices with the same Tax Registration Number, Customer, Address and Telephone Number, Bank Name, Bank Account Number, and Invoice Type exceed the limits, the selected GTA invoices that fail to consolidate are listed in the output with the error message.

    In case that there are both credit memos and positive invoices in selected GTA invoices, if the absolute value of total amount of credit memos exceeds the total amount of positive invoice with same Tax Registration Number, Customer, Address and Telephone Number, Bank Name, Bank Account Number, and Invoice Type in the selected GTA invoices, an error message appears. Also for this case, , the consolidated GTA invoice cannot include negative lines. For example, all lines in a credit memo should be offset by the lines in the positive invoice. If not, the system displays an error message.

    Consolidation Rules are:

    the picture is described in the document text

    Note: You can click OK to submit the consolidation, or you can click Cancel to cancel the consolidation.

    A new concurrent request will be created to consolidate the selected invoices based on consolidation rule you selected.

    You can view summary and detailed output of the invoices that were successfully consolidated, invoices that were successfully consolidated with warning, or invoices that failed to consolidate. In case of failure or success with warning, the reason for the failure or the warning appears.

  10. The consolidated Golden Tax Adaptor invoice can be unconsolidated from workbench. If the consolidated invoice is unconsolidated, then the consolidated invoice is deleted and the consolidation invoices is updated to status Draft.

  11. When you have made all adjustments and are ready to create the flat file for import into the Aisino Golden Tax System, select the desired invoices and click Generate in the Invoices (Workbench) window. The Generate window appears and displays the batch number. Click OK.

    the picture is described in the document text

    Note: If you selected manual numeric rule for VAT invoice batch, then you must enter a batch number when you click Generate. After you enter the batch number, you can click OK to submit the transfer, or you can click Cancel to cancel the transfer.

    A new concurrent request will be created to export the Invoice data in the Adaptor to a data file that can be imported into the Aisino Golden Tax System. However, if you do not have permission to view the complete bank account number according to the profile option; CE: Mask Internal Bank Account Numbers, then you cannot export the data to the file.

  12. View related VAT invoices by clicking View VAT Invoice. If you have not imported the VAT invoice, then the View VAT Invoice window will be blank.

    Note: You can also view VAT invoices by selecting View VAT Invoice from the Golden Tax Adaptor responsibility. See: Viewing VAT Invoices.

    the picture is described in the document text

    Exception Messages

    The Golden Tax Adaptor Consolidation program identifies and reports these exceptions:

Golden Tax Invoice Export

When data modifications are not required in the workbench before the invoice data is exported to a data file, you can directly export the data using the Golden Tax Invoice Export concurrent program. When you export from the Golden Tax Invoice Workbench, the application runs the same program. Only the invoices that are of same invoice type can be exported to a flat file. After you export invoices to a data file, the status of the selected invoices is updated to Generated. The output of the Golden Tax Invoice Export concurrent program is a data file, which you can save to any location. Then, you can import the data file into the Aisino Golden Tax system. To successfully export the data, you must have full access to view the bank account number according to the profile option which is CE: Mask Internal Bank Account Numbers.

Note: In order to export the data, using the Golden Tax Invoice Export concurrent program, the CE: Mask Internal Bank Account Numbers profile option must be set to No.

The application creates a new batch when the data is exported for each run. You can set batch numbering in the system options to Manual or Automatic. If you select manual numbering, then you must enter the batch number in the Parameters window. You can also regenerate the data file by selecting the Regeneration run option. Then, you must enter the batch number of the export that you regenerate.

Parameters

Parameter Required Default Value List of Values
Operating Unit Yes Current Operating Unit Refer to MOAC
Generation Option Yes New Batch New Batch and Regeneration
Transfer Rule No - All transfer rules per selected Operating Unit
Export Batch Number No Max batch number plus 1 for Automatic Batch number. Blank for Manual Batch Numbering -
Customer Number No - -
Customer Name No - -
Taxpayer ID No - -
AR Transaction Number From No - -
AR Transaction Number To No - -
AR Transaction Date From No - -
AR Transaction Date To No - -
AR Transaction GL Date From No - -
AR Transaction GL Date To No - -
AR Transaction Batch From No - -
AR Transaction Batch To No - -
Transaction Class No - -
Generated Batch Number Yes if Generation Option is Regeneration - All existing Batch ID according to Operating Unit selected
Invoice Type Yes 0 - Special VAT Invoice 0 - Special VAT Invoice
1 - Recycle VAT Invoice
2 - Common VAT Invoice

To export Golden Tax invoices

  1. From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Interface Programs window.

  2. In the Name field, select Golden Tax Invoice Export from the list of values. The Parameters window appears.

    the picture is described in the document text

  3. Click OK to return to the Golden Tax Interface Programs window.

  4. Click Submit.

    the picture is described in the document text

To view request output

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

  2. Select your Golden Tax Invoice Export request and click View Output. This example illustrates the flat file that is created:

    the picture is described in the document text

    Exported fields and validations are:

    Field Mandatory for Specific VAT Invoice? Mandatory for Recycle VAT invoice? Mandatory for Common VAT invoice? Length limitation Header or Line Level
    Document number Yes Yes Yes 20 Header
    Line quantity Yes Yes Yes 4 Header
    Customer name Yes Yes No 100 Header
    Customer taxpayer ID Yes Yes No 15 Header
    Customer address and phone number Yes Yes No 80 Header
    Customer bank account Yes Yes No 80 Header
    Goods name Yes Yes Yes 60 Line
    UOM No No No 16 Line
    Model Yes Yes Yes 30 Line
    Quantity No No No 16.6 Line
    Net amount Yes Yes Yes 14.2 Line
    Tax rate Yes Yes Yes 4.2 Line
    Tax denominations Yes Yes Yes 4 Line
    Discount amount No No No 14.2 Line

    The export program performs these validations:

Golden Tax Invoice Import

After you successfully create and print VAT invoices from the Aisino Golden Tax System, you can then import VAT invoice information from the Aisino Golden Tax system. You can import this VAT invoice data into the Golden Tax Adaptor using the Golden Tax Invoice Import program. When you import this data, the invoices data in the Golden Tax Adaptor is updated with the corresponding VAT invoice data, such as VAT invoice number, date, VAT amount, and so on. When the VAT invoice data is successfully imported against an invoice in the Adaptor, the status of the invoice changes to Completed. The output of the report is an XML Publisher report that summarizes the VAT invoices imported into the Adaptor successfully and displays an exception message for any failure.

To import VAT invoices

  1. From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Interfaces Programs window (Request Set.)

  2. In the Request Set field, select Golden Tax Invoice Import.

    the picture is described in the document text

  3. In the Parameters field, enter the path of the flat file that is to be imported. The path entered on the profile AR: Golden Tax Import Directory is provided by default for this parameter. You can override the default.

  4. Click Submit.

To view Golden Tax Invoice Import request output

  1. From the Golden Tax Adaptor responsibility, navigate to the Requests window from the View toolbar.

    the picture is described in the document text

  2. Select your request and click View Output. The XML report appears. This example illustrates the result of the VAT Invoice Import request.

    the picture is described in the document text

Viewing VAT Invoices

Use the View VAT Invoice window to view the VAT invoices imported from the Aisino Golden Tax system and the corresponding receivables Invoice.

Parameters

Parameter Required Default Value List of Values
Operating Unit Yes Default Operating Unit LOV from the security profile definition Default OU from system profile: MO: Default Operating Unit
Tax Registration Number Yes - -
Customer Name No - LOV: from all the customer names that exist in GTA table whose source is GT
Customer Tax Registration Number No - LOV: from all the taxpayer ID that exist in GTA table whose source is GT
Receivables Transaction Numbers No - -
VAT Invoice Numbers No - LOV: from all the VAT invoice numbers that exist in GTA table whose source is GT
Invoice Dates No - -
Total Amounts No - -
Status No - -

To view VAT invoices

  1. From the Golden Tax Adaptor responsibility, navigate to the Find VAT Invoices window.

    the picture is described in the document text

  2. Enter VAT invoice search parameters and click Find. The View VAT Invoice Summary window appears.

    the picture is described in the document text

    In this window, all fields are protected from update and you cannot create new records.

    When you select a VAT invoice and click View GTA Invoice, the Golden Tax Invoice Workbench window appears and displays the related Golden Tax Adaptor invoice information.

    the picture is described in the document text

    When you select a VAT invoice and click Open, the View VAT Invoice window appears and displays VAT invoice details.

    the picture is described in the document text

    This window displays the same information as the VAT Invoice window opened from the Golden Tax Invoice Workbench. In this window, you can also click View GTA Invoices to find and view the related Golden Tax Adaptor invoice.

To view VAT invoices from receivables transactions

You can also view VAT invoices from the Receivables Transaction window.

  1. Navigate to the Action Menu and select View VAT Invoice.

    the picture is described in the document text

  2. View all corresponding VAT invoices against this receivables invoice. Drill down to the VAT invoice lines, or view the corresponding Golden Tax Adaptor invoice.

    the picture is described in the document text

Golden Tax Invoice Purge

As data in the Golden Tax Adaptor accumulates over time, the performance of inquiries and reports can deteriorate. You can delete obsolete data that you no longer need to maintain in the system by using the Golden Tax Invoice Purge concurrent request. This concurrent request checks the receivables tables to ensure that the corresponding receivables invoice information is also purged before it purges the data in the Golden Tax Adaptor.

Parameters

Parameter Required Default Value List of Values
Operating Unit Yes - All Operating Units assigned to current user
Customer name No - All customer names
Transaction GL date from Yes - Closed GL period dates
Transaction GL date to Yes - Closed GL period dates

To purge Golden Tax Adaptor invoices

  1. From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Interface Programs window.

  2. In the Name field, select Golden Tax Invoice Purge from the list of values and click OK. The Parameters window appears.

    the picture is described in the document text

  3. Enter request parameters and click OK.

  4. From the Golden Tax Interface Programs window, enter request settings and click Submit.

    the picture is described in the document text

Credit Memo Process

When a credit memo is issued to a customer, it must be processed through the Aisino Golden Tax system, just as an invoice is processed, and a value-added tax (VAT) invoice must be generated. The validations are different between credit memo reference to Common VAT Invoice and credit memo reference to Recycle VAT Invoice or Special VAT Invoice. A credit memo can be issued against one VAT invoice or multiple VAT invoices in Golden Tax system, and a credit memo can reference to one VAT invoice or multiple VAT invoices.

The Receivables Transfer to Golden Tax Adaptor process performs these additional validations when a credit memo reference to Common VAT Invoice is transferred to the Adaptor:

Once the credit memo is transferred to the Adaptor, the remaining processes for generating VAT invoices are similar to those for generating regular invoices.

Handling Exception Scenarios

This section provides details for handling some of the exception scenarios that you encounter.

VAT Invoice Cancellation

After you create a VAT invoice and import it into the Golden Tax Adaptor, you might need to cancel this VAT invoice and issue a new VAT invoice in its place. In the Aisino Golden Tax system, you can cancel a VAT invoice and create a new VAT invoice against the same imported data. However, you cannot import this VAT invoice into the Golden Tax Adaptor because the corresponding Adaptor invoice already has a VAT invoice against it. Therefore, you must first delete the VAT invoice number using the Golden Tax Invoice workbench and then re-import the new VAT invoice number.

You might have to cancel the VAT invoice in the Aisino Golden Tax system because of a printing error. If the VAT invoice is not yet imported back into the Adaptor, then no additional action is required. When a new VAT invoice is generated, you can import it directly into the Adaptor. Cancelled VAT invoices cannot be imported into the Adaptor.

Failure to Import Into the Aisino Golden Tax System

When you import the data file exported from the Adaptor into the Aisino system, the import might fail for some invoices. If this failure occurs, go to the Golden Tax Invoice Workbench and change the status of the invoice from Generated to Failed. When you identify the reason for failure, you can change the status from Failed to Draft, make modifications on the workbench, export the invoice to a data file, and then import this data file into the Aisino system.