Pending List Bill Date Wise

Discussion in 'Requests' started by Bipin Damania, May 18, 2019.

    
  1. Bipin Damania

    Bipin Damania Active Member


    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.
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Similar query already raised before and solution given too...........

    Kindly browse / search through the forum for the same.
     


  3. Bipin Damania

    Bipin Damania Active Member


    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.
     


  4. mukeshb

    mukeshb Member


    Correct Sir Ji,
    It is not Shorting date .
     


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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........

    1Capture.PNG


    2nd screen with DATEwise Sorting........

    2Capture.PNG

     


  6. Bipin Damania

    Bipin Damania Active Member


    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.

    2019-05-19 (2).png
     


  7. Bipin Damania

    Bipin Damania Active Member


    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
    
     


  8. nasir

    nasir Member


    kindly share full code plzzzzzzz
     


  9. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    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.
     


  10. Bipin Damania

    Bipin Damania Active Member


    Thank you Amitji
     


Share This Page