Integrations and Extensions

Enterprise Resource Planning

Topic

    David Cesteros
    How works 'Tax Entry Repository Data Upload...
    Topic posted March 1, 2016 by David CesterosRed Ribbon: 250+ Points, last edited January 30, 2019, tagged Financials 
    136 Views, 13 Comments
    Title:
    How works 'Tax Entry Repository Data Upload Interface' template
    Summary:
    I´d like to know how works 'Tax Entry Repository Data Upload Interface' template
    Content:

    Hi,

    We are trying to use 'Tax Entry Repository Data Upload Interface' template in a demo instance, but not works

    Could anybody explain how works?

    Besides we want to load GL  journals with tax information for customer invoices from external systems, but we don´t have integreted those customer in the system. I think customer should be created in Oracle fusion. How we can manage this?

    Besides, we´re not able to see flexfield fields in the template, is possible to add those fields? we´d need to load more information that the fields seeded in the templete

    Thanks in advance

     

     

     

    Comment

     

    • Uma Pachipala

      Hi David,

      Which method you are attempting to use? Spreadsheet (ADFDI) or FBDI?

      Uma

    • David Cesteros

      Hi Uma,

      We are attempting use all of these:

      1-Create Taxable Journals spreedshet
      2-Taxable Transaction spreadsheets
      3-Tax Entry Repository Data Upload Interface (FBDI)

      Although we have doubts with all of them, the most complex is the last one.

      Thanks


       

       

    • Uma Pachipala

      David,

      Tax Entry Repository Data upload (FBDI) is the most complex one and I could never make it work. Couple of my customers use Create Taxable Journals spreadsheet. I did use Taxable Transaction spreadsheet during CRPs.

      Key points on taxable journals and transactions

      1) Taxable journal requires legal entity level subscription which you do in you tax regime setup

      2) Taxable transaction requires BU level subscription

      3) Taxable transaction is similar to making a transaction in AP or AR i.e. you require to fill in all details

      4) Taxable journal works at legal entity level, thus do not require BU level details. You enter the amount details and GL accounts. GL accounts you enter are not tax accounts. The tax accounts are derived from tax setups. 

      5) Spradsheet upload process submits Create Accounting, which do the GL journals

      I hope this assists and clarifies few things 

       

      Uma

       

       

    • David Cesteros

      Hi Uma,

      Thanks for your response.

      It´s  discouraging know that the most complex one you are not able to do that it works...

      Regarding with the spreedsheet templates, for your comments it´s seems you need to have customer created in the system, you are not able to include customer not included in the system, is correct my assumption?

      Do you know if it´s possible to add flexfields fields in the seeded template? we´d need to add more information in the journal lines

      Thanks again

      David

       

    • Uma Pachipala

      David,

      I did had a quick look at R10 setups of my instances. It appears to me that there is no DFF available for Tax Repository. I believe that is the reason the excel templates do not hold Flex columns.

      Secondly, if you check in the Enterprise Repository the FBDI Tax template is not available for R10.

      Perhaps worth raising an SR

      Uma

    • David Cesteros

      Hi Uma,

      Thanks for your interest.

      As we don´t have Receivables module, do you know if it´s possible to assign a customer that doesn´t  exist in the system?

      I have just raised a SR.

      I already saw that the FBDI tax template was for R9, but I assumed that it should work for R10 also....

      Thanks again for your support

       

    • Uma Pachipala

      David,

      Given you do not have Receivable module and assuming FBDI is not supported for R10, you are left with only one choice to get the tax information loaded into repository i.e. Tax Journal (Sales journal) . This gives you only 2 description columns which you can design to use to get the customer name, something like comma separated values.

      Uma

    • David Cesteros

      Hi Uma,

      Thanks again for your help

      The problem that we have is that Tax journal spreedsheet only have 2 description field, and we´d need to add around 10 new fields, we not only have to add customer name, also we´d need Tax registration number, invoice number and other mandatory fields in order to send tax information to spanish authorities 

      I think the only choice that we will have is use the standard journal spreedsheet template and create a report in order to get all that information...We´d need to add a journal line with the tax accounting

      Kind Regards

      David

    • Uma Pachipala

      Hi David,

      Without the presence of Receivable module, I believe that is the only choice you have. Use GL Journal line DFF to populate all info and refer that line in tax repository. Its not elegant, but not sure any other choice.

      Uma

    • David Cesteros

      Hi Uma,

      Thanks for your response.

      How we can refer the journal tax line in tax repository? I didn´t know this choice...

      What adventages have this choice?

      Thanks again

      David

       

       

    • Uma Pachipala

      David,

      What I meant is 

      (1) Enable doc sequences on journals.

      (2) Load your data into GL Journals - GL journals do have enough DFF fields to let you add extra information 

      (3) Use the doc sequence number and load tax information into tax repository 

      (4) Use a custom report to link them

      Yes, its not ideal, but given you do not have or you do not want to implement AR and Tax spreadsheets do not support DFF's, your options are limited, and there is no clean solution to it.

      Uma

    • David Cesteros

      Thanks Uma,

      I will review your action plan

      Thanks again for your help

      David

       

       

    • Uma Pachipala

      I have a special interest on tax. Let me know how you go.

       

      Uma