@al3xicon no, but if you end up getting this, please share!

will do, but i don't have high hopes. SuiteAnswers mentions starting from the Bill record and referring to the Bill Payment from there (via Applying Transaction join), but to me this doesn't allow for partial bill payments. need to test more...

Alex, maybe hit me up on jabber, I don't remember how I did it, but I definitely have

will do! that gives me hope, might not be til tomorrow though, couple of other things to wrap up today...

I remembered how I did this - you start from the payments - but you filter on Main line is FALSE. From there it's one of the payment/applied to joins (I just added all 4 while looking to see which one it was) This handles your partial payments. The only thing it can't do- is show which expense accounts were involved, so you can't show the 1099 impact this way.

@KevinJ of Kansas yes that allows you to show the line amount but what about the discount amount?

Oh. I think I did a case statement to include discount amount and turned off my mainline filter

hmm ok, i didn't have luck with that approach but maybe i'll try again

I know I got it to work, just a matter of putting enough time in to replicate it.