Is it possible to get a report or save search of both sides of a transactions when specifying 1 side?
EX: I am trying to get transactions that hit Account#123 but when I run reports it will SPLIT and not show me the other side (which I want to see). I am also not sure how this can be accomplished with a save search since anything I do will filter out the other lines.
d
Dylan Fields
02/07/2024, 7:44 PM
Doesn't appear possible.
m
Marc
02/08/2024, 12:52 AM
Why you don’t use a register account ?
c
Chris
02/08/2024, 12:54 AM
The end user wanted to see the other accounts that the transaction hit, but it only says split. I was able to just create a transaction search and filtered by the document # on the IS. Not ideal but works in a pinch. Going to see if there is something else I can do in the future
m
Marc
02/08/2024, 12:59 AM
If you have flagged the JE , you can create a custom field on all JE and update by csv with value of your account in the custom field
On your saved search use criteria : custom field is not empty
Account is not account123
Then in result you can see the counterpart
m
mhendricks
05/02/2024, 11:29 AM
safety tip for this suggestion ^ learned from experience. If you ever 'apply' JEs to transactions like a payment/invoice/credit importing an update via CSV will sever the existing apply list and can cause a lot of problems. just make sure if you're doing this to first check that the JEs you're updating are not applied to anything (even in closed periods). 🙂
d
Dylan Fields
05/02/2024, 3:14 PM
@mhendricks yep been there done that myself. General law to attempt to live by: don't ever mass "Touch" old JEs without extensive testing/precautions.