;;Experts please help me correct this cord ;;i have created a group account under Capital Account and wants to retrieve the amount field value ;;i used the bellow formula but its not fetching ;; CapitalTotal:$ClosingBalance:Group:$$GroupCapital ;;its rather retriving the Capital Account Amount Field ;;any guidance [#Menu:GateWay Of Tally] Add:Item:Shares Reportisplay:BSDetailRep [Report:BSDetailRep] Form:BSDetailRep [Form:BSDetailRep] Part:BSDetailRep [Part:BSDetailRep] Line:BSDetailRep [Line:BSDetailRep] Field:BSDetailRep [Field:BSDetailRep] Use:Amount Field ;;Use:Number Field Use:Name Field Set as@CapitalTotal [System:Formulae] CapitalTotal:$ClosingBalance:Group:$$GroupCapital ;;[#Field: BSName] ;;Background:blue ;;[#Field: BSMainTotal] ;; Background:blue ;;Regards Philip
Please find the below corrected code.. it is working fine for me.. Hope it will work for you as well [#Menu:GateWay Of Tally] Add:Item:Shares Reportisplay:BSDetailRep [Report:BSDetailRep] Form:BSDetailRep [Form:BSDetailRep] Part:BSDetailRep [Part:BSDetailRep] Line:BSDetailRep [Line:BSDetailRep] Field:BSDetailRep [Field:BSDetailRep] Use:Amount Field Set as@CapitalTotal [System:Formulae] CapitalTotal:$ClosingBalance:Group:$$GroupCapital
Use this way............ Code: [#Menu:GateWay Of Tally] Add:Item:Shares Report:Display:BSDetailRep [Report:BSDetailRep] Form:BSDetailRep Object : Company [Form:BSDetailRep] Part:BSDetailRep [Part:BSDetailRep] Line:BSDetailRep [Line:BSDetailRep] Field:BSDetailRep [Field:BSDetailRep] Use:Amount Field Set as:@@CapitalTotal [System:Formulae] CapitalTotal:$ClosingBalance:Group:$$GroupCapital
I have created a group name call shares under the capital account. Now I want to retrieve the amount field of the shares i created under capital The above formula is fetching the amount field of the capital I need formula to fetch the amount field of the shares and not the capital account Thanks
Now you are explaining clearly........... U should learn to communicate your query properly.................
Thanks Amit Kamdar. Little drops of water makes a mighty ocean Any guidance I have created a group name call shares under the capital account. Now I want to retrieve the amount field of the shares i created under capital Account from the Balance Sheet The above formula is fetching the amount field of the capital Account from the Balance Sheet I need formula to fetch the amount field of the shares in report and not the capital account in report Thanks
Well since little drops makes a mighty ocean ........ and it can drown/sink you if you don't know how to swim. And so here is the guidance you seek ----- Search for Insurance module, posted by me some 4-5 months ago............ go through the code and you will find answer to your problem.