Tuesday, October 16, 2018

Oracle Project Billing

Oracle Project Billing

Oracle Project Billing enables simple client invoicing, improved cash flow, and measurement of the profitability of contract projects with support for planning, execution, and analysis. It utilizes information from the work breakdown structure and provides flexible revenue accrual and invoice generation features.
This chapter describes the following test flows in Oracle Project Billing:
  • Project Revenue and Invoice Generation
Prerequisites
None.
Profile Options
Not applicable.
Predefined Data
Not applicable.
Setup Data
Not applicable.

17.1 Project Revenue and Invoice Generation

Project revenue and invoice generation covers the integration between Project Billing and the other modules within Projects product family, like Project Foundation and Project Costing and also with Financials products like Receivables and E Business Tax.
A contract project is created which gets funded by an agreement. Costs and billing events are recorded on the projects. For these costs and events, project revenue is generated and accounted. Projects invoices are also generated and fully processed by interfacing the same to receivables.
Prerequisites
None.
Profile Options
Table 17-1 Profile Options for Project Revenue and Invoice Generation Flow
Profile NameProfile ValueLevel
Profile NameProfile ValueLevel
PA: Transaction Billability derived from Work TypeYesSite
PA: Require Work Type Entry for ExpendituresYesSite
Predefined Data
Table 17-2 Predefined Data for Project Revenue and Invoice Generation Flow
Window NameField NameField Value
Project Implementation OptionsTransaction SourcePROJECTS INVOICES-600
Setup Data
Table 17-3 Setup Data for Project Revenue and Invoice Generation Flow

Window NameField NameField ValueComments
Project TypeService TypeBuild

Work TypeCommercial Customer-billableBillable or capitalizable option should be selected

Resource ListExpenditure Category

Rate SchedulePJCB-EMP-BR-1

Rate SchedulePJCB-JOB-BR-1

Rate SchedulePJCB-NL-BR-1Expenditure type Consulting has a markup of 10% defined.

Billing CycleFirst Day
Project TemplateEmployeeMarlin, Ms. Amy

CustomerHilman and Associates

Tax Classification CodePJB_TAX_RATETax Rate of 10% is defined
AgreementAgreement TypePurchase Orders

Payment Terms30 NET
Pre-Approved BatchExpenditure TypeConsulting
Billing EventsEvent TypeManual

No comments:

Post a Comment

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...