on 03-30-2017 9:41 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.