learned programmers please check my code for correction i need to make the newly created column field appear only in the cash account screen in the trial balance follow this steps to get to the cash account in the reports trial Balance>current assets>Cash Account in the cash account screen i want to see the newly created fields but the column is appearing in all items in the trial balance.its appearing on capital account please help me remove it from the other items apart from cash ledger and also help me do the alignment Thanks Philip code is below [#Line: DSP AccLine] ;;Border:Thick box Add: Field:Number Field Local:Field:Number Field:Set as@ClDrValue* 20% Local:Field:Number Field:Space Left:80 Local:Field:Number Field:Use: Amount Forex Field
Thanks pankaj Bohndle for the reply inactive:not $$cashaccount Is not working The above field value is appearing in all the sub forms in the trial balance Please how do I prevent that Field value from appearing in some of the Sub form in the trial balance I only need it in one sub form(cash account) Thanks Programmers please guide me
[#Field: DSP AccName] Add: Field: After : DSP ActualName : MyNumberField Local:Field:MyNumberField:Set as@ClDrValue* 20% [#Field: DSP DispName] Width : 30 [Field : MyNumberField] Use : Amount Field Width : 20 Invisible : NOT $$IsBelongsTo:$$GroupCash
[#Field: DSP AccName] Add: Field: After : DSP ActualName : MyNumberField [#Field: DSP DispName] Full Width : Yes [Field : MyNumberField] Use : Amount Field Width : 20 Invisible: NOT $$IsLedger:$$GroupCash ;1) SHOW IN CASH LEDGER ;Invisible : NOT $$IsBelongsTo:$$GroupCash ; 2) SHOW IN CASH GROUP (CASH-IN HAND) ;Background:GREEN Set as:$$TOTALSPClDrAmtA*20%
How will I get @@ClDrValue* 60% On capital account on same trial balance after helping me have @@ClDrValue* 20% on cash account I need @@ClDrValue* 60% on capital account and @@ClDrValue* 20% on cash account All in the trial balance Thanks once again
same way you wrote code for CASH...........make a small one for your Capital account. Hint : use conditional formula in Set as .............. If Cash then ABC * 20% Else If Capital then ABC * 60% Else 0
Thanks so m4uch Mr Kamdar and Pankaj.I'm trying to understand something and need ur help. I could not find below fields with tally developer mode on the trial balance form [#Field: DSP AccName] [#FieldSP ActualName ] Can u please explain the logic hereI can't find them in the trial balance yet u use them in ur codes and its working perfectly.Please guide me to understand
Hello Mr Kamdar I made changes below and I'm not getting effects on cash and capital account in trial balance Plz check for correction I need 30% and 60% on cash and capital account [#FieldSP AccName] Add:Field:AfterSP ActualName:MyNumberField Local:Field:MyNumberField:Set as:If $$GroupCash then @@CLDrValue*20% else If $$GroupCapital Then @@CLDrValue*60% else 0;;@@CLDrValue*30% Local:Field:MyNumberField:Background:Red Local:Field:MyNumberField:Invisible:NOT $$IsBelongsTo:$$GroupCash Local:Field:MyNumberField:Invisible: NOT $$IsBelongsTo:$$GroupCapital ;;Local:Field:MyNumberField:Invisible:NOT $$IsLedger:$$GroupCurrentLiab [#FieldSP DispName] Width:30 Background:Green [Field:MyNumberField] Use:Amount Field Width:30
Set as:IF $$IsBelongsTo:$$GROUPCASH THEN #DSPClDrAmtA*20% ELSE if $$IsBelongsTo:$$GroupCapital then #DSPClDrAmtA*60% else 0
learned programmers please check my code for correction i need to make the newly created column field appear only in the cash account and capital account screen in the cash and capital account screen i want to see the newly created fields but the column is appearing in all items in the trial balance.its appearing on capital account please help me remove it from the other items apart from cash and capital account Thanks Philip code is below [#Line: DSP AccLine] ;;Border:Thick box Add: Field:Number Field Local:Field:Number Field:Set as@ClDrValue* 20% Local:Field:Number Field:Space Left:80 Local:Field:Number Field:Use: Amount Forex Field