Previous Balance in Invoice

what is code for showing the previous balance in invoice printing ?

& also pl tell what is code for Ledger View at Voucher Entry ?

 

but how set in sales invoice printing?

 

[Field : TMFldBal]

Use : Amount Forex Field
Storage : TMFldBal
Set AS : If $$IsEmpty:$$Value Then $ClosingBalance:Ledger:$PartyLedgerName Else $$Value

[System : UDF]
TMFldBal : Amount : 21000

;;Comprehensive Invoice

[#Part: EXPINV EOE]
Add : Line :After : EXPINV EOE : EXPINVBalance

[Line : EXPINVBalance]
Right Field : EXPINVBalance

[Field :EXPINVBalance]

Use : Name Field
Set As : "Closing Balance : " + $$StringABC
ABC:$$ToValue:$Date:$ClosingBalance:Ledger:$PartyLedgerName

 

[#Part: EXPSMP EOE]
Option : EXPSMP EOE Prev : @@EnPrevBalLeft And Not @@EnPrevBalRight


[!Part:EXPSMP EOE Prev]
Add : Part : At End : EXPSMP PrevBal
Vertical : Yes

[Part : EXPSMP PrevBal]
Line : EXPSMP PrevBal,EXPSMP BillAmt, EXPSMP NetBal
Width : 30 % Screen
Invisible : ##HidePrevBalVar

[Line : EXPSMP PrevBal]
Field : Short Prompt, EXPSMP PrevBal
Local : Field : Short prompt : Set as : "Prev.Balance"
Invisible : $$IsGroupCash:$Parent:Ledger:$PartyLedgerName

[Field : EXPSMP PrevBal]
Use : Amount Field
Set as : $$AsDrAmt:#EXPSMPNetBal - #EXPSMPBillAmt
Format : "DrCr"
Style : Small Bold


[Line : EXPSMP BillAmt]
Field : Short Prompt, EXPSMP BillAmt
Local : Field : Short prompt : Set as : "Bill Amt."
Invisible : $$IsGroupCash:$Parent:Ledger:$PartyLedgerName

[Field : EXPSMP BillAmt]
Use : Amount Field
Set as : $Amount
Border : Thin Bottom
Format : "DrCr"
Style : Small Bold

[Line : EXPSMP NetBal]
Field : Short Prompt, EXPSMP NetBal
Local : Field : Short prompt : Set as : "Net Balance"
Space Bottom : 3 mms
Invisible : $$IsGroupCash:$Parent:Ledger:$PartyLedgerName


[Field : EXPSMP NetBal]
Use : Amount Field
Set as : $$AsDrAmt:$$ToValue:$Date:$ClosingBalance:Ledger:$PartyLedgerName
Border : Thin Bottom
Format : "DrCr"
Style : Small Bold


[#Part: EXPINV LeftSign]
Option : EXPSMP EOE Prev : @@EnPrevBalLeft And Not @@EnPrevBalRight

[#Part: EXPINV Words]
Option : EXPSMP EOE PrevRight : @@EnPrevBalRight And Not @@EnPrevBalLeft And ##SASimple

[!Part:EXPSMP EOE PrevRight]
Add:Line :After : EXPINV AmtInWords: EXPSMP PrevBalRight,EXPSMP BillAmtRight, EXPSMP NetBalRight


[Part : EXPSMP PrevBalRight]
Line : EXPSMP PrevBalRight,EXPSMP BillAmtRight, EXPSMP NetBalRight
;;Width : 50 % Page
Space Top : 0.25
Invisible : ##HidePrevBalVar

[Line : EXPSMP PrevBalRight]
Right Field : Short Prompt, EXPSMP PrevBalRight
Local : Field : Short prompt : Set as : "Prev.Balance"
Invisible : $$IsGroupCash:$Parent:Ledger:$PartyLedgerName

[Field : EXPSMP PrevBalRight]
Use : Amount Field
Set as : $$AsDrAmt:#EXPSMPNetBalRight - #EXPSMPBillAmtRight
Format : "DrCr"
Style : Small Bold


[Line : EXPSMP BillAmtRight]
Right Field : Short Prompt, EXPSMP BillAmtRight
Local : Field : Short prompt : Set as : "Bill Amt."
Invisible : $$IsGroupCash:$Parent:Ledger:$PartyLedgerName

[Field : EXPSMP BillAmtRight]
Use : Amount Field
Set as : $Amount
Border : Thin Bottom
Format : "DrCr"
Style : Small Bold

[Line : EXPSMP NetBalRight]
Right Field : Short Prompt, EXPSMP NetBalRight
Local : Field : Short prompt : Set as : "Net Balance"
Space Bottom : 3 mms
Invisible : $$IsGroupCash:$Parent:Ledger:$PartyLedgerName


[Field : EXPSMP NetBalRight]
Use : Amount Field
Set as : $$AsDrAmt:$$ToValue:$Date:$ClosingBalance:Ledger:$PartyLedgerName
Border : Thin Bottom
Format : "DrCr"
Style : Small Bold


[#Part: EXPINV RightSign]
Option : EXPINV RightSign Sales : @@EnPrevBalRight And Not @@EnPrevBalLeft

[!Part:EXPINV RightSign Sales]
Add : Part : After : EXPINV EOE : EXPSMP PrevBalRight

[System : Variable]
HidePrevBalVar : No

[Variable : HidePrevBalVar]
Type : Logical
Default : No

[#Part : IPCFG Left]
Add : Line : At End : HidePrevBal

[Line : HidePrevBal]
Field : Medium Prompt, Logical Field
Local : Field : Medium Prompt : Info : $$LocaleString:"Hide Previous Balance Details ?"
Local : Field : Logical Field : Modifies : HidePrevBalVar
Local : Field : Logical Field : Set as : ##HidePrevBalVar


[System:UDF]
EnPrevBalLeft : Logical : 238
EnPrevBalRight : Logical : 239

[System:Formula]
EnPrevBalLeft : $EnPrevBalLeft:VoucherType:$VoucherTypeName
EnPrevBalRight : $EnPrevBalRight:VoucherType:$VoucherTypeName


[System:formula]
IsInvType : ($$IsSales:$Parent Or $$IsSalesOrder:$Parent Or +
$$IsDelNote:$Parent Or $$IsPurchase:$Parent Or +
$$IsRcptNote:$Parent Or $$IsPurcOrder:$Parent Or +
$$IsDebitNote:$Parent Or $$IsCreditNote:$Parent)

IsJouType : ($$IsCreditNote:$Parent Or $$IsDebitNote:$Parent)


[#Part : VTYP BehaviourMain]
Add : Line : After : VTYP PrintSave : VTYP EnPrevBalLeft, VTYP EnPrevBalRight

[Line : VTYP EnPrevBalLeft]
Fields : Long Prompt, Logical Field
Local : FIeld : Long Prompt : Set as : "Print Previous Balance Left ?"
Local : Field : Long Prompt : Width : @@LongWidth
Local : Field : Default : Inactive : Not @@IsInvType
Local : Field : Logical Field : Storage : EnPrevBalLeft


[Line : VTYP EnPrevBalRight]
Fields : Long Prompt, Logical Field
Local : FIeld : Long Prompt : Set as : "Print Previous Balance Right ?"
Local : Field : Long Prompt : Width : @@LongWidth
Local : Field : Default : Inactive : Not @@IsInvType
Local : Field : Logical Field : Storage : EnPrevBalRight

 

Not working.

 

accounts info ____voucher type ---------- alter -----sales --- print previous balance left " no "
'" "' """ "" "" "" right " yes"

enjoy

 

Thanks.

 

sir can u gave me ur contact no

 

your mail id

 

KHADER.FMSOLUTIONS@GMAIL.COM

 

hello sir this is vinoth I am a new person of tally user

thank u very much

 

sir please provide this code in simpal invoice printing ....

 

Dear all "Is you can help us"

 

Hello sir

Nice Work done.

It is not showing Exact Previous Balance in case of Sales Return.

Thanks

 

Guyz i tried the above tdls but it didnt worked for me . Its my request to make a fresh copy of tdl and send it to me . My ehatsapp no is 8541827625

 

try this bro its working

[*Part: EXPINV Words]
Lines : EXPINV WordTitle , EXPINV AmtInWords,prevbal,Billamt,Closingbal
Space Bottom: 0.25
Option : WithVATValue : (@@IsSales OR @@IsPurchase) AND @@IsIndianVATVch AND @@InvVATAnalysis
Option : WithExciseValue : @@IsSales AND @@IsIndian AND NOT $$IsEmpty:$ExciseRegn:Company:##SVCurrentCompany AND ##ICFGExcisePrinting
Option : WithServiceTaxValue : (@@IsSales OR @@IsPurchase OR @@IsReceipt OR @@IsPayment OR @@IsPurcOrder OR @@IsSalesOrder OR @@IsDebitNote OR @@IsCreditNote) AND @@IsIndianServiceTax AND $$STXCanUpdateDutyLed



[Part:lastbal]
Linerevbal
Line:Billamt
Line:Closingbal1
[Linerevbal]
Fieldsrevbalt,prevbald1
[Line:Billamt]
Fields:Billamtt, Billamtd
[Line:Closingbal]
Field:Closingbalt,Closingbald
[Fieldrevbalt]
Info:"Prev.Balance"
Width:10
[Fieldrevbald1]
Use :Amount Field
Set as$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries)-$$abs:#EXPINVTOTAL
[Field:Billamtt]
Info:"Bill Amount"
Width:10
[Field: Billamtd]
Use:Amount Field
Set as:#EXPINVTotal
[Field:Closingbalt]
Info:"Curr.Balance"
Width:10
[Field:Closingbald]
Use:Amount Field
Info:$$ToValue:$Date:$ClosingBalance:Ledger:$$CollectionField:$LedgerName:1:LedgerEntries

 

Sand me tdl files @ejajpathan@gmial.com

 

thanks bro working

 

Experts need party previous due Bill details in current invoice
Sample below
Invoice no date amount
005 10/04/2017 15032.00
011 15/05/2017 15499.00
027 05/06/2017 25232.00

Need such detail in current invoice at the end


Thanks in advance

 

THANKS SIR JI