Cash Balance in Day book....

Dear Experts,
I Make an Report Like Day book with Cash balance. But, cash balance not coming correctly. Because, It adding the amount instead of subtracting the amount in payment & Receipt voucher type. please correct my formula. I attached the cash running balance formula & screenshots.

[Field: ClAmount]

Use : Amount Field
Set as : If ($$Line = 1) Then If (##DSPWithOpening) Then @NettOpBal Else +
@NettDrCrTotal Else $$NettAmountNettDrCrTotalPrevTot
PrevTot : $$PrevLineField
NettOpBal : $$NettAmountOpgBalanceNettDrCrTotal
OpgBalance : @LedOpening
LedOpening : If $$IsEmpty@LedOpening1 Then $$AsAmount:0 Else @@LedOpening1
NettDrCrTotal : If ($$IsEmpty:#MyVchAmount5 AND NOT $$IsEmpty:#MyVchAmount4) Then #MyVchAmount4 Else +
If (NOT $$IsEmpty:#MyVchAmount5 AND $$IsEmpty:#MyVchAmount4) Then #MyVchAmount5 Else +
$$AmountSubtract:#MyVchAmount4:#MyVchAmount5
Style : If $$InPrintMode then "Normal" Else "Normal Bold"
; Format : "DrCr,NoZero," + ##ShowForex
Width : @@AmountWidth
;Border : Thin Left

 

@Ganesh01 see this code



[#Form : Normal Day Book]

Add : Bottom Part : TFGTDetails

[Part : TFGTDetails]

Line : TFGTDetailsTL,TFGTDetails
Repeat : TFGTDetails : MyBANKCASHColl
Scroll : Vertical
Height : 25 % Page

[Line : TFGTDetailsTL]

Field : Simple Field
Local : Field : Simple Field : Set As : "Cash and Bank Details and on " + $$String:##SVCurrentDate
Border : Thin Bottom

[Line : TFGTDetails]

Field : TFGTDetails
Right Field : TFGTAMTDR,TFGTAMTCR

[Field : TFGTDetails]

Use : Name Field
Set As : $Name

[Field : TFGTAMTDR]

Use : Amount Field
Set As : IF $$IsDr:$ClosingBalance then $ClosingBalance Else ""

[Field : TFGTAMTCR]

Use : Amount Field
Set As : If Not $$IsDr:$ClosingBalance then $ClosingBalance Else ""


[Collection : MyBANKCASHColl]

Collection : MYBankLedColl
Collection : MyCashLedColl

[Collection : MYBankLedColl]

Type : Ledger
Child of : $$GroupBank
Belongsto : yes
Fetch : Name ,ClosingBalance

[Collection : MyCashLedColl]

Type : Ledger
Child of : $$GroupCash
Belongsto : yes
Fetch : Name ,ClosingBalance

 

Post Screenshot Please.

 

@Jay sir please load this code in your tally and then open your daybook and see bottom side will show daybook with cash and bank balance also.

SEE THIS SCREENSHOT ​

​

 

Be happy and keep others happy too.

 

Sir,
See my uploaded screenshot....It's not a closing balance....It is a Cash running balance...

 

did u got the solution.if yes please share

 

[#Form : Normal Day Book]

Add : Bottom Part : TFGTDetails

[Part : TFGTDetails]
Line : TFGTDetailsTL,TFGTDetails1,TFGTDetails
Repeat : TFGTDetails : MyBANKCASHColl
Scroll : Vertical
Height : 10 ;;25 % Page

[Line : TFGTDetailsTL]
Field : Simple Field
Local : Field : Simple Field : Set as : "Cash, Bank and Loans Details and on " + $$String:##SVCurrentDate + " " + " (" + $$String:##SVFromDate + " " + "Cash Opening Balance : " + " " ;;+ if NOT ##DSPWithOpening then 0 else if $$ParentPeriodFrom < @@DSPFromDate then $$FromValue:$$ParentPeriodFrom:$$ToValue@DSPFromDateLessOne:$ClosingBalance else $OpeningBalance
Border : Thin Bottom


[Line:TFGTDetails1]
Use : TFGTDetails
Border : Column Titles
Local : Field : Default : Type : String
Local : Field : Default : Align : Center
Local : Field : Default : Border : Thin Box ;;Thin Left
Local : Field : Default : Style : Large
Local : Field : TFGTHeadSno : Set as : "S.No."
;;Local : Field : TFGTHeadSno : Border : Thin Left Right
Local : Field : TFGTDetails : Set as : "Name of the Income"
Local : Field : TFGTHeadOpeningBalance : Align : Center
Local : Field : TFGTAMTOP : Set as : "OpeningBalance"
Local : Field : TFGTAMTDR : Set as : "Closing Balance Dr"
Local : Field : TFGTAMTCR : Set as : "Closing Balance Cr"

[Line : TFGTDetails]

Field : TFGTHeadSno,TFGTDetails,TFGTAMTOP,TFGTAMTDR,TFGTAMTCR
;;Right Field : TFGTAMTDR,TFGTAMTCR

[Field : TFGTHeadSno]
Use : Number Field
Set As : $$Line
Align : Centre
width : 15 MM
Border : Thin Box

[Field : TFGTDetails]
Use : Name Field
Set As :$Name
Border : Thin Box
Format : "DrCr, No Zero"


[Field : TFGTAMTOP]
Use:Amount Field
set as : if NOT ##DSPWithOpening then 0 else if $$ParentPeriodFrom < @@DSPFromDate then $$FromValue:$$ParentPeriodFrom:$$ToValue@DSPFromDateLessOne:$ClosingBalance else $OpeningBalance
;;Format : "Dr,Cr"
Border : Thin Box
Format : "DrCr, No Zero"


[Field : TFGTAMTDR]

Use : Amount Field
Set As : IF $$IsDr:$ClosingBalance then $ClosingBalance Else ""
Border : Thin Box
Format : "Dr,Cr"


[Field : TFGTAMTCR]

Use : Amount Field
set as : $$IsCashLedger:$LedgerName AND $$IsDr:$Amount
Set As : If Not $$IsDr:$ClosingBalance then $ClosingBalance Else ""
Border : Thin Box
Format : "Dr,Cr"


[Collection : MyBANKCASHColl]

Collection : MYBankLedColl
Collection : MyCashLedColl

[Collection : MYBankLedColl]

Type : Ledger
Child of : $$GroupBank
Belongsto : yes
;;Fetch : ClosingBalance, Name ,
Sort : Default : $ClosingBalance, $Name

[Collection : MyCashLedColl]

Type : Ledger
Child of : $$GroupCash
BelongstoGroupCash : yes
Filter : ClosingStatusFilter, NonEmptyClosingBalance
Sort : Default : $ClosingBalance, $Name
;[System : Formula]
; only_OpBal : $OpeningBalance:Ledger:$Name