Can add GL account # in Material Transaction Detail report?

[b.huang (Ben Huang)]

Our users want to have the GL account #s in the Material Transaction Detail report. Anyone has this experience and know how to do? I know the material transaction detail report mainly uses the two tables, PartTran and Company. How can we associate GL #s with the PartTran? Which table should be used? Thanks.

[Mark_Wonsil]

TranGLC

I am trying to design a BAQ that shows all the transactions from the TranGLC (by date range) and shows the user that did that transaction. However, I am having trouble pulling all the tables into one query to list the entry person or changed by person. My question is, what table could be connected to the TranGLC that the other tables could connect off of it. So far to get the user information I have identified the following tables that need to be included in the query. APInvExp APInvHead C…

[b.huang (Ben Huang)]

Thanks a lot, Mark.

[ckrusen (Calvin Krusen)]

You could run into trouble because the GL account to use isn’t actually used until the Capture WIP/COS is run. It is at that time when the GL account is actually selected.

So a potential pitfall would be determining if there was a change to the GLC (or the thing the GLC is tied to) between when the material transaction report was printed, and when the Capture WIP/COS process is run.

Your Mtl Tran report would indicate the anticipated GL account

[b.huang (Ben Huang)]

Thanks for your info, Calvin.