issue with the link between gl_code_combinations and ZX_ACCOUNTS — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

issue with the link between gl_code_combinations and ZX_ACCOUNTS

edited Oct 31, 2024 5:40PM in Tax & Global 1 comment

Summary:

I am creating a report to gather the taxes and all invoices related to this tax.

Content (please ensure you mask any confidential information):

I used the below query in my data model to get the tax accounts used in the general ledger along with the tax details(tax rate code, percentage rate, etc.).

SELECT
RB.TAX_RATE_CODE,
RB.CREATION_DATE,
COMB.Segment4,
RB.PERCENTAGE_RATE,
COMB.chart_of_accounts_id
FROM zx_rates_b RB
JOIN ZX_ACCOUNTS TA ON TA.TAX_ACCOUNT_ENTITY_ID = RB.tax_rate_id
JOIN gl_code_combinations COMB ON COMB.code_combination_id IN

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!