Payables & Cash Management

Get Involved. Join the Conversation.


    Thomas Paul
    AP Invoice Import Tax Lines
    Topic posted May 4, 2017 by Thomas PaulBronze Medal: 1,250+ Points, last edited January 30, 2019, tagged Payables 
    312 Views, 4 Comments
    AP Invoice Import Tax Lines
    Importing AP Tax Lines


    We are importing AP Invoices with tax lines from external system. An example:

    Line 1: item  $ 100
    Line 2: item  $ 250

    Line 3: Tax  $ 10

    Line 4: Tax $ 25

    After the import, taxes are getting combined into 1 tax line for $ 35(tax distributions are showing as two lines).

    How can we bring 2 tax lines?



    • Becky Alvarez


      We summarize the tax lines and have one tax line per rate to regime (R2R). So they can bring in two tax lines but if both of them belong to the same R2R then it will be combined into one. If they belong to different R2R then they will not be combined.

    • Thomas Paul

      Thanks for the response. So basically our tax logic is same for the country(as opposed to counties/states etc)- i guess that's one R2R? Is there any way to get our requirement of different tax lines with our logic mentioned above.

    • Becky Alvarez


      Unfortunately I am not a tax expert.  Here is what I found in the online help pages.  I hope this answers your questions.


      Regimes to Rates: Explained

      Help topic
      | 03/08/2017 | Generic
      Add to browser favoritesBookmark Print E-Mail

      Regime to rate setup contains the details of a tax regime, including all taxes, tax jurisdictions, tax statuses, and tax rates. You can update existing records or create new records at any point in the tax regime hierarchy.

      Regime to rate setup tasks include:

      Tax Regimes

      Set up tax regimes in each country and geographical region where you do business and where a separate tax applies. A tax regime associates a common set of default information, regulations, fiscal classifications, and optionally, registrations, to one or more taxes. For example, in the US, create a Sales and Use Tax tax regime to group taxes levied at the state, county, and district levels. For the UK, create a tax regime for GB VAT.


      Set up details for the taxes of a tax regime. Each separate tax in a tax regime includes records for the tax statuses, tax rates, and tax rules that are used to calculate and report on the tax.

      For example, for US Sales and Use Tax define a tax for each state, county, and city. For the UK, set up a tax for GB VAT.

      Tax Jurisdictions

      Set up tax jurisdictions for geographic regions or tax zones where a specific tax authority levies a tax. A tax jurisdiction specifies the association between a tax and a geographic location.

      You also use tax jurisdictions to define jurisdiction-based tax rates. A tax jurisdiction tax rate is a rate that's distinct to a specific geographic region or tax zone for a specific tax.

      For example, for US Sales and Use Tax create a county jurisdiction for every county in the parent geography type of State and in the parent geography name of California. For the UK, create a tax jurisdiction for the country of United Kingdom.

      Tax Statuses

      Set up the tax statuses that you need for each tax that you create for a combination of tax regime, tax, and configuration owner. A tax status is the taxable nature of a product in the context of a transaction and specific tax on the transaction.

      For example, for US Sales and Use Tax create a tax status for standard and exempt. For the UK set up separate tax statuses for standard, zero, exempt, and reduced rates.

      Tax Rates

      Set up tax rates for your tax statuses and tax jurisdictions. For tax statuses, set up a tax rate record for each applicable tax rate that a tax status identifies. For tax jurisdictions, set up tax rate records to identify the tax rate variations for a specific tax within different tax jurisdictions.

      For example, for US Sales and Use Tax create a tax rate for each tax jurisdiction (jurisdiction-based rates). For the UK, set up separate tax rates for standard, zero, exempt, and reduced (tax status-based rates).

      Tax Recovery Rates

      Set up tax recovery rate codes for the recovery types identified on the taxes within a tax regime. A tax recovery rate code identifies the percentage of recovery designated by the tax authority for a specific transaction.

      For example, organizations that produce VAT-applicable goods and services are allowed to recover 100% of the VAT they pay on typical purchases. They would use a default 100% recovery rate.

      Organizations, such as financial institutions, which create services that are exempt from VAT, are not able to recover VAT on their normal purchases. They would use a default 0% recovery rate.

    • Santosh Pallerla

      Could you upload the AP invoice interface FBDI to take a closer look of data which is getting summarized?

      Under which scenario your issue falls in?

       2: Exclusive Manual Tax               

       3: Exclusive Manual Tax Applicable to All Item Lines       

       4: Exclusive Manual Tax Line Not Applicable to All Item Lines     

       5: Multiple Exclusive and Manual Tax Lines         

       6: Multiple Exclusive and Manual Tax Lines, Not All Lines have Tax          

       7: Multiple Exclusive and Manual Tax Lines, One Tax Line Prorated Across Many Lines

       8:  Multiple Exclusive and Manual Tax Lines, Same Regime to Rate Information

       9: Inclusive Manual Tax Line Applicable to All Lines

       10: Multiple Inclusive and Manual Tax Lines