This chapter covers the following topics:
The following flow shows the required setup for implementing the Golden Tax Adaptor.
Key setup steps include:
Enable Golden Tax Adaptor profile options
Configure descriptive flexfields for inventory item and receivables transaction lines
Define item cross-references (optional)
Set up flexible address (optional)
Define Golden Tax System options
Define transfer rules
Define customer taxpayer type
Export customer and item master data
You must enable the following profile options:
AR: Golden Tax Enabled
AR: Golden Tax Import Directory
CE: Mask Internal Bank Account Numbers
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.
The Chinese VAT regime classifies items by the following attributes:
Item Model
Tax Denomination
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
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Applications field, select Inventory (Items).
Select an existing context or define a new context.
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.
Save your work.
Freeze the flexfield and compile.
To define the Receivables Invoice Line Information descriptive flexfield
From the System Administrator responsibility, navigate to the Descriptive Flexfield Segments window.
In the Applications field, select the Receivables Invoice Line Information.
Select an existing context or define a new context.
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.
Save your work.
Freeze the flexfield and compile.
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
From the Inventory responsibility, navigate to the Cross Reference Types window.
Enter a new cross-reference type or an existing type.)
Click Assign. The Assign Cross References window appears.
Select an Item and enter a Value (required).
Save your work.
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
Navigate to the Countries and Territories window.
Query China.
In the Address Style field, select China.
Save your work.
To set up flexible address formatting
Navigate to the Descriptive Flexfield Segments window.
In the Title field, query the Address descriptive flexfield.
In the Context Field Values region, select the CN (Chinese Address Style) code.
Click the Segments button.
In Segment Summary window, in addition to other segments, add the Alternate Address segment and ADDRESS_LINES_PHONETIC column. For example:
Save your work.
Freeze the flexfield and compile.
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
From the Golden Tax Adaptor responsibility, navigate to the System Options window.
Select the Golden Tax tab and enter data in the following fields:
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 |
Select the Batch Numbering tab.
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.
Select the Item Source tab and enter the following attributes:
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.
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
From the Golden Tax Adaptor responsibility, navigate to the Transfer Rules window.
Select an Operating Unit (required.)
Enter a Rule Name (required.)
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.
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.
Enter a description.
Enter Effective Dates (required.)
Select the Invoice Type. You can define a transfer rule for all invoice types or a specific invoice type.
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.
Select the Descriptive Flexfield tab.
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.
Select the Currency tab.
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.
Save your work.
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
From the Receivable responsibility, navigate to the Tax Profile tab for the customer.
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.
Define Fiscal Classification Code, Effective From and Effective To.
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
From the Receivables responsibility, create (or import by order) the transaction.
Click the Line Items button to open the Lines window.
Click the Tax Information button to open the Additional Tax Determining Factors window.
Note: The default in the Document Subtype field is set to blank.
Specify ‘Chinese Common VAT Invoice’ in the Document Subtype field.
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.
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
From the Inventory responsibility, navigate to the Master Item window.
Enter descriptive values for the flexfield attributes for Item Model and Tax Denomination.
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
From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Interface Programs window.
In the Name field, select Golden Tax Item Export. The Parameters window appears.
Enter request parameters and click OK.
In the Golden Tax Interface Programs window, click Submit.
This example shows the flat file produced from the Golden Tax Item Export concurrent request:
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
From the Golden Tax Adaptor responsibility, navigate to the Golden Tax Interface Programs window.
In the Name field, select Golden Tax Customer Export. The Parameters window appears.
Enter request parameters and click OK.
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: