[jsutton Contributions: 0Level 1☆]

Hello,

I’m been pulling my hair out for months and really struggling with this one: I simply want to create a report or a saved search for the balance sheet detail of accrued expenses – grouped by vendor. The problem is, the balance is created by entering a journal entry (which I’ve found is the entity(line) field). Then the bills or checks that post against those journal entries, that is name field on those transactions is just entity. The system can’t seem to marry the two…has anyone else had this problem?
This is a cached copy. Click here to see the original post.

[michoel Contributions: 0Level 1☆]

I haven’t tested this, but you may be able to get it to work by grouping on a Formula field, something like –

Code:
CASE WHEN {type} = ‘Journal’ THEN {name} ELSE {​mainname} END

[Author]

Posts