HCM - JDE1 (MOSC)

MOSC Banner

Relationship between payroll tables and service billing tables

edited Mar 17, 2020 5:04AM in HCM - JDE1 (MOSC) 3 commentsAnswered

My company runs business across various Canadian provinces, and since last year, BC has implemented a new Employer Health Tax that is not calculated during payroll.

Because we do service billing and invoice clients with employee wages and burdens, we have to create a custom report that calculates this tax and also displays the related service billing accounts.

The report that I am interested in creating will look something like the screenshot and accounting will do a manual entry to the operating account for the tax amount.

I have been trying to find how payroll tables F0618 and F0719 are linked to service billing information in table F0911 and F4801 so that I can find the operating account where to charge the calculated taxes, but I am not able to find the relationship. Does anyone have a suggestion about how to handle this?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center