Batch No, Mfg Date and Expiry Date Column in Sales Voucher

Discussion in 'Free Source Codes' started by Rohit Khedar, Mar 21, 2021.

    
  1. Rohit Khedar

    Rohit Khedar Member


    ;; Plz Help When I select Item after Cursor go again reference field


    [#Line: EI ColumnOne]
    Option : TlyErp EI ColumnOne

    [!Line : TlyErp EI ColumnOne]

    Add : Right Fields : Before : VCH QtyTitle : TlyErp VCH BatchTitle, TlyErp VCH MfgTitle, TlyErp VCH ExpTitle

    [Field: TlyErp VCH BatchTitle]

    Set as : $$LocaleString:"Batch No"
    Style : Small Bold
    Align : Centre
    Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : Yes
    Fixed : Yes
    Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise

    [Field: TlyErp VCH MfgTitle]

    Set as : $$LocaleString:"Mfg. Date"
    Style : Small Bold
    Align : Centre
    Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : Yes
    Fixed : Yes
    Width : if (@@HasExpiryDate OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise

    [Field: TlyErp VCH ExpTitle]

    Set as : $$LocaleString:"Exp. Date"
    Style : Small Bold
    Align : Centre
    Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : Yes
    Fixed : Yes
    Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise


    ;; ------------------------------------------------------------- ;;

    [#Line: EI InvInfo]
    Option : TlyErp EI InvInfo

    [#Line: CI InvInfo]
    Option : TlyErp EI InvInfo

    [!Line : TlyErp EI InvInfo]
    Add : Right Fields : Before : VCH BilledQty : TlyErp VCH BatchName, TlyErp VCH MfgDate, TlyErp VCH ExpDate

    [Field : TlyErp VCH BatchName]

    Use : Batch Name Field
    Align : Centre
    Style : Small
    Set as : $BatchName
    Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise
    Color : @@SV_VCHCOLOR
    Background : @@SV_VCHTYPE

    [Field : TlyErp VCH MfgDate]

    Use : Short Date Field
    Align : Centre
    Style : Small
    Set as : $MfdOn
    Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise
    Color : @@SV_VCHCOLOR
    Background : @@SV_VCHTYPE


    [Field : TlyErp VCH ExpDate]

    Use : Due Date Field
    Align : Centre
    Style : Small
    Set as : $ExpiryPeriod
    Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise
    Color : @@SV_VCHCOLOR
    Background : @@SV_VCHTYPE
     



  2. [#Line: EI ColumnOne]
    Option : TlyErp EI ColumnOne : Yes

    [#Line: EI ColumnTwo]
    Option : TlyErp EI ColumnOne : Yes
    [#Line: EI ColumnOneRate]
    Option : TlyErp EI ColumnOne : Yes
    [!Line : TlyErp EI ColumnOne]

    Add : Right Fields : Before : VCH QtyTitle : TlyErp VCH BatchTitle, TlyErp VCH MfgTitle, TlyErp VCH ExpTitle

    [Field: TlyErp VCH BatchTitle]

    Set as : $$LocaleString:"Batch No"
    Style : Small Bold
    Align : Centre
    ;Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : Yes
    Fixed : Yes
    ;Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise

    [Field: TlyErp VCH MfgTitle]

    Set as : $$LocaleString:"Mfg. Date"
    Style : Small Bold
    Align : Centre
    ;Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : Yes
    Fixed : Yes
    ;Width : if (@@HasExpiryDate OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise

    [Field: TlyErp VCH ExpTitle]

    Set as : $$LocaleString:"Exp. Date"
    Style : Small Bold
    Align : Centre
    ;Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT @@IsPhysStock AND NOT @@IsStockJrnl
    Skip : Yes
    Fixed : Yes
    ;Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise


    ;; ------------------------------------------------------------- ;;

    [#Line: EI InvInfo]
    Option : TlyErp EI InvInfo : @@issales

    [#Line: CI InvInfo]
    Option : TlyErp EI InvInfo : @@issales

    [!Line : TlyErp EI InvInfo]
    Add : Right Fields : Before : VCH BilledQty : TlyErp VCH BatchName, TlyErp VCH MfgDate, TlyErp VCH ExpDate

    [Field : TlyErp VCH BatchName]

    Use : Batch Name Field
    Align : Centre
    Style : Small
    Set as : $BatchName
    ;Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise
    Color : @@SV_VCHCOLOR
    Background : @@SV_VCHTYPE

    [Field : TlyErp VCH MfgDate]

    Use : Short Date Field
    Align : Centre
    Style : Small
    Set as : $MfdOn
    ;Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise
    Color : @@SV_VCHCOLOR
    Background : @@SV_VCHTYPE


    [Field : TlyErp VCH ExpDate]

    Use : Due Date Field
    Align : Centre
    Style : Small
    Set as : $ExpiryPeriod
    ;Width : if (@@HasMfgDateSet OR @@IsPhysStock) then 9 else @@VCHBatchNameWidth
    Inactive : NOT @@HasBatchWise
    Color : @@SV_VCHCOLOR
    Background : @@SV_VCHTYPE
     



  3. see if u are setting a condition which need to check the main object , for eg u set width on basis of voucher type condition, then each time tally check that condition is true or not. so its back to first field of object = voucher , which is reference field.
    pl check this repaired code
     


  4. Rohit Khedar

    Rohit Khedar Member


    cursor no back but now title name hidden
    here I want batch set item select then title name show otherwise hide title name
     


  5. Rohit Khedar

    Rohit Khedar Member


    cursor no back but now title name hidden
    here I want batch set item select then title name show otherwise hide title name
     

    Attached Files:

    • 2.jpg
      2.jpg
      File size:
      44.8 KB
      Views:
      49
    • 2.jpg
      2.jpg
      File size:
      44.8 KB
      Views:
      57
    Muhammadhaneef likes this.


Share This Page