Can someone help me to get purchase bill date

Discussion in 'Free Source Codes' started by ANURAG954245, Oct 1, 2021.

    
  1. ANURAG954245

    ANURAG954245 Member


    [#Line:VCHREF]
    Field:LRNOTITLE
    Left Field:LRNODATA
    Invisible:NOT $$IsPurchase:$VoucherTypeName

    [Field:LRNOTITLE]
    Use:MEDIUM PROMPT
    Set as:'LR NO'

    [Field:LRNODATA]
    Use:NAME FIELD
    Storage:LRNODATA
    Align:Center

    [#Line:VCHREF]
    Field:NOOFPARCELSTITLE
    Left Field:NOOFPARDATA
    Invisible:NOT $$IsPurchase:$VoucherTypeName

    [Field:NOOFPARCELSTITLE]
    Use:MEDIUM PROMPT
    Set as:'NO OF PARCELS'

    [Field:NOOFPARDATA]
    Use:NAME FIELD
    Storage:NOOFPARDATAS
    Align:Center

    [System:UDF]
    LRNODATA:String:10005
    NOOFPARDATAS:String:10006

    [#Part: VCHTitle2Left]
    Width:100


    ; above code is to feed tha data from purchase sale


    ;below codes are to display tha data in dayu book

    [#Line: DBTitle1]

    Add : Field : After : DSP VchAcctTitle : BILLREFNOT,LRNOT,BILLINGDATET,NOOFPART



    [Field:BILLREFNOT]
    Set as :'REFERENCE NO'
    Width : 10
    Align : center
    Style : Normal
    border : thin right left
    Border : Thin bottom
    Space Right:1
    Color:RED

    [Field:LRNOT]
    Set as :'LR NO'
    Width : 5
    Align : center
    Style : Normal
    border : thin right left
    Border : Thin bottom
    Space Right:1
    Color:BLUE



    [Field:BILLINGDATET]
    Set as :'PURCHASE DATE'
    Width : 10
    Align : center
    Style : Normal
    border : thin right left
    Border : Thin bottom
    Space Right:1
    Color:Magenta

    [Field:NOOFPART]
    Set as :'NO OF PARCELS'
    Width : 10
    Align : center
    Style : Normal
    border : thin right left
    Border : Thin bottom
    Space Right:35
    Color:GREEN

    [#Field:INVDT]
    Invisible:Yes










    [#Field:INVDT]

    Invisible:Yes



    [#Line: DSP VchDyBkDetail]
    Add : Field : After : DSP VchAccount : REFNOD,LRNOD,BILLDATED,NOOFPARD




    [Field: REFNOD]
    Use : Name Field
    Set As : $Reference
    Width : 8
    Align : Left
    Color: RED
    Style : Normal


    [Field:LRNOD]
    Use : Name Field
    Set As : $LRNODATA
    Width : 8
    Align : Left
    Color:BLUE
    Style : Normal

    [Field:BILLDATED]

    Use : Uni Date Field
    Set as : $BillDate
    Width : 8
    Align : Left
    Color:Magenta
    Style : Normal


    [Field:NOOFPARD]
    Use : Name Field
    Set As : $NOOFPARDATAS
    Width : 8
    Align : Left
    Color:GREEN
    Style : Normal







    [#Collection: Vouchers of Ledger]

    Fetch : Reference]
    Fetch:NOOFPARDATAS
    Fetch:LRNODATA
    Fetch:$BillDate



    [#Collection: Daybook Vouchers of Company]

    Fetch : Reference]
    Fetch:NOOFPARDATAS
    Fetch:LRNODATA
    Fetch:$BillDate

    [#Collection : Specific Vouchers of Company]
    Fetch : Reference]
    Fetch:NOOFPARDATAS
    Fetch:LRNODATA
    Fetch:$BillDate



    [#Collection: Vouchers of Group]

    Fetch : Reference]
    Fetch:NOOFPARDATAS
    Fetch:LRNODATA
    Fetch:$BillDate



    upload_2021-10-1_10-41-27.png
    im not able to fetch this date in day book
     


  2. jgkumar1976

    jgkumar1976 Member


    USE

    Set As:$ReferenceDate
     


  3. ANURAG954245

    ANURAG954245 Member


    thanks but this code worked for me
    Set as : $VCHReferenceDate
    Fetch:VCHReferenceDate
     


Share This Page