When the Income By Payment Method report is run with "Detail all payment methods" set to "No" it still displays On Account payment methods separately, not as a part of "others", which is what I'd expected. I've looked at the SQL and it looks like the criteria for "others" is just act_type is null, which is true for On Account payment methods. So I'm not sure why they're not getting lumped in there.
I saw another post that said the report by design lumps into "others" all but credit card and debit account payment methods. The notes in the report say it's combining all payment methods that aren't amex/visa/mc. Looking at the SQL for the report, I'm not seeing how the On Account methods, which do have null act_type stay separated out. Can anyone point me at what I'm missing?
act_type has been assigned to -1 instead of keeping null.
in tr_payment_method table on_account has a pmt_type=2
this is what you were missing.
have fun.
:-):-):-)
in [AP_INCOME_BY_PMT_METHOD_2]
from line 193 to 203:
bu
,
desig
act_type
99
account_type
posted_to_GL
),
y
posted_dt
From
)
id
sequence_no