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