Golden Tax Adaptor for China - Fusion Financials for
Golden Tax Adaptor for China ERP CLOUD Fusion Financials for Asia Pacific Table of Contents 1. Purpose of the document ............................................................................................................................................... 2 2. Assumptions and Prerequisites....................................................................................................................................... 3 3. Feature Specific Setup..................................................................................................................................................... 3 Financial Feature Choices for China .................................................................................................................................... 3 Assigning GTA Duty Role to relevant job role and data role............................................................................................... 4 Modifying the policy for data role and add GTA action ...................................................................................................... 9 Modifying the profile value for ‘Mask Internal Bank Account Numbers’ ......................................................................... 15 Setting Up Item Model and Tax Denomination ................................................................................................................ 15 Setting up Golden Tax System Options for China ............................................................................................................. 38 Setting up Golden Tax Transfer Rules for China ............................................................................................................... 42 Setting Up Tax Payer Type for Customer .......................................................................................................................... 44 4. Golden Tax Adaptor Process ......................................................................................................................................... 47 Overview ........................................................................................................................................................................... 47 Receivables Invoices ......................................................................................................................................................... 48 Transferring Receivables Invoices to Golden Tax Adaptor ............................................................................................... 48 Manage the data in the Adaptor using the Golden Tax Invoice Workbench ................................................................... 52 Golden Tax Invoice Export ................................................................................................................................................ 53 Golden Tax Invoice Import by file based data import(FBDI) ............................................................................................ 55 Viewing VAT Invoices ........................................................................................................................................................ 62 5. Reporting....................................................................................................................................................................... 66 Golden Tax Discrepancy Report for China ........................................................................................................................ 66 VAT Invoice Mapping Report for China............................................................................................................................. 69 Golden Tax Transaction Consolidation Detail Report for China ....................................................................................... 72 6. Appendix ....................................................................................................................................................................... 74 1 1. Purpose of the document Golden Tax is an integrated nationwide value-added tax (VAT) monitoring system in China. All businesses operating in Mainland China are required to use a government-certified tax software, referred to as Golden Tax software, to generate VAT invoices, VAT calculations, and statutory tax reporting. Chinese government policies require all businesses to issue all VAT invoices through the Golden Tax system. The Golden Tax Adaptor provides integration between Oracle Fusion Receivables and the Golden Tax software system. The Golden Tax Adaptor manages the conversion of Receivables transactions to VAT invoices for China. The Golden Tax Adaptor integrates with the Golden Tax software provided by the Aisino Corporation, the leading provider of Golden Tax software to Mainland China. The Golden Tax Adaptor and the Aisino Golden Tax System together manage the processing of Receivables transactions for the Golden Tax system for China. This document explains the implementation and usage guidelines for Golden Tax Adaptor Feature in Fusion, and mainly covers the following topics: Set up In order to use Golden Tax Adaptor feature, some specific setups are required besides some common setups. Golden Tax Adaptor Process Introduce the key processes for a typical workflow, including: Create or import transactions in Oracle Fusion Receivables. Transfer receivables transactions to the Golden Tax Adaptor as Golden Tax transactions. Modify the Golden Tax transactions to conform to the requirements of VAT invoices for China. Generate a flat file of VAT invoice data for import by the Aisino Golden Tax System. After the Aisino Golden Tax System generates VAT invoices from the Golden Tax Adaptor data: Import VAT invoice data from the Aisino Golden Tax System. Review and compare the imported VAT invoice data with the flat file exported to the Aisino Golden Tax System. Correct any discrepancies between the two data files. Reports Mainly introduce Golden Tax Discrepancy Report for China, VAT Invoice Mapping Report for China and Golden Tax Transaction Consolidation Detail Report for China. 2 2. Assumptions and Prerequisites In this document, the following entities are assumed to have already been set up: Data Security Geographies Enterprise Structure Ledger Business Unit Tax Regime to Rate setup(Note: Golden Tax Adaptor feature is only for China, the country for tax regime must be China) Tax Rules Tax Party Profiles (Note: you need to add tax registrations information for GTA Legal Reporting Unit tax profile.) Common setups for Receivables Customers(Note: You need to create customer address, telephone number, tax registration number, bank and bank account if you want to issue special VAT invoice, address country must be China) It is recommended that the ‘Implementation Project’ is complete for your organization before commencing the ‘Feature Specific Setup’ outlined below. If you require further details, refer to the Appendix. 3. Feature Specific Setup The following flow shows the required setup for implementing the Golden Tax Adaptor. Financial Feature Choices for China Task name: Configure Offerings Navigation: Navigator –> Setup and Maintenance -> Configure Offerings -> Financials -> Select Feature Choices 3 Customer need to enable the Regional Localization for China before they can use China related tasks in the implementation Projects. Assigning GTA Duty Role to relevant job role and data role. GTA duty roles are orphan duty roles, you need to assign these orphan duty roles to corresponding job role or data role, and otherwise you can’t see GTA tasks. In Rel9 GTA have two kinds of duty roles, one is for setup, for example Golden Tax Administration for China Duty, you need to assign to job role that can process setup, such as Financial Application Administrator; the other is for transaction and ESS process, for example Golden Tax Management for China duty, you need to assign to data role that can process GTA Transaction, such as Billing Manager - Vision China 0101. Login APM, and choose FSM in Application Name area Menu: Search Navigation: Application Roles–> Search 4 Click ‘Search’ menu, enter filter criteria and query out GTA duty role. Assign Golden Tax Management for China Duty role to data role, such as Billing Manager - Vision China 0101, Billing Manager - Vision China 0102 and so on. 5 Assign Golden Tax Administration for China Duty to job role, such as Financial Application Administrator. Switch to obi in Application Name area and navigator to Search from Application Roles. Menu: Search Navigation: Application Roles–> Search 6 Click ‘Search’ menu, enter filter criteria and query out GTA duty role. Assign Golden Tax Management for China Duty to data role, such as Billing Manager - Vision China 0101, Billing Manager - Vision China 0102 and so on. 7 8 Modifying the policy for data role and add GTA action GTA Tasks are based on BU or data set. Modify the policy and add GTA action so that GTA tasks can access to specified BU or data set. Login APM, and choose FSM in Application Name area Menu: Search-External Roles Navigation: Search and Create–> External Roles Enter data role to modify, such as Billing Manager - Vision China 0101. 9 Click Open Role button. Open the role and click Find Global Policies button. 10 Open the policy for the data role. If there is the action group of which resource name is business Unit, you can edit the action group and directly add GTA action to the group; if no, you need add the kind of group of which resource name is business Unit, and then add GTA action to the group. Choose one existing action group, such as Manage Receivables Activities, edit it. 11 Click Edit button and open the action. Switch to Action tab and add GTA action, including Manager Golden Tax Transaction for China, View VAT Invoice for China and Manage Golden Tax System Option for China. 12 Click ‘Save’ and save your work If there is the action group of which resource name is SetID Set, you can edit the action group and directly add GTA action to the group; if no, you need add the kind of group of which resource name is SetID Set, and then add GTA action to the group. Choose one existing action group, such as Manage Customer Account Relationship, edit it. Switch to Action tab, Add ‘Manage Golden Tax Transfer Rule for China’ in Selected Actions area 13 Click ‘Save’ and save your work 14 Modifying the profile value for ‘Mask Internal Bank Account Numbers’ 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 process to export data, Mask Internal Bank Account Numbers profile option must be set to No Masking. Task name: Manage Administrator Profile Values Navigation: Navigator –> Setup and Maintenance -> Manage Administrator Profile Values You can update this profile option at all levels. Setting Up Item Model and Tax Denomination 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. You may maintain Item Model and Tax Denomination in Receivables Transactions Line Fields or inventory master item DFF. Initially, item model and tax denomination will be retrieved from transaction line fields, if there is no value at transaction line level field, and then they will be retrieved from DFF in master item. Three fields from Receivables Transactions Line are used to maintain Item Model and Tax Denomination. Product Fiscal Classification field will be used for Item Model of inventory items. Values maintained under product fiscal classification 15 code, which category set is assigned to functional area “VAT Invoices for China”, will be considered as valid item model for inventory items. Task name: Create Catalog Navigation: Navigator –> Setup and Maintenance -> Create Catalog Note: Do not select the Enable hierarchies for categories option Task name: Manage Catalog Navigation: Navigator –> Setup and Maintenance -> Manage Catalog 16 17 18 19 Task name: Manage Default Catalogs Navigation: Navigator –> Setup and Maintenance -> Manage Default Catalogs 20 21 22 Create a Product Fiscal Classification within Tax functionality and associate the Inventory Catalogue to this Product Fiscal Classification. Task name: Manage Product Fiscal Classifications Navigation: Navigator –> Setup and Maintenance -> Manage Product Fiscal Classifications 23 Setup the Product Fiscal Classification with the Country defaults. Task name: Manage Country Default Controls Navigation: Navigator –> Setup and Maintenance -> Manage Country Default Controls Then user can see the categories of item model in the ‘Product Fiscal Classification’ Field from AR transaction Line. 24 Product Category field will be leveraged for Item Model of non-inventory items. Values maintained under product category JA_CN_NON_INV_ITEM_MODEL should be considered as valid item model for non inventory items. Task name: Manage Product-Based Fiscal Classifications Navigation: Navigator –> Setup and Maintenance -> Manage Product-Based Fiscal Classifications Click ‘Create Child Node’ button. 25 Transaction Business Category will be used for Tax Denomination. Values maintained under transaction business category code JA_CN_TAX_DENOM will be considered as valid tax denomination. Task name: Manage Transaction Business Category Navigation: Navigator –> Setup and Maintenance -> Manage Transaction Business Category 26 Expand SALES_TRANSACTION Create Child Node 27 Then user can see the category codes of tax denomination in the ‘Transaction Business Category’ Field from AR transaction Line. Descriptive flexfields for Inventory Master Items 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. Task name: Manage Descriptive Flexfield Navigation: Navigator –> Setup and Maintenance -> Manage Descriptive Flexfield 28 Manage contexts for Golden Tax Adaptor 29 Create segment for Item Model Create value Set for Item Model 30 Create Values Save and Close Done 31 Create another segment for Tax denomination (You can use the existing value set, too.) 32 Save and Close 33 Now, complete the Item Model & Tax denomination setup. Deploy Flexfiled 34 Setup Item Model & Tax Denomination in DFF for Item: GTATest001 35 36 37 Setting up Golden Tax System Options for China Use Manage Golden Tax System Options for China task to define setup information for each legal reporting 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 task. To define system options Task name: Manage Golden Tax System Options for China Navigation: Navigator –> Setup and Maintenance -> Manage Golden Tax System Options for China Select VAT Related Options tab: Enter data in the following fields 38 Tax Registration Number: This is the transaction tax registration number of the legal reporting unit that is issuing the VAT invoice. In Legal Reporting Unit Tax Profile, you can define the tax registration number for a legal reporting unit. A legal reporting unit 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. Maximum Invoice Amount (CNY): The maximum CNY amount allowed on a single VAT invoice. This limit is specified by the Chinese VAT regime for the legal reporting unit with the specified tax registration number. Maximum Invoice Lines: The maximum lines allowed on a single VAT invoice. This limit is specified by the Chinese VAT regime for the legal reporting unit with the specified tax registration number. 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. Descriptive Flexfield Assignments: In this region, define the contexts and attributes of the Inventory Item Descriptive flexfield that are configured for capturing and storing these additional Golden Tax attributes: Item Model Tax Denomination Please refer to Setting up Item Model and Tax Denomination Part for specific attributes. These attributes are optional for generating VAT invoices. You can set up these flexfields as needed. Switch to Miscellaneous Options. 39 Enter the following fields as need. Split Rules: Specify how to split when transfer AR transaction to Golden Tax Adaptor if invoice amount is more than maximum amount limit. Split Transaction Line: 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 40 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 Invoice 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, then a transaction line is split to several invoices with decimal item quantity. 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 the attribute is selected, then the invoice is split into two invoices as shown by these examples: 1st Invoice: Line No. Item Quantity Line Amount (CNY) 1 1 6000 2 .33333333 4000 2nd Invoice: 41 Line No. Item Quantity Line Amount (CNY) 1 .66666667 8000 If the attribute is not selected, then the invoice is not transferred and an exception is generated. Item Description Source: 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. If you select Receivables Transaction, then the item description on the receivables transaction line is transferred to the Golden Tax Adaptor; if you select Item Cross Reference, the item cross reference functionality is applicable, you need to select the cross reference type to specify which item description is to be printed on the VAT invoices. Use item description if no reference exists: This is applicable if you have selected that Item 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 submit Transfer Transactions to Golden Tax Adaptor for China process. You can then define a cross reference for the specific item and run the transfer. Use latest reference if multiple references exist: This is applicable when you have selected Item Cross Reference, 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 exists 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 when you submit Transfer Transactions to Golden Tax Adaptor for China process. You can resolve the exception by deleting the invalid cross references and run the transfer. Batch Numbering: 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 process. When automatic, specify Staring Batch Number. Setting up Golden Tax Transfer Rules for China 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 for one business unit. To define transfer rule Task name: Manage Golden Tax Transfer Rules for China Navigation: Navigator –> Setup and Maintenance -> Manage Golden Tax Transfer Rules for China 42 Click Create button to add one transfer rule. Select transfer rule set (Required) Enter a Rule Name (required.) Enter a description. Select the Invoice Type. You can define a transfer rule for all invoice types or a specific invoice type. Define Receivables Transaction 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 NonGolden Tax Currencies, then only foreign currency invoices using this rule are transferred 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. 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. 43 Exclude or include specific transaction Descriptive Flexfield. Set transfer rules to use the Receivables Transaction Information Flexfield attributes. Similar to the above Transaction Type, you can exclude or include specific flexfield contexts and attributes. Setting Up Tax Payer Type for Customer You can specify customer taxpayer type at customer or customer site level. To define tax payer type for customer Task name: Manage Customers Navigation: Navigator –> Setup and Maintenance -> Manage Customers Enter filter condition and query out GTA customer as needed, such as GTA_Account_General. Click Registry ID link and edit customer information. 44 Switch to Tax Profile tab. Navigator to Classifications sub tab and add Classification information. 45 You can define tax payer type information in customer site level, too. The taxpayer type defined at customer site level has higher priority than at customer level. If bill to customer is specified as General Taxpayer, special VAT invoices will be defaulted for corresponding Receivables transactions. But in some special case, General Taxpayer needs to be issued Common VAT Invoice. For the case, Common VAT Invoice for China needs to be specified in Document Fiscal Classification field from Receivables Transaction header level. 46 4. Golden Tax Adaptor Process This chapter covers the following topics: Overview Receivables Invoices Transferring Receivables Invoices to the Golden Tax Adaptor Golden Tax Invoice Workbench Golden Tax Invoice Export Golden Tax Invoice Import Viewing VAT Invoices Overview This flowchart shows the key processes of the Golden Tax system: 47 The key processes for a typical workflow are: Create receivables invoices manually or by using auto-invoice. Transfer receivables transactions to the Golden Tax Adaptor. Manage the data in the Adaptor using the Golden Tax Invoice Workbench. Consolidate multiple invoices to an invoice based on the Consolidation rule. Export the invoice information either from the Golden Tax Invoice Workbench or a separate process. Import the flat file into the Aisino Golden Tax System (perform this activity in the Golden Tax software.) Generate corresponding VAT invoices in the Aisino Golden Tax System (perform this activity in the Golden Tax software.) Export the VAT invoice information from the Aisino Golden Tax System (perform this activity in the Golden Tax software.) Import the VAT invoices data file back into the Golden Tax Adaptor. Receivables Invoices You can manually create receivables invoices, debit memos, and credit memos, or you can create them using autoinvoice. Invoices must be in a complete status before you can transfer them to the Golden Tax Adaptor. Task name: Create Transaction Navigation: Navigator –> Billing -> Create Transaction Create an invoice and pay special attention to the following. Transferring Receivables Invoices to Golden Tax Adaptor Transfer Transactions to Golden Tax Adaptor for China process 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 48 invoices so that only the desired invoices are transferred. Transfer rules eliminate the need to specify different parameters each time you submit the transfer process. Transfer Transactions to Golden Tax Adaptor for China process: Identifies the receivables invoices, debit memos, and credit memos that are at complete status based on the transfer rules for the current operating unit. Invoice Type: The available invoice types are Special VAT Invoice, Common VAT Invoice. o The Customer Tax Registration Number, Address, Phone Number and Bank Account are optional fields for Common VAT Invoice, but required fields for Special VAT Invoice. Examines invoice-splitting limits and criteria, and splits receivables invoices into multiple child Golden Tax Adaptor invoices, accordingly. The program creates one VAT invoice for each Golden Tax Adaptor invoice. The criteria for invoice splitting is as follows: o Tax Registration Number: This value refers to the tax registration number of the legal reporting unit that is creating the invoice. When a single receivables invoice has invoice lines pertaining to different tax registration numbers, then it is split into multiple child invoices in the Adaptor so that one child invoice pertains to a single tax registration number. One VAT invoice cannot be issued for more than one tax registration number. o Tax Rate: A single VAT invoice cannot have more than one tax rate. Therefore, if different invoice lines of a receivables invoice have different tax rates, then it is split into multiple child invoices in the Adaptor so that one child invoice only has lines belonging to the same tax rate. o Maximum Amount Limit: This value is specified for each combination of tax registration number and invoice type in the System Options window. If this amount limit is exceeded, then the receivables invoice is split into multiple child invoices in the Adaptor. o Maximum Memo Lines Limit: This value is specified for each combination of tax registration number and invoice type in the System Options window. If this limit is exceeded, then the receivables invoice is split into multiple child invoices in the Adaptor. However, if the transfer rule that is being used indicates that sales list is applicable, then this limit is ignored and the receivables invoices are not split according to this limit. o Splitting Hierarchy: The application enforces the splitting criteria described previously as follows: The receivables invoice is split by tax registration number. For each tax registration number, the lines are further split by tax code. Lines are further split based on the limits for maximum amount and maximum memo lines. If sales list is applicable, then the maximum memo lines limit is not applied and only the maximum amount limit is applied. Item Model and Tax Denomination: For receivables transactions that are transferred to the Golden Tax Adaptor, transfers Item Model and Tax Denomination values for each line to the Adaptor. These values can be defined in the item descriptive flexfield when you create the master items or in the transaction line field when you create receivables transactions. The program first looks at the receivables transaction line fields. If no values are available, then it refers to the inventory item flexfield for that item. Item Description: Retrieves the item description from the appropriate cross-reference type rather than from the item master when item cross-reference functionality is used. To transfer AR transactions to Golden Tax Adaptor Task name: Schedule Processes 49 Navigation: Navigator->Tools->Scheduled Processes Click Schedule New Process to submit the process Transfer Transactions to Golden Tax Adaptor for China. 50 Enter the parameter as required and submit the process. After the process ends successfully, please review Transactions Transfer Report for China BIP report and check the result. 51 Manage the data in the Adaptor using the 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. Task name: Manage Golden Tax Transactions for China Navigation: Navigator->Receivables->Billing -> Manage Golden Tax Transactions for China 52 Enter search parameter and query out the transaction transferred from Receivables. You can make a slight modification to conform to the requirements of VAT invoices for China. You can also use the Golden Tax Invoice Workbench to track the VAT invoices and to manage invoice status, consolidate Golden Tax Transactions with small amount .Please refer to Oracle Fusion Applications Documentation (Financials) for more details. 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 Export Golden Tax Transactions for China process. Task name: Export Golden Tax Transactions for China Navigation: Navigator –> Tools-> Scheduled Processes–> Export Golden Tax Transactions for China 53 You can also export the invoice from the Golden Tax Invoice Workbench. The application runs the same process by the above two ways. 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. 54 The output of Export Golden Tax Transactions for China process 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 Mask Internal Bank Account Numbers. Note: In order to export the data, using the Export Golden Tax Transactions for China process, the Mask Internal Bank Account Numbers profile option must be set to No Masking. Golden Tax Invoice Import by file based data import(FBDI) 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 by FBDI. 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. To import VAT invoice to Golden Tax Adaptor Specify the file which is generated from Aisino Golden Tax System, and compress it to a Zip file. Make sure there is no blank space in file name For example we compress this file to 6.zip 55 Compress to ZIP file. Login fusion and navigate to File Import and Export Task name: File Import and Export Navigation: Navigator->Tools-> File Import and Export Open File Import and Export task, click Upload button. 56 Specify the file that you want to upload, such as 6.ZIP, and choose Account fin/receivables/import. Click Save and Close button to save your work. 57 Load data to interface table and import GTA application table. Task name: Load Interface File for Import Navigation: Navigator->Tools-> Scheduled Processes-> Load Interface File for Import Enter the process parameters as required. 58 Parameters: Import process: Import VAT Invoices for China Data file:the Zip file you want to upload. Click Submit button. The process will trig other 3 sub processes, including Transfer File, Load File to Interface, Import VAT invoices for China. Moreover, output one BIP report VAT Invoices Import Report for China. Query up VAT invoice. After the process ends successfully, you can check the output by the BIP report VAT Invoices Import Report for China. When the VAT invoice data is successfully imported against an invoice in the Adaptor, the status of the invoice is changed to Completed. 59 You can drill down to VAT invoice by clicking Actions menu in Golden Tax Workbench. 60 You can also drill down to original AR transactions in Golden Tax Workbench. 61 Viewing VAT Invoices Use Review VAT Invoices for China UI to view the VAT invoices imported from the Aisino Golden Tax system and the corresponding receivables Invoice. Task name: Review VAT Invoices for China Navigation: Navigator->Receivables->Billing -> Review VAT Invoices for China Navigator to Review VAT Invoices for China UI and open the UI. Enter VAT invoice search parameter as required to query out VAT data. 62 In this window, all fields are protected from update and you cannot create new records. When you select a VAT invoice and click View Golden Tax transaction button, the Golden Tax Invoice Workbench window appears and displays the related Golden Tax Adaptor invoice information. 63 You can also view original Receivables transactions from Review VAT Invoices for China UI. Click Receivables transaction number. Open original receivables transaction UI. 64 You can also drill down VAT invoice from original AR transaction. 65 5. Reporting Golden Tax Discrepancy Report for China Use the Golden Tax Discrepancy Report for China to review discrepancies in your Golden Tax Adaptor data. The Golden Tax Adaptor uses and maintains three types of data: Receivables transactions. Golden Tax transactions created during the transfer process. Completed VAT invoices imported from the Aisino Golden Tax System. This data may contain discrepancies for one or more of these reasons: Original receivables transactions were modified after transfer to the Golden Tax Adaptor. Data in the Golden Tax Adaptor was modified before export to the Aisino Golden Tax System. Data was modified in the Aisino Golden Tax System before the VAT invoices were generated. VAT calculations in the Aisino Golden Tax System may differ from the Golden Tax Adaptor and may contain small rounding errors. To run the report. Task name: Golden Tax Discrepancy Report for China Navigation: Navigator->Tools->Scheduled Processes -> Golden Tax Discrepancy Report for China Navigate to Scheduled Processes task and schedule new process. In the Name field, select Golden Tax Discrepancy Report for China from the list of values. The Parameter window appears. 66 Enter report parameters and click Submit button. 67 Then check the report output. 68 The report displays the discrepancies within different sections for each receivables invoice: Header: In this section, the discrepancies in the header attributes, such as Invoice Type, Address, Bank Name, Bank Account Number, and Amounts, appear. Lines: In this section, discrepancies in the line attributes, such as Item Description and Model, appear. Missing AR lines: In this section, AR lines that are present in receivables but not in the Adaptor, or vice versa, appear. This discrepancy arises when a new line is added, or an existing line is deleted from a receivables invoice after it is transferred to the Adaptor. Unmatched lines: When the VAT invoice lines do not match the lines of the corresponding invoices in the Golden Tax Adaptor, then both lines appear separately. VAT Invoice Mapping Report for China VAT Invoice Mapping Report for China prints the receivables invoices information and the corresponding VAT invoice information. There are the following mapping relations between AR transactions and VAT invoices, one to one, one to multiple, multiple to one and multiple to multiple because of invoice split and consolidation. This report lists the mapping data between the receivables invoices information and the corresponding VAT invoice. It groups all of the VAT invoices and all relevant Receivables transactions, and displays the amounts. To run the report. Task name: VAT Invoice Mapping Report for China Navigation: Navigator->Tools->Scheduled Processes -> VAT Invoice Mapping Report for China Navigate to Scheduled Processes task and schedule new process. In the Name field, select VAT Invoice Mapping Report for China from the list of values. The Parameter window appears. 69 Enter report parameters and click Submit button. 70 Then check the report output. 71 Golden Tax Transaction Consolidation Detail Report for China Golden Tax Transaction Consolidation Detail Report for China provides the mappings between parent consolidation Golden Tax Adaptor invoices and Child consolidated Golden Tax Adaptor invoice. The report can show the data only when you consolidate Golden Tax Transactions. You can refer to Oracle Fusion Applications Documentation (Financials) for more details regarding consolidation. The report groups all of the consolidation Golden Tax Adaptor invoices for a single consolidated Golden Tax Adaptor invoice. To run the report Task name: Golden Tax Transaction Consolidation Detail Report for China Navigation: Navigator->Tools->Scheduled Processes -> Golden Tax Transaction Consolidation Detail Report for China Navigate to Scheduled Processes task and schedule new process. In the Name field, select Golden Tax Transaction Consolidation Detail Report for China from the list of values. The Parameter window appears. 72 Enter report parameters and click Submit button. 73 Then check the report output. 6. Appendix 74 Here are some useful information sources to assist with the implementation : Oracle Enterprise Repository (Financial Report Listing) The OER provides content relating to the report parameters and sample report output Oracle Fusion Financials Cloud Release 9 What’s New This document contains additional information relating to this feature and other Fusion Financials features and capabilities Oracle Fusion Applications Documentation (Financials) The web site contains links to all Fusion Applications User Guides Copyright © 2014, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group. 0114 75
© Copyright 2024