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
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"