Free Tally TDL for Separate Column for Item Description
Free Tally TDL for Separate Column for Item Description
THIS TDL FOR INVOICING, THAT PROVIDES YOU A SEPARATE COLUMN FOR ADDITIONAL DESCRIPTION OF STOCK ITEMS.
This is how you can get detailed information,
Code :
[#Line: EXPSMP Column1]
Add: Field : After : EXPINV DescTitle :RBCSMP AddlDescTitle; : @@RBCAddlDescDetails
Add : Right Field : Before : EXPINV QtyTitle : EXPINV PackagesTitle1
Local : Field : EXPINV PackagesTitle1 : Border: Thin Left
Local : Field : EXPINV PackagesTitle1 : Info: "Package"
Local : Field : EXPINV DescTitle : Align : Left
[#Line: EXPSMP Column2]
Add: Field : After :EXPINV DiscTitle: RBCSMP Column2; : @@RBCAddlDescDetails
Add : Right Field : Before : EXPINV ActualQtyTitle : EXPINV PackagesTitle2
Local : Field : EXPINV PackagesTitle2 : Border: Thin Left
Local : Field : EXPINV PackagesTitle2 : Info: ""
[#Line: EXPSMP InvDetails]
Add: Field : After :EXPINV Desc :RBCSMP AddlDesc InvDetails
Add : Field : Before : EXPINV ActualQty : EXPINV Packages
[Field: RBCSMP AddlDescTitle]
Use : ShortName Field
Info : $$LocaleString:"Description"
Border : Thin Left
Align : Left
Style : Small
Cells : If (@@InvWithActQty AND (NOT @@IsJobWorkVouchers)) Then 2 Else 1
Width : @@NameWidth - 15
Invisible : NOT @@RBCAddlDescDetails
[Field: RBCSMP Column2]
Use : ShortName Field
Set as : ""
Align : Centre
Style : Small
Width : @@NameWidth - 15
Invisible : NOT @@RBCAddlDescDetails
[Field: RBCSMP AddlDesc InvDetails]
Use : Name Title Field
Width : @@NameWidth - 15
Set as : @@RBCOther_DetailsName
Align : Left
Style : Small
Border : Thin Left
Invisible : NOT @@RBCAddlDescDetails
[#Line: EXPINV Column1]
Add : Left Field : After : EXPINV DescTitle: RbcEXPINV AddlDescTitle
Delete: Field : EXPINV PackagesTitle1
Add : Right Field : Before : EXPINV QtyTitle : EXPINV PackagesTitle1
Local : Field : EXPINV PackagesTitle1 : Border: Thin Left
Local : Field : EXPINV PackagesTitle1 : Info: "Package"
Local : Field : EXPINV DescTitle : Align : Left
[#Line: EXPINV Column2]
Add: Field : After : EXPINV DescTitle: RbcEXPINV AddlDescTitle2
Delete: Field : EXPINV PackagesTitle2
Add : Right Field : Before : EXPINV ActualQtyTitle : EXPINV PackagesTitle2
Local : Field : EXPINV PackagesTitle2 : Border: Thin Left
Local : Field : EXPINV PackagesTitle2 : Info: ""
[#Line: EXPINV InvDetails]
Add: Field : After : EXPINV Desc: RBCEXPAddlDescDetails
Delete: Field : EXPINV Packages
Add : Right Field : Before : EXPINV ActualQty : EXPINV Packages
Local : Field : EXPINV Packages : Border: Thin Left
Local : Field : EXPINV Packages : Style: Tiny
Local : Field : EXPINV Packages : Align: Justified
[#Line: EXPINV Totals]
Delete: Field : EXPINV PackagesTitle1
Add : Right Field : Before : EXPINV ActualQtyTotal : EXPINV PackagesTitle1
Local : Field : EXPINV PackagesTitle1 : Info : ""
Local : Field : EXPINV PackagesTitle1 : Border: Thin Left
[Field: RbcEXPINV AddlDescTitle]
Use : ShortName Field
Info : $$LocaleString:"Description"
Border : Thin Left
Align : Left
Style : Small
Cells : If (@@InvWithActQty AND (NOT @@IsJobWorkVouchers)) Then 2 Else 1
Width : @@TrackingWidth
Invisible : NOT @@RBCAddlDescDetails
[Field: RbcEXPINV AddlDescTitle2]
Use : ShortName Field
Set as : ""
Align : Centre
Style : Small
Width : @@TrackingWidth
Cells : If (@@InvWithActQty AND (NOT @@IsJobWorkVouchers)) Then 2 Else 1
Invisible : NOT @@RBCAddlDescDetails
[Field: RBCEXPAddlDescDetails ]
Use : ShortName Field
Set as : @@RBCOther_DetailsName
Style : Small
Align : Left
Border : Thin Left
Cells : If (@@InvWithActQty AND (NOT @@IsJobWorkVouchers)) Then 2 Else 1
Width : @@TrackingWidth
Invisible : NOT @@RBCAddlDescDetails
[#Line: EXPINV AccDetails]
Add : Field: After: EXPINV AccDesc :RBCAccAddlDescDetails
Delete: Field : EXPINV AccPackages
Add : Right Field : Before : EXPINV AccActualQty : EXPINV AccPackages
Local : Field : EXPINV AccPackages : Border: Thin Left
[Field: RBCAccAddlDescDetails ]
Use : ShortName Field
Border : Thin Left
Style : Small
Align : Left
Width : @@TrackingWidth
Set as : @@RBCOther_DetailsName
Invisible : NOT @@RBCAddlDescDetails
[Variable: RBCTraderAddlDesc]
Type : Logical
Persistent : Yes
[System: Variables]
RBCTraderAddlDesc : No
[#Part: VchF12PrnSTDConfig SalesInvoiceLeft]
Add : Line : Before : SATraderAddlDesc : RBCAddlDescColumn
[Line: RBCAddlDescColumn]
Field : Medium Prompt, Logical Field
Local : Field : Medium Prompt : Info : $$LocaleString:"Print Additional Description in separate Column?" ;;; To Display Print Additional Description(s) for Item Name in Print F12 Config
Local : Field : Logical Field : Modifies : RBCTraderAddlDesc
;Invisible : NOT (@@IsExciseTraderOn AND @@IsSalesConfig AND ##IsExciseVoucher AND NOT @@IsTraderSVCommercialInvoice)
[System:Formulae]
RBCOther_DetailsName : @@VATBuyerDescription
RBCAddlDescDetails : If @@IsSales OR @@IsCreditNote OR @@IsDelNote Then ##RBCTraderAddlDesc Else No
;;End of the Code
Please Support us by Subscribe our YouTube Channel for more Video and Free TDL
Comments
Post a Comment