Dear All Experts While making Payment or Receipt from Sundry Creditors or Sundry Debtors List appearing Bill No wise, If I want List to display Bill Date wise, How the same is possible. Please reply.
Similar query already raised before and solution given too........... Kindly browse / search through the forum for the same.
Dear Amitji Mapl2311 has replied this It is not Possible. In Tally, in the Table display, fields are converted into String. So Date field sorting not work... Hope you asking to refer the same. Thank you.
Thank you and I have also replied in the same...........but later on made it possible......... And I had even shared the screenshot of the same......... sharing the screen once again......... First screen.....is normal Tally sorting....... Second is my revised.....based on date........ 2nd screen with DATEwise Sorting........
Amitji I got Pending Bills List as per Date-Wise but With 2 problem 1] Heading is not proper & 2] On selection instead of Bill Name, Bill Date is showing... Please guide. Thank you.
Amitji Please find code Code: [#Collection: Pending Bills] Delete: Format Title : $$LocaleString:"Pending Bills" add:Sub Title : $$LocaleString:"Date", "Name", "Balance", "Final Balance" Source Collection : Pending Bills SRC Fetch : BillDate, Name, BillCreditPeriod, BaseClosing, FinalBalance Add : Format : $BillDate, 8 : Short Date : "DD-MM-YY" Add : Format : $$Name, 14 Unique : $$Name Add : Format : $BaseClosing : "AllSymbols, DrCr" Client Only : Yes Keep Source : ... ;; Keep the source at Bill allocations subform Level Option : ShowBillFnlBlnc : ##VchShowBillFnlBlnc
Amitji I got Pending Bills List as per Date-Wise but With 2 problem (still they are not date-wise. You need to reverse the dates to yyyy-mm-dd to have a proper sorting) 1] Heading is not proper & (need to delete sub-title also, before adding new sub-titles.) 2] On selection instead of Bill Name, Bill Date is showing... (Yes. I never tried it....just sorted the dates. I guess for this changes ..... one needs to change the Tally Function ..... FnSetBillName .... which is covered under the Field : VCHBILL Name. ) Long before I knew TDL.......... i used to apply simple logic................ In all bill references I started with 2015/001, 2015/002 and so on.... in this manner I always got it chronological order. Even though the Party's bill reference has characters or anything, I always prefix it with the year. Please guide. Thank you.