Gayl,
The GL report does not depend on the batch jobs. That shouldn't be the
issue. Double check that you have entered transactions for the branch in
question between your selected dates, and that you are entering the dates in
correctly.
Also, you can try running the query directly against your database to double
check as well:
SELECT financial_trxn.posted_date,
gl_code.glcode_value,
SUM(IF(debit_credit_flag = 0, ABS(posted_amount), 0.000)) AS debit,
SUM(IF(debit_credit_flag = 1, ABS(posted_amount),0.000)) AS credit
FROM financial_trxn
INNER JOIN gl_code USING (glcode_id)
INNER JOIN account_trxn ON account_trxn.account_trxn_id =
financial_trxn.account_trxn_id
INNER JOIN account ON account.account_id = account_trxn.account_id
WHERE account.OFFICE_ID = ?
AND financial_trxn.posted_date >= ?
AND financial_trxn.posted_date <= ?
GROUP BY posted_date, glcode_value
ORDER BY posted_date, glcode_value
This appears to run fine on demo.mifos.org.
Ryan
On 9/6/10 20:08, "Gayl Kennedy" <[email protected]> wrote:
> Hi Jeff
> thanks for the new version. The fix to the GL report is now allowing
> us to select branch and date but no data is showing so need to check
> batch jobs etc.
>
> We still have the issue with the branch progress report originally
> referenced on this thread.
> Regards
> Gayl
>
>
>
> On 06/09/2010, Jeff Brewster <[email protected]> wrote:
>>> Hi Jeff,
>>>
>>> If I use your modified GL report, it works !! :-)
>>>
>>
>> Good to know Binny. Are you having any issues with the other reports at
>> this point?
>>
>> Jeff
>>
>>
>>
----------------------------------------------------------------------------->>
-
>> This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> 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.
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
Mifos-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-users
