,ISNULL((SELECT T0.Debit-T0.Credit WHERE DateDiff(day, T0.DueDate,'')=0 and DateDiff(day, T0.DueDate,'')30 and DateDiff(day, T0.DueDate,'')60 and DateDiff(day, T0.DueDate,'')90 and DateDiff(day, T0.DueDate,'')=121),0) '121+ Days'įROM JDT1 T0 INNER JOIN OCRD T1 ON T0.ShortName = T1.CardCode T0.DueDate, (T0.Debit- T0.Credit) 'Balance' SELECT T1.CardCode, T1.CardName, T1.CreditLine, T0.RefDate, T0.Ref1 'Document Number', DESCRIPTION: This SQL script is for debtors aging reports on specified date and can be modified as required. B-FN Debtors Aging Report by date Ver 1 ND 2011 05 20 It is the basic outline and can be used as base to modify as per customer requirements. This query will show Debtors Ageing Report on specified date entered. PURPOSE AND BACKGROUND: This SQL was created in 8.8 PL16. (Back to B-FN Financials Module SQL Posted to Wiki Listing - B-FN Financials Module SQL Posted to Wiki )
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |