Invoice Problem

[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

 

Finally done.