Break On Line

Discussion in 'Tally Developer' started by Mahesh Sethi, Feb 19, 2023.

    
  1. Mahesh Sethi

    Mahesh Sethi Member


    Dear Resp. Member & Amit Ji,

    i have a issue when i give the condition to break on on part level, then why cursor goes to My add UDF fields.

    Pls correct me if i go wrong:

    [#Part: EI InvInfo]
    Lines : EI InvDetails, EI InvSubTotal
    Repeat : EI InvDetails : Inventory Entries
    ;; BreakOn : $$IsEnd:$StockItemName
    Total : VCH Value
    Break : $$IsEnd:$StockItemName
    [#Line: EI InvInfo]
    ;;Right Fields : VCH ActualQty
    Add:Right Fields:Before:VCH ActualQty:VCH Stockhsn,TransportNm,VNOV,DNV,DTV


    Awaiting for your valuable help.

    Thanks & Regards,

    Mani
     

    Attached Files:



  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Use..... SKIP ...if stockitem is empty in your user-defined field.
     


  3. Mahesh Sethi

    Mahesh Sethi Member


    Resp. Sir,

    i follow your guidance but its not working.

    [Field:VCH Stockhsn]
    Use :Number Field
    Set as : $$dpk ;;$(Stockitem,$stockitem).GstDetails[Last].hsncode
    Storage : dpk
    Format : "No Comma, No Decimal,"
    Alignment :Left
    Width : 9
    Skip : $$IsEmpty:$StockItem

    [Field:TransportNm]
    Use : Name Field
    Table : Transporter, EndofList
    Show Table : Always
    ;;Set as : $$TptNm ;;$(Stockitem,$stockitem).GstDetails[Last].hsncode
    Storage : TptNm
    Alignment : Left
    Width : 9+9
    Skip : $$IsEmpty:$StockItem
    ;;Table:table,allitems, endoflist
    ;;Show Table:Always

    ;;=====================================
    [Collection: Transporter]
    Title : $$LocaleString:"Transporter Name"
    Type : Ledger
    Child Of:"Transporter"
    ;;=====================================
    [Field: VNOV]
    Use : Name Field
    Set as : $$VNOV ;;$(Stockitem,$stockitem).GstDetails[Last].hsncode
    Storage : VNOV
    Alignment : Left
    Width : 9
    Skip : $$IsEmpty:$StockItem

    [Field: DNV]
    Use : Name Field
    Set as : $$DNV ;;$(Stockitem,$stockitem).GstDetails[Last].hsncode
    Storage : DNV
    Alignment : Left
    Width : 9
    Skip : $$IsEmpty:$StockItem

    [Field: DTV]
    Use :Number Field
    Set as : $$DTV ;;$(Stockitem,$stockitem).GstDetails[Last].hsncode
    Storage : DTV
    Format : "No Comma, No Decimal,"
    Alignment : Left
    Width : 9
    Skip : $$IsEmpty:$StockItem
     


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Skip : $$IsEmpty:$StockItemName:StockItem:#VchStockItem
     
    Mahesh Sethi likes this.


  5. Ruwan

    Ruwan New Member


    Dear sir,

    Please help to correct this code.

    I need Sales invoice "Reference No " Tally Prime Default Outstanding Statement.


    [#Line: BILL Detail]

    Add : Fields : After : BILLRef : BillLPONo1
    [Field : BillLPONo1]

    [#Field: BILLFixed]
    Add : Fields: After: BillLPONo1 : Invoice


    [#Line: BILLCol2]
    Local:Field:Invoice:Set as:"Invoice No"

    [Field : Invoice]
    use : namefield
    Width: 14
    Set as :$name ( I entered here invoice number field for testing)
     

    Attached Files:



  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Kindly make your own post for this topic, as it differs from the subject title of this post.

    Your code is not workable in the Bill O/s report......... due to logic problems. Bill O/s is a collection of bills.... each bill reference will contain Vouchers of Sales, receipts, CN, Journals ..... so from which voucher to extract the data from.......... so for this you need to write a function to extract the information from the Sales Voucher.
     


  7. Mahesh Sethi

    Mahesh Sethi Member


    Thank You Amit Sir Its DONE
    :)
     


Share This Page