Trial Balance

Dear Experts,

Please help me how out for the below issue.

Have added one column in Trial Balance report, But after exporting the trial balance report into excel facing some alignment issue.

Below is the code:


[#Form: GroupSummary]

Local : Part : DSP AccBody : Local: LineSP AccLine :Local: Field: DSP AccName:Add: Field:AfterSP DispName: DSPAliasName
Local : Part : DSP AccBody : Local: LineSP AccLine :Local: Field: DSPAliasName :Align:Right
Local : Part : DSP ColTitles : Local : Line : DSP ColTitles : Delete : Line : DspDateTitle
Local : Part : DSP ColTitles : Local : Line : DSP ColTitles : Add : Line : After SP CmpTitle: ParticularsLine

Local:LinearticularsLine :Local:FieldSPALiasTitle:Cells:1
Local: LineSP AccLine :Local: Field: DSPAliasName :Cells:1
Local : Line : DSP ColTitles :Local:FieldSP CmpTitle:Cells:6

Local : Field : DSP ValuationTitle: delete:Cells : @@AccCellCommonTitle
Local : Field : DSP BreakupTitle : delete:Cells : @@AccCellCommonTitle
Local : Field : DSP GodownTitle : delete:Cells : @@AccCellCommonTitle
Local : Field : DSP CategoryTitle : delete:Cells : @@AccCellCommonTitle
Local : Field : DSP BudgetTitle : delete:Cells : @@AccCellCommonTitle
Local : Field : DSP OrderTitle : delete:Cells : @@AccCellCommonTitle
Local : Field : DSP CurrencyTitle : delete:Cells : @@AccCellCommonTitle
Local : Field : DSP ColTotTitle : delete:Cells : @@AccCellCommonTitle
Local : Field : DSP Scale Factor : delete:Cells : If ##DSPColumnTotal Then ($$Numsets * @@AccCellCommonTitle) + 1 + @@AccCellCommonTitle Else ($$Numsets * @@AccCellCommonTitle) +


Local : Field : DSP ValuationTitle: Add:Cells : 1;@@AccCellCommonTitle
Local : Field : DSP BreakupTitle : Add:Cells : 1;@@AccCellCommonTitle
Local : Field : DSP GodownTitle : add:Cells : 1;@@AccCellCommonTitle
Local : Field : DSP CategoryTitle : Add:Cells : 1;@@AccCellCommonTitle
Local : Field : DSP BudgetTitle : Add:Cells : 1;@@AccCellCommonTitle
Local : Field : DSP OrderTitle : Add:Cells : 1;@@AccCellCommonTitle
Local : Field : DSP CurrencyTitle : Add:Cells : 1;@@AccCellCommonTitle
Local : Field : DSP ColTotTitle : Add:Cells : 1;@@AccCellCommonTitle
Local : Field : DSP Scale Factor :Add: Cells : 1;If ##DSPColumnTotal Then ($$Numsets * @@AccCellCommonTitle) + 1 + @@AccCellCommonTitle Else ($$Numsets * @@AccCellCommonTitle) + 1




[FieldSPAliasName]

Add:OptionSPAliasLedger:$$IsLedger:#DSPDispName
Add:OptionSPAliasGroup:$$IsGroup:##DSPDispName

[!FieldSPAliasLedger]

Use: Name field
Set as: If Not $$IsLedger:#DSPDispName then "" else $(Ledger,#DSPDispName).Name[2].Name
Space Left: 10
Width: 15
Align:Right

[FieldSPALiasTitle]

Width : @@DSPNameWidth
Set as : $$LocaleString:"Alias"
Skip : Yes
Fixed : Yes
Style : Small Bold
WideSpace : Yes
Indent : if ##DSPShowMonthly then 0 else 2

[Line: ParticularsLine]

Use : DspDateTitle
Add : Fields: AfterSP NameTitleSPALiasTitle
Local : Field : Default : Align : Center
Local : Field : Default : Style : Normal
Local : Field : DSPAliasName : Set as: $$LocaleString:"Alias"


[!FieldSPAliasGroup]

Use: Name field
Set as: If Not $$IsGroup:#DSPDispName then "" else $(Group,#DSPDispName).Name[2].Name
Space Left: 10
Width: 15
Align:Right

Also,Please check the Excel i have attached.

 

Field level cell : 2 & 3 & 4 variable value

 

Dear Experts, Please reply.

 

I tried with multiple variables cell locally as well as field level, but none of them is working

 

[Line: DSP ColTitles]
Lines : DSP ItemTitle, DSP CmpTitle, DSP DateTitle, DSP ValuationTitle, DSP BudgetTitle, DSP CurrencyTitle

In all the LINES Above, add one blankfield having same width as your added field.

 

H

Hi ,

Already Added like that and checked,but i dont know where i gone wrong,Please help


[#Line : DSP ItemTitle]

Add:Field :After: DSP NameTitleSPALiasTitle
Local : Field : DSP NameTitle : Inactive : Yes
Local : Field : DSP ColTotTitle : Inactive : Yes
Local : Field : DSP ItemTitle : Cells : 2
Local: FieldSPALiasTitle:Inactive:Yes

[#LineSP CmpTitle]

Add:Field :After: DSP NameTitleSPALiasTitle
Local : Field : DSP NameTitle : Inactive : Yes
Local : Field : DSP ColTotTitle : Inactive : Yes
Local : Field : DSP ItemTitle : Cells : 1
Local: FieldSPALiasTitle:Inactive:Yes

[#LineSP DateTitle]

Add:Field :After: DSP NameTitleSPALiasTitle
Local : Field : DSP ItemTitle : Cells : 2
Local: FieldSPALiasTitle:Set as:$$LocaleString:"Alias"
Local: FieldSPALiasTitle:Cells:1

[#LineSP ValuationTitle]

Add:Field :After: DSP NameTitleSPALiasTitle
Local : Field : DSP NameTitle : Inactive : Yes
Local : Field : DSP ColTotTitle : Inactive : Yes

Local: FieldSPALiasTitle:Inactive:Yes

[#Line: DSP BudgetTitle]

Add:Field :After: DSP NameTitleSPALiasTitle
Local : Field : DSP NameTitle : Inactive : Yes
Local : Field : DSP ColTotTitle : Inactive : Yes
Local: FieldSPALiasTitle:Inactive:Yes

[#LineSP CurrencyTitle]

Add:Field :After: DSP NameTitleSPALiasTitle
Local : Field : DSP NameTitle : Inactive : Yes
Local : Field : DSP ColTotTitle : Inactive : Yes
Local: FieldSPALiasTitle:Inactive:Yes

 

Yes Sir, Thank You....

My side some Issue with Default Tally....Customer side it was working perfectly.I thought problem with code. But code is fine.

Anyway Thanks for the reply.

 

Yes....Even im not getting ,the code which you have shared is also not working at my end..Alignment is getting disturbing...Really I'm wondering.
Problem with Excel or Tally Im not getting.

 

In my system, Default Export is also not working properly, Without any TDL alignment issue is occuring. Then how customization will work.

 

Pirated and Tally Prime new 1.1.3 version