[Part : My Invoice Body Part] Part : MI ColumnTitles, IE Details, LE Details,;;MI SlDetails, Vertical : Yes ;Scroll : Vertical Common Border : yes ;border : Thin cover Border:Thin Left Right [Part : MI ColumnTitles] Line: MI Column Titles [Line: MI Column Titles] Use : IE Details Local : Field : Default : Align : center Local : Field : Default : Lines : 1 Local : Field : Default : Type : String Local : Field : Default : Style : Large Bold Local: Field : IE: Set As: "Sl." Local : Field : IE SiName : Set as : "Description Of Test" ;Local : Field : IE Qty : Set as : "Test" ;Local : Field : IE UOM : Set as : "Unit" ;Local : Field : IE Rate : Set as : "Rate" Local : Field : IE Amount : Set as : "Amount" Border: Column Titles [Part : MI SlDetails] LINE : MI SlDetails /* ;[Field : MI SlDetails] Use : Name Field Set As : $$Line Width :3 Style : Normal Border : Thin Left Right */ [field : MI SlDetails] Set as : "SL." Style : Normal Bold Width : 15 mm Align : Center [Part : IE Details] ;Local : Field : Default :Align :Right Line :IE Details Repeat : IE Details : Inventory Entries Local : Field : Default :Align :Left Total : IE Amount, ;IE Qty, [Line : IE Details] Field : IE SiName Right Field : IE Amount ; IE Qty, IE Rate, Explode : Item Desc : $$NumItems:UserDescription > 0 [Part : Item Desc] Local : Field : Default :Align : Left Line : Item Desc Repeat : Item Desc : UserDescription [Line : Item Desc] Field : Item Desc [Field : Item Desc] Use : Name Field Width : 20 Indent : 6 Set as : $UserDescription Style : Normal Border : Thin left [Field : IE SIName] Use : Name Field Align : Left Set as : $StockItemName ;Border : Thin Left FullWIdth : Yes ;[Field : IE Qty] ;Use : Qty Field ;Set as : $BilledQty ;Border : Thin Left ;Format : "NoZero" ;Align : Right ;[Field : IE rate] ;Use : Rate Field ;Set as : $Rate ;Border : Thin Right [Field : IE Amount] Use : Amount Field Set as : $Amount Align : Right Border : Thin Left Format : "NoZero" [Part : LE Details] Line : LE Details Repeat : LE Details : Ledger Entries Scroll : Vertical [Line : LE Details] Use : IE Details Local : Field : IE SiName: Set as : $LedgerName Local : Field : IE Qty : Set as : "" Local : Field : IE Rate : Set as : if $$IsEmpty:$RateOfInvoiceTax then "" else $$String:$RateOfInvoiceTax + "%" Local : Field : IE Amount: Set as : $Amount Local : Field : IE SiName: Align : Right Local : Field : IE Qty : Format : "NoZero" Local : Field : IE Rate : InActive: $RateOfInvoiceTax = 0 Local : Field : IE Rate : Type : String Empty : $LedgerName = $PartyLedgerName [Part : MI TOTAL] Line : MI Total Line, MI AmtInWords [Line : MI Total Line] Use : IE Details Local : Field : Default :Align : right Local : Field : Default : Style : Large Bold Local : Field : IE SiName: Set as : "TOTAL" ;Local : Field : IE Qty : Set as : $$Total:IEQuantity Local : Field : IE Qty : Set as : $$Total:IEAmount Local : Field : IE Rate : Set as : "" Local : Field : IE Amount: Set as : $Amount ;Local : Field : IE Quantity : Set as : $Quantity Border : Totals [Line : MI AmtInWords] Border : Thin Box Field : Short Prompt, MI AmtInWords Local : Field : Short Prompt : Set as : "In Words : " ;Local : Field : simple field : Width : 90 ;Local : Field : simple field : STYLE : Normal Bold Local : Field : Default : Style : Large Bold [Field : MI AmtInWords] Use : Name Field Set as : $$InWords:$Amount + " Only." FullWidth : yes Style : Normal
Local: Field : IE: Set As: "Sl." for "sl.no" you have to define field below lyk as description,amount fields... and for subtotal also u have to define a part,line and in setas feed this "$$CollAmtTotal:InventoryEntries:$Amount" and for left border you have to feed scroll:vertical