Skip to Content
avatar image
Former Member

Vendor Liabilities Aging Report

Hello Experts!

When generating report in vendor liabilities aging my client don't want it to appear in negative balance since credit is its normal balance, is there a solution for this as it was SAP standard report? thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 30, 2017 at 12:43 PM

    Hi Mary Rachelle Garcia,

    In standard report its not possible since Display Credit Balance with Negative Sign is checked the balance for vendors will list in negative sign. Through Sql report you can change the sign.

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

    • Try this as per need u may need to change some lines

      select OCRD.cardcode 'Supplier Code',OCRD.cardname 'Name',sysdeb 'Debit GBP',syscred 'Credit GBP', case JDT1.transtype when '-2' then 'OB' when '18' then 'PU' when '19' then 'PC' when '46' then 'PS' else 'Other' end 'Type', Ref1, fccurrency 'BP Currency', CONVERT(VARCHAR(10), refdate, 103)'Posting Date' , CONVERT(VARCHAR(10), duedate, 103) 'Due Date', CONVERT(VARCHAR(10), taxdate, 103) 'Doc Date' , CASE when DATEDIFF(dd,taxdate,current_timestamp) < 31 then case when syscred <> 0 then syscred * 1 else sysdeb end end "0-30 days", case when (datediff(dd,taxdate,current_timestamp) > 30 and datediff(dd,taxdate,current_timestamp)< 61) then case when syscred <> 0 then syscred * 1 else sysdeb end end "31 to 60 days", case when (datediff(dd,taxdate,current_timestamp) > 60 and datediff(dd,taxdate,current_timestamp)< 91) then case when syscred <> 0 then syscred * 1 else sysdeb end end "61 to 90 days", CASE when DATEDIFF(dd,taxdate,current_timestamp) > 90 then case when syscred <> 0 then syscred * 1 else sysdeb end end "90 + days" from JDT1,OCRD where JDT1.shortname = OCRD.cardcode and cardtype = 's' and intrnmatch = '0' ORDER BY OCRD.CARDCODE, taxdate