Transaction Entry Zoom

(0) Share

Report

Posted on by Community Member

Hello,

I'm looking for the sql table for this windows (Transaction Entry Zoom), and how can i identify the transaction related the this windows.

thanks,

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

mavrick5 100 on at

Like (0)

Report

Try using the resource descriptions feature under tools. Select the Financial series and scroll down to the "Transaction Entry Zoom" window display name. It will tell you all the tables used by this window. I would assume the table you are looking for is the GL_YTD_TRX_OPEN table. You can use SQL to select the data from the table or use one of the numerous search stored procedures available on the web to search for the batch id or the reference.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Aissam,

The information exists in one of two tables. Either the YTD Transaction Open table (GL20000) for years that have not yet been closed, or the Account Transaction History table (GL30000) for closed years.

If you do a UNION of those two tables, you should have all of the information you need.

Maverick5 gives you good advice on how you can research this information using the Resource Descriptions, the one he is describing is for Window resources.

Was this reply helpful? Yes No
Verified answer

L Vail 65,271 on at

Like (0)

Report

Aissam,

There is a view in your company database named 'Account Transactions' that has already created the union. You should be able to get all of the account transactions, including unposted and history, from that view.

Kind regards,

Leslie

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

ok, but when i drill down to (Source document) to see which transaction is related, i have error rmessage (Transaction history does not exist for this transaction), i want to track this transaction, how can i do.

thanks,

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hello every one, thanks for your help, i find my solution here:

support.microsoft.com/.../2448193

Was this reply helpful? Yes No