Dear Admin and Experts, can any one suggest me how to repeat both Accounting and Inventories values in same line
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
sir i tried with your code help but i am not getting auto columns of tax ledgers pls help thnks in advance
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 Style9B 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" Style9 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@TCSITTaxRate Then "" Else "%" Inactive : $$IsSysName:$LedgerName Invisible : NOT @@InvWithRate Width: 2 Style9 [Field:OTSLedgerAmount] Use : Amount Forex Field Set as : $$SignedAmount:$Amount@VchOpposite Border: Thick Left Align: Right Width: 10 Style9