Bill Ref Name/Number

Discussion in 'Requests' started by anish, Mar 30, 2015.

    
  1. anish

    anish Member


    Dear All Intellectual members,
    I have made a code in which Bill Ref Name/Number is not showing............... Please help

    Code:
    [#Part: CMP COLBasics]
        Lines   :COLREGWithINVNo
       
    [Line: COLREGWithINVNo]
    
            Fields      : Medium Prompt, COLREGWithINVNo
            Local       : Field : Medium Prompt : Info : $$LocaleString:"Show Invoice No. ?"
           
    [Field: COLREGWithINVNo]
    
                Use     : Logical Field
                Modifies: COLREGWithINVNo
               
    [Variable: COLREGWithINVNo]
    
        Type        : Logical
        Persistent  : Yes
       
    [System: Variables]
        COLREGWithINVNo:No
       
    
    ;==================================================
    [#Line: DSP ColVchTitle]
            Local:Field:LomeInvoice:Set as : $$LocaleString:"Invoice No."
           
    [#Part: DBC UserName]
            Local   : Field : LomeInvoice         : Set as    : ""
           
    [#Line: DSP ColVchDetailAlt]
            Add:Field:Before:DBC VchNo:LomeInvoice
            Local   : Field : LomeInvoice         : Set as    : ""
           
    [#Line: DSP ColVchDetail]
            Add:Field:Before:DBC VchNo:LomeInvoice
    
    [Field: LomeInvoice]
    
            Use            : Short Name Field
            Set As      : $Name
            Width       : 0
            Style       : Normal
            Bound       : 8,15
            Invisible    : NOT ##COLREGWithINVNo
            Scroll      : Yes
            Border          : Thin Left 
           
    [Collection: VouchersCol]
    Type : Vouchers
    IsODBCTable: Yes
    
    [Collection : VoucherBillColl]
    Source Collection : VouchersColl
    Walk : AllLedgerEntries,BillAllocations
    by : Name : $Name
    
    [​IMG]
     


  2. talha62481

    talha62481 Member


    what is your requirement?
     


  3. anish

    anish Member


    I want Below Field there
    [​IMG]
     


  4. talha62481

    talha62481 Member


    Code:
     
    
        [#Line : DB Title1]
        Add : Right Fields : After : DSP VchNumberTitle : DSP VchRefNoTitle
        [#Line : DSP VchAccTitles]
        Add : Right Fields : After : DSP VchNumberTitle : DSP VchRefNoTitle
        [#Line : DSP VchDetail]
        Add : Right Fields : After : DSP VchNumber : DSP VchRefNo
        [#Line : DSP VchInv1Titles]
        Add : Right Fields : After : DSP VchNumberTitle : DSP VchRefNoTitle
        Local : Field : DSP VchRefNoTitle : Set as : "Ref."
        [#Line : DSP VchInv2Titles]
        Add : Right Fields : After : DSP VchNumberTitle : DSP VchRefNoTitle
        Local : Field : DSP VchRefNoTitle : Set as : "No."
        [#Line : STKVCH NormalDetail]
        Add : Right Fields : After : DSP VchNumber : DSP VchRefNo
        [Field : DSP VchRefNoTitle]
        Use : Short Name Title Field
        Width : 3
        Info : "Ref"
        Align : Right
        Invisible : ##BankRecMode OR $$InDraftMode
        Delete : Border
    
        [Field : DSP VchRefNo]
        Use : Name Field
        Width : 3
        Set as : $Reference;$$CollectionField:$ExcisePurchaseNumber:1:ExciseAllocations;$Reference ;;if Not $$IsVoucher then "" else
        ;;Set as : if Not $$IsVoucher then "" else @OptStr + $Reference;$$CollectionField:$ExcisePurchaseNumber:1:ExciseAllocations;$Reference ;;
        OptStr : if $IsOptional then "(Optional) " else ""
        Style : Small
        Align : Right
        Invisible : ##BankRecMode OR $$InDraftMode
        Delete : Border
    
        [#Field : DBC Qty]
        Set as : if $IsDeemedPositive:VoucherType:##VoucherTypeName then $$AsOutQty:$VchTotalQty else $$AsInQty:$VchTotalQty
        [#Part : DBC QtyDetails]
        Local : Field : DBC Qty : Set as : If NOT $$IsEmpty:$BilledQty then $BilledQty else $ActualQty
        [#Line : DSP VchExplosion]
        Add : Right Fields : DSP InBlock, DSP OutBlock, DSP ClBlock
        Local : Field : Default : Delete : Border
        Local : Field : DSP VchInQty : Set as : If @@IsInType then @@GetNewVal else ""
        Local : Field : DSP VchInAmt : Set as : ""
        Local : Field : DSP VchOutQty : Set as : If @@IsOutType then @@GetNewVal else ""
        Local : Field : DSP VchOutAmt : Set as : ""
        Local : Field : DSP VchClQty : Set as : ""
        Local : Field : DSP VchClAmt : Set as : ""
        ;___ @@-OBJECT-MODIFICATIONS ____________________________________________________________
        [#Object : Voucher]
        VchTotalQty : $$CollQtyTotal:InventoryEntries:$ActualQty
    
        ;___ @@-SYSTEM-FORMULA __________________________________________________________________
        [System : Formula]
        GetNewVal : If NOT $$IsEmpty:$BilledQty then $BilledQty else $ActualQty
        IsOutType : ($$IsDelNote:$VoucherTypeName OR $$IsSales:$VoucherTypeName OR $$IsCreditNote:$VoucherTypeName)
        IsInType : ($$IsRcptNote:$VoucherTypeName OR $$IsPurchase:$VoucherTypeName OR $$IsDebitNote:$VoucherTypeName)
        ;___ @@-END-OF-VCH-REFERENCE ____________________________________________________________
    
        [#Collection: Daybook Vouchers of Company]
        Fetch : reference
    
    
        [#Collection: Vouchers of Ledger]
        Fetch : reference
    
    
     


  5. anish

    anish Member


    its not working Brother !
     


  6. anish

    anish Member


    Ok I have finish the code the full and final code is below

     


Share This Page