Column total not coming in voucher screen

Dear Experts,

I have added a column (Brokerage) before Quantity field in main voucher screen, now I want to total of this column in bottom of voucher screen.

I have written the following code for total of column(Brokerage), but the total is not coming.


;;=========code for adding column/field in main voucher screen============
[#Line: EI ColumnOne]

Add: Right Field: Before:VCH QtyTitle : VCH BrokerageTitle

[Field:VCH BrokerageTitle]
Use: Name Field
Set as: "Brokerage"
Width: 8
Skip: Yes
Invisible : @@IsPurchase

[#Line: EI InvInfo]

Add: Right Field: Before:VCH BilledQty: VCH Brokerage10


[Field:VCH Brokerage10]
Use:Amount Field
Set as: $VBrokerageTot
Storage: MYBrokerage
Width: 10
Align: Right
Space Right: 5
Skip: Yes
;;========code for total of brokerage in main voucher screen in bottom of screen============

[#Field: EI QtyTotal]

Add: Field: Before:EI BilledQtyTotal : EI BrokerageTotal
Border : Totals
Invisible : @@AcctsInvoice


[Field: EI BrokerageTotal]
Use : Amount Field
Type : Amount: Forced
Set as : $$Total:VCHBrokerage10

Requested to please help me in this regard.

Thanks in Advance

 

you need add total : filedname to the part where line is repeating
try this:

Code:

[#Line: EI ColumnOne]

Add: Right Field: Before:VCH QtyTitle : VCH BrokerageTitle

[Field:VCH BrokerageTitle]
Use: Name Field
Set as: "Brokerage"
Width: 8
Skip: Yes
Invisible : @@IsPurchase

[#Part: EI InvInfo]
    Total:VCHBrokerage10

[#Line: EI InvInfo]

Add: Right Field: Before:VCH BilledQty: VCH Brokerage10


[Field:VCH Brokerage10]
Use:Amount Field
Set as: $VBrokerageTot
Storage: MYBrokerage
Width: 10
Align: Right
Space Right: 5
;Skip: Yes
;;========code for total of brokerage in main voucher screen in bottom of screen============

[System:UDF]
    MyBrokerage:Amount:4545

[#Field: EI QtyTotal]

Add: Field: Before:EI BilledQtyTotal : EI BrokerageTotal
Border : Totals
Invisible : @@AcctsInvoice


[Field: EI BrokerageTotal]
Use : Amount Field
Set as : $$Total:VCHBrokerage10
Set Always:Yes

 

Dear Teja Varma, Now column total coming properly...........Thanks for your valuable support.

Regards

 

Dear Teja Varma,

When I select the voucher type without Voucher class then total of (brokerage column) is coming, and if I select voucher type
with Voucher class then total of (brokerage column) is not coming. Please guide me what is the reason. I am here attaching two screenshots for you reference.

Regards

 

because the line or part name is different when you use class for voucher type so find that line and add these new fields as well

 

Dear Teja Varma,

As per your suggestion I find the following part name and set the total field

[#Part: EI Default Vch InvInfo]
Total:VCHBrokerage10

After this changes when voucher open with class in creation mode then total of (brokerage) column coming , but when open that voucher in alteration mode then total of (brokerage) column is not coming. please guide.

Regards

 

in the above screenshots i didn't found any class in the Voucher
anyway post your code i will try to rectify it

 

Dear Teja Varma,

this is my tried code, please rectify it.

Regards

;;========================code for adding column/field in main voucher screen=============================
[#Line: EI ColumnOne]

Add: Right Field: Before:VCH QtyTitle : VCH BrokerageTitle

[Field:VCH BrokerageTitle]
Use: Name Field
Set as: "Brokerage"
Width: 8
Skip: Yes
Invisible : @@IsPurchase

[#Part: EI Default Vch InvInfo]
Total:VCHBrokerage10

[#Line: EI InvInfo]
Add: Right Field: Before:VCH BilledQty: VCH Brokerage10


[Field:VCH Brokerage10]
Use:Amount Field
Set as: $VBrokerageTot
Storage: MYBrokerage
Width: 10
Align: Right
Space Right: 5
Skip: Yes
;;====================code for total of brokerage in main voucher screen in bottom of screen===================

[#Field: EI QtyTotal]

Add: Field: Before:EI BilledQtyTotal : EI BrokerageTotal
Border : Totals
Invisible : @@AcctsInvoice


[Field: EI BrokerageTotal]
Use : Amount Field
Type : Amount: Forced
Set as : $$Total:VCHBrokerage10

[#Field: EI Value]
Set by Condition : (#EIAccDesc Contains $$LocaleString:"Brokerage") :#EIBrokerageTotal

[System: UDF]
VBrokerageTot :Amount:4001
MYBrokerage :Amount:4002

 

Dear Teja Varma..........its done........... i used the following code for total of (Brokerage) column

[#Part: EI Details]
Total:VCHBrokerage10

Now, the total of column is coming properly in vch alteration mode.........Thanks