My Oracle Support Banner

E1: 48S/52: FAQ Regarding Billing Rate/Markup Table (P48096) (Doc ID 640697.1)

Last updated on OCTOBER 05, 2022

Applies to:

JD Edwards EnterpriseOne Contract and Service Billing - Version 8.0 and later
Information in this document applies to any platform.


The purpose of this document is to answer frequently asked questions about Markup Tables (P48096) and Billing Rate/Markup Report (R48096B)  in Contract and Service Billing

Questions and Answers

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
Questions and Answers
 Question 1:  How can the Effective Date (EFTE) field be changed in the Markup Table (P48096)?
 Question 2: Is there a way to enable the QBE line in Markup Table?
 Question 3:  The wrong markup table (P48096) is being used for a transaction.
 Question 4:  Is it possible to set up the Billing Rate/Mark up Table (P48096) so that certain accounts will produce a zero amount on the invoice?
  Question 5:  Is it possible to use the Pieces (PCUN) field in the F06116 or F0618 to update the Units field in the F0911 so that the Service Billing Markup table (P48096) can be used for piecework in the same manner that hours is used for units.
  Question 6How can I charge a different rates for different customers?  Example an employee working for one customer would be an upcharge of 2% and a different customer would be an upcharge of 5%. 
Is it possible to use the address book record as a subledger with an A for subledger type to define a rate in the markup table (P48096)?
 Question 7:  Would  it be possible to set up a Markup Table (P48096) to generate an invoice where the invoice and revenue amounts are different based a percentage times units times rate?  For example:  We bill 10 units at 100 dollars but need to defer 10% of revenue.  So the JE would be debit Trade A/R = 1000, credit Revenue (900), credit Deferred Revenue (liability account) (100).
  Question 8:  Why when adding an Ad Hoc entry in Workfile Revisions (P4812) the record does not have the mark up applied to it as set up in the Billing Rate/Mark up table (P48096), in the same manner as it doe is processed through Workfile Generation (R48120)?
 Question 9:  What is the Billing Rate / Markup Table Listing - R48096B.  How is it possible to run it for specific information instead of wide open data selection?
 Question 10: When is likely Key Type 9 is used?
 Question 11: If needing to bill an employee 10 hours at one rate and anything over 10 hours per employee at a different rate, is there a way to set that up in the Billing Rate / Mark up Table (F48096)? Is it possible to create markup table based on number of hours that are billed at different billing rates? ?
  Question 12: When setting up Billing Rate/ Markup Table (P48096) is it possible to set up 2 records for the same Key Type and Table Key, but with a different date range?
If not, please explain.
 Question 13:  How to update a new markup rate defined in (P48096) for existing records in the Workfile (P4812)?

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