Sir I have already downloaded this file from Talltsolutions.com, send me some guidelines and basic tutorial by any institution... Thanks Dear
I have already changed my Inv. Format using the tdl below :- Sales Inv. with group :- But I want to know that if I want sales Inv. Format with categories what will be the best Tdl for that purpose? Plz Help? ;; Sri Ganeshji : Sri Balaji : Sri Pitreshwarji : Sri Durgaji : Sri Venkateshwara [#Form: SalesColor] Delete : Print Add : Print : BristleInvoice [Report: BristleInvoice] Use : Printed Invoice Delete : Form Add : Form : BristleInvoice [Form: BristleInvoice] Use : STDInvoiceDimensions Top Parts : STDInvoiceTop, BristleTopPart Part : BristleBodyPart Bottom Part : BristleBottomPart Space Top : 0 mms Space Bottom : 0 mms PageBreak : BristleClosingPageBreak,BristleOpeningPageBreak ;;------------------------------------------------------------------------------------------- [Part: BristleOpeningPageBreak] Parts : BristleTopPart, BristleColHeads Vertical: Yes [Part: BristleClosingPageBreak] Use : BristleBottomPart Local : Field : BristleAmtInWords : Set as : 'continued...' Local : Field : BristleAmtInWords : Align : Right Local : Field : BristleAmtInWords : Style : Normal ;;---------------------------TOP PART---------------------------------------------------------------- [Part: BristleTopPart] Top Parts : BristleRepTitle, BristleCompDetail Vertical : Yes Height : 30 mms [Part: BristleRepTitle] Height : 5 mms Line : BristleCmpReport [Line: BristleCmpReport] Field : BristleCmpReport [Field: BristleCmpReport] Set As : ##ReportTitle + @@BristlePageNo Align : Center Style : Large Bold [Part: BristleCompDetail] Border : Thin Box Height : 25 mms Part : BristleCmpAddress Right Part : BristleCmpOrderDetails [Part: BristleCmpAddress] Height : 25 mms Width : 94 mms Lines : BristleCmpType,BristleCmpName,BristleCmpAddress PrePrinted : Yes Border : Thin Right Repeat : BristleCmpAddress : Company Address [Line: BristleCmpType] Field : BristleCmpType [Field: BristleCmpType] Width : 94 mms Set As : 'Exporter' Style : Small Space Left : 2 mms [Line: BristleCmpName] Field : BristleCmpName [Field: BristleCmpName] Width : 94 mms Set As : @@CmpMailName Style : Normal Bold Space Left : 5 mms [Line: BristleCmpAddress] Field: BristleCmpAddress [Field: BristleCmpAddress] Width : 94 mms Set As : $Address Space Left : 5 mms [Part: BristleCmpOrderDetails] Parts : BristleCmpReportHead,BristleCmpBuyerOrder Height : 25 mms Width : 93 mms Vertical : Yes [Part: BristleCmpReportHead] Width : 93 mms Height : 8 mms Parts : BristleCmpReportNoHead,BristleCmpReportRef [Part: BristleCmpReportNoHead] Width : 46 mms Height : 8 mms Lines : BristleCmpReportNoHead,BristleCmpReportNo Border : Thin Right [Line: BristleCmpReportNoHead] Height : 3 mms Field : BristleCmpReportNoHead [Field: BristleCmpReportNoHead] Width : 46 mms Set As : 'Invoice No. & Date' PrePrinted : Yes Space Left : 2 mms Style : Small [Line: BristleCmpReportNo] Height : 4 mms Field : BristleCmpReportNo Right Field : BristleCmpReportNoDt Border : Thin Bottom [Field: BristleCmpReportNo] Width : 23 mms Set As : $VoucherNumber Style : Normal Bold Space Left : 2 mms [Field: BristleCmpReportNoDt] Width : 23 mms Set As : $$String:$Date:UniversalDate Style : Normal Bold [Part: BristleCmpReportRef] Width : 47 mms Height : 8 mms Lines : BristleCmpReportRef,BristleCmpReportRefNo [Line: BristleCmpReportRef] Height : 3 mms Field : BristleCmpReportRef [Field: BristleCmpReportRef] Width : 47 mms Set As : "Exporter's Ref" PrePrinted : Yes Space Left : 2 mms Style : Small [Line: BristleCmpReportRefNo] Field : BristleCmpReportRefNo Height : 4 mms Space Bottom : 1 mms Border : Thin Bottom [Field: BristleCmpReportRefNo] Width : 47 mms Set as : $Reference Style : Normal Bold Space Left : 2 mms [Part: BristleCmpBuyerOrder] Width : 93 mms Height : 17 mms Lines : BristleCmpBuyerOrderHead,BristleCmpBuyerOrderNo,BristleCmpOtherRef, BristleCmpOtherRefNo [Line: BristleCmpBuyerOrderHead] Height : 2 mms Space Bottom : 2 mms Field : BristleCmpBuyerOrderHead [Field: BristleCmpBuyerOrderHead] Width : 93 mms Set As : 'Buyers Order No. & Date' PrePrinted : Yes Space Left : 2 mms Style : Small [Line: BristleCmpBuyerOrderNo] Height : 3 mms Space Bottom : 1 mms Border : Thin Bottom Left Field : BristleCmpBuyerOrderNo Right Field : BristleCmpBuyerOrderNoDt [Field: BristleCmpBuyerOrderNo] Width : 46.5 mms Set As : $PurchaseOrderNo Style : Normal Bold Space Left : 2 mms [Field: BristleCmpBuyerOrderNoDt] Width : 46.5 mms Set As : $$String:$OrderDate Style : Normal Bold [Line: BristleCmpOtherRef] Field : BristleCmpOtherRef Height : 2 mms Space Bottom : 2 mms [Field: BristleCmpOtherRef] Width : 93 mms Set As : 'Other Reference(s)' PrePrinted : Yes Space Left : 2 mms Style : Small [Line: BristleCmpOtherRefNo] Height : 3 mms Space Bottom : 2 mms Field : BristleCmpOtherRefNo [Field: BristleCmpOtherRefNo] Width : 93 mms Set As : $OrderRef Style : Normal Bold Space Left : 2 mms ;;---------------------------------------------------------------------------- [Part: BristleBuyerDetails] Left Part : BristleConsigneeDet Right Part : BristleBuyerDet Height : 76 mms Border : Thin Box [Part: BristleConsigneeDet] Height : 76 mms Width : 94 mms Border : Thin Right Parts : BristleConsigneeAddress,BristleDispatchDet Vertical : Yes [Part: BristleConsigneeAddress] Height : 51 mms Width : 94 mms Lines : BristleConsigneeTo,BristleConsigneeName,BristleConsigneeAdd Repeat : BristleConsigneeAdd: Buyer Address [Line: BristleConsigneeTo] Field : BristleConsigneeTo [Field: BristleConsigneeTo] Width : 94 mms Set As : 'Consignee' PrePrinted : Yes Style : Small [Line: BristleConsigneeName] Field : BristleConsigneeName [Field: BristleConsigneeName] Width : 94 mms Space Left : 5 mms Set As : $BuyerName Style : Normal Bold [Line: BristleConsigneeAdd] Field : BristleConsigneeAdd [Field: BristleConsigneeAdd] Width : 94 mms Space Left : 5 mms Set As : $BuyerAddress [Part: BristleDispatchDet] Height : 25 mms Width : 94 mms Parts : BristlePrecarriage,BristleVesselNoHead,BristlePortOfDischargeHead Vertical : Yes Border : Thick Top [Part: BristlePrecarriage] Width : 94 mms Height : 8 mms Parts : BristlePrecarriageBy,BristlePlaceofReceiptHead [Part: BristlePrecarriageBy] Width : 47 mms Height : 8 mms Line : BristlePrecarriage,BristlePrecarriageBy Border : Thin Right [Line: BristlePrecarriage] Field : BristlePrecarriage Height : 2 mms Space Bottom : 2 mms [Field: BristlePrecarriage] Width : 47 mms Set As : 'Pre-Carriage by' PrePrinted : Yes Style : Small [Line: BristlePrecarriageBy] Height : 3 mms Space Bottom : 1 mms Fields : BristlePrecarriageBy Border : Thin Bottom [Field: BristlePrecarriageBy] Width : 47 mms Set As : $ShippedBy Style : Normal Bold [Part: BristlePlaceofReceiptHead] Width : 47 mms Height : 8 mms Lines : BristlePlaceofReceiptHead,BristlePlaceofReceipt [Line: BristlePlaceofReceiptHead] Height : 2 mms Space Bottom : 2 mms Field : BristlePlaceofReceiptHead [Field: BristlePlaceofReceiptHead] Width : 47 mms Set As : 'Place of Receipt by Pre-carrier' PrePrinted : Yes Style : Small [Line: BristlePlaceofReceipt] Height : 3 mms Space Bottom : 1 mms Field : BristlePlaceofReceipt Border : Thin Bottom [Field: BristlePlaceofReceipt] Width : 47 mms Set As : $PlaceOfReceipt Style : Normal Bold [Part: BristleVesselNoHead] Width : 94 mms Height : 8 mms Parts : BristleVesselNo,BristlePortofLoadingHead [Part: BristleVesselNo] Width : 47 mms Height : 8 mms Lines : BristleVesselNoHead,BristleVesselNo Border : Thin Right [Line: BristleVesselNoHead] Fields : BristleVesselNoHead Height : 2 mms Space Bottom : 2 mms [Field: BristleVesselNoHead] Width : 47 mms Set As : 'Vessel / Flight No' PrePrinted : Yes Style : Small [Line: BristleVesselNo] Field : BristleVesselNo Height : 3 mms Space Bottom : 1 mms Border : Thin Bottom [Field: BristleVesselNo] Width : 47 mms Set As : $ShipVesselNo Style : Normal Bold [Part: BristlePortofLoadingHead] Width : 47 mms Height : 8 mms Lines : BristlePortofLoadingHead,BristlePortofLoading [Line: BristlePortofLoadingHead] Field : BristlePortofLoadingHead Height : 2 mms Space Bottom: 2 mms [Field: BristlePortofLoadingHead] Width : 47 mms Set As : 'Port of Loadding' PrePrinted : Yes Style : Small [Line: BristlePortofLoading] Height : 3 mms Space Bottom: 1 mms Field : BristlePortofLoading Border : Thin Bottom [Field: BristlePortofLoading] Width : 47 mms Set As : $PortOfLoading Style : Normal Bold [Part: BristlePortOfDischargeHead] Width : 94 mms Height : 9 mms Parts : BristlePortOfDischarge,BristlePlaceOfDeliveryHead [Part: BristlePortOfDischarge] Width : 47 mms Height : 9 mms Lines : BristlePortOfDischargeHead,BristlePortOfDischarge Border : Thin Right [Line: BristlePortOfDischargeHead] Field : BristlePortOfDischargeHead Height : 2 mms Space Bottom: 2 mms [Field: BristlePortOfDischargeHead] Width : 47 mms Set As : 'Port of Discharge' PrePrinted : Yes Style : Small [Line: BristlePortOfDischarge] Field : BristlePortOfDischarge Height : 3 mms Space Bottom : 2 mms [Field: BristlePortOfDischarge] Width : 47 mms Set As : $PortOfDischarge Style : Normal Bold [Part: BristlePlaceOfDeliveryHead] Width : 47 mms Height : 9 mms Lines : BristlePlaceOfDeliveryHead,BristlePlaceOfDelivery [Line: BristlePlaceOfDeliveryHead] Height : 2 mms Space Bottom : 2 mms Field : BristlePlaceOfDeliveryHead [Field: BristlePlaceOfDeliveryHead] Width : 47 mms Set As : 'Place of Delivery' PrePrinted : Yes Style : Small [Line: BristlePlaceOfDelivery] Height : 3 mms Field : BristlePlaceOfDelivery Space Bottom: 2 mms [Field: BristlePlaceOfDelivery] Width : 47 mms Set As : $FinalDestination Style : Normal Bold [Part: BristleBuyerDet] Height : 76 mms Width : 93 mms Parts : BristleBuyerAddress,BristleGoodsDet,BristleExportDet Vertical: Yes [Part: BristleBuyerAddress] Height : 35 mms Width : 93 mms Lines : BristleBuyerTo,BristleBuyerName,BristleBuyerAdd Repeat : BristleBuyerAdd : Address [Line: BristleBuyerTo] Field: BristleBuyerTo [Field: BristleBuyerTo] Width : 93 mms Set As : 'Buyer(if other than consignee)' PrePrinted : Yes Style : Small [Line: BristleBuyerName] Field : Bristle BuyerName [Field: BristleBuyerName] Width : 93 mms Space Left : 5 mms Set As : @@InvPartyName Style : Normal Bold [Line: BristleBuyerAdd] Field: BristleBuyerAdd [Field: BristleBuyerAdd] Width : 93 mms Space Left : 5 mms Set As : $Address [Part: BristleGoodsDet] Width : 93 mms Height : 8 mms Parts : BristleGoodsDetHead,BristleGoodsFinalDestinationHead [Part: BristleGoodsDetHead] Width : 46 mms Height : 8 mms Lines : BristleGoodsDetHead,BristleGoodsDet Border : Thin Right [Line: BristleGoodsDetHead] Height : 2 mms Space Bottom : 2 mms Border : Thin Top Field : BristleGoodsDetHead [Field: BristleGoodsDetHead] Width : 46 mms Set As : 'Country of Origin of Goods' Space Left : 2 mms PrePrinted : Yes Style : Small [Line: BristleGoodsDet] Height : 3 mms Space Bottom : 1 mms Field : BristleGoodsDet Border : Thin Bottom [Field: BristleGoodsDet] Width : 46 mms Set As : @@CountryOrgin Space Left : 2 mms Style : Normal Bold [Part: BristleGoodsFinalDestinationHead] Width : 47 mms Height : 8 mms Lines : BristleGoodsFinalDestinationHead,BristleGoodsFinalDestination [Line: BristleGoodsFinalDestinationHead] Height : 2 mms Space Bottom : 2 mms Field : BristleGoodsFinalDestinationHead Border : Thin Top [Field: BristleGoodsFinalDestinationHead] Width : 47 mms Set As : 'Country of Final Destination' Space Left : 2 mms PrePrinted : Yes Style : Small [Line: BristleGoodsFinalDestination] Height : 3 mms Space Bottom : 1 mms Field : BristleGoodsFinalDestination Border : Thin Bottom [Field: BristleGoodsFinalDestination] Width : 47 mms Set As : $DestinationCountry Space Left : 2 mms Style : Normal Bold [Part: BristleExportDet] Width : 93 mms Height : 33 mms Repeat : BristleExportDet : OrderTerms Line : BristleExportDetHead,BristleExportDet [Line: BristleExportDetHead] Field : BristleExportDetHead [Field: BristleExportDetHead] Width : 93 mms Set As : 'Terms of Delivery and Payment' Space Left : 2 mms Style : Small [Line: BristleExportDet] Field : BristleExportDet [Field: BristleExportDet] Width : 93 mms Set As : $OrderTerms Space Left : 2 mms Style : Normal Bold ;---------------------- BODY PART ------------------------------------------------------------------- [Part: BristleBodyPart] Parts : BristleBuyerDetails, Bristlecolchk Vertical : Yes [Part: Bristlecolchk] Parts : BristleColHeads, BristleInventoryPart Vertical : Yes Border : Thin Left Right [Part: BristleColHeads] Lines : BristleItemsDesHead, BristleItemsDesHead1 [Line: BristleItemsDesHead] Fields : BristleItemMarks, BristleItemPackages, BristleItemDescription, BristleItemQty, BristleItemRate Right Field : BristleItemAmount PrePrinted : Yes [Field: BristleItemMarks] Set As : "Sl No" Width : 23 mms Align : Left Style : Normal Bold [Field: BristleItemPackages] Set As : "Item Name" Width : 34 mms Align : Center Style : Normal Bold [Field: BristleItemDescription] Set As : "Group Name" Width : 59 mms Align : Center Style : Normal Bold [Field: BristleItemQty] Set As : "Quantity" Width : 24 mms Align : Center Border : Thin Left Style : Normal Bold [Field: BristleItemRate] Set As : "Rate" Width : 23 mms Border : Thin Left Align : Center Style : Normal Bold [Field: BristleItemAmount] Set As : "Amount" Width : 24 mms Align : Center Border : Thin Left Style : Normal Bold [Line: BristleItemsDesHead1] Use : BristleItemsDesHead Local : Field : Default : Set As : "" PrePrinted : Yes Border : Thin Bottom [Part: BristleInventoryPart] Parts : BristleItemsDes, BristleStockGroupTotal, BristleLedgerTotal Vertical : Yes Scroll : Vertical Common Border : Yes [Part: BristleItemsDes] Line : BristleStockGroup Repeat : BristleStockGroup : BristleStockGroup [Line: BristleStockGroup] Use : BristleItemsDesHead Local : Field : BristleItemMarks : Set As : "" Local : Field : BristleItemPackages : Set As : "" Local : Field : BristleItemDescription : Set As : $Name Local : Field : BristleItemQty : Set As : "" Local : Field : BristleItemRate : Set As : "" Local : Field : BristleItemAmount : Set As : "" Local : Field : BristleItemDescription : Style : Normal Bold Local : Field : BristleItemDescription : Align : Centre Local : Field : BristleItemDescription : Variable : StockGroupName Local : Field : BristleItemDescription : SubTitle : Yes Local : Field : BristleItemDescription : Border : Flush Thin Bottom Explode : BristleStockItemsPart : NOT $$IsEmpty:$VchStkGrpValue Empty : NOT @@InVoucherList [Part: BristleStockItemsPart] Lines : BristleItemsDes,BristleItemTotal Repeat : BristleItemsDes : BristleInvCollection Total : ItemAmount Space Bottom: 2 mms [Line: BristleItemsDes] Fields : ItemMarks,ItemDescription,ItemQty,ItemRemarks Right Field : ItemAmount Empty : $$IsEmpty:$BristleQty [Field: ItemMarks] Use : Name Field Set As : $$Line Width : 23 mms Align : Left Style : Normal [Field: ItemDescription] Type : String Set As : $Name Width : 93 mms Style : Normal Align : Left [Field: ItemQty] Use : Qty Primary Field Set As : $BristleQty Width : 24 mms Align : Right Style : Normal Bold [Field: ItemRemarks] Set As : $BristleAmount / $BristleQty Width : 23 mms Align : Right [Field: ItemAmount] Use : Amount Base Field Set As : $BristleAmount Width : 28 mms Style : Normal Bold Align : Right [Line: BristleItemTotal] Fields : BristleTotalDescription,BristleTotalQty,BristleTotalRemarks Right Field : BristleTotalAmount Space Bottom: 2 mms [Field: BristleTotalDescription] Set As : "Total" Width : 115 mms Align : Right Space Right : 2 mms [Field: BristleTotalQty] Set As : " " Width : 24 mms [Field: BristleTotalRemarks] Set As : " " Width : 23 mms [Field: BristleTotalAmount] Set As : $$Total:ItemAmount Width : 24 mms Inactive : $$NumItems:LedgerEntries <= 1 Align : Right Border : Totals [Part: BristleStockGroupTotal] Line : BristleStockGroupTotal,BristleStockGroupGrandTotal Repeat : BristleStockGroupTotal : BristleStockGroup Total : StkGpTotalValue [Line: BristleStockGroupTotal] Fields : StkGpTotalMarks,StkGpTotalDescription,StkGpTotalValue,StkGpTotalQty,StkGpTotalRemarks,StkGpTotalAmount Empty : NOT @@InVoucherList Space Bottom : 2 mms [Field: StkGpTotalMarks] Set As : "" Width : 23 mms [Field: StkGpTotalDescription] Type : String Set As : $Name Width : 73 mms Style : Normal Bold Align : Left Variable : StockGroupName [Field: StkGpTotalValue] Use : Amount Base Field Set As : $VchStkGrpValue Width : 20 mms Align : Right [Field: StkGpTotalQty] Set As : "" Width : 24 mms [Field: StkGpTotalRemarks] Set As : "" Width : 23 mms [Field: StkGpTotalAmount] Set As : "" Width : 24 mms [Line: BristleStockGroupGrandTotal] Use : BristleItemTotal Local : Field : BristleTotalDescription : Set As : "Sub Total" Local : Field : BristleTotalQty : Set As : "" Local : Field : BristleTotalRemarks : Set As : "" Local : Field : BristleTotalAmount : Set As : $$Total:StkGpTotalValue Local : Field : BristleTotalDescription : Space Right : 2 mms Local : Field : BristleTotalDescription : Style : Normal Bold Italic Local : Field : BristleTotalAmount : Style : Normal Bold Local : Field : BristleTotalAmount : Delete : Border : Totals [Part: BristleLedgerTotal] Line : BristleItemLedgers Repeat : BristleItemLedgers : LedgerEntries Space Bottom: 2 mms [Line: BristleItemLedgers] Fields : LedgerItemDescription,LedgerItemQty,LedgerItemRemarks Right Field : LedgerItemAmount [Field: LedgerItemDescription] Type : String Set As : $LedgerName Width : 116 mms Align : Right Style : Normal Bold Italic Space Right : 3 mms [Field: LedgerItemQty] Use : Qty Primary Field Set As : ' ' Width : 24 mms Align : Right [Field: LedgerItemRemarks] Set As : If $$IsEmpty:$RateOfInvoiceTax Then "" Else $$String:$RateOfInvoiceTax + ' %' Width : 23 mms Align : Right Space Right : 2 mms [Field: LedgerItemAmount] Use : Amount Base Field Set As : $Amount Width : 27 mms Align : Right ;---------------------------------- BOTTOM PART---------------------------------------------------------- [Part: BristleBottomPart] Parts : BristleAmtInWords,BristleDeclPart Vertical : Yes Border : Thin Box ;---------------------------------- PART AMOUNT IN WORDS---------------------------------------------------------- [Part: BristleAmtInWords] Height : 57 mms Left Part : BristleAmtInWordsHead Right Part : BristleTotalAmt [Part: BristleAmtInWordsHead] Width : 150 mms Height : 57 mms Lines : BristleAmtInWordsHead,BristleAmtInWordsTitle,BristleAmtInWords,BristleCertify [Line: BristleAmtInWordsHead] Field : BristleAmtInWordsHead Space Top : 1 mms Height : 2 mms Space Bottom: 1 mms [Field: BristleAmtInWordsHead] Width : 150 mms Set As : 'Amount Chargeable' Style : Small PrePrinted : yes [Line: BristleAmtInWordsTitle] Field : BristleAmtInWordsTitle Space Top : 1 mms Height : 2 mms Space Bottom: 1 mms [Field: BristleAmtInWordsTitle] Width : 150 mms Set As : '(In Words)' Style : Small PrePrinted : yes [Line: BristleAmtInWords] Space Top : 3 mms Height : 5 mms Field : BristleAmtInWords Space Bottom: 2 mms [Field: BristleAmtInWords] Width : 150 mms Set As : $$InWords:#EXPINVInvTotal + ' Only.' Style : Normal Bold [Line: BristleCertify] Space Top : 3 mms Height : 5 mms Field : BristleCertify Space Bottom: 2 mms [Field: BristleCertify] Width : 150 mms Set As : $IncomeTaxNumber:Company:##SVCurrentCompany Style : Normal Bold [Part: BristleTotalAmt] Width : 37 mms Height : 57 mms Parts : BristleTotalHead,BristleTotal [Part: BristleTotalHead] Width : 13 mms Height : 8 mms Line : BristleTotalAmt [Line: BristleTotalAmt] Field : BristleTotalAmt Space Top : 2 mms Height : 4 mms Space Bottom: 2 mms [Field: BristleTotalAmt] Width : 13 mms Set As : 'Total' PrePrinted : Yes Style : Normal Bold [Part: BristleTotal] Width : 24 mms Height : 8 mms Line : BristleTotal [Line: BristleTotal] Space Top : 2 mms Height : 4 mms Space Bottom: 2 mms Right Field : BristleTotal [Field: BristleTotal] Width : 21 mms Set As : #EXPINVInvTotal Style : Normal Bold Align : Right ;---------------------------------- PART DECLARATION---------------------------------------------------------- [Part: BristleDeclPart] Left Part : BristleDeclarationItem Right Part : BristleInvFor Height : 16 mms [Part: BristleDeclarationItem] Width : 116 mms Lines : BristleDeclarationItem,BristleDeclarationLine1,BristleDeclarationLine2 Border : Thin Right PrePrinted : Yes [Line: BristleDeclarationItem] Field : BristleDeclarationItem [Field: BristleDeclarationItem] Width : 116 mms Set As : 'Declaration' Space Left : 2 mms [Line: BristleDeclarationLine1] Use : BristleDeclarationItem Local : Field : BristleDeclarationItem : Set as : 'We declare that this invoice shows the actual price of the goods' [Line: BristleDeclarationLine2] Use : BristleDeclarationItem Local : Field : BristleDeclarationItem : Set as : 'described and that all particulars are true and correct' [Part: BristleInvFor] Width : 71 mms Lines : BristleInvForHead,BristleInvFor [Line: BristleInvForHead] Field : BristleInvForHead Space Top : 2 mms Height : 2 mms Space Bottom: 2 mms Border : Thin Top [Field: BristleInvForHead] Width : 73 mms Set As : 'Signature & Date' Style : Normal Bold PrePrinted : Yes Space Left : 2 mms [Line: BristleInvFor] Field : BristleInvFor Space Bottom: 2 mms [Field: BristleInvFor] Width : 71 mms Set As : ' ' Space Left : 2 mms ;-----------------------------------SYSTEM FORMULA------------------------------------------- [System: Formula] BristlePageNo : If $$PageNo = 1 Then "" Else (" (Page " + $$String:$$PageNo + ")") InVoucherList : $$ReportObject:$$FilterCount:InventoryEntries:LineForStkGrp > 0 LineForStkGrp : $Parent:StockItem:$StockItemName = $$ReqObject:$Name LineForStkItm : $StockItemName = $$ReqObject:$Name ;-----------------------------------OBJECT MODIFICATIONS------------------------------------------- [#Object: StockGroup] VchStkGrpValue : $$ReportObject:$$FilterAmtTotal:InventoryEntries:LineForStkGrp:$Amount [#Object: StockItem] BristleQty : $$ReportObject:$$FilterQtyTotal:InventoryEntries:LineForStkItm:$BilledQty BristleAmount : $$ReportObject:$$FilterAmtTotal:InventoryEntries:LineForStkItm:$Amount ;-----------------------------------COLLECTION CREATION------------------------------------------- [Collection: BristleStockGroup] Type : Stock Group With Alias : No [Collection: BristleInvCollection] Type : Stock Item Childof : #StockGroupName BelongsTo : Yes ;; End of File
I have already changed my Inv. Format using the tdl below :- Sales Inv. with group :- But I want to know that if I want sales Inv. Format with categories what will be the best Tdl for that purpose? Plz Help?
I want to add every party ledger name with its narration and amount in the payment voucher. How to do it? Also how to add Bank Ledger Name ???
It is customize payment voucher, and I am making the tdl file............ but I dont know the code to get every party ledger name, narration and amount. How to use REPEAT in tdl to get those fields (e.g. to get voucher number, $VoucherNumber)
;;*********************************** System Date & Voucher No *** [Part : SMTDate] Lines : SMDate HorizontalAlign : Left [Line : SMDate] Fields : Simple Prompt, SystDate RightFields : Info Field, VCHNo Local : Field : Simple Prompt: Info: "Date " Local : Field : Simple Prompt: Style : StyleAllText Local : Field : Info Field : Info : "Voucher No. : " Local : Field : Info Field : Style : StyleAllText [Field : SystDate] Set as : $$MachineDate Style : StyleAllTextBold [Field : VCHNo] Set as : $VoucherNumber Style : StyleAllTextBold ;;*** System Date & Voucher No *********************************** ;;************************ System Time & Voucher Creation Date *** [Part : SMTTime] Lines : SMTTimeLine HorizontalAlign : Left [Line : SMTTimeLine] Fields : Simple Prompt, SystTime RightFields : Info Field, VCHDated Local : Field : Simple Prompt : Info: "Time " Local : Field : Simple Prompt : Style : StyleAllText Local : Field : Info Field : Info : "Dated : " Local : Field : Info Field : Style : StyleAllText [Field : SystTime] Set as : $$MachineTime Style : StyleAllTextBold [Field : VCHDated] Set as : $Date Style : StyleAllTextBold ;;*** System Time & Voucher Creation Date ************************ ;;*********************************************** Voucher Type *** [Part : VoucherType] Lines : VoucherTypeLine HorizontalAlign : Center [Line : VoucherTypeLine] Fields : Info Field Local : Field : Info Field : Info: "Payment Voucher" Local : Field : Info Field : Style : StyleHeadingI ;;*** Voucher Type *********************************************** ;;********************************************* Cheque Details *** [Part : ChqDetail] Lines : ChqDetailLine HorizontalAlign : Right [Line : ChqDetailLine] Fields : Info Field, ChqNum Local : Field : Info Field : Info: "Cheque # " Local : Field : Info Field : Style : StyleAllText [Field : ChqNum] Set as : ????????????????????????? ;; what should I write here ???????? Style : StyleAllTextBold ;;*** Cheque Details *********************************************