cancel
Showing results for 
Search instead for 
Did you mean: 

Vendor Liabilities Aging Report

former_member413571
Discoverer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member312729
Active Contributor
0 Kudos

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

former_member413571
Discoverer
0 Kudos

Hi Balaji Selvaraj, thanks for your answer. If this the case if you don't mind, do you have script for this?

former_member312729
Active Contributor
0 Kudos

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

Answers (0)