Need Rate Field Zero while Printing Time...

Discussion in 'Free Source Codes' started by ANAND J, Apr 19, 2021.

    
  1. ANAND J

    ANAND J Member


    Dear Admin,
    Sometime we are entering without rate for FOC Items. While Printing time i need rate field as ZERO (0)
    Use : Rate Price Field
    Border : Thin Left
    Set as : $Rate
    Format : "Forex"
    Please guide me ..
     


  2. balajimg

    balajimg Active Member


    format : "Forex,Zero"
     


  3. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Set as : $$IsEmpty:$Rate Then $$Number:0 Else $Rate
     


  4. ANAND J

    ANAND J Member


    Dear Admin ,
    Set as : $$IsEmpty:$Rate Then $$Number:0 Else $Rate
    That Line not taking its coming red alert..
     


  5. balajimg

    balajimg Active Member


    add IF
     
    Amit Kamdar likes this.


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    one of my latest and stupid TYPO :):)
     


  7. ANAND J

    ANAND J Member


    Dears,

    I dont have that much knowledge for that IF or IS Condition .Please advice me a correct line
    Set as : $$IsEmpty:$Rate Then $$Number:0 Else $Rate
    Add : IF

    I tried below line also its error
    Set as : $$IFEmpty:$Rate Then $$Number:0 Else $Rate
     


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    You must sincerely learn to understand the Syntax of coding by referring to many sample codes and in Developer too. Make a good effort to learn. Practical is the best way of learning. Cheers.

    Set as : If $$IsEmpty:$Rate Then $$Number:0 Else $Rate
     
    ANAND J likes this.


  9. ANAND J

    ANAND J Member


    I tried this line its not coming that is why i ask may be i enter wrong Please find the attachment. still not coming


    [Field: GI Rate]
    Use : Rate Price Field;;this field taking qar price
    Set as : $rate
    Border : Thin Left
    Format : "Nosymbol"
    Style : Normal bold
    Set as : If $$IsEmpty:$Rate Then $$Number:0 Else $Rate
     

    Attached Files:

    • S1.jpg
      S1.jpg
      File size:
      1.7 MB
      Views:
      22
    • S2.JPG
      S2.JPG
      File size:
      2.4 MB
      Views:
      26


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    What is -- Field: GI Rate ??

    It is not the default Tally's Field. You need to refer to the actual Field by using # before the word Field e.g. #Field

    Is this a customized code??? or are you using the default Tally's code?
     


  11. ANAND J

    ANAND J Member


    Default Program .. please check below my Invoice Body Part Details .



    [Part: Global Invoice Body]
    Lines : GI Inventory Details
    Repeat : GI Inventory Details : Inventory Entries
    Scroll : Vertical
    Border : Thin Left Right Bottom
    Common Borders : Yes
    ;Height : 45% page

    [Line: GI Inventory Details]
    Fields : GI SI No, GI Part No, GI Item Name,
    Right Fields: GI Item Name2,GI Units, GI Qty, GI Rate, GI Amount;,
    Space Top : 0.5;if $$Line = 1 then 1 else 0

    [Field: GI SI No]
    Use : Number Field
    Set as : $$Line
    Border : Thin Right
    Width : 4
    Align : Center

    [Field: GI Item Name]
    Use : Name Field
    Set as : if NOT $$IsSysName:$StockItemName then @@InvItemName else ""
    ;FullWidth : Yes
    Line : 0;2
    Width : 120 mms


    [Field: GI Part No]
    Use : Name Field
    Set as : $PartNo:StockItem:$StockItemName
    Width : 15;13;Yes
    Border : Thin Right

    [Field: GI Item Name2]
    Use : Name Field
    Set as : $ORDERDUEDATE
    Border : Thin Left
    Align : RIGHT
    Width : 13

    [Field: GI Qty]
    Use : Qty Primary Field
    Set as : $BilledQty
    Border : Thin Left
    Format : "Nosymbol"
    Width : 15;7
    Align : Right
    Style : Normal bold

    [Field: GI Units]
    Use : Rate Units Field
    Set as : $rate
    Border : Thin Left
    ;Full Width : yes
    ;Format : "Nosymbol"
    Width : 7

    [Field: GI Rate]
    Use : Rate Price Field;;this field taking qar price
    ; Set as : $rate
    Border : Thin Left
    Format : "Nosymbol"
    Width : 13;7
    Align : Right
    ;Format : "Forex,Zero"
    Style : Normal bold
    Set as : If $$IsEmpty:$Rate Then $$Number:0 Else $Rate

    [Field: GI Amount]
    Use : Amount Forex Field
    Border : Thin Left
    Set as : $Amount
    Width : 17;7
    Style : Normal bold
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    While referencing all Default fields, you must put # e.g. [#Part: Global Invoice Body]

    Also, since you need to alter only one field, there is no need to replicate all the other PARTS/LINES/FIELDS.
     


  13. ANAND J

    ANAND J Member


    Wooowww .. done....

    But we need do disable ;use:rate field....
    Thanks for giving an IDEA SUPPORT:))
    Basically i am a Support Engineer i don't have that much knowledge for TDL's....
     


  14. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    After disabling RATE FIELD .......... is your calculations working???
     


  15. ANAND J

    ANAND J Member


    Yes Admin:) See below image
     

    Attached Files:



Share This Page