You’re offline. This is a read only version of the page.
60
Hi All,
I see that when I'm reversing a transaction I'm getting an entry in TRANSACTIONREVERSALTRANS table. This table contains a column called reftableid id. From which table I can get the list of these tables and their associated IDs.
Thanks,
Arti
*This post is locked for comments
I think it's easier to write a job (in AOT go to Jobs - right click - New job) with this one line:
info(tableId2str(123));
Just replace 123 with any number you want to find out. Then click Play button in the code editor.
I'm sure you can do that!
Hi Arti,
Given the architecture MS used, it's possible to use any table that house any transaction that can be reversed. However your environment only will have values where a specific transaction is reversed. E.g. If you don't use Fixed Assets, you may never get "AssetTrans" in your table. Below are some of the tables that you can be stored in RefTableId column, but the list is not complete and may never be complete given the architecture MS has used (RefTableId and RefRecId).
TaxTrans
TaxPurchaseTaxTrans
TaxReportVoucher
AssetTrans
CustCollectionLetterJour
CustCollectionLetterTrans
CustTrans
GeneralJournalAccountEntry
TransactionReversalTrans
VendTrans
Exchange rates and the list goes on....
Suggest that you have folks in your organization run all reversal scenarios and then get those table name using the function Nikolaos mentioned below (tableid2name()).
Thanks,
Satish Panwar
Please help verify answer(s) if they guide you in right direction so other community members can also benefit from your question with verified answer.
You can use tableid2name function to get a table name from table id.
If you want to, you can also develop a job to extract ids and names of all tables. This blog (even though the topic is a bit different) shows one example: dynamicsuser.net/.../how-to-get-list-oftables-table-group-main-tables-in-x
Please remember that table ids might be different in different environments, especially for your custom tables.
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,151
Super User 2024 Season 2
#2
Martin Dráb
229,993
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (