Dear Experts I want to Know the Pending Bills for Given Particular Period But Tally Give all Pending bills To Period Date Example: 001 1.4.2104 1000 pending 002 2.4.2014 2000 pending IF I give the Period From : 02.04.2014 To 02.04.2014 Tally Show the 001 1.4.2014 1000 002 2.4.2014 2000 But I want 002 2.4.2014 2000 How to Solve the Issue
Mr.Manish, Just given one filter in Outstanding Collection. You have to filter the date between period.
Dear Sir, I give one filter but it is not working [#Collection: Ledger Bills] Filter: GPeriod [System: Formula] GPeriod : $BillDate >= @@DSPFromDate or $BillDate <= @@DSPToDate
Respected sir, Kindly use the following code and try [#Collection: Company Receivables] Add:Filter:IsmyFromDt [System:Formula] IsmyFromDt:$billdate=>##svfromdate
In Display/Statement of accounts/Outstandings/Bills Outstanding just use AltF12 filter in default tally and Filter Bill/Date/Equel To/02.04.2014 Same way you can use Greater Than or Less Than parameters too, you will get filtered outstanding bills.
Dear Experts I have also one query payment received on after 7th april 2014 when I view outstanding report on dated 7th april with using including post dated transaction in f12 outstanding show is perfect but my query is final balance amount nil then not show in o/s report. I attached screen shot
Final Balance is arrived at after considering the post dated receipt, means the final balance is not as on the date of report but after considering the post dated receipt.