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

All responses (3)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Adding Taxcodes to the general ledger

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
Kasper Hedegaard 5 on at

Like (0)

Report

RE: Adding Taxcodes to the general ledger

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?
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Adding Taxcodes to the general ledger

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