1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

CAN ANY 1 HELP ME

Discussion in 'Requests' started by RINKAL, Nov 26, 2012.

    
  1. RINKAL

    RINKAL New Member


    TO MAKE EXTRA FIELD IN VOUCHER ENTRY NEXT TO QUANTITY (OF MY need) on purchase & sales & it will print on invoice & other report as well
     
    RINKAL, Nov 26, 2012
    #1


  2. admin

    admin Administrator Staff Member


    [#Line: EI InvInfo]
    Add: Right Field: After: VCH BilledQty: VCS VCH Free Qty

    [Field: VCS VCH Free Qty]
    Use: Qty Field
    Set As: #VCHActualQty - #VCHBilledQty
    Set Always: Yes
    Skip: Yes
    Border: Thin Right

    [#Line: EI ColumnOne]
    Add: Right Field: After: VCH QtyTitle: VCS VCH FreeQty Title

    [Field: VCS VCH FreeQty Title]
    Use: Name Field
    Set As: "Free"
    Skip: Yes
    Align: Centre
    Width: @@QtyWidth


    [#Line: EI ColumnTwo]
    Add: Right Field: After: VCH BilledQtyTitle: VCS VCH FreeQty Title
    Local: Field: VCS VCH FreeQty Title: Set As: "Qty"


    [#Form: Export Invoice]
    Local : Line : VCH NarrPrompt : Add : Right Fields : After: EI QtyTotal: VCS VCH FreeQTy Total

    [Field: VCS VCH FreeQTy Total]
    Use: Qty Field
    Set As: #EIActualQtyTotal - #EIBilledQtyTotal
    Set Always: Yes
    Skip: Yes
    Border: Totals


    ;;Printing

    [#Line: EXPINV InvDetails]
    Add: Right Fields: After: EXPINV Qty: VCS VCH Print Free Qty

    [Field: VCS VCH Print Free Qty]
    Use: Qty Field
    Set As: $ActualQty - $BilledQty
    Set Always: Yes
    Skip: Yes
    Border: Thin Right

    [#Line: EXPINV Column1]
    Add: Right Fields: After: EXPINV QtyTitle: VCS VCH FreeQty Title
    Local: Field: VCS VCH FreeQty Title: Set As: "Free"
    Local: Field: VCS VCH FreeQty Title:Border: Thin Left
    [#Line: EXPINV Column2]
    Add: Right Fields: After: EXPINV BilledQtyTitle: VCS VCH FreeQty Title
    Local: Field: VCS VCH FreeQty Title: Set As: "Qty"
    Local: Field: VCS VCH FreeQty Title:Border: Thin Left
    [#Line: EXPINV Totals]
    Add: Right Fields: After: EXPINVBilledQtyTotal: VCS VCH Print Free Qty Total

    [Field: VCS VCH Print Free Qty Total]
    Use: Qty Field
    Set As: #EXPINVActualQtyTotal - #EXPINVBilledQtyTotal
    Set Always: Yes
    Skip: Yes
    Border: Thin Left
     
    admin, Nov 29, 2012
    #2
    Ejajkhan likes this.


  3. ganesha chavan

    ganesha chavan New Member


    Hello Sir,
    We are unable to write anything in free qty column, in other words free qty column is not editable by using the above code.
    please assist.
    Thanks
     
    ganesha chavan, Jan 13, 2013
    #3


  4. NMS

    NMS Member


    Hello ganesh,
    what you want to write in free column.
     
    NMS, Jan 13, 2013
    #4


  5. NMS

    NMS Member


    Dear Ganesh,
    If you Want to Edit Free qty remove skip:yes in This Field (VCS VCH Free Qty)

    Thanks .....
     
    NMS, Jan 13, 2013
    #5


  6. ganesha chavan

    ganesha chavan New Member


    i want to add free qty no that are given to the customers
     
    ganesha chavan, Jan 13, 2013
    #6


  7. ganesha chavan

    ganesha chavan New Member


    we can not edit the free qty column but its adjustable with actual and billed qty...that will be fine.
    However, where we can find the report for free qty given. In other words how can i get the total number of free qty given at the month end.
    How come the free qty analysis be done without any report?.

    Kindly assist.
    Thanks
     
    ganesha chavan, Jan 13, 2013
    #7


  8. A.Marudhachalamurthi

    A.Marudhachalamurthi Member


    hai,

    try to understand the logic. It is given in default invoice printing only. If you want seperate report you need to write the code for the same.
     
    A.Marudhachalamurthi, Jan 13, 2013
    #8


Share This Page