Setup

This chapter covers the following topics:

Overview of Setting Up the Golden Tax Adaptor

The following flow shows the required setup for implementing the Golden Tax Adaptor.

the picture is described in the document text

Key setup steps include:

Setting Profile Options

You must enable the following profile options:

  User Sys Admin Sys Admin Sys Admin Sys Admin    
Profile Option User User Resp App Site Required Default Value
AR: Golden Tax Enabled - - - - Yes Yes No
AR: Golden Tax Import Directory Yes Yes Yes Yes Yes No -
CE: Mask Internal Bank Account Numbers Yes Yes Yes Yes Yes No -
Yes You can update the profile option
- You can view the profile option value but you cannot change it.
No You cannot view or change the profile option value.

AR: Golden Tax Enabled:

This profile must be set to Yes to use the Golden Tax Adaptor feature. You can update this profile option at the site level only.

Yes: Enables the Golden Tax Adaptor

No: Disables the Golden Tax Adaptor

AR: Golden Tax Import Directory

Use the Golden Tax Import Directory profile option to define the default path of the VAT invoices data file that is received from the Aisino Golden Tax System. The path you specify here is defaulted when you run the Golden Tax Invoice Import program, and it can be overridden. You can update this profile option at all levels.

CE: Mask Internal Bank Account Numbers

Use the CE: Mask Internal Bank Account Numbers profile option to mask bank account numbers on Golden Tax invoice workbench and Golden Tax Discrepancy report. If you want to use the Golden Tax Invoice Export concurrent program to export data, the CE:Mask Internal Bank Account Numbers profile option must be set to No.

You can update this profile option at all levels.

Related Topics

See: Setting User Profile Options, Oracle Applications System Administrator's Guide and Defining Preferences with User Profile Options, Oracle Applications System Administrator's Guide.

Setting Up Descriptive Flexfields

The Chinese VAT regime classifies items by the following attributes:

For creating the VAT invoice, these attributes are optional. If tax denomination is not entered on receivable transaction line or inventory item, then “0” is defaulted during the transfer. If needed, you can also update tax denomination and item model using the Golden Tax Invoices workbench.

Descriptive flexfields for Inventory Master Items and Receivables Line Transactions can be configured to capture these attributes. You can assign any two attributes of these flexfields for this purpose. Once the flexfields are configured, you can enter the values when new items are created, or when receivables transactions are entered. When available at both levels, the system uses the attributes entered on the receivables transaction line. For a receivables transaction that is created for a non-inventory item, the descriptive flexfield at the AR transaction line level becomes very useful.

To define the inventory item descriptive flexfield

  1. From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.

  2. In the Applications field, select Inventory (Items).

  3. Select an existing context or define a new context.

    the picture is described in the document text

  4. Click Segments. System displays the Segments Summary window. In the Segments window you can assign any two attributes to define Item Model and Tax Denomination.

    the picture is described in the document text

  5. Save your work.

  6. Freeze the flexfield and compile.

To define the Receivables Invoice Line Information descriptive flexfield

  1. From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.

  2. In the Applications field, select the Receivables Invoice Line Information.

  3. Select an existing context or define a new context.

    the picture is described in the document text

  4. Click Segments. System displays the Segments Summary window. In the Segments window you can assign any two attributes to define Item Model and Tax Denomination.

    the picture is described in the document text

  5. Save your work.

  6. Freeze the flexfield and compile.

Defining Item Cross-References

You can use the item cross-reference feature in Oracle Inventory to define item descriptions in the Golden Tax System. This is useful when the item description that must be printed on the VAT invoice is different than the internal item description. When receivables invoices are transferred to the Golden Tax Adaptor, the item description from the cross-reference is transferred and printed on the VAT invoice.

To define item cross references

  1. From the Inventory responsibility, navigate to the Cross Reference Types window.

  2. Enter a new cross-reference type or an existing type.)

    the picture is described in the document text

  3. Click Assign. The Assign Cross References window appears.

  4. Select an Item and enter a Value (required).

    the picture is described in the document text

  5. Save your work.

Setting Up Flexible Address

Flexible Address Formats let you enter and validate addresses in the country-specific format. Following are the setup steps you need to perform to implement this feature to support customer address in Chinese. You need to assign China to the Address Style field and implement Flexible Addresses for the Address Alternate Name field.

To assign address styles

  1. Navigate to the Countries and Territories window.

  2. Query China.

  3. In the Address Style field, select China.

  4. Save your work.

    the picture is described in the document text

To set up flexible address formatting

  1. Navigate to the Descriptive Flexfield Segments window.

  2. In the Title field, query the Address descriptive flexfield.

  3. In the Context Field Values region, select the CN (Chinese Address Style) code.

  4. Click the Segments button.

    the picture is described in the document text

  5. In Segment Summary window, in addition to other segments, add the Alternate Address segment and ADDRESS_LINES_PHONETIC column. For example:

    the picture is described in the document text

  6. Save your work.

  7. Freeze the flexfield and compile.

Setting Up System Options

Use the System Options window to define setup information for each operating unit.

The Chinese VAT regime enforces limitations for maximum amounts and maximum memo lines for all VAT invoices. Therefore, if an AR invoice exceeds these limits, then it must be split into multiple VAT invoices. You can define these limitations in the System Options window.

To define system options

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

  2. Select the Golden Tax tab and enter data in the following fields:

    the picture is described in the document text

    • Tax Registration Number: This is the transaction tax registration number of the business establishment that is issuing the VAT invoice. In Oracle E-Business Tax, you can define the tax registration number for a business establishment. A business establishment can be a legal entity, an operating unit, an inventory organization (warehouse), or a location.

    • Invoice Type: Select one of the following VAT invoice types:

      • Special VAT Invoice: When a sale is made to a General Taxpayer, the Special VAT Invoice is issued.

      • Common VAT Invoice: If the sale is made to a Small Scale Taxpayer, the Common VAT Invoice is issued.

    • Max Amount: The maximum amount allowed on a single VAT invoice. This limit is specified by the Chinese VAT regime for the business establishment with the specified tax registration number.

    • Max Memo Line: The maximum lines allowed on a single VAT invoice. This limit is specified by the Chinese VAT regime for the business establishment with the specified tax registration number.

    • Currency Code: This value indicates the currency in which VAT invoices will be issued. Receivables invoice amounts in any other currency will be converted to this currency before they are transferred to the Golden Tax Adaptor. The maximum amount limit is applied to the converted amount.

    • Tax Type: This value indicates the Chinese VAT tax type. In China, VAT invoices must be created only when VAT is applicable; VAT invoices are not generated for other tax types. Receivables invoices with tax lines belonging only to this tax type are transferred to the Golden Tax Adaptor.

    • Split Transaction Line indicator: This attribute indicates how a receivables invoice should be split when the invoice amount exceeds the maximum amount limit. If the attribute is selected, then an invoice line is split and distributed between two child invoices. Otherwise, the entire invoice line is moved to the next child invoice. This example shows a receivables invoice with two lines:

      Line No. Line Amount (CNY)
      1 6000
      2 7000

      The maximum amount limit is 10000 CNY. In this example, if the attribute is selected, then the invoice is split into two child invoices as shown by these examples:

      1st Invoice:

      Line No. Line Amount (CNY)
      1 6000
      2 4000

      2nd Invoice:

      Line No. Line Amount (CNY)
      1 3000

      If the attribute is not selected, then the entire line amount (7000 CNY) is shifted to the second child invoice. However, if the invoice line amount itself exceeds the maximum amount limit, then it is always split.

    • Allow Unit Price Exceeding VAT Amount Limit: This attribute indicates whether a transaction line should be split when its unit price exceeds the maximum amount limit. If the attribute is selected, a transaction line can be split to several invoices when unit price exceeding VAT amount limit, otherwise the invoice is not transferred and an exception is generated. User can choose split line by quantity or by unit price if the attribute is selected. If split by quantity, the unit price won’t be changed; if split by unit price, the quantity won’t be changed. This example shows a receivables invoice with two lines:

      Line No. Item Quantity Line Amount (CNY)
      1 1 6000
      2 1 12000

      The maximum amount limit is 10000 CNY. In this example, if split by quantity, then the invoice is split into two invoices as shown by these examples:

      1st Invoice:

      Line No. Item Quantity Unit Price (CNY Line Amount (CNY)
      1 1 6000 6000
      2 .33333333 12000 4000

      2nd Invoice:

      Line No. Item Quantity Unit Price(CNY) Line Amount (CNY)
      1 .66666667 12000 8000

      If split by unit price, then the invoice is split into two invoices as shown by these examples:

      1st Invoice:

      Line No. Item Quantity Unit Price (CNY Line Amount (CNY)
      1 1 6000 6000
      2 1 4000 4000

      2nd Invoice:

      Line No. Item Quantity Unit Price(CNY) Line Amount (CNY)
      1 1 8000 8000
  3. Select the Batch Numbering tab.

    the picture is described in the document text

  4. Select Automatic or Manual for batch number entry. This batch numbering refers to the batches created when the Golden Tax Adaptor data is exported to a data file from the workbench or when using the Golden Tax Invoice Export concurrent program.

  5. Select the Item Source tab and enter the following attributes:

    the picture is described in the document text

    • Item Name: In this region, define whether the item cross reference functionality is applicable, and indicate how the item description that prints on the VAT invoice is derived.

      • Item Description From Receivables Transaction: If you select this radio button, then the item description on the receivables transaction line is transferred to the Golden Tax Adaptor. For receivables transaction lines for non-inventory items, the description on the transaction line is always transferred.

      • Cross Reference: Select this radio button if the item description from the item cross references should be transferred to the Golden Tax Adaptor.

      • Cross Reference Type: Select the cross reference type to specify which item description is to be printed on the VAT invoices.

      • Master Item Description If No References Exist: This is applicable if you have selected that the cross reference should be used, but you have not defined the cross reference for an item. Select this check box if you want to transfer the item description on the master item. If a cross reference is not defined for an item and this attribute is not selected, then that receivables invoice is not transferred to the Golden Tax Adaptor, and an exception message displays on the report that is created when you run the Receivables Transfer to Golden Tax concurrent program. You can then define a cross reference for the specific item and run the transfer.

      • Latest Reference If Multiple References Exist: This is applicable when you have selected the cross reference radio button, but a specific item has multiple cross references defined against it under the cross reference type indicated in this window. If this check box is selected, then the most recent cross reference is transferred to the Golden Tax Adaptor. When multiple cross references exist for an item and this check box is not selected, then that receivables transaction is not transferred to the Golden Tax Adaptor, and an exception message displays on the report that is created when you run the Receivables Transfer to Golden Tax concurrent program. You can resolve the exception by deleting the invalid cross references and run the transfer.

    • Item Model and Tax Denomination: In this region, define the contexts and attributes of the Inventory Item Descriptive flexfield and the Receivables Invoice Line Information descriptive flexfield that are configured for capturing and storing these additional Golden Tax attributes:

      • Item Model

      • Tax Denomination

      These attributes are optional for generating VAT invoices. You can set up these flexfields, as needed.

Setting Up Transfer Rules

You can set up transfer rules to define the filter criteria for your transfer of receivables invoices to the Golden Tax Adaptor. You can define multiple transfer rules within an operating unit. You can set up one rule as the primary rule that is provided by default when you run the transfer program.

To set up transfer rules

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

    the picture is described in the document text

  2. Select an Operating Unit (required.)

  3. Enter a Rule Name (required.)

  4. Select the Primary Rule check box if this is the primary rule. You can have only one primary rule that is effective in an operating unit. The primary rule is provided by default when you run the Receivables Transfer to Golden Tax process.

  5. Select the Sales List Enabled check box to create sales list VAT invoices. If you select this check box, then you are not required to split the receivables transaction according to the maximum lines limit.

  6. Enter a description.

  7. Enter Effective Dates (required.)

  8. Select the Invoice Type. You can define a transfer rule for all invoice types or a specific invoice type.

  9. Exclude or include specific receivables transaction types. If you include a specific transaction type, then only the receivables transactions with that transaction type are transferred to the Golden Tax Adaptor. If you exclude a specific transaction type, then all receivables transactions except those that belong to this transaction type are transferred.

  10. Select the Descriptive Flexfield tab.

  11. On the Descriptive Flexfield tab, set transfer rules using the Receivables Transaction Information Flexfield attributes. Similar to the Transaction Type in step 8, you can exclude or include specific flexfield contexts and attributes.

  12. Select the Currency tab.

    the picture is described in the document text

  13. You can define the transfer rule based on invoice currency. You can select to transfer invoices that are created in a specific currency or in all currencies. For example, if you are working with a foreign currency and you set this to Non-Golden Tax Currencies, then only foreign currency invoices using this rule are transferred.

  14. Save your work.

Defining Customer Taxpayer Type

You can specify the Customer Taxpayer Type at Customer or Customer Site level. The Taxpayer Type defined at Customer Site level has higher priority than the one specified at Customer level.

To Define Customer Taxpayer Type

  1. From the Receivable responsibility, navigate to the Tax Profile tab for the customer.

    the picture is described in the document text

  2. In the Associated Fiscal Classifications region, click the Add Another Row button and add Fiscal Classification Type code ‘AR_GTA_FISCAL_TAXPAYER_TYPE’

    There are two Fisical Classification codes; AR_GTA_GENERAL_TAXPAYER and AR_GTA_SMALL_SCALE_TAXPAYER. If the customer is a general taxpayer, define ‘AR_GTA_GENERAL_TAXPAYER’ for Fiscal Classification code, otherwise ‘AR_GTA_SMALL_SCALE_TAXPAYER’. Fiscal Classification Code determines the VAT Invoice type for the customer:

    • If ‘AR_GTA_GENERAL_TAXPAYER’, special VAT invoices will be defaulted for corresponding Receivables transactions.

    • If ‘AR_GTA_SMALL_SCALE_TAXPAYER’, common VAT invoices will be issued for corresponding Receivables transactions.

    the picture is described in the document text

  3. Define Fiscal Classification Code, Effective From and Effective To.

    the picture is described in the document text

  4. Click Apply and save your work.

    If Bill to Customer is specified as General Taxpayer, Special VAT invoices will be defaulted for corresponding Receivables transactions. However, in some special case, General Taxpayer needs to be issued Common VAT Invoice. In this situation, Common VAT Invoice need to be specified in the Document Subtype field in the Receivables Transactions window.

    To Specify Common VAT Invoice in Receivables Transactions Window

    1. From the Receivables responsibility, create (or import by order) the transaction.

      the picture is described in the document text

    2. Click the Line Items button to open the Lines window.

      the picture is described in the document text

    3. Click the Tax Information button to open the Additional Tax Determining Factors window.

      the picture is described in the document text

      Note: The default in the Document Subtype field is set to blank.

    4. Specify ‘Chinese Common VAT Invoice’ in the Document Subtype field.

      the picture is described in the document text

    5. Click OK to save your work.

      Note: Document Subtype value cannot be modified after the transaction has been completed. If the transaction is not complete then the Document Subtype value can be modified. If the Customer Taxpayer Type is not correct, you can modify it at the Customer site or head level before transferring the Receivable transaction (only if you don’t create accounting for the AR transaction). If the Receivable transaction has been transferred, but not exported to the flat file, you can delete the Golden Tax transaction in Golden Tax workbench, then modify customer Tax payer Type and transfer again.

Defining Master Items

When setting up the Inventory Item Descriptive flexfield, you can assign any two attributes to define Item Model and Tax Denomination. Define these attributes when you create new items.

To define master items

  1. From the Inventory responsibility, navigate to the Master Item window.

  2. Enter descriptive values for the flexfield attributes for Item Model and Tax Denomination.

    the picture is described in the document text

Item Export

The Golden Tax Item Export concurrent request exports item related information from the Oracle application into a flat file. The output file can then be imported into the Aisino Golden Tax System.

This exportation eliminates the need to manually create item master records in the Aisino Golden Tax System. If item cross-reference functionality is used, then the appropriate cross references are exported. You can also use Item Descriptive flexfields to set up and define item model attributes.

Parameters

Parameter Required Default Value List of Values
Master Organization Yes - Master Organizations of Operating Unit selected
Item Number From No - -
Item Number To No - -
Category Set No - -
Item Category Name From No - Category set chosen
Item Category Name To No - Category set chosen
Item Name Source Yes - Master Item Description and Latest Item Cross Reference Description
Cross Reference Type Yes if you select Latest Item Cross Reference Description for Item Name Source - All cross reference types
Item Status No - Item status
Creation Date From No - -
Creation Date To No - -

To run Golden Tax Item Export

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

  2. In the Name field, select Golden Tax Item Export. The Parameters window appears.

    the picture is described in the document text

  3. Enter request parameters and click OK.

  4. In the Golden Tax Interface Programs window, click Submit.

    the picture is described in the document text

    This example shows the flat file produced from the Golden Tax Item Export concurrent request:

    the picture is described in the document text

Customer Export

The Golden Tax Customer Export concurrent request exports customer-related information from the Oracle application to a flat file. The output file can then be imported into the Aisino Golden Tax system.

Parameters

Parameter Required Default Value List of Values
Customer Number From - - -
Customer Number To - - -
Customer Name From - - -
Customer Name To - - -
Creation Date From - - -
Creation Date To - - -

To run Golden Tax Customer Export

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

  2. In the Name field, select Golden Tax Customer Export. The Parameters window appears.

    the picture is described in the document text

  3. Enter request parameters and click OK.

  4. In the Golden Tax Interface Programs window, click Submit.

    This example illustrates the flat file that is produced from the Golden Tax Customer Export concurrent request:

    the picture is described in the document text