Export Invoice

Discussion in 'Free Source Codes' started by gangstar, Aug 14, 2019.

         
  1. gangstar

    gangstar Member


    Sir i dont know how to reduce the body parts. Any other solution is there ha Sir?
    *Screen shot of export invoice has been attached
    *export invoice tdl has been attached
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    U must study and then incorporate Page Break in your code............
     


  3. gangstar

    gangstar Member


    Sir how to use page break in invoice any other solution?
     


  4. gangstar

    gangstar Member


    Sir Page Break up Solved.
    Lots of page i am having in fist page till now its printing on second page
     

    Attached Files:



  5. uttam100

    uttam100 Member


    Nice one congrats.
     
    gangstar likes this.


  6. gangstar

    gangstar Member


    Sir give me solution for reduce the body height?
     


  7. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    wait a few days....will check it out.....
     


  8. gangstar

    gangstar Member


    Sir this formula is not working in normal sales voucher type



    [#line:ei columnone]

    add:right field:at beginning:exchratetit,exchcurtit,exchamttit



    [field:exchcurtit]

    use:name title field

    width:30 mms

    type:string

    set as: if @@salesornot then "cur" else "";+

    ;if @@ispurchase then "cur" else ""

    style: normal bold

    align:center



    [field:exchratetit]

    use:name title field

    width:30 mms

    type:string

    set as: if @@salesornot then "usd" else "";+

    ;if @@ispurchase then "usd" else ""

    style: normal bold

    align:center



    [field:exchamttit]

    use:name title field

    type:string

    info:if @@salesornot then "value" else "";+

    ;if @@ispurchase then "value" else ""

    width:30 mms

    align:center

    style:normal bold



    [#line:ei invinfo]

    add:right field:at beginning:exchrate,exchcur,exchamt,vch value

    local:field:exchrate:skip on:mad:@salesornotvch

    local:field:exchcur:skip on:mad:@salesornotvch

    local:field:exchamt:skip on:mad:@salesornotvch

    local:field:vch value:skip on:mad:@salesornotvch



    [field:exchcur]

    use:name field

    set as:$formalname:currency:($$currency:$udfexchrate)

    width:30 mms

    inactive:$$isend:$stockitemname

    align:center

    format:"currency,showbasesymbol"

    skip:yes



    [field:exchrate]

    use:amount forex field

    storage:udfexchrate

    width:30 mms

    inactive:$$isend:$stockitemname

    align:center

    format:"currency"



    [field:exchamt]

    use:amount forex field

    set as:$billedqty * $rate

    width:30 mms

    inactive:$$isend:$stockitemname

    align:center

    skip:no



    [#field: vch value]

    use:amount field

    resetval:if (@@nobaseunits or $$isempty:$billedqty) then $$value else (@@bqudfbqr) ;or (($rate * $billedqty * (100 - $discount)) / 100)

    skip:yes



    [system:udf]

    udfexchrate:amount:5894



    [system:formulae]

    bqudfbqr:($udfexchrate * #exchamt)

    udfbr:($billedqty * $rate)

    salesornot:$vouchertypename = "sales"

    salesornotvch:$vouchertypename = "balaji"


    [#field: vch nrmlrate]

    delete:set by condition

    add:set by condition:yes:$$value
     


  9. balajimg

    balajimg Member


    In creation with voucher class, you have used

    [#line:ei columnone]
    [#line:ei invinfo]

    these below lines also to be considered

    [#line:Ci columnone]
    [#line:Ci invinfo]
     


  10. gangstar

    gangstar Member


    Balaji Sir
    *I added ur corrections in my tdl
    *I added a screenshot of Sales voucher type till now i didnot get [#field:Vch value] amount.
     

    Attached Files:



  11. balajimg

    balajimg Member


    Try this

    [system:formulae]

    bqudfbqr:($$Number:$udfexchrate * $$Number:#exchamt)
     


  12. gangstar

    gangstar Member


    Sir
    still iam getting same problem
     

    Attached Files:



  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    From the screen, you are getting the value of 600/- and 50/-.... so what is the issue? give detailed explanation.
     


  14. gangstar

    gangstar Member


    Sir
    I need a formula for both calculation
    If I mentioned USD calculation is taken correctly
    If I mentioned 0 in USD means straight away I want to put quantity, rate & amount want to calculate.
    That's all my quire's Sir @amit @Balaji
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    put a conditional formula.........
    If $$IsEmpty:#exchamt then $Qty * $Rate Else @@bqudfbqr

    am assuming exchamt means USD unit. Also replace $Qty and $Rate with the appropriate UDF name (refer Developer)
     


  16. gangstar

    gangstar Member


    Finally Done my Export Invoice Model.
    Thanks a lot @amit Sir @balajimg Sir
     


Share This Page