where i have gone wrong ?

dear expert

plz let me know where i have gone wrong in fetching the value from voucher to ledger

my code is as follows;
;;;;jai ganeshaya namaha
[#Line: ACLSTitle]
Add:Right Field:Before:VCH DebitTitle:cash,cheq
[Field:cash]
Use:name field
Set as:"CASH "
Border:column titles
Color:blue
[Field:cheq]
Use:name field
Set as:"CHEQ"
Border:column titles
Color:blue
[#Line: ACLSInfo]
Add:Right Field:Before:ACLSAmt:CASH1,CHEQ1

[Field:CASH1]
Use:AMOUNT FIELD
Storage: CASH1
Color:BLUE
Set Always: Yes
Space Right:17
Width: 5

[Field:CHEQ1]
Use:AMOUNT FIELD
Storage:CHEQ1
Color:BLUE
Set Always:Yes
Space Right: 20
Width: 5

[System:UDF]
CASH1:Amount:896
CHEQ1:Amount:897

;;;;;============================= CREATION OF UDF TITLES IN LEDGER======
[#Line: DSP VchAccTitles]
USE:LINE: VCHDETAIL
Add:Right Field:BeforeSP VchTypeTitle:CASH2,CHEQ2
[Field:CASH2]
Use:name field
Set as:"CASH"
Skip:Yes
Color:blue
[Field:CHEQ2]
Use:name field
Set as:"CHEQ"
Skip:Yes
Color:blue
[#LineSP VchDetail]
Add:Right Field:BeforeSP VchType:CASH3,CHEQ3
[Field:CASH3]
Use:AMOUNT field
Set as:$CASH1
Color:BLUE
[Field:CHEQ3]
Use:AMOUNT field
Set as: $CHEQ1
Color:BLUE
[#Collection : Vouchers of Ledger]
Fetch:CASH1,CHEQ1

 

I am not 100% Sure But If I will do this then I will follow this steps

Step 1: Create a Collection Which Contains All Vouchers

Example:

[Collection: MySalesVouchersColl]
Type:Vouchers:VoucherType
Child Of:$$VchTypeSales
Belongs To:Yes

Step 2: Walk In Collection and Fetch Required Values

[Collection:Sales AllVoucher]
Source Collection: MySalesVouchersColl
Walk:Inventory Entries
Compute : MyInventoryCash :$MyUDF
Compute : MyInventoryCheque:$MyUDF2

Step 3: Use Computer Value in Field

Example:

[Field: MyField]
Set as: $MyInventoryCash

[Field: MyField2]
Set as: $MyInventoryCheque


Hope This Helps

 

If You want to fetch total Cash Or Cheque Value only from that particular voucher then You can use By and Aggre Compute attributes
Too

 

sir
i could get the total value from the voucher as displayed in the attachment but partywise amount is not being fetched to respective party ledger
eg: received from abc 2/- (1/- in cash and 1/- in cheque) and in the same way received from badri 25/- (13/- cash and 12/- cheque)
but in any ledger the total of 2/- and 25/- is being displayed in both ledgers

hence plz tell me how to filter party wise voucher amount to be fetched to the respective ledger

 

my code is
[#LineSP VchDetail]
Add:Right Field:BeforeSP VchType:CASH3,CHEQ3
[Field:CASH3]
Use:AMOUNT field
Set as:$mymode
Color: Blue
Style: Normal
Space Right:15
[Field:Cheq3]
Use:AMOUNT field
Set as:$mymode1
Color: Blue
Style: Normal
Space Right: 15
[#Collection : Vouchers of Ledger]

Compute : mymode : $$CollAmtTotal:LedgerEntries:$cash1
Compute : mymode1 :$$CollAmtTotal:LedgerEntries:$cheq1

 

Sir Study By, Aggre Compute, Walk Attributes and My explanation which I give earlier

 

After that If you are unable to achieve it Tell me I will try to give a detailed explanation with Codes

 

I am little busy with my studies ( IIT Aspirant ) that is why Maybe I will reply you little late but I will reply you For sure

 

thank you sir and all the best for your studies and sorry for the late reply, i do my best try to apply "by and agree and walk attribute"