Repeat Both Accounting and Inventory Entries in One Line

Discussion in 'Tally Developer' started by kamal, Apr 23, 2017.

    
  1. kamal

    kamal Member


    Dear Admin and Experts,

    can any one suggest me how to repeat both Accounting and Inventories values in same line
     

    Attached Files:



  2. admin

    admin Administrator Staff Member


    Dear Kamal,

    You can write the below collection to the values.

    [Collection : My Src Coll]
    Type : Vouchers : Voucher Type
    Child of : $$VchTypeSales
    belongs to : yes

    [Collection : My Repeat Coll]
    Source Collection : My Src Coll
    Walk : Inventory Entries
    By : ValMasterID: $MasterID
    By : valStockItemName : $StockItemName

    Aggr Compute : ValBilledQty : Sum : $BilledQty
    AggrCompute : ValAmount : Sum : $Amount

    Fetch: date,VoucherNumber,PartyLedgerName

    ;; In the Part, Repeat the Line over - My Repeat Coll Collection

    ;; In the field use - $valStockItemName, $ValBilledQty,$ValAmount , $date,$VoucherNumber,$PartyLedgerName

    ;; For Rate --> $ValAmount / $ValBilledQty
     


  3. kamal

    kamal Member


    Dear Admin ,
    thank you for guiding me
    the above code working fine
     


  4. jgkumar1976

    jgkumar1976 Member


    sir i tried with your code help but i am not getting auto columns of tax ledgers pls help
    thnks in advance
     

    Attached Files:



  5. svn

    svn Member


    sir,
    i am using pre defined ledger in sales voucher.
    sgst@2.5
    cgst@2.5
    sgst@6
    cgst@6
    sgst@9
    cgst@9
    sgst@14
    cgst@14
    igst@5
    igst@12
    igst@18
    igst@28
    round off

    i want only using ledgers in sales voucher
    ex: if i sale the one 5% stock item in local state sgt2.5 and cgst2.5 will take automatically.Remining ledgers also = 0
    when i take print out it will show all ledgers. i want only ledgers witch is amount.

    here is my code.............


    [Part:OTSLedgerEnteries]
    Line:OTSLedgerEnteries
    Repeat:OTSLedgerEnteries:Ledger Entries
    Border: Thick Left
    Common Border: Yes
    ;Scroll: Vertical
    Float: No


    [Line:OTSLedgerEnteries]
    Field: OTSLedgerName, OTSLedgerPercentage,OTSPercentageSing, OTSLedgerAmount
    Remove if: $LedgerName = $PartyLedgerName
    Remove if :$Ledger amount=0


    [Field:OTSLedgerName]
    Set as : if ##SATCSDetails AND @@TaxLedgerHasTCS then $$LocaleString:"TCS : Income Tax" else +
    if NOT $$IsSysName:$LedgerName then $LedgerName else "" ;;; used to print on invoice
    Style:p9B
    Align : Right
    FullWidth : Yes
    AbatementVal: If $$Number:$STXAbatementRate = 0 Then $$String:"0" Else $$String:$STXAbatementRate
    LedNarr : (@@IsSales AND ##SALedgerNarr) OR (@@IsPurchase AND ##PULedgerNarr) AND $$Filtercount:LedgerEntries:LedgerNarrFltr > 0
    Option : LeftAlignField : @@AcctsInvoice
    Width:16



    [Field:OTSLedgerPercentage]
    Use : Rate Price Field
    Type : Number
    Align : Right
    Format : "NoZero,Decimals:-1"
    Style:p9
    Set as : if ##SATCSDetails AND @@TaxLedgerHasTCS AND NOT $$IsSysName:$TDSRateName:Ledger:$LedgerName then @@TCSITTaxRate else +
    $BasicRateOfInvoiceTax
    Inactive : $$IsSysName:$LedgerName
    Invisible : NOT @@InvWithRate

    Width: 4

    [Field:OTSPercentageSing]
    Set as:if $$IsEmpty:$BasicRateOfInvoiceTax then "" else "%"
    Set By Condition : @@TaxLedgerHasTCS AND NOT ($$IsSysName:$TDSRateName:Ledger:$LedgerName) : If $$IsEmpty:mad:@TCSITTaxRate Then "" Else "%"
    Inactive : $$IsSysName:$LedgerName
    Invisible : NOT @@InvWithRate
    Width: 2
    Style:p9

    [Field:OTSLedgerAmount]
    Use : Amount Forex Field
    Set as : $$SignedAmount:$Amount:mad:@VchOpposite
    Border: Thick Left
    Align: Right
    Width: 10
    Style:p9
     


Share This Page