Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    ALEXANDER JOSEPH
    Default the distribution combination based on Project...Answered
    Topic posted October 10, 2019 by ALEXANDER JOSEPHRed Ribbon: 250+ Points, tagged Payables, Setup / Administration, Subledger Accounting 
    29 Views, 4 Comments
    Title:
    Default the distribution combination based on Project details
    Summary:
    Default the distribution combination based on Project details
    Content:

    Requirement is to default the distribution combination based on Project details.

    Setup done:

    We have setup project accounting rules for the various segments and linked it to the Subledger Journal Entry Rule Sets for payables for invoice event class and different journal lines for item expense , tax etc

    Created a distribution set to default a distribution combination and then based on the above rules , the new distribution combination would be derived.

    Issues/Clarifications:

    1. Is it necessary to create a distribution set to default a distribution combination. We are unable to derive the distribution combination from the Subledger Journal Entry Rule Set unless there is a distribution set?

    2. In Procurement , when the user enters the Project details , the distribution combination are populated immediately. In the case of AP , this happens only when we run Create Accounting.Is this the functionality?

    3.The distribution combination is created correctly when Create accounting is doen and posted to ledger , however the new combination doesnt get updated on the invoice

    4.Account coding workflow functionality cannot be used since the user now has to enter both the project details and distribution combination which doesnt make sense

    5.Is there an option to disable the distribution combination field on the invoice

    Please point me to any documentation if available

    Thanks

    Alex

     

     

    Best Comment

    Gopal Somani

    Hi Alex,

    Agreed, Its not a proper solution. There is already a Bug raise for this

    Bug 21660055 : TRANSACTION ACCOUNT BUILDER FOR PAYABLES

    You can check below support notes as well

    PJC: Unable To Access Project Fields On Project-Related Payables Invoice Distribution Line and Can't Setup Transaction Account Builder(TAB) For Projects (Doc ID 1490691.1)

    Is Transaction Account Builder Feature Available In Fusion Payables? (Doc ID 2190739.1)

    Regards,

    Gopal

    Comment

     

    • Gopal Somani

      Hi Alex,

      Procurement has TAB (transaction account builder) which defaults the accounts. TAB is not there in Payable so defaulting the distribution account is not possible here. Here we need to enter distribution manually or enter a distribution set. But you can create SLA rules to override the accounting based on Project related attributes.

      The override works on the accounting only, it does not update the distribution.

      Please let me know if you have any further questions.

      Regards,

      Gopal

      • ALEXANDER JOSEPH

        Hi Gopal,

        More of a usability issue because of this limitation, the customer has to enter a distribution manually which is a dummy value , then enter the project details. After running Create accounting to default the distribution combination , the user sees 2 values , one in the view accounting and the dummy value in the distribution combination.

        Entering dummy values , distribution combination not getting updated just doesnt feel like a proper solution.

        regards

        Ale

    • Gopal Somani

      Hi Alex,

      Agreed, Its not a proper solution. There is already a Bug raise for this

      Bug 21660055 : TRANSACTION ACCOUNT BUILDER FOR PAYABLES

      You can check below support notes as well

      PJC: Unable To Access Project Fields On Project-Related Payables Invoice Distribution Line and Can't Setup Transaction Account Builder(TAB) For Projects (Doc ID 1490691.1)

      Is Transaction Account Builder Feature Available In Fusion Payables? (Doc ID 2190739.1)

      Regards,

      Gopal

    • Janelle Azimullah

      I've added my customer to the SR for this but it would be really good to have this raised in Ideas - I'm sure there would be plenty of Customer Connect members who would vote for this. This has been a pain point for a while now.