John, Thank you for your response. I was out of the office from Jan 21st - 28th. To answer your question, yes for every entry in the collection sheet we assign a receipt id. So when I ran this script I the receipt id repeats itself but with a unique search id. I am looking for a scenerio where the receipt id appears only one (one instance)
Polly On 20/01/2011, John Woodlock <[email protected]> wrote: > Polly, > > So your situation is that for a particular collection sheet entry one > receipt id is created? > you can probably do the following > > *SELECT distinctrow c.BRANCH_ID, c.SEARCH_ID,ap.PAYMENT_TYPE_ID, > ap.RECEIPT_NUMBER,** > **ap.RECEIPT_DATE, rosc.display_name as Rosca * > > > depending on your context the sql 'group by ' clause might be applicable. > > John > > > > On Thu, Jan 20, 2011 at 8:17 PM, Polly <[email protected]> wrote: > >> Hi, >> >> Am not a guru in coming up with this statements but the one I made is >> generating so many repetitions >> * >> * >> *SELECT c.BRANCH_ID, c.SEARCH_ID,ap.PAYMENT_TYPE_ID, ap.RECEIPT_NUMBER,** >> **ap.RECEIPT_DATE, rosc.display_name as Rosca FROM customer c** >> **join account acc on acc.customer_id = c.customer_id** >> **left outer join customer as git on git.customer_id=c.parent_customer_id* >> * >> **left outer join customer as rosc on >> rosc.customer_id=git.parent_customer_id** >> **join account_payment ap on ap.account_id = acc.account_id where >> payment_date** >> **between '2011-01-17' and '2011-01-18';* >> >> The unique field in this is the search_id, the receipt ID and the >> receipt_date are repeated. In my head am thinking if there is a way I can >> tag each use of the collection sheet which will display one instance of >> the >> receipt_id and the receipt_date. >> >> Polly >> >> >> On 20 January 2011 10:22, Polly <[email protected]> wrote: >> >>> John, >>> >>> Thank you so much for your help. >>> >>> Polly >>> >>> On 14 January 2011 14:04, John Woodlock <[email protected]> wrote: >>> >>>> Hi Polly, >>>> >>>> If I've understood what you are doing the following such get the info: >>>> 1st you go thru customer table with the branch_id and search_id of the >>>> center to pick up all customers under the center as per usual and from >>>> customer to account and then account to account_payment which has the >>>> column >>>> you want :receipt id and date and the payment_type_id that is used to >>>> link >>>> the the 'mode of payment' you are re-using >>>> >>>> John >>>> >>>> On Fri, Jan 14, 2011 at 8:24 PM, Polly <[email protected]> wrote: >>>> >>>>> Hi, >>>>> >>>>> We have figured that since we use the "mode of payment feature as a >>>>> formality" since the mode is normally posted as cash. What we have in >>>>> mind >>>>> is that from the collection sheet dashboard, The drop down menu will >>>>> have a >>>>> list of 3 banks instead of the mode of payment (cash, cheque, voucher). >>>>> Then >>>>> in the Receipt ID feature we will post the total amount on the banking >>>>> slip >>>>> and for the Receipt ID we post the date of banking on the slip. i.e. >>>>> >>>>> Branch Office: *Kajiado* >>>>> Loan Officer: *Juma Abdi* >>>>> Center: *Tega Self Help Group* >>>>> Date of Transaction: *11 - 01 - 2011* >>>>> Mode of Payment (Name of Bank): Select '*Kenya Commercial Bank*' >>>>> Receipt ID(Total in Ksh:): *45,415* >>>>> Receipt Date (Banking Date): *12 - 01 - 2011* >>>>> >>>>> >>>>> In which tables will I extract this data? >>>>> >>>>> Polly >>>>> >>>>> >>>>> On 6 December 2010 23:24, Ryan Whitney >>>>> <[email protected]>wrote: >>>>> >>>>>> Polly, >>>>>> >>>>>> Something you might try (and I would test this heavily first) is >>>>>> making >>>>>> four different collection sheet payments. For example >>>>>> >>>>>> Open CSE and enter in first receipt, then zero out all accounts that >>>>>> weren’t deposited with that receipt. >>>>>> Repeat with 2nd receipt (clients already paid on the previous entry >>>>>> will show up as zero). >>>>>> Repeat with 3rd and 4th. >>>>>> >>>>>> This might get you over the hump until a feature can be created. >>>>>> >>>>>> Ryan >>>>>> >>>>>> >>>>>> >>>>>> On 11/4/10 4:39 PM, "Polly" <[email protected]> wrote: >>>>>> >>>>>> Hi Kay, >>>>>> >>>>>> We want all the payments posted in that collection sheet to be tagged >>>>>> with different banks. >>>>>> I will log an improvement for it. A scenerio is where a group has loan >>>>>> repayments of Ksh: 41000 and Ksh: 15890 savings but the amounts have >>>>>> been >>>>>> banked in different banks but we have it consolidated in the >>>>>> Collection >>>>>> Sheet, so we need to tag this payments to all the banks. Currently we >>>>>> are >>>>>> working with 4 banks only that is why we put the limit to 4. >>>>>> >>>>>> Polly. >>>>>> >>>>>> On 28 October 2010 18:48, Kay Chau <[email protected]> >>>>>> wrote: >>>>>> >>>>>> Hi Polly, do you need to track where each individual payment was from >>>>>> in Collection Sheet Entry, or do you want all payments in that >>>>>> collection >>>>>> sheet to be “tagged” with all 4 different banks? >>>>>> >>>>>> Just trying to understand your scenario, this is not possible in >>>>>> Mifos, >>>>>> but it would be good to log an Improvement in Jira for it. Was trying >>>>>> to >>>>>> find one I thought already existed but couldn’t find it. >>>>>> >>>>>> Thanks >>>>>> Kay >>>>>> >>>>>> >>>>>> *From:* Polly >>>>>> [mailto:[email protected]<[email protected]>] >>>>>> >>>>>> *Sent:* Wednesday, October 27, 2010 10:52 PM >>>>>> *To:* A good place to start for users or folks new to Mifos.; >>>>>> [email protected]; Mwangangi Manuel Muingi >>>>>> *Subject:* [Mifos-users] Collection Sheet >>>>>> >>>>>> >>>>>> Hi, >>>>>> >>>>>> On the collection sheet dashboard, we use the Receipt ID and Receipt >>>>>> date to post information bank details >>>>>> >>>>>> e.g. Receipt ID : Name of Bank >>>>>> Receipt Date: Date of Banking >>>>>> >>>>>> Now this works well where the group banks all the money for the >>>>>> meeting >>>>>> date in one bank. But we have very many scenerios where money is >>>>>> banked in >>>>>> different Banks. We want to track all this banking transactions and >>>>>> the best >>>>>> way we agreed is increasing the 'control boxes' to post information >>>>>> from all >>>>>> possible banks: >>>>>> >>>>>> Receipt ID : Name of Bank 1 >>>>>> Receipt Date: Date of Banking >>>>>> >>>>>> Receipt ID : Name of Bank 2 >>>>>> Receipt Date: Date of Banking >>>>>> >>>>>> Receipt ID : Name of Bank 3 >>>>>> Receipt Date: Date of Banking >>>>>> >>>>>> Receipt ID : Name of Bank 4 >>>>>> Receipt Date: Date of Banking >>>>>> >>>>>> How feasible is it to have this option on the collection sheet >>>>>> dashboard? We are using Mifos v 1.3. >>>>>> >>>>>> Polly >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> Nokia and AT&T present the 2010 Calling All Innovators-North America >>>>>> contest >>>>>> Create new apps & games for the Nokia N8 for consumers in U.S. and >>>>>> Canada >>>>>> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in >>>>>> marketing >>>>>> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi >>>>>> Store >>>>>> http://p.sf.net/sfu/nokia-dev2dev >>>>>> _______________________________________________ >>>>>> Mifos-users mailing list >>>>>> [email protected] >>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> *Ryan Whitney ** >>>>>> **Mifos Technical Program Manager >>>>>> **[email protected]* >>>>>> Mifos® - Technology that Empowers Microfinance (www.mifos.org) >>>>>> *Our mission is to enable the poor, especially the poorest, to create >>>>>> a world without poverty. >>>>>> <**http://grameenfoundation.org/take-action/ingenuity-fund-challenge/* >>>>>> > >>>>>> P please consider the environment before printing this e-mail. >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> What happens now with your Lotus Notes apps - do you make another >>>>>> costly >>>>>> upgrade, or settle for being marooned without product support? Time to >>>>>> move >>>>>> off Lotus Notes and onto the cloud with Force.com, apps are easier to >>>>>> build, >>>>>> use, and manage than apps on traditional platforms. Sign up for the >>>>>> Lotus >>>>>> Notes Migration Kit to learn more. http://p.sf.net/sfu/salesforce-d2d >>>>>> >>>>>> _______________________________________________ >>>>>> Mifos-users mailing list >>>>>> [email protected] >>>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Best Regards >>>>> Polly Najori >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Protect Your Site and Customers from Malware Attacks >>>>> Learn about various malware tactics and how to avoid them. Understand >>>>> malware threats, the impact they can have on your business, and how you >>>>> can protect your company and customers by using code signing. >>>>> http://p.sf.net/sfu/oracle-sfdevnl >>>>> >>>>> _______________________________________________ >>>>> Mifos-users mailing list >>>>> [email protected] >>>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>>> >>>>> >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Protect Your Site and Customers from Malware Attacks >>>> Learn about various malware tactics and how to avoid them. Understand >>>> malware threats, the impact they can have on your business, and how you >>>> can protect your company and customers by using code signing. >>>> http://p.sf.net/sfu/oracle-sfdevnl >>>> _______________________________________________ >>>> Mifos-users mailing list >>>> [email protected] >>>> https://lists.sourceforge.net/lists/listinfo/mifos-users >>>> >>>> >>> >>> >>> -- >>> Best Regards >>> Polly Najori >>> >>> >> >> >> -- >> Best Regards >> Polly Najori >> >> >> >> ------------------------------------------------------------------------------ >> Protect Your Site and Customers from Malware Attacks >> Learn about various malware tactics and how to avoid them. Understand >> malware threats, the impact they can have on your business, and how you >> can protect your company and customers by using code signing. >> http://p.sf.net/sfu/oracle-sfdevnl >> _______________________________________________ >> Mifos-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/mifos-users >> >> > -- Best Regards Polly Najori ------------------------------------------------------------------------------ Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)! Finally, a world-class log management solution at an even better price-free! Download using promo code Free_Logger_4_Dev2Dev. Offer expires February 28th, so secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsight-sfd2d _______________________________________________ Mifos-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mifos-users
