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