Dear Admin, I am Trying to generate a report which should show month wise Cash receipt Total and bank receipt total. i could able to get months but i am unable to get Total of Cash Receipts Month wise. I am attaching my code and also my desired report picture for your observation and necessary suggestions. Thanks in advance
In your collection : Ledger Period Collection1............ Aggr Compute : CashAmount : If $$IsLedofGrp$AllLedgerEntries[1].LedgerName):$$GroupCash OR $$IsLedofGrp$AllLedgerEntries[-1].LedgerName):$$GroupCash Then $Amount Else 0 And you have already computed the total amount....so deduct that from the CashAmount and you will get your BankAmount
Thanks for your Immediate reply But Values are getting in the last Line after March month of Cash Field and i want total of all receipt type vouchers and not onnly receipt voucher i modified the filter but all values are not summed voucher wise totals are shown. how to overcome this. I am also attaching Sample Company Data along with modified code and Its Results
Dear Sir, As per PANKAJ BHONDLE sir advise i have adopted the code given inn Monthly Summary Sales & Purchase tdl in this forum but i am getting totals ledger wise. I mean if i have two cash accounts then two columns are shown automatically similarly if more than 1 bank account means similar number of bank columns. I am attaching code as well as output screen picture for your observation kindly advise me
I need Monthly outstanding report Vertically Like: Jan Feb March Apr May any one have sample pls share with me 8825750797