GL Report Needed

SOLVED

A client requires a list containing general journal history, but they need to know:

1.  Who entered the journal entry.

2.  Who posted the entry.

I'm dumping a bunch of GL tables, but it seems like I can only get who posted it.

One of the ODBC 'views' (vGeneralJounralHistory) has both 'createdby' and 'updatedby' columns, but these columns contain the same user in every case (appears to be the person who posted it in both fields), even though we know most of those entries were 'created' by someone else.

Anyone have any tips on this?  Thanks in advance.

Parents Reply Children