Using the Golden Tax Adapter (GTA)

Export Golden Tax Customer Data

A .txt flat file is created that contains all the selected customer information defined in the selection criteria on the Export Golden Tax Customer run control page.

See Export Golden Tax Customer Page

Export Golden Tax Identifier Data

A .txt flat file is created that contains all the selected Golden Tax identifier information defined in the selection criteria on the Export Golden Tax Identifier run control page.

See Export Golden Tax Identifier Page

Transfer Billing Invoices to the Golden Tax Adapter

You can transfer Billing invoices based on the Transfer Billing Invoices Run Control criteria to the Staged Billing Invoice tables. You need to transfer the entire Billing invoice to the Golden Tax Adapter. You cannot partially transfer Billing Invoices to the Staged Billing Invoice tables. Use the Transfer Billing Invoices page (RUN_BI_TR_STG) for specifying the criteria.

See Transfer Billing Invoices Page

Generate Golden Tax Adapter Invoices

Billing stage invoices data is extracted from the Billing stage tables. The invoice data is split based on the limitations enforced in Golden Tax system. See Set Up Golden Tax Options Page. You can then create the Adapter Invoice with a new batch number and an Adapter Invoice ID. Adapter Invoice header/lines are then inserted into the Adapter Invoice tables.

See Generate Adapter Invoices Page

Export Golden Tax Adapter Invoices

A .txt file is generated that contains all the user selected Adapter Invoice information. Selection criteria are defined on the Export Adapter Invoices page. The .txt flat file is then imported into the GT system and the invoice information within the flat file assists the user to generate GT invoices.

If companies need to pay VAT for exporting special goods controlled by the government, VAT invoices need to be issued from the GTA using the Chinese currency. In such cases, the export invoice in Billing might be in a foreign currency. The currency rate for those currency conversion must be regulated and confirmed with the Tax authorities before issuing the VAT invoice in the Golden Tax system. PeopleSoft must support the currency conversion from foreign currency to the Chinese currency and the different amount in the extract file. All reports must indicate both foreign and local currency when applicable.

See Export Adapter Invoices Page

Import Golden Tax VAT Invoices

Using the Golden tax VAT invoice import process, users can import the Golden Tax VAT invoice information into Golden Tax Adapter. It imports the Golden Tax generated flat file into Golden Tax Adapter.

See Import Golden Tax VAT Invoices Page

Run Discrepancy Report and Reconcile

You can check the discrepancy between the Adapter Invoice and the GT invoice by running the Golden Tax Discrepancy Report. The GT report examines the data in the Adapter Invoice tables and the GT tables to identify the discrepancies in data between Billing, GTA and GT invoices.

See Golden Tax Discrepancy Report Page

Transfer Billing Invoices to the Golden Tax Adapter Process

The following preconditions and post conditions must be met before and after the Transfer Billing Invoices to the Golden Tax Adapter process:

Preconditions

• The BILL_STATUS must be INV (Invoiced) in the Billing Invoice Header.

• The FINAL_CURCNV_FLG must be Y in the Billing Invoice Header.

• The currency code of either the Transaction Currency or the Base Currency must be CNY.

Post conditions

• The Staged Billing Invoice Tables must be ready to be updated in the GTA Workbench.

• The GTA_STATUS on the Billing Header Sibling table for all Billing Invoices, which are transferred to the GTA, must be set to T (Transferred).

• The Billing Staging Status on the headers for all the staged Billing Invoices must be set to Transferred, Rejected, Ignore, or Error.

• The Billing Staging Status on the lines for all the staged Billing Invoices must be set to Transferred, Rejected, Ignore, or Prorated.

Process Flow for Transfer Billing Invoices to GTA

Transferring of Billing Invoices to the GTA includes the following steps:

1. Data Copy from PeopleSoft Billing to the Staged Billing Invoice Tables.

   This step includes the following tasks:

   • Retrieve all the parameters on the Run Control page before performing the Data Copy action.

   • Enter the explicit selection criteria, which include Business Unit, From Customer ID, To Customer ID, From Invoice Date, To Invoice Date, From Invoice, To Invoice, Bill Type, and Bill Source.

   • Enter the implicit selection criteria. Consider the following points for implicit selection criteria:

     • The invoice must be finalized (BILL_STATUS = INV).

     • The invoice must be currency converted (FINAL_CURCNV_FLG = Y).

     • The invoice is not transferred to GTA (GTA_STATUS = BLANK).

     • The invoice is not running in any AE process (PROCESS_INSTANCE = 0).

     • The currency code of either the Transaction Currency or the Base Currency is CNY (BI_CURRENCY_CD = CNY or BASE_CURRENCY = CNY).

   • Select the Consolidated or Non-Consolidated option.

     Note: For Consolidated Invoices, transfer only the attached Consolidated invoices from Billing to the GTA. The consolidated header should not be transferred. For Non-Consolidated Invoices, transfer all the non-consolidated invoices from Billing to the GTA. The invoices attached to the consolidated header must satisfy the selection criteria.

   • Copy both the Transaction Currency and Base Currency related amounts from Billing to the GTA.

     • If both the Transaction Currency and Base Currency are CNY, the Pretax Invoice Amount in the Staged Billing Invoice Header is used to compare the Max Invoice Amount, which is defined in the Golden Tax Adapter Setup Options.

     • If the Transaction Currency is CNY and the Base Currency is not CNY, the Pretax Invoice Amount in the Staged Billing Invoice Header is used to compare the Max Invoice Amount, which is defined in the Golden Tax Adapter Setup Options.

     • If the Base Currency is CNY and the Transaction Currency is not CNY, the Pretax Invoice Amount Base in the Staged Billing Invoice Header is used to compare the Max Invoice Amount, which is defined in the Golden Tax Adapter Setup Options.

   • Validate data when copying data from PeopleSoft Billing to the Staged Billing Invoice Tables.

   • Map data from PeopleSoft Billing Invoice Header to Staged Billing Invoice Header.

   • Map data from PeopleSoft Billing Invoice Line to Staged Billing Invoice Line.

2. VAT Invoice Type Auto Classification.

   The VAT Invoice Type Defaulting consists of three levels: Setup Golden Tax Options, Golden Tax Customer, and Transfer Billing Invoices Run Control. You can retrieve the default Invoice Type from this hierarchy.

   Note: The VAT Invoice Type is a required field in the Golden Tax Adapter Setup Options. So, ensure that you specify the VAT Invoice Type for the staged invoices.

3. Staged Billing Invoice Data Conversion.

   The following fields need data conversion in the Staged Billing Invoice Header:

   • Customer Tax Registration Number

   • Customer Address/Phone

   • Customer Bank Account Name/Number

   • Supplier Tax Registration Number

   • Supplier Bank Account Name/Number

   • Supplier Address/Phone

   The following fields need data conversion in the Staged Billing Invoice Line:

   • Golden Tax Identifier

   • Model

   • Tax Denomination

   • PS Identifier Type

4. Staged Billing Invoice Discount Proration.

   If a Billing invoice has one or more single discount lines, use the discount proration to prorate these lines to other lines with positive amount. The discount proration must be processed in both the Transaction Currency and Base Currency. The single Discount Lines are only prorated to the invoice lines with the same VAT Rate.

The status of the transferred Billing Invoice (GTA_STATUS = T) is updated to avoid the re-transferring of the same Billing Invoices.

Validation for Transfer Billing Invoices to the GTA Process

Basic validations are performed for the selection criteria before transferring the invoices. You must correct all the errors to proceed with the process.

The invoices are rejected at the following scenarios:

The following error messages are displayed, when the selection criteria entered are incorrect:

Generate Golden Tax Adapter Invoice Process

The following preconditions and post conditions must be met before and after the Generate Golden Tax Adapter Invoice process:

Preconditions

• The Maximum Invoice Amount and Maximum Number of Invoices Line must be defined in the Set Up Golden Tax Options page.

• The Invoice Line Split option must be enabled or disabled in the Set Up Golden Tax Options page.

• GT Invoice Type of each invoice must be identified in the Transfer Billing Invoices to the GTA process.

• Separate discount lines should not exist in the invoice.

Post conditions

• Adapter Invoices are split as per the GT system limitations set on the Set Up Golden Tax Options page.

• GTA Status of the Billing Invoice is changed to Generated.

The process includes the following steps:

1. Extract Billing Stage Invoices data from the Billing Stage tables.

   Get the Billing stage data from the GTA Billing Stage table for executing the Adapter invoice preprocess and invoice generation.

2. Split the Billing Stage Invoice, if required, as per the GT system limitations.

   On the Set Up Golden Tax Options page, you can define the limitations for the Maximum Invoice Amount and the Maximum Lines of a single VAT Invoice at the Business Unit and Customer Level. If the total amount of the invoice exceeds the maximum amount limit or the number of invoice lines exceeds the maximum memo lines limit, you have to split the invoice into multiple VAT invoices.

3. Create Adapter Invoice with the new Batch Number and Adapter Invoice ID and insert the Adapter Header/Lines into the Adapter Invoice tables.

   When an original invoice is split into multiple invoices, a new invoice number and line number are auto-generated. The total amount and the total line number in the Adapter Invoice Header gets updated according to the new values.

   After an Adapter Invoice is created, this process validates the current Adapter Invoice to ensure that the Adapter Invoice is valid. The same validation rules for Adapter Invoice Workbench apply here. If the validation is successful, the status of the Adapter invoice changes to Draft. Otherwise, the status changes to Error.

Export GT Adapter Invoices to the Golden Tax Adapter Process

The following preconditions and post conditions must be met before and after the Export GT Adapter Invoices to the Golden Tax Adapter process:

Preconditions

• Ensure that PeopleSoft does not generate any duplicate VAT invoices from the GT system for Billing transactions.

• Set the status of the Adapter Invoice to Ready.

• Trigger the Adapter Invoice Export process from the Invoice Export Run Control page.

Post conditions

• Creates the flat file that contains the selected Adapter Invoice information in the PeopleSoft default output folder. You can review and download the exported file from Main Menu > Reporting Tools > Report Manager > Administration tab.

• Creates a Log file for validation errors.

• Updates the Adapter Invoice Status to Exported.

The Adapter Invoice Export process includes the following steps:

• Enter the required string at the beginning of the first line to export the Adapter Invoices.

• Enter the invoice header data of the next selected Adapter Invoice at the beginning of the next line.

• Enter the next Adapter Invoice line data related to the previously entered Adapter Invoice header at the beginning of the next line.

• Save the flat file in the required format.

• Exit the process.

Import GT VAT Invoices to GTA process

The following preconditions and post conditions must be met before and after the Import GT VAT Invoices to the Golden Tax Adapter process:

Preconditions

• Export GT VAT information to the flat file.

• Ensure that the flat file exists in the pre-defined directory.

Post conditions

• Imports GT VAT invoices information to the GT Invoice Header/Line tables.

• Changes the mapped flag of the current VAT Invoice to Y if the VAT Invoice is associated with the Adapter Invoice. Otherwise, the mapped flag is N.

• Changes the MATCH_FLAG in the GT Invoice Header and Adapter Invoice Header to Y if the GT Invoice Header matches with the Adapter Invoice Header. If the GT Invoice Line is matched with the Adapter Invoice Line, the MATCH_FLAG in the GT Invoice Line record and the Adapter Invoice Line record is updated to Y.

• Displays the Adapter Invoice details when the Adapter Invoice ID is clicked. The VAT Invoice ID displays the imported GT VAT invoice information. You can review the details and flag the invoices as Reviewed to prevent selecting the same invoices by the Discrepancy Report. The Reviewed field defaults to N.

Process Flow for Import GT VAT Invoices to GTA

The Import GT VAT Invoices to GTA process includes the following steps:

1. Import GT Flat file.

   Load the GT flat file to the GTA and insert the GT VAT Invoice information into GT Invoice tables. The import process loops each line of the current flat file. Next, you find the original Adapter Invoice of the GT Invoice and insert GT Invoice header/line data into the GT invoice Header/Line table.

2. Update GTA Invoice Status.

   Update the GTA Invoice status in the Adapter Invoice header. This process at once loops the temp table, which is loaded by Mapper, checks the association between VAT Invoice and Adapter Invoice, insert the VAT Invoice data into database, and updates the status of both the VAT Invoice and Adapter Invoice.

   Note: If the original GTA Invoice is not found, the import process ignores the current GT Invoice and selects the next GT Invoice.

   If the current GT Invoice is not existing in the GT Invoice Table, the process imports the GT invoice directly. If the current GST Invoice already exists in the GT Invoice Table, the import process deletes the old data and inserts the GT Invoice info into the GT invoice Header/Line tables. In these cases, the status is changed to Imported. After the status is updated to Imported, the auto match action can be performed.

   If the import process identifies the Cancel flag in the GT Invoice Header, the import process updates the GTA status of the original Adapter Invoice to GT cancelled.

   If there are multiple occurrences of the same Adapter Invoice inside the same VAT Invoice file, the last record is used to determine the status of the Adapter Invoice.

3. Auto match GT Invoices with GTA Invoices.

   After the original Adapter Invoice status is changed to Imported, the GT import process performs the auto match action. This process matches the GT Invoice Header with the Adapter Invoice Header and the GT Invoice Line with the Adapter Invoice Line. Before performing GT Invoice Line matching, the GT Invoice line must be merged with the corresponding discount line in the work record.

   • Auto match GT Invoice Header and Adapter Invoice Header

     Import process compares the field values of GT Invoice Header and Adapter Invoice Header. If all the key field values are similar, GT Invoice Header and Adapter Invoice Header can be flagged to Matched.

     The following table lists the fields to be matched:

     GT Invoice Header	Adapter Invoice Header
     Invoice Type	GT Invoice Type
     Net Amount	Invoice Amount
     Tax Rate	Tax Rate
     Tax Amount	Total Vat Amount
     Customer Name	Customer Name
     Customer Tax Registration Number	Customer Tax Registration Number

     If the GT Invoice Header is matched with the Adapter Invoice Header, the MATCH_FLAG in the GT Header and GTA Header is updated to Y.

   • Auto match GT Invoice Line and Adapter Invoice Line

     The following table lists the invoice line fields to be matched:

     GT Invoice Line	Adapter Invoice Line
     Product Name	GT Identifier
     Item Model	Item Model
     UOM	UOM
     Quantity	Quantity
     Unit price	Unit price
     Amount	GT Net Amount
     Tax Rate	Tax Rate
     Tax Amount	Tax Amount
     Discount Amount	Discount Amount
     Discount Tax Amount	Discount Tax Amount

   • If the next line of the current GT Invoice Line is a discount line, the import process merges the discount amount and discount tax amount into current line. The import process checks the next line (order by line sequence number) before auto matching a GT Invoice Line. Then it compares the values between VAT Invoice Line fields and Adapter Invoice Line fields.

   • If the current GT Invoice Line matches the Adapter Invoice Line, update the Adapter Invoice line seq field in the GT invoice line record.

   • If a VAT Invoice line is discount line, the match process ignores it.

If the import process cannot match the GT Invoice Line to the Adapter Invoice Line, an error messaged is displayed indicating that no data has changed after the match process completion.