Family Pledge by Fiscal Year report about crm HOT 3 OPEN

** Update **

First of all, I am not a coder. I have spent enough years looking at PHP and SQL to be able to sort through (mostly) what data is being looked for and where it's supposed to find it. With that caveat …

I went back and looked at the pledge_plg table, and compared it against the query in the query_qry table.

The query_qry table has the following SQL, in qry_SQL, regarding the "Family Pledge by Fiscal Year" report:

SELECT fam_Name, fam_Envelope, b.fun_Name as Fund_Name, a.plg_amount as Pledge from family_fam left join pledge_plg a on a.plg_famID = fam_ID and a.plg_FYID=fyid and a.plg_PledgeOrPayment='Pledge' and a.plg_amount>0 join donationfund_fun b on b.fun_ID = a.plg_fundID order by fam_Name, a.plg_fundID

The a.plg_FYID=fyid is pulling information from the pledge_plg table, in the plg_FYID field. If I set the "Fiscal Year" in the deposit slip to "2023", it should pull "27" from the gpo_grp_ID field, which it does. The a.plg_PledgeOrPayment field is looking for a value of "Pledge".

I went in and looked at my table information in "pledge_plg". In the deposits, I set the "Fiscal Year" for 2023, which had an option/ID value of "27". Fine so far. However, every entry in the "plg_PledgeOrPayment" field is listed as "Payment", even if the money was credited in the "Fund Split" section under "Pledges".

In looking at DepositSlipEditor.php, there doesn't appear to be a point where a deposit can be credited as "Pledge" versus "Payment", so I'm not sure what's missing. But that would explain why I don't get anything back in the report.

I may have this all wrong, and if so, and I need to make other changes, I'd appreciate getting pointed in the right direction.

from crm.

Well, maybe I'm not so smart after all. I manually changed the information in the "pledge_plg" table to reflect "Pledge" instead of "Payment". No joy on the report.

from crm.

This issue is stale because it has been open 30 days with no activity. Remove stale label or comment or this will be closed in 5 days.

from crm.