Received Amt Column in Sales Register

hello adeshwar mehta ji

maine aapki prblem solve ki hai isi plateform ki help se.
1) pending amount total
2) remove if

plese chek




;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
[#Menu : Gateway of Tally]
Add : Item : Sales Report : DISPLAY : Sales Report

[Report : SalesReport]
Form : SalesReport
Set : variable : svfromdate, svtodate
Set : SVFromDate : ##SVToDate
Set : SVToDate : ##SVCurrentDate


[Form : SalesReport]
Part : ASTPURTitle,ASTPURDtls
Bottom Part : ASTTotal
Height : 100% Screen
use : DSP Template


[Part : ASTPURTitle]

Line : ASTPURTL1,ASTPURTL2

[Line : ASTPURTL1]

Field : ASTPURTL1

[Field : ASTPURTL1]
Set as : @@cmpmailname
Full Width : Yes
Align : Centre
Style : Large Bold
Skip : Yes

[Line : ASTPURTL2]
Field : ASTPURTL2
Right Field : AStPeriod
; Border : Column Titles

[Field : ASTPURTL2]
use : Name Field
Set as : "Sales Register"
Fullwidth : Yes
Align : Centre
Skip : Yes
[Field : Astperiod]
Set as : "From "+$$String:##svfromdate+" To "+$$String:##svtodate
Skip : Yes


[Part : ASTPURDtls]

Line : saleTitles,salesdtls
Repeat : salesdtls : Salescoll
Total : Invamt
Total : CollectedAmountInfo
Scroll : Vertical

[Line : Saletitles]

Field :hksn, Invno, invdt,Party,Invamt,CollectedAmountInfo
Local : Field : hksn : Info: "S.No."
Local : Field : Party : Set as: "Buyer Name"
Local : Field : invdt : Set as :"Inv Dt"
Local : Field : Invno : Set as :"Invno."
Local : Field : Invamt : type : String
Local : Field : Invamt : Set as : "Inv.Amt"
Local : Field : CollectedAmountInfo : Type : String
Local : Field : CollectedAmountInfo : Set as : "Pending Amount"
Border : Column Titles


[Line : salesdtls]

Field : hksn,invno,invdt,Party, Invamt,CollectedAmountInfo
Option : AlterOnEnter
remove if : $$IsEmpty:#CollectedAmountInfo


[Field:hksn]
Use:Number Field
Set as:$$Line
Style:normal

[Field : Party]
use : Name Field
set as : $PartyLedgername
Width : 30% Screen

[Field : InvNO]
use : Name Field
Set as : $Vouchernumber
Width : 15% Screen

[Field : Invdt]
Set as : $Date
Width : 15% Screen

[Field : Invamt]
use : Amount Field
Set as : $Amount
Width : 15% Screen

[Field: CollectedAmountInfo]
Use : Amount Field
Align : Right
Width : 15% Screen
Style : large bold
Set as: $PendingAmount
Set always : Yes
Skip : Yes
Background:Grey

[Part : ASTTotal]

Line : Asttotal

[Line : Asttotal]

Field : hksn,Invno,invdt,party, Invamt,CollectedAmountInfo
Local : Field : hksn : Info: ""
Local : Field : Party : Set as: "Total..."
Local : Field : Cstno : Set as : ""
Local : Field : invdt : Set as :""
Local : Field : Invno : Set as :""
Local : Field : Invamt : Set as : $$Total:Invamt
Local : Field : goods : type : String
Local :Field : goods : Set as :""
Local : Field : CollectedAmountInfo : Set as : $$Total:CollectedAmountInfo
Border : Column Titles


[Collection:CollForBills]

Type: Bills
Compute : VoucherNumber : $$CollectionField:$VoucherNumber:1:LedgerEntries


[Collection: MycollforCollection]

Source Collection : CollForBills
Fetch : ClosingBalance, VoucherNumber
Compute : LedgerName : $$CollectionField:$LedgerName:1:LedgerEntries
Search Key : $VoucherNumber


[Collection : Salescoll]

Type : voucher
Filter : IsSale
Fetch : Vouchernumber,PartyLedgername,Amount,Buyerscstnumber,Date
Compute : qty:$$CollQtyTotal:Inventoryentries:$BilledQty
Compute : PendingAmount:$$ReportObject:$$CollectionFieldByKey:$ClosingBalance:$VoucherNumber:MycollforCollection


[Collection : SalesColldtl]

Source Collection : Salescoll
Walk : Inventoryentries
By : Vouchernumber: $Vouchernumber
Fetch : Vouchernumber,PartyLedgername,Amount,Buyerscstnumber,Date,Amount

;,Stockitemname

[System : Formula]
Issale : $$IsSales:$vouchertypename
ChkParty : $PartyLedgername = ##Newchangecoll


;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;

 

dear experts
mai tdl me naya member hu
is plateform ki help se thoda bahut kuch seekha hai.

mujhe

dear members
i m new in tdl
maine isi plateform se thoda bahut seekha hai.

mai sale report me pending amount ka coloum nahi balki
explode karne per particular bill ke receipt voucher ki detail show karana chahta hu

ye kaise hoga please help,

exxample

Gatway of tally
display
statement of accounts
outstanding
ledger

then f12

range of bills to show = all bills

then alt + f1


is tarah