Accounting Hub

Get Involved. Join the Conversation.

Topic

    Amit Mishra
    Modify Payables SLA rules for 'Payment request'...Answered
    Topic posted July 17, 2019 by Amit MishraRed Ribbon: 250+ Points, tagged Configuration, Expenses, Financials, Payables, Setup / Administration, Subledger Accounting 
    152 Views, 8 Comments
    Title:
    Modify Payables SLA rules for 'Payment request' invoice type imported from Expenses cloud
    Summary:
    Update product segment based on the cost center segment value for AP invoices created imported from expense report
    Content:

    Hi All,

    We have expenses cloud implemented and employees are submitting expense report and invoices are being imported into payables with invoice type as 'Payment request'. The default distribution account is automatically picked from the employees default expense account setup in HCM.

    Now We have a requirement to derive one of our segment (product which is segment 2 in our COA) value based on the cost center segment (segment 3 in our COA) value on the AP line distribution account. I have defined an account rule of value type mapping set. The mapping set will have hold a mapping between the cost center and product segment value. The input source of the mapping set which I am choosing is the cost center (Value for the cost center segment of the accounting flexfield that payables overlays on the generated distribution combination) of the 'Invoice' event class. 

    I have assigned this account rule to the journal entry rule set of journal line rule of 'Item Expense'. Assigned the journal entry rule set to the appropriate accounting method and activated the assignments.

    Finally after the invoice of 'Payment request' type is created in AP, when I account in draft, system doesn't derive the accounting as intended, instead it keeps the same default expense account from the employee level.

    What am I missing here? I doubt the cost center input source in the mapping set because the description says - Value for the cost center segment of the accounting flexfield that payables overlays on the generated distribution combination -- What is that overlays ? Is it any different than the cost center which system is getting from the employee setup in HCM by default? There is no other cost center source available for invoices event class.

    Any help would be appreciated. 

    Thanks 

     

    Version:
    19B
    Image:
    Document:
    AP SLA.docx (208KB)

    Best Comment

    Gergana Radoutcheva

    You could try a mapping set with Output type: Segment using the Cost Center Segment of the Invoice Distribution Account source as input.

     

     

    Comment

     

    • Becky Alvarez

      Moved from Payables & Cash Management in hopes of finding the experts in SLA he needs.

    • afton liu

      hi,amit

      you can set the condition at account rule,then I test,it can works fine

      pls review attachment

      • Amit Mishra

        Thanks, Afton. This condition is already in place in my account rule too, however, my question was about mapping set input source which I chose as the cost center (Value for the cost center segment of the accounting flexfield that payables overlays on the generated distribution combination) of the 'Invoice' event class.

        My objective is to derive the product segment based on the cost center on the accounting string. SLA rules don't seem to recognize the cost center input source of the mapping set.

        Hope it clarifies

        Regards/Amit

         

    • Gergana Radoutcheva

      You could try a mapping set with Output type: Segment using the Cost Center Segment of the Invoice Distribution Account source as input.