Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Brandon Sell
    SLA account rule for tax that takes segments from the AP...Answered
    Topic posted November 19, 2019 by Brandon SellBlue Ribbon: 750+ Points, tagged Accounting Hub Cloud Service, Configuration, Payables, Subledger Accounting 
    27 Views, 2 Comments
    Title:
    SLA account rule for tax that takes segments from the AP invoice distribution
    Content:

    We have a requirement for accounting on the recoverable and nonrecoverable tax lines. The cost center and location segments need to be the same as the AP invoice distribution line that the tax comes from. Is this possible?

    I tried creating 2 account rules that use the Source: "Invoice Distribution Account" and I selected the 2 segments that I needed. I applied these 2 rules to the invoice journal rule set in AP for both recoverable tax and nonrecoverable tax. However, when testing by creating the accounting, the tax lines still used the account string setup on the tax.

    I found a MOS document ( Doc ID 1914253.1 ) that says this is not currently possible in E-Business Suite for EBTax. Could the same true for taxes in Cloud for payables?

    Best Comment

    Stephen Horgan

    Brandon,

    It sounds like you were going down the right track trying to change the accounts via account rules.  However, the source should be "Item Charge Account for Tax".  Please review the following document for more details on making this type of account rule change:

    FUSION SLA: How to Setup Recoverable Tax to Use the Item Distribution Balancing Segment Value (BSV) (Doc ID 2247037.1)

    Regards,

    Steve

    Comment

     

    • David Taylor

      Brandon,

      It is certainly possible to do this in eBusiness Suite within SLA.  The non-recoverable tax automatically picks up the same accounting as the item distribution so theer is nothing needed there.  Are you saying the non-recoverable tax is going to a GL account that is different to the associated item distribution account?  For the recoverable tax we implemented a derivation rule to pick the value of the profit center segment for the 1st item line distribution.  We had to create a custom source to do that though whcih is probably not an option for cloud (not tried that yet). 

    • Stephen Horgan

      Brandon,

      It sounds like you were going down the right track trying to change the accounts via account rules.  However, the source should be "Item Charge Account for Tax".  Please review the following document for more details on making this type of account rule change:

      FUSION SLA: How to Setup Recoverable Tax to Use the Item Distribution Balancing Segment Value (BSV) (Doc ID 2247037.1)

      Regards,

      Steve