Finance | Project Operations, Human Resources, ...

Adding Taxcodes to the general ledger

(0) Share

Report

Posted on by Kasper Hedegaard

Hi everybody

We 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

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Kasper Hedegaard 5 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Best regards,

Ludwig

Was this reply helpful? Yes No