Notifications
Announcements
No record found.
Hi everybodyWe are looking in to adding the taxcodes to the general ledger for our EDW. From the table TaxTrans we want to link to the table LedgerTrans. How do we do that? I do not seem to find a way to do so. We will be thankful for any help we may get.
/Kasper
Hello Kasper,
What does EDW stand for?
Have you tried linking your main accounts and tax codes through the available validation options that you can setup in the main accounts form?
Best regards,
Ludwig
Hi Ludwig
Thank you very much for a quick reply!
EDW is our Enterprise Datawarehouse. So we want to connect to the tables through SQL Server Management Studio and build our own reports through Tableau.
Here we already work with the table LedgerTrans and are wondering if we can add a unique taxcode to the different postings.
Does that specify my problem?
Hi Kasper,
I don't think that you will always have a simple 1:1 relation. Depending on your vouchers the might be multiple tax codes posted for a transaction - for example when you make a split posting. You can check the relationship of the tax and the ledger trans tables in the AOT. Just have a look at that and try to analyze some of your more complex vouchers. That should give you an idea how to design your Tableau report.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 592 Most Valuable Professional
André Arnaud de Cal... 478 Super User 2025 Season 2
BillurSamdancioglu 305 Most Valuable Professional
