I can't get the receipt amount total right I have used the following code but cant fetch the collection totals just like the sales totals. Experts please tell me what I am doing wrong here. The sales amount total worked but receipt does not. Code: [Field:RprtReceipt] Use : Amount Field Set as : $$CollAmtTotal:RcptSumcoll:$Amount ;$$FilterAmtTotal:RcptSumcoll:ReceiptAmountfilter:$Amount ; Format : "DrCr,NoZero," + ##ShowForex Space Right : 2 mms [Collection: RcptSumcoll] Source Collection : Rcptcoll Walk : Inventory entries By : PartyLedgerName : $PartyLedgerName By : vouchernumber : $vouchernumber Aggr Compute : Amount : sum : $Amount ; Aggr Compute : RecAmtTotal : Add : $Amount Search Key : $PartyLedgerName + $vouchernumber [Collection: Rcptcoll] Type : Vouchers Child Of: $$VchTypeReceipt Fetch: PartyLedgerName ,vouchernumber, Amount
Tried this as well but unique amount totals from collection not picking. I tried this Code: Set as :$$CollectionField:$Amount:1:RcptSumcoll Then this Code: Set as :$$CollAmtTotal:RcptSumcoll:($$CollectionField:$Amount:1:RcptSumcoll) but the result is not as expected.
What is the main Collection that you are using in REPEAT at BODY part level ???? The compute is not done in the main collection.......... U should try this......... [System : Formula] myRcptSum : $$CollAmtTotal:RcptSumcoll:$Amount Then in your main Collection......... Compute : myRcptSum : $myRcptSum
Tried the same at part level collection the result is same as the first post. Code: [Collection:AgentNameListColl] Type : AgentDB : Company Childof : ##SVCurrentCompany Fetch : AgentDB,AgentTypeList,AgentNameList Filter : NamelistFormula Compute: rcptsumamt : $myRcptSum [System:Formula] myRcptSum : $$CollAmtTotal:RcptSumcoll:$Amount
Hello Amit Sir , thank you very much for helping me . I solved it by computing the exploding receipt values in the collection Agntreprt Voucher instead of directly accessing them with $$collectionfieldbykey.
Sir I solved this but now another problem arose. The credit Note column theorotically should not display any amounts as no credit note has been issued, But it is displaying amounts which are same as receipt amounts. The collections are and search key both are different, what might have caused this?
[Collection: CredSumcoll] Aggr Compute : Amount : Sum : If @@CreditAmountFilter Then $Amount Else 0 Put similar in RECEIPTS too.....
Sir the amounts are not displaying after doing this. tried different variations of filtering values like this. Still not working.
I solved this problem, thank you very much for helping. can you guide me on why the credit note totals are duplicated ?
[Collection: CredSumcoll] Aggr Compute : CrNtAmount : Sum : If @@CreditAmountFilter Then $Amount Else 0
You You are struggling because you are not willing to share full code. Two heads are better than one. Share full code so other members can help you