Share
ReportHello,
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
You’re offline. This is a read only version of the page.
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
hello every one, thanks for your help, i find my solution here:
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,
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
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.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (