Adding Column in Ledger Voucher

Sir, I think you have misunderstood me. I was asking what is that line represent. I don't know it. That is why I have asked to you

 

This is the screen shot of data I am entering.

 

Si

Sir,

You mean to say that, I have to add that particular line in the Report where I have made TDL for data Entry?

 

[#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
[#Object : Ledger]
DriverName : $DriverName

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


Now the tally showing - "Not Responding"

 

Not Responding Issue Solved But Probably You are using sub Collection to Store Values So, I don't think will work....It requires a big post explaining concept of sub Collection, Collection and Objects that is not possible for me currently So, I will prefer you to study below things

1. Aggregate UDF
2. Sub Collection
3. Object

[#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
[#Object : Ledger]
MyDriverName : $DriverName

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

 

Dear Friend,

I am not a developer, I don't know this TDL Coding. I was trying to assemble the various codes from different forums and was making a custom development of TDL. Here I am providing my assembled TDL.

 

Try This Way

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

 

[#Line: DSP VchAccTitles]
Add :Right Fields : Before : DSP VchTypeTitle : RCPLedLocationTitle, RCPLedDriverTitle, RCPLedTruckNoTitle

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

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


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

[#Line: DSP VchDetail]
Add : Right Fields : Before : DSP VchType : RCPLedLocation, RCPLedDriver, RCPLedTruckNo

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


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


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

[#Collection: Vouchers of Ledger]
fetch: EICHECKPOST, BASICFINALDESTINATION, BASICSHIPVESSELNO, brokerto


Sir,

I was trying to add some custom field in the ledger report. With the above code, I can get the desired report from now onwards. However, I was using a different STORAGE before. So I thought I could set a conditional field value by modifying the field as below:

[Field: RCPLedLocation]
Use: Short Name Field
Set as: If NOT $$IsEmpty: $brokerto Then $BASICFINALDESTINATION Else $brokerto
Skip: Yes
Align: Right
Style: Normal Bold
Width:20

But I think, I am missing some serious thing in the above formula. can anyone please guide me in this regard?

 

Th

Thank You So much Sir..........................................

Once again thanking you the entire group admin for opening such a wonderful group for sharing knowledge..