Hello all, I am new to the world of TDL I added a column to Sales Invoice, but I am having a few issues in print, see attached image Please advise?
If you go through the source code of Comprehensive invoice. you can find out the part name where you can add your customised part. for alignment try with out specifying width of part .
Thank you for your reply, atleast help me out with the Sales Tax part, it should print before the border.
Thankyou, I added the terms box as needed, but am still stuck on how to correct this one thing only. Check image. Please help !
I have not gone through entire TDL. I believe you are missing one or two field. add same fields in inventory line. set all field as empty e.g. local:fieldefault:Set as:"" set 'item description' field as ledger name and align right. remove item amount field. add ledger amount field.
Thanks a ton Sir for your valuable guidance! I got it finally! Check attachment, I did some other changes too!
[#Line: EI ColumnOne] Add: Right Field : At Beginning: gold Add: Right Field : At Beginning: gold3 [Field:gold3] Width : If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth SubTitle : Yes Set as : Gross Weight Style : Normal Serif Bold Align : Centre Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType Skip : Yes Fixed : Yes [Field:gold] Width : If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth SubTitle : Yes Set as : Net weight Style : Normal Serif Bold Align : Centre Border : Double Sub Column Titles : If @@IsJobOrdersOn OR @@IsExciseSupplementaryInv Then No Else $DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType Skip : Yes Fixed : Yes [#Line : EI Inv Info] Add: Right Field : Before:VCH ActualQty :gold2 Add: Right Field : After:gold2:gold4 [Field:GOLD2];;;;net weight field Use : Qty Primary Field Width : @@VCHQtyWidth;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Scroll : Vertical Align : Centre Invisible : NOT @@ISSale or Not @@ISPurchase Skip : No ;Border: Thin Left Setas : "" Storage :mohsin Color:blues [Field:gold4];;;;;gross weight field Use : Qty Primary Field Width : @@VCHQtyWidth;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Scroll : Vertical Align : Centre Invisible : NOT @@ISSale or Not @@ISPurchase Skip : No ;Border: Thin Left Setas : "" Storage:weight [#Line: EIAccInfo] Add: Right Field : Before:EI AccActualQty:g1 Add: Right Field : After: g1:gold2 [Field:g1];;;;net weight field Use : Qty Primary Field Width : @@VCHQtyWidth;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Scroll : Vertical Align : Centre Invisible : NOT @@ISSale or Not @@ISPurchase Skip : No ;Border: Thin Left Setas : "" Storage :mohsin Color:blues [Field:g2];;;;;gross weight field Use : Qty Primary Field Width : @@VCHQtyWidth;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Scroll : Vertical Align : Centre Invisible : NOT @@ISSale or Not @@ISPurchase Skip : No ;Border: Thin Left Setas : "" Storage:weight [System:UDF] mohsin:Quantity:1889 weight:Quantity:1888 ;;;;;;;;;;;;;;;;;;;printing;;;;;;;;;;;;;;;;;;;;;; [#Part: EXPSMP InvDetails] Background:"red" [#Line: EXPSMP Column1] Local:Field:defultrint BG:red Add: Right Field :Before:EXPINV QtyTitle: pgold Add: Right Field :After: pgold: pgold3 [Fieldgold] Set as : "Gross weight" Align : Centre Width : @@VCHQtyWidth;@@VCHQtyWidthIf @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Style : Small Border : thin left [Fieldgold3] Set as : "Net weight" Align : Centre Width : @@VCHQtyWidth;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Style : Small Border : thin left [#Line: EXPSMP AccDetails] Add : Right Field : Before: EXPINV Qty : ace1 Add: Right Field :Before :ace1 :ace2 Explode : EXPINV AltQty : @@InvWithQty AND NOT $$IsEmpty:$StockItemName AND NOT @@NoAltUnits and (Not @@AltUnitasCol and @@InvWithAltunit) Explode : EXPSMP ServiceCategory : $$IsServiceTaxOn AND @@IsSTTaxenabledDate_Vch AND (NOT $$IsSysNameEqual:NOTApplicable:$STItemServiceCategory) AND $ForServiceTax:Ledger:$PartyLedgerName Explode : EXPSMP GodownDetails : NOT ($$IsEmpty:$StockItemName OR $$IsSysName:$StockItemName) AND ($$IsMultiGodownOn OR @@IsOrderVch) AND @@InvWithGodowns AND (NOT @@IsOrderVch OR + ((NOT $$IsSysName:$GodownName AND $$IsMultiGodownOn) OR ($$NumItems:BatchAllocations => 1))) Explode : EXPSMP BatchDetails : (@@HasBatchWise OR @@IsOrderVch) AND @@InvWithBatches AND (NOT @@IsOrderVch OR @@OrdExplBatch) AND NOT @@InvWithGodowns /*Explode for components*/ Explode : EXPInv JWBatch Components : (@@IsJobOrderEnabled AND ((@@IsJobOrderOut AND ##JWOOComponentsList) OR (@@IsJobOrderIn AND ##JWIOComponentsList)) AND $IsTrackComponent) Explode : EI DescExplosion : NOT $$IsEmpty:$StockItemName AND ##PRNWithItemDesc AND + Not $$IsEmpty:$BasicUserDescription NextPage : NOT $$DoExplosionsFit OR + (($$LineNumber = $$LastLineNumber) AND ($$BalanceLines > 0 ) AND ($$BalanceLines < 2)) [Field : ace1] Use : Name Field Border : Thin right Width : @@VCHQtyWidth;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Set As :$mohsin Style :Small Align : Centre [Field : ace2] Use : Name Field Style :Small Bold Width @VCHQtyWidth;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Align :Centre Border: Thin left Set As :$weight Option : ExciseSupInv ActualQty : @@IsExciseSupplemInvoice Option : QtyWithcmdUnit : ##ICFGStkCmdunit [#Line: EXPSMP InvDetails] Add : Right Field : Before: EXPINV Qty : VCS BatchPERm Add: Right Field :Before :vcs batchperm :chall Explode : EXPINV AltQty : @@InvWithQty AND NOT $$IsEmpty:$StockItemName AND NOT @@NoAltUnits and (Not @@AltUnitasCol and @@InvWithAltunit) Explode : EXPSMP ServiceCategory : $$IsServiceTaxOn AND @@IsSTTaxenabledDate_Vch AND (NOT $$IsSysNameEqual:NOTApplicable:$STItemServiceCategory) AND $ForServiceTax:Ledger:$PartyLedgerName Explode : EXPSMP GodownDetails : NOT ($$IsEmpty:$StockItemName OR $$IsSysName:$StockItemName) AND ($$IsMultiGodownOn OR @@IsOrderVch) AND @@InvWithGodowns AND (NOT @@IsOrderVch OR + ((NOT $$IsSysName:$GodownName AND $$IsMultiGodownOn) OR ($$NumItems:BatchAllocations => 1))) Explode : EXPSMP BatchDetails : (@@HasBatchWise OR @@IsOrderVch) AND @@InvWithBatches AND (NOT @@IsOrderVch OR @@OrdExplBatch) AND NOT @@InvWithGodowns /*Explode for components*/ Explode : EXPInv JWBatch Components : (@@IsJobOrderEnabled AND ((@@IsJobOrderOut AND ##JWOOComponentsList) OR (@@IsJobOrderIn AND ##JWIOComponentsList)) AND $IsTrackComponent) Explode : EI DescExplosion : NOT $$IsEmpty:$StockItemName AND ##PRNWithItemDesc AND + Not $$IsEmpty:$BasicUserDescription NextPage : NOT $$DoExplosionsFit OR + (($$LineNumber = $$LastLineNumber) AND ($$BalanceLines > 0 ) AND ($$BalanceLines < 2)) [Field : VCS BatchPERm] Use : Name Field Border : Thin left Width : @@VCHQtyWidth;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Set As :$mohsin Style :Small Align : Centre [Field : chall] Use : Name Field Style :Small Bold Width @VCHQtyWidth;If @@IsJobOrdersOn Then @@VCHQtyWidth Else if ($DiffActualQty AND NOT $$IsPhysStock:##SVVoucherType AND NOT $$IsStockJrnl:##SVVoucherType AND NOT @@IsExciseSupplementaryInv ) then (@@VCHQtyWidth + @@VCHQtyWidth + 1) else @@VCHQtyWidth Align :Centre Border: Thin left:$$InPrintMode Set As :$weight Option : ExciseSupInv ActualQty : @@IsExciseSupplemInvoice Option : QtyWithcmdUnit : ##ICFGStkCmdunit [#Line: EXPSMP BaseCurrTotals] Local:Field:defualtrint BG:"red"
How many fields are used in Item line. same number of fields in same order has to be used Ledger line also. Unused line can be set as ""