HI Everyone Greetings!!! Please find attached is my Code to get Party / Customer all bills ( Cleared / Non Cleared ) i need your help in following I want to generate a report showing All Party Name with their Bill NO , Date, Amount and Collection details, Meaning ageing analysis of Collection that is Amount Recd against Bill in Withing 45 days or 45 to 60 days or 60 to 90 days or 90 days and above. but i dont know some how it is not working the way i want also if there are multiple rect or payment agst particular bill it show full amt outstanding. kindyy go through my attached code and pls guide what needs to be changed
Change this........... IsBillDateInAge1 : (($$IsEmpty:##AgeFrom) OR ((@@DSPToDate) > ($BillDate + ##AgeFrom))) AND + (($$IsEmpty:##AgeTo) OR ((@@DSPToDate) <= ($BillDate + ##AgeTo))) This will take care of the columnar bi-furcation as per dates............ Second...regarding the Age-wise amount, your collection is about Bills, and so is the compute within the collections. Hence it is taking the Bill Amount, ignoring the full receipt or partial receipt amount. You need to make a function which will extract the amount if it is a Receipt Voucher..... after comparing $Reference (billRef) + $LedgerName against which Sales Invoice it has been set-off. Add a Columnar field after BILLCl, where you dump this total receipt amount (which you can later hide) ..... then apply it in age-wise columns.
Thanks For your Reply But i had change the Code and Filter now it is working in way i wanted sample screen shot attached
Hi, No its not Auto column now i have hard coded this was in Hurry as client wanted to submit this report to auditor I have changed little with asking first Group Name - as it was taking long time b4 opening the report so this divides the time
