John, I ordered_by rosca, removed the search id and the list is more refined!! I will forward the data to the accounts department for feedback. Thank you so much for the support.
Polly On 31/01/2011, Polly <[email protected]> wrote: > 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 > -- 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
