Delete Extra Space

Discussion in 'Tally Developer' started by auruem, Sep 8, 2020.

    
  1. auruem

    auruem Member


    Dear expert

    Please Guide.....

    How to delete extra space of Terms of Delivery. So we can have extra space for stock items.

    I Wants to Delete Only Extra Space...
     


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Remove that PART..........
     


  3. auruem

    auruem Member


    Sir I only wants To Delete extra space. .
    And not full Part
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    show screenshot.........
     


  5. auruem

    auruem Member


    Thanks For Quick Replies

    Also Reply With The Parts Details Terms 2.png Terms 1.png
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Open the Sales Invoice......Press Ctrl+V for Invoice Mode and then give Print command.

    As for bottom part, you will have to search for it, as per your Invoice format..............maybe Comprehensive Invoice format.
     
    Jaydeep Shah likes this.


  7. ahmed elhadary

    ahmed elhadary New Member


    try this code

    Code:
    ;bottom part
    [#Part: EXPINV SignOff]
    
      Left Parts  : EXPINV LeftSign
      Right Parts : EXPINV RightSign
      delete:Height  : If ((NOT $$InPrintMode) AND ($$InExportAction OR $$InMailAction)) Then 40% else If (##SATaxAnalysis AND ##SAVATAnalysis) Then (If @@IsSales AND ##SACustomerSign Then 25% Else 32%) else 25% Page
      Option      : Small Size Part
      Border      : Thin Left Right Bottom
      Vertical    : No
      Local  : Part : EXPINV Signature  : Invisible : @@IsSales AND ##SACustomerSign
      ;; Option introduced for Multi-Currency
      Option  : EXPINV FCSignOff     : @@PrintAmtForeignCurr
    
    
    ;;;;;;;;;;;terms
    
    [#Part: EXPINV Terms]
    
                Lines       : EXPINV SubTitle, EXPINV Terms
                Repeat      : EXPINV Terms : BasicOrderTerms
                Local       : Field : EXPINV SubTitle : Info        : $$LocaleString:"Terms of Delivery"
                Local       : Line  : EXPINV SubTitle : SpaceBottom : 0.25
       Local       : Field : EXPINV SubTitle : Cells   : @@ExcelCellColumn - 2 * ($$Quotient:@@ExcelCellColumn:4)
                Delete:Height      : 10% Page
                Width       : 50% Page
                Invisible   : If @@IsJobMaterialRcpt Then No Else NOT @@OrderTerms OR NOT @@IsInvoice OR @@IsJobOrderOut OR @@IsJobOrderIn
       Local       : Field : EXPINV SubTitle : Width : 50% Page
                Option      : GST EXPINV Terms : @@IsGSTOnAppl AND @@IsGSTTaxAnalysisWithItems
      
    
    
    
    
    
    [#Line: EXPINV BatchName]
    
                            Fields      : EXPINV SLNoTitle, EXPINV AccMarks, EXPINV AccPackages, EXPINV BatchNamePrompt, EXPINV BatchName,EXPINV ExpPrompt1, EXPINV ExpDate1
          RightFields : EXPINV VATPerc, EXPINV DueOn, EXPINV BatchActualQty, EXPINV BatchBilledQty, EXPINV RateTitle, EXPINV RatePerTitle, EXPINV AccDiscount, Amount Base Field
      
    
    [Field: EXPINV ExpPrompt1]
    
        Indent      : if (@@HasMfgDateSet AND ((NOT ##ICFGMarks AND NOT ##ICFGNumPackages AND NOT ##SAPartNo AND NOT ##SAWithVAT AND NOT @@InvGSTHSNDetais AND NOT @@InvGSTIGSTRate) OR @@IsOrderVch)) then 0 else 2
        Info        : $$LocaleString:"Exp:"
        Style       : Small Italic
    ;    Invisible   : NOT @@HasExpiryDate
        Width       : 4
        Align       : Right
    
    [Field: EXPINV ExpDate1]
    
        Use         : Due Date Field
        Align       : Left
        Style       : Small
        Storage     : Expiry Period
    ;    Invisible   : NOT @@HasExpiryDate
    
    [#Field: EXPINV ExpPrompt]
    
        Indent      : if (@@HasMfgDateSet AND ((NOT ##ICFGMarks AND NOT ##ICFGNumPackages AND NOT ##SAPartNo AND NOT ##SAWithVAT AND NOT @@InvGSTHSNDetais AND NOT @@InvGSTIGSTRate) OR @@IsOrderVch)) then 0 else 2
        Info        : $$LocaleString:"Expiry:"
        Style       : Small Italic
        Invisible   : NOT @@HasExpiryDate
        Width       : 8
        Align       : Prompt
    Invisible:Yes
    [#Field: EXPINV ExpDate]
    
        Use         : Due Date Field
        Align       : Left
        Style       : Small
        Storage     : Expiry Period
        Invisible   : Yes
    
    
    
    [#Field: EXPINV BatchNamePrompt]
    
        Indent      : 2
        Set as      : $$LocaleString:"Batch"
        Style       : Small Italic
        Width       : 6
        Align       : Prompt
        Skip        : Yes
        Fixed       : Yes
        Inactive    : NOT @@HasBatchWise
    
    [#Field: EXPINV BatchName]
    
        Use         : Name Field
    Width       : if ($$InPixelMode AND @@InvWithActQty AND ((##ICFGNumPackages AND ##ICFGMarks) OR @@IsOrderVch)) then @@NameWidth - @@QtyWidth - 8 else +
          if @@INVSeparateColVar Then @@NameWidth - 12 else @@NameWidth - 8
      
        Storage     : Batch Name
        Style       : Small Bold
        Inactive    : NOT @@HasBatchWise
    Cells    : $$Number:@@ExcelItemColumn - 1
    
    
    
    
    [#Field: EXPINV BatchBilledQty]
    
        Use         : Qty Primary Field
        Style       : Small
        Storage     : BilledQty
        Invisible   :Yes; NOT @@InvWithQty
    Option      : QtyWithcmdUnit : ##ICFGStkCmdunit
    
    Format:" symbol"
    Align:Left
    
    
    [#Field: EXPINV Desc]
    
        FullWidth   : Yes
        Width       : 0
        Lines       : 0
        Set as      : If @@InvWithPartNo And (@@UseNamePartNo OR @@UsePartNoName) Then $StockItemName Else If NOT $$IsSysName:$StockItemName then @@InvItemName else ""
        Style       : Normal
        Cells    : @@ExcelItemColumn
     
    auruem likes this.


  8. auruem

    auruem Member


    Extactly

    Great Sir

    Thanks a Lot

    Good Luck.... Take Care.....
     


  9. ahmed elhadary

    ahmed elhadary New Member


    you welcome
     


  10. Sambanthan

    Sambanthan New Member


    Useful code Thanks a Lot.
     


  11. Bipin Damania

    Bipin Damania Active Member


    If you want to delete Extra Part of Terms and Condition on Right then you have to check Left Part also and in that part there may be different Part and Lines...
     


Share This Page