[SOLVED] Column Added Not Printing

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.

 

can you upload correct code of this

 

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.

 

Unable to make it work! :-(

 

Refer my TDL. You will get idea.


Add field Batch in Accounts Line also

 

Which TDL?

 

Thanks a ton Sir for your valuable guidance! I got it finally! Check attachment, I did some other changes too!

 

Please share your codes.

 

Kindly share the Tdl

 

pls send TDL file in

 

Under free code section you can find out a number of TDl which gives you an idea how to do it.

 

[#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"

 

i am facing same problem plz solved

 

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 ""

 

Please share your codes.

 

Sir,
Can you provide TDL for Product code as showing in Your invoice ?