Please help ! Batch wise filter not working

Discussion in 'Free Source Codes' started by Ullas M M, Sep 7, 2018.

    
  1. Ullas M M

    Ullas M M New Member


    [#Menu : Gatewayoftally]

    Add : Key Item : Before : @@LocQuit : Search Serial Number : E : Display Collection : UPS Serial Number Search : NOT $$IsEmpty:$$SelectedCmps ;UPS Serial Number Search


    [Collection: UPS Serial Number Search]

    <unitgroup:itembatchgodownvch>
    Use : List of ExtractBatchStockItems
    Title : $$LocaleString:"List of Items"
    Trigger : Batch Items
    Variable : StockItemName
    Report : UPS Voucher Register
    Align : Right
    FullHeight : Yes
    Format : $Name, 25
    Fetch : Name, IsBatchWiseOn, MfdOn, ExpiryPeriod, HasMfgDate, IsPerishableOn
    Filter : IsItemBatchEnabled




    [System : Formulae]

    IsValidSerialNo :$UPSStkBatch Contains ##DSPBatchName; if not ($$IsEmpty:##StockItemName) then ($UPSStkBatch COntains ##DSPBatchName) else Yes


    [#Object : Voucher]

    UPSStkName :$$FullList:AllInventoryEntries:$StockItemName
    UPSStkBatch : $$FullList:AllInventoryEntries:$BatchAllocations.BatchName












    ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; Serial Filter Report ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;



    [Report: UPS Voucher Register]

    Use : Day Book

    Title : $$LocaleString:"Serial Number"
    Family : $$Translate:"Serial Number"
    Replace : Set : SV From Date : SV From Date : (if $$InPrintMode then $$MonthStart:##SVCurrentDate else ##SVFromDate)
    Replace : Set : SV To Date : SV To Date : (if $$InPrintMode then $$MonthEnd:##SVCurrentDate else ##SVToDate)
    Replace : Set : VoucherTypeName : VoucherTypeName : $$SysName:AllItems ;##VoucherTypeName
    Local : Line : DSP VchDetail : Empty : $IsOptional OR @@ForexEmpty

    Set : VchOfMaterialTranserOut : If $$IsJobMaterialIssue:##VoucherTypeName Then Yes Else No
    Set : VchOfMaterialTranserIn : If $$IsJobMaterialReceive:##VoucherTypeName Then Yes Else No

    Variable : IsPOSRegister, POSRegister : Logical
    Local : Collection: SALEExtract : Add : Parm Var : IsPOSRegister : Logical : ##POSRegister
    Local : Collection: GroupVoucherExtract : Add : Parm Var : IsPOSRegister : Logical : ##POSRegister
    Local : Collection: INVExtract : Add : Parm Var : IsPOSRegister : Logical : ##POSRegister
    Local : Collection: SRC Specific Vouchers of Company : Belongs To : Yes

    Local : Part : DB Title : Local : Line : DB Title : Local : Field : Name Field : Set as : $$LocaleString:"List of Vouchers"

    Local :Collection :Daybook Vouchers of Company :Add :Filter : IsValidSerialNo
    Local :Collection :Daybook Vouchers of Company :Add :Fetch : PartyLedgerName ,BatchName ,AllInventoryEntries.BatchAllocations.BatchName, StockItemName,InventoryEntries.StockItemName

    Local :Form :daybook :Delete :Button
    Local :Form :daybook :Delete :Bottom Button
    Local :Form :daybook :Delete :Bottom Toolbar Buttons
    Local :Form :daybook :add: Button :ChangeDybkDate, ChangePeriod ;,PhNumber;,ByName
    Local :Form :daybook :add: Buttons :printButton, ExportButton, UploadButton, MailButton
    Local :Form :DAYBOOK :ADD :Background :Light Sea Green
     


Share This Page