My Oracle Support Banner

Billing Specific Clients A Flat-Rate On Per-Diem Meal Types (Doc ID 2439400.1)

Last updated on AUGUST 27, 2018

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

On : 12.1.3 version, Misc Billing Issues

Billing Specific Clients a Flat-Rate on Per-Diem Meal Types

In Projects, per-diem meals are charged by employees to a project and then are billed back to the client. But because meals are tax-included, the adjusted cost base of the meal varies from province to province if there is a different tax basis.

EXAMPLE:
1) Breakfast Per-Diem: $15/day (tax included)
2) Employee from Québec: Breakfast is then broken out to become $13.18/breakfast + $1.82 taxes = $15.00
3) We wish to bill a specific project a flat rate of $10.40/breakfast BEFORE taxes
4) In Bill Rates & Discount Overrides (See Note 1), for this specific project, we can define a markup% to rebill (See Note 2)


NOTE 1)
ENTERING BILL RATES FOR SPECIFIC PROJECTS:
Oracle --> Project Billing Super User --> Projects --> Number: (enter project #) --> Click "Find" --> Click "Open" --> Options: Option Name: Bill Rates and Discount Overrides: Non-Labor Bill Rate and Discount Overrides -->

NOTE 2)
= Original x (1 + MU%) = Bill Rate
= (1 + MU%) = (Bill Rate / Original)
= MU% = (Bill Rate / Original) - 1
= MU% = ($10.40 / $13.18) - 1
= MU% = -21.09%

Because "Original" amount can vary depending on sales tax of each province, there is no way to include a markup/discount rate that factors in tax rates into the equation. Is there a simple way to charge a flat rate per meal type? The other option the user could think of would be to create every single permutation of mark up % rate (i.e. (10 provinces + 3 territories) x 4 per diem meal types = 52 individual markup % bill rates for the project)
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.