Before Period Voucher Total Issue

Discussion in 'Free Source Codes' started by Jayashri, Sep 25, 2021.

    
  1. Jayashri

    Jayashri Member


    Help me,,,

    Total UDF Qty of the voucher that existed before the selected period should come today,,,




    [#Line: DSP VchTotalAmt]

    Add:Line:After:DSP VchClAmt:DSP VchOpAmtQty Bot

    [Line: DSP VchOpAmtQty Bot]

    Right Fields : DSP VchBalQtyTotal Title,DSP VchInQtyTotal
    Border : Full Thin Top


    [Field:DSP VchBalQtyTotal Title]

    Info : $$LocaleString:"OP Qty" + " " + ":"
    Color : Blue
    Align : Right
    Width : 12



    [Field: DSP VchInQtyTotal]
    Use : Number Field
    Color :Blue
    Set as :$$CollQtyTotal:partyAllin:$EIKGSTOTALWW ;+#DSPVchCrOpAmta
    Width :48
    Align :Left
    Format : "Decimal:3,NoSymbol,Primary"



    [Collection : PartyAllIn]

    Parm Var : svFromDate : Date : @@CMPStartDate
    Parm Var : svToDate : Date : @@DSPFromDate - 1
    Parm Var : pConsignee : String: #LedgerName

    Type : Vouchers : Ledger
    Child Of: ##pConsignee
    Walk : All Inventory Entries
    Filter : MySalesJobIn
    Fetch : Amount, AllLedgerEntries.Amount,Date,AllLedgerEntries.Date,EIKGSTOTALWW,inventoryentries:$billedqty

    [System: Formulae]

    MySalesJobIn : $Vouchertypename Contains "Job Work In"

    [#Form: Export Invoice]

    Option : Global Export Job Bot Line : @@MySalesJobIn

    [!Form : Global Export Job Bot Line]

    Local : Line : VCH NarrPrompt: Add : Right Fields : At Beginning : EIJob Qty Totals
    [Field: EIJob Qty Totals]

    Use : Qty Primary Field
    Set as : $$Total:VCHBilledQty
    Border : Totals
    Storage : EIKGSTOTALWW
    Set always : Yes
    ;Skip : Yes
    Format: "Decimal:3"

    [System:UDF]
    EIKGSTOTALWW:Quantity:7639
     

    Attached Files:

    • job.jpg
      job.jpg
      File size:
      128.7 KB
      Views:
      37


Share This Page