ONESOURCEIndirectTaxIntegratorPlaybook_04-22-2016WebServices2009 (2)

Test Data

Tips & TricksOverviewThis section provides additional information on areas not directly related to the ONESOURCE product, but might be helpful in managing theintegration.ContentLog Formatting and Comparing

Log Formatting and ComparingLOG FORMATTINGThis section explains how to format an SAP SOAP log quickly for easy analysis and sharing.PREREQUISITEYou must have Notepad++ installed. Go to http://notepad-plus-plus.org/download to download and install the free tool.XML TOOLS PLUG-IN FOR NOTEPAD++ INSTALLOnce Notepad++ is installed we need to install XML Tools. Download the latest version from the link provided. Here we use xmltools_2.3.2_r908_unicode_beta4. Once downloaded, unzip the XML Tools plug-in. Then copy the XMLTools.dll file into the Notepad++ plugins directory (usually at C:\Program Files (x86)\Notepad++\plugins). Copy all the dll files in the ext_libs directory of the zip file into the root directory of Notepad++ (usually C:\Program Files (x86)\Notepad++). Once done start Notepad++ (close it and restart it if it was open during the plugin install). Now you shouldsee under the Plugins menu a new sub-menu for XML Tools:MAKING NOTEPAD++ YOUR DEFAULT TEXT EDITORInternet ExplorerIf you use IE as the browser default, you have to change the text editor default in IE. Open IE, then got to Tools (Alt-X) and select F12 DeveloperTools (F12).You will now see a new window on the bottom of the browser screen. Use menu File -> Customizing… -> Other.

In the pop-up browse to Notepad++ (usually at C:\Program Files (x86)\Notepad++) and select notepad++.exe file. Close the Developer option in IE via F12. Close IE. You are now set up!ChromeIf you use Chrome as the ...Fire FoxIf you use Chrome as the ...READING A SAP LOG FILE WITH THE NEW SETUPGo to an SAP log and select it to get the pop-up with the SOAP request/response details:Right click in the log and select View Source. Notepad++ will now automatically open and show the log details:

But this is difficult to read in the format shown….So let's solve this in one quick step! Use Ctrl+Alt+Shift+B (or menu Plugins -> XML Tools -> Pretty Print (XML only – with line breaks)).Voila!! You can now analyze, copy sections out, or even copy the <INDATA> to </INDATA> section and run it through the Determination XML Invoice servlet, soapUI, or other tool of choice.COMPARING LOG FILESOnce you have your log file formatted it's easy to compare two files to each other. You can for example quickly copy the <INDATA> to </INDATA> section of two logs into separate files and then compare them. You can use WinMerge (free at http://winmerge.org/downloads) to compare the f

ormatted files. WinMerge compare example:

ReferencesSpace Index A ... 6 B ... 1 C ... 6 G ... 1 H ... 0 0-9 ... 0 M ... 2 N ... 1 I ... 4 F ... 0 S ... 6 T ... 7 L ... 2 Y ... 0 Z ... 0 O ... 3 R ... 4 X ... 0 U ... 4 0-9 !@#$ ... 0B A Business Processes About This Playbook Business Process Considerations The examples in this section Purpose This guide assists clients and partners who wan illustrate the basic process flow of an order and it's interaction with ONESOURCE Indirect Tax on our cloud platform with a ONESOURCE Indirect Tax. Consider when the tax liability (audit) resource planning (ERP) or e-commerce system. This gu should be recorded for each of these examples. See Tax Lia Add New Field Description Some transaction systems do not have a com another standard product grouping. In these cases, a ne transaction system at the item master level to categorize Address Validation Service This section is only relevant for addresses located in the accurate US tax, Determination requires complete and v In financial systems where an address validation / addre Addresses Description Addresses are one of the primary pieces of d tax calculation. The key addresses used are: ship from s order acceptance Business Usage Addresses are used f Amounts Description Transactions in a financial system can conta the correct amount from the transaction to send to Deter describes the transaction amounts and related data ne Architectural Overview Thomson Reuters Indirect Tax Cloud services provides r financials systems. Partners can build their integration ut Address Validation API The specific implementation vari C Charges HANDLING, FREIGHT, DELIVERY, OR SIMILAR CHAR and handling charges can be processed by ONESOURC Determination in the tax request determines how the tax Coding Standards Description During the sign-up process for the Thomson Community, the Terms Of Use https://developers.thomso On this page, we describe a few considerations to keep Commodity Code Description The commodity code is a standard way to g such as a Harmonized Commodity Description and Codi United Nations Standard Products and Services Code (U Company Role Description The company role is the role the transacting buyer or seller. Each role results with different transactio the transacting company referred to is from the ONESOU Configuration Screen TEST process Description It is desired to have the ability to test the con directly from the setup screen to ensure that the credent “dummy” request has to be sent to the ONESOURCE Ind

Currencies Description There are two basic currencies, the currenc Determination stores its audit data in the defined compan new markets includes US dollars or Canadian dollars. DeDEDates ERP Testing Description Multiple dates are used in the tax request for a variety of Exempt Management reporting and tax calculation purposes. Available dates are: document date, fiscal date, and original document date. In addition, Description The basic assumption of a tax calculation is the Determination audit database contains a transacti some cases, taxes do not need to be assessed. In these Usage The recommended process to apply an exemptioDesign Concepts Description There are several key concepts to be understood when designing and developing an integration to Determination. Using the Simple Tax Service request format, the following linked pages describe the concept and highlight the business and tax usagDetermining Postal Code and Geo Code This section is only relevant for addresses located in the United States. Overview In 1983, the US Postal Service began using an expanded ZIP+4 code. The ZIP+4 code consists of two segments: a five-digit postal code and a four-digit geo code. The ZIP+4 coDocument History DOCUMENT HISTORY Version Number Version Date Summary v1 March 2015 First version of this guideDocument Types Description The DocumentType field in the XML can provide more granular information about the type of document being sent in the tax request. Business Usage The document type is used primarily for troubleshooting to aid in identifying the transaction iFG Glossary Audit ONESOURCE Indirect Tax Database where transa referred to as Determination Audit. Consumer's Use Tax purchaser is obligated to pay in their state of residence aHI INCOTERMS/Point of Title Transfer Description Two components, Incoterms and Point of Ti transfer of ownership (liability) occurs and when and whe important to identify where the transfer of ownership occ Informational Fields Purpose A collection of fields in HostRequestInfo provide assistance and to uniquely identify a transaction in our m HostRequestInfo collection are required, i.e., they must h Integration Configuration Screens Description It is preferred that Integrations are configured this method enhances the user experience and allows fo solution. Standard Method All configuration screens m Introduction Thomson Reuters ONESOURCE™ Indirect Tax offers a tax management solution that seamlessly integrates for a document management and effortless filing and remittanJKL M Log Formatting and Comparing Main Components of a Tax Call LOG FORMATTING This section explains how to format an SAP Two versions of web services available for tax calculatio SOAP log quickly for easy analysis and sharing. PREREQUISITE the SimpleTaxService and TaxCalculationService (also r Unless advised by your Thomson Reuters implementatio Simple

You must have Notepad++ installed. Go to Miscellaneous http://notepad-plus-plus.org/download http://notepad-plus-plus.org/download to download and ins Determination Allocation Functionality The allocation fun by the Simple Tax Calculation web service at this time. TLogging instead, it calculates “regular” tax. As a workaroun Description When two systems exchange data it is imperative to provide a means to review the exchanged data for troubleshooting and issue resolution. To assist with this process, each integration needs a minimum standard of logging on the calling applicatNONon-Inventory Items ONESOURCE Indirect Tax Integrator Playbook Description Some financial systems do not provide an easy way to ONESOURCE Indirect Tax Integrator Playbook Docu assign product tax codes to non-inventory items. An alternative 2016 Thomson Reuters/ONESOURCE. All Rights Rese method to determine line-item taxability is to map the general ledger information of Thomson Reuters. Disclosure, use, or rep account or cost center element on non-inventory items. P Organizational Structure Description A company's legal entity structure, defined to a defined company in Determination. Business Usage transaction and audit data, create B2B relationships, and Other Standard ERP Field Description Some transaction systems may not have a c field to hold a product code value. Implementers can se system that represents a grouping of products that can bPQPOO, POA, and Bill To Addresses Quantity and Unit of Measure Description Addresses Description The quantity and unit of measure (UOM) are http://confluence.corp.ositax.com:8090/display/INTPlay/Addressesare transaction and can affect the taxability or tax rate on a t one of the primary pieces of data used by Determination for accurate the number of items the transaction refers to. The value tax calculation. Although Ship To and Ship From are primarily used as the taxing address, someProcessing Transactions without ONESOURCE Overview While our failover design and other solutions limit downtime on the ONESOURCE, there are still situations where transactions cannot call the tax engine. This could be caused by a local network issue, an inability to connect to the WAN, service prProduct Tax Code This section on applies to United States transactions. Description Thomson Reuters Product Tax Codes represent the tax treatment of a group of similar items or materials in the financials system using a 4-digit code. Business Usage Product codes are mappProduct Tax Code Import Description Ideally, the use of an automated method to load the ONESOUCE Indirect Tax Product Codes into the ERP is preferred. Business Usage It is desired to have the ability to load this data using a provided .csv file by command line, database script,Product Taxability Description For proper taxation, the tax engine needs the kind of product being sold, e.g., milk products might be taxed differently than automotive products. Instead of mapping each item from a transaction system in the tax system to its product taxabiliRSReferences Sales Tax Code Integration Level MethodsRegistrations Description Different tax level details can be returned to code integration level methods indicate the level of tax d Description In order to collect and report VAT (or VAT-like tax; system. Business Usage There are two different sal Canada GST, PST, etc), a registration number is required. Currently, only The US and Canada are in scope. In Canada, there are Security Considerations registration numbers for GST, HST, QST and PST. Business Usage Description When building an integration, consider the seRelated Lines tax calculations as well as preventing changes to the inte key areas that should be implemented in an integration. Description Transaction data may be related to other data on the same transaction. The Related Lines functionality provides a SimpleTaxService Description The SimpleTaxService provides real-time tax

mechanism for building a relationship between these data elements. format. The functionality and elements are less complex Determination can then identify that the two are related and http://confluence.corp.ositax.com:8090/display/INTPlay/TReversals SoapUI Description A reversal is a negative transaction. Reversals must be Description We recommend using SoapUI, a free tool av sent to Determination to account for credits or reversing original at http://sourceforge.net/projects/soapui/files/ http://sourc transactions. Business Usage Reversals identified by the ERP basic communication with our services. Once communic system need to be sent to Determination. A reversal can Status of a Response Description It's imperative to know quickly if a request se calculated tax for all documents and lines. To assist in th collections, RequestStatus and DocumentStatus. Statu System Access Description Successful tax calls require several pieces o the Thomson Reuters product development or onboardin formulating the tax request to Thomson Reuters IndirectTUTax Liability Tracking (Audit) Uniqueness in Audit Description Legal documents with tax liabilities, like invoices and Description As outlined in the Main Components of a Ta credit memos, need to be recorded in the ONESOURCE Indirect Tax http://confluence.corp.ositax.com:8090/display/INTPlay/M Determination audit database for future reporting and return tax liabilities have to be written to the Determination data preparation. It is imperative that once transactions are audi US to Canada Purchasing Cross Border TransactionsTax Results Mapping Description Cross-border purchasing (buyer) transaction Description The SOAP response has three main areas containing tax input and output GST. The Simple Tax Service currently results in different summarization levels at line level: Level Output) on the tax result. Therefore, a workaround must Description TaxSummary Contains the total tax for the line ZoneTaxSummaries Returns tax in up to four buckets; State, County, Use TaxTaxability This section is only relevant for addresses located in the transaction, the vendor charged tax amount may not agr Tax determination is based on several factors, which include the amount. To accommodate this difference, the Integration following: Product Taxability: The type of product being transacted. Non-Inventory Items: The use of the product (non-inventory) can UserAttributeContainer determine taxability. Exempt Management: Products, custom Description In the SimpleTaxService, ONESOURCE IndTaxCalculationService line level to be appended for tax calculation. These addit as Input XML Custom Attributes. The TransEditor functio Description This tax calculation service provides real-time tax calculation using XML format. The functionality and elements are more complex than the simple tax service. At this time the Integrator Playbook focuses on the SimpleTaxService http://confluenTest CasesTest DataTips & Tricks Overview This section provides additional information on areas not directly related to the ONESOURCE product, but might be helpful in managing the integration. ContentVW Web Service Request Description The body of a web service request contains based on the transaction system's data. The fields sent t determination based on the tax policy configured and the Web Service Response Description The body of a web service response contain appropriate tax information to return to the transaction sy containers: request status tax document tax line tax data WSS-Header-Requirements Description In order to connect an application to ONESO following requirements and recommendations should be Password element with Type attribute. RECOMMENDEDXYZ !@#$

Document History Version Date Summary March 2015 First version of this guideDOCUMENT HISTORY Version Number v1

GlossaryAuditONESOURCE Indirect Tax Database where transaction tax liabilities are stored. Also referred to as Determination Audit.Consumer's Use TaxTax on the sale of a good or service that a purchaser is obligated to pay in their state of residence after the sale when the retailer did not chargetax on the good or service at the time of the sale. Consumer use tax is paid directly by the purchaser to the state department of revenue.DeterminationThe Thomson Reuters ONESOURCE Indirect Tax Determination product. A tax engine developed by Thomson Reuters that determines,calculates and records indirect tax liability. Also referred to as the Tax Engine. It is an application that calculates tax based on your company’sconfiguration and Determination Content.E-CommerceCommercial transactions conducted electronically on the Internet, usually providing shopping chart functionality. Also referred to as transactionsystem.ERPEnterprise resource planning (ERP) is a category of business-management software—typically a suite of integrated applications—that anorganization can use to collect, store, manage and interpret data from many business activities. Also referred to as the financial system ortransaction system.O2CAcronym for the order to cash, the end-to-end business process for receiving and processing customer orders (sales), invoicing the customer.and receiving payment from the customer.P2PAcronym for the procure to pay, the end-to-end business process for ordering products from suppliers (purchase orders), receiving supplierinvoices, and paying the supplier.Product CodeProduct codes are mapped to products (items/SKUs). They are usually stored on the master record of the item and cannot be changed during thetransaction process (order/invoice, etc.). Thomson Reuters provides a list of preset 4-character product codes/50 character product codedescription for customers to select from. Of the over 4,000 product codes provided, most customers only use a subset that is relevant to theirindustry. Product codes can be assigned to products (items, SKUs), sales categories, and/or miscellaneous charges.Sales TaxTax on the sale of a good or service that the seller is obligated to collect at the time of the transaction.Seller's Use TaxTax on the sale of a good or service that an out-of-state seller is obligated by the state to collect when selling the good or service into a statewhere they have nexus.Tax CodeA generic term; tax code, tax ID, tax schedule, tax area, or similar are common names for the indicator in a system of what tax to charge. Intraditional approaches, behind that tax code is a set of tables that hold tax rates which make up the tax to be charged for a given tax code. Inmost of our solutions, we replace that native tax code in the system with one indicating that tax on the transaction will be calculated externally. Weusually select a tax code of IDT or ONESOURCE. Tax codes are usually maintained in the master data (Customer/Vendor and Item) and usedfor tax calculation by a transaction when the customer and item tax codes match. In addition to alerting the transaction system that tax iscalculated externally, the tax code value plays a role when managing exemptions, see below.

Tax ContentStandard tax data for over 174 countries and 14,000 taxing authorities around the world, including sales, use, value-added and specialty taxes;updated monthly by the Thomson Reuters Tax Research Department.Tax EngineThe Thomson Reuters ONESOURCE Indirect Tax Determination product. A tax engine developed by Thomson Reuters that determines,calculates, and records indirect tax liability. Also referred to as Determination.TransEditorAbbreviation of transaction editor, it modifies the input XML before it is processed by Determination.