Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Yasmin
    Payables Invoice T-Account
    Topic posted January 22, 2019 by YasminSilver Trophy: 7,500+ Points, last edited February 6, 2019, tagged Financials, Fusion, Payables, Public Sector, Setup, Subledger Accounting 
    55 Views, 4 Comments
    Title:
    Payables Invoice T-Account
    Summary:
    Payables Invoice T-Account layout
    Content:

    Hi Everyone,

    After creating the Payables standard invoice and validated it successful  

    then creating the draft accounting, it creates the below entry lines

    Where:

    Line #1 it's the expense side (1000)

    Line #4 It's the Withholding tax (100)

    Line #3 it's the AP account (1000)

    Line #2 is What ?

    Is there a way to get the net of lines 2 and 3 together? so it shows only 900 (the amount will be paid)

    Also why the total shows 1100 ?

    the above 3 pints are annoying  the implementation client, and for them it's a "show stopper"

    and can't proceed in the implementation project :(

     

    Can someone help please to show only the net of the AP activities, and with the transaction total as it shows amount more than what entered

     

    Thanks

     

    Yasmin

    1   Invoice Validated
       
     
    10-10-5141000-10001-000000000000    
    Item expense 1,000.000  
    2   Invoice Validated
       
     
    10-00-2111010-00000-000000000000    
    Liability 100.000  
    3   Invoice Validated
       
     
    10-00-2111010-00000-000000000000    
    Liability   1,000.000
    4   Invoice Validated
       
     
    10-00-2111040-00000-000000000000    
    Withholding tax   100.000
    Image:

    Comment

     

    • Suresh Kumarasamy

      Hi,

       

      Actually, withholding tax liability will be paid to concerned tax authority, so your total liability due to supplier will be 900 and 100 liable to your tax authority. When you check the liability account balance in GL, it will show only 900 balance in AP liability account. 

      This is the seeded oracle accounting,

       

      Regards

      Sk

      • Yasmin

        Hi SK,

        Thanks for your reply,

        I'm totally aware that this is the standard functionality ,

        and this is what we said to the client,

        but there are asking for the T-Account itself, how can we change the way it presents the accounting 

         

        Yasmin

    • Neelam Thakur

      Hi Yasmin,

       

      In EBS, there used to be display options for T-Accounts. I am not sure those are available in Fusion yet. If I am understanding correctly, it is the presentation of the T-Accounts that you client wishes to change. It may not be possible, but I would log a How-to SR and perhaps put in an Enhancement request. Also add to the Idea dashboard.

       

      Thanks,

      Neelam

      • Yasmin

        Hi Neelam,

        Yes you are right, it's only the presentation that not accepted by the client

        how can we change it ?

         

        Yasmin