Skip to Content
0

Vendor Liabilities Aging Report

Mar 30, 2017 at 08:41 AM

52

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Balaji Selvaraj Mar 30, 2017 at 12:43 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0