Adding Column in Ledger Voucher

I added 1 Column in Ledger Voucher Report
Code:
[#Line: DSP VchAccTitles]
Add : Fields : AFter : DSP VchAcctTitle : Example

[Field: Example]
Use: Short Name Field
Set as: "Example"
Skip: Yes
Align: Right
Style: Normal Bold
Width:20

[#Line: DSP VchDetail]
Add : Right Fields : Before : DSP VchType : ExampleBody

[Field: ExampleBody]
Use: Short Name Field
Set as: "Example"
Skip: Yes
Align: Right
Style: Normal Bold
Width:20

It is working Perfectly But the Same Thing is added in Stock Vouchers too So, I want to remove that and I know I have to use the option to achieve it But I don't about that system formula

Example:

[#Line: DSP VchAccTitles]
Option:Example:@@IsLedgerReport

I just want to know that System Formula which I write in Red Colour

 

Already Tried But I don't know the logic which I have to write So, I failed doing that

 

Worked... Thank You Sir

 

Updated Sample Code

[#Line: DSP VchAccTitles]
Add : Fields : AFter : DSP VchAcctTitle : Example

[Field: Example]
Use: Short Name Field
Set as: "Example"
Skip: Yes
Align: Right
Style: Normal Bold
Width:20
Invisible : NOT ##IsLedgerReport

[#Line: DSP VchDetail]
Add : Right Fields : Before : DSP VchType : ExampleBody

[Field: ExampleBody]
Use: Short Name Field
Set as: "Example"
Skip: Yes
Align: Right
Style: Normal Bold
Width:20
Invisible : NOT ##IsLedgerReport

 

Sir, if want to add details of "Driver" in the Ledger Report. I have set my codes as below:

[#Line: DSP VchAccTitles]
Add : Fields : AFter : DSP VchAcctTitle : Deliveredby

[Field: Deliveredby]
Use: name field
Set as: "Delivered By"
Skip: Yes
Align: Right
Style: Normal Bold
Width:20
Invisible : NOT ##IsLedgerReport

#Line: DSP VchDetail

repeat SP VchDetail : salesVchBrokarCollct
[#Line: DSP VchDetail]

Add : Right Fields : Before : DSP VchType : DeliveredbyBody

[Field: DeliveredbyBody]
Use: name field
Set as: $DriverName
Skip: Yes
Align: Right
Style: Normal Bold
Width:20
Invisible : NOT ##IsLedgerReport


But it doesn't work. Can anyone please guide me?

 

Driver Name is entered as an additional Details to the vocuher. its custom made
And the collection is:

[Collection:salesVchBrokarCollct]
Type : Voucher ;;s:Ledger
child of : $EntryBrokarage
Fetch : EntryBrokarage,Amount,Brokerunit,brokerRate,ServicetaxPaidby,brokerAmt,brokerto,brokerfrom,brokerQUANTIEY,EibrokerTruckNo,Despatchmode1,Billtyno

 

Sir Actually, I want to add a custom field in the Customer Ledger (Sundry Debtors) which shows the drivers name who delivered. For the Transportation Records, I have added additional details in the voucher with driver details. Now I was trying to add the driver details to the Custer Ledger Report.

 

Probably Your Collection doesn't have the value which you trying to fetch.
To check Type this in your calculator

Select $DriverName From salesVchBrokarCollct

 

It shows the values

 

Is there any way I can filter the collection by the selected ledger?

 

Hmm...If value is there and voucher is associated with that then Just Modify the Ledger Voucher Collections

Modified Code ( Not Tested )

[#Line: DSP VchAccTitles]
Add : Fields : AFter : DSP VchAcctTitle : Example

[Field: Example]
Use: Short Name Field
Set as: "Example"
Skip: Yes
Align: Right
Style: Normal Bold
Width:20

[#Line: DSP VchDetail]
Add : Right Fields : Before : DSP VchType : ExampleBody

[Field: ExampleBody]
Use: Short Name Field
Set as: $Narration
Skip: Yes
Align: Right
Style: Normal Bold
Width:20

[#Collection: Vouchers of Ledger]
Fetch: Narration

I don't remember the Collection name So, Please check the same and After that replace the method name with your UDF Name

 

Value of Ledger which is selected is stored in variable LedgerName

Example:
[Collection: Example]
Type: Vouchers
Fetch:*.*
Filter: LedFil

[System: Formulas]
LedFil: $PartyLedgerName = ##LedgerName

 

[#Line: DSP VchAccTitles]
Add : Fields : AFter : DSP VchAcctTitle : Deliveredby

[Field: Deliveredby]
Use: name field
Set as: "Delivered By"
Skip: Yes
Align: Right
Style: Normal Bold
Width:20
Invisible : NOT ##IsLedgerReport

[#Line: DSP VchDetail]

Add : Right Fields : Before : DSP VchType : DeliveredbyBody

[Field: DeliveredbyBody]
Use: name field
Set as: $DriverName
Skip: Yes
Align: Right
Style: Normal Bold
Width:20
Invisible : NOT ##IsLedgerReport

[Collection:LedDriverCollect]
Type : Vouchers
Fetch:*.*
Filter: LedFil

[System: Formulas]
LedFil: $PartyLedgerName = ##LedgerName



I think I am missing something which links the value of Filed "DeliveredbyBody" with the Collection

 

Add Code Which is Told By Amit Sir and Sir You are using filter in a wrong way... Please refer the Same in TDL Refrence Manual Or Search the Forum

 

Actually I didnt understand it fully. I am not a Developer, I am an auditor, however I was planning to develop few things for our internal controls. My number is +968 96224499. If you don't mind, can I get your number please? I would like to get in touch with you.

 

Thank You,

[#Object : Voucher]
LedDriverName : $DriverName -----------------------------What is this line? What does it mean?

[Field: DeliveredbyBody]
Use: name field
Set as: $LedDriverName
Skip: Yes
Align: Right
Style: Normal Bold
Width:20

 

The field heading is is coming correctly but the details are not coming

 

Whether I should define this "LedDriverNamed"? IF so, can I define it as string?

 

NSA Sir....Did You ever Converted English To English ?? You are asking the same thing......Your UDF is Already a string then Does it make sense to convert it in String Again ? and Post a screenshot of Voucher Screen where you are adding your Field So, Everyone Can help you better