GM400 query/tables?

tewright

Does anyone happen to have an sql query or report like the GM400 that they could share? I've checked out the tables GM400 hits in the technical documentation but when I query them I'm not getting the same dollar amounts for everything and I don't even see some of the accounts that the GM400 shows. It looks like it pulls most of its amounts from ACTRANS directly but there must be another place I'm not finding.