How to use Ledger as Invoice Description (Non-Inventory) For Professional Services

1. How to make code for Ledger description (excl stock item and inventory part)
2. Qty and Rate needed not coming
3. Total Qty and Total Value not coming in bottom

Code i have used:

Part:EBY Body Coloumns Title]
Line: EBY Coloumns Title1
Border: Thick Cover
Common Border: Yes

[Line: EBY Coloumns Title1]
Use: EBY Invoice Body
Local: Field: Default: Type: String
Local: Field: Default: Style: O9B
Local: Field: Default: Align: Center
Space Top: 0.25
Space Bottom: 0.25

Local: Field: EBY SrNo: Set as: "S.No."
Local: Field: EBY Description:Set as:"Description Of Services"
Local: Field: EBY Qty: Set as:"Qty"
Local: Field: EBY Rate: Set as:"Rate"
Local: Field: EBY GrossAmt: Set as:"Total Value"

[Part:EBY Invoice Body]
Line: EBY Invoice Body
Repeat:EBY Invoice Body: Ledger Entries
Bottom Line: EBY Coloumn Total
Border: Thick Cover
Scroll: Vertical
Float: No
Common Border: Yes


[Line: EBY Invoice Body]
Field: EBY SrNo, EBY Description
Right Field: EBY Qty, EBY Rate, EBY GrossAmt

Local: Field: EBY SrNo: Width:5
Local: Field: EBY Qty: Width:8
Local: Field: EBY Rate: Width: 8
Local: Field: EBY GrossAmt: Width: 13


Local: Field: EBY SrNo: Border: Thick Right
Local: Field: EBY Qty: Border: Thick Left
Local: Field: EBY Rate: Border: Thick Left
Local: Field: EBY GrossAmt: Border: Thick Left
Space Top: 0.15

[Field: EBY SrNo]
Use: Simple Field
Set as: $$Line
Style: O9
Align : Center

[Field: EBY Description]
Use: Simple Field
Style: O9
Set as: $LedgerName
Full Width: Yes
Line: 0

[Field:EBY Qty]
Use: Simple Field
Set as: $BilledQty
Style:O9

[Field:EBY Rate]
Use: Simple Field
Set as: $Rate
Style:O9

[Field:EBY GrossAmt]
Use: Amount Field
Set as: $Amount
Style:O9

[Line:EBY Coloumn Total]
Use:EBY Invoice Body
Border: Thick Top Bottom
Local: Field: EBY SrNo: Set as: ""
Local: Field: EBY Description:Set as:"TOTAL"
Local: Field: EBY Qty: Set as:""
Local: Field: EBY Qty : Type: String
Local: Field: EBY Qty Amt: Set as:$$FilterAmtTotal:InventoryEntries:Qty:$Amount
Local: Field: EBY Rate: Set as:""
Local: Field: EBY GrossAmt: Set as:$$CollAmtTotal:LedgerEntries:$Amount
Local: Field: EBY Item Total: Set as:#EBYGrossAmt

[System: Formula]

Round : $$FilterAmtTotal:LedgerEntries:Round1:$Amount
Round1 : $Name:Ledger:$LedgerName Contains $$LocaleString:"Round"

 

Invisible the fields based on the Condition.