The billing report process of the R12 payable module

Target

1. You can set the billing report options for the payable options and supplier-related options for the payable System Options (payables system setup ).

2. A billing report is created.

3. expense report export will be usedProgram, Generate an invoice for the expense report

4. Add the export results function and oie_export_results_fn to the payable menu to view the export result.

5. write off the prepayment In the expense report (or use the invoice generated in the expense report to write off the prepayment)

 

Billing report Concept

The expense report is used for reimbursement! Oracle EBS has powerful and flexible functions to handle daily reimbursement activities. You can not only process reimbursement activities in the payable module, but also use the Internet expense to reimburse expenses at any time and anywhere through the network. You can write off the prepayment In the expense report to reduce the amount payable (for example, before an employee is on a business trip, the Company advances part of the amount to the employee. After an employee returns to the company on a business trip, the company uses the AP function to write off the prepayment report based on the actual reimbursement amount. After calculation, pay or revoke the fee to the employee)

 

Billing report processing process

 

Create expense report in the payable module

Prerequisites:

1. Enter employees and their locations, expense addresses, supervisors, and default expense accounts.

2. Enter human resources privileges als options and expense report payables options.

3. Define expense report templates.

The content in the official document is clearer than the original version.

 

Example:

 

 

About creating employees as suppliers

One of the invoices is a supplier and is mandatory. However, the report source is an employee. Therefore, it is necessary to create an employee as a supplier when generating an invoice for the report.

The system can automatically create an employee as the supplier when running the expense report export program. However, you must make the following settings (this step is important ):

1. Select "automatically create an employee as a supplier" in the "expense report" setting area of the "Payable options.

2. The "employee ID" in the "human resource" setting area of the financial options "is" automatic number ".

3. Set the entry in the supplier number (supplier number) in the payable System Option (payable System Setup) to automatic; otherwise, employees cannot be automatically created as suppliers.

 

RunExpense report exportProgram

Run the expense report export program to generate an invoice of the billing report type (invoice type: expense report) entered in the payable module and in the Internet expense. The invoice in the expense report is created based on the following attributes:

1. billing report type

2. The invoice number is the expense report number.

3. lines and distribution of invoices are obtained from the line content of the expense report.

4. Information about the invoice supplier (including trading partner, supplier site, supplier number, etc.) from the employee (employee) who applied for the expense report

5. the invoice date, currency, amount, and GL date are directly from the corresponding items in the expense report.

6. The payment term of the invoice is defined in the billing report setting area of the payable options.

7. the payment method of an invoice is obtained from the definition of the supplier site, but the employee is not a supplier. Therefore, you can define the default payment method on the Payment administrator page.

This can be extended: When the running program fails to create an invoice, can you check whether these property values are ready? Is it complete? Whether an error exists. You can find out the cause of the creation failure.

 

Example:

 

Invoice for expense report

After the expense report export program is successfully run, you can view the invoice information generated by the expense report in the invoice window. In this case, if there is a prepayment, you can use the prepayment to write off this invoice, thus reducing the payable amount of the invoice. Finally, you can make payment for this invoice and create accounting entries.

 

Last

Oracle EBS is awesome to me for its flexibility: different economic business objects processed by different modules have different business flows, and EBS can connect these N-plus entities, just like a grid chart, you can decide how the route goes! She also provides the most optimized business processing solutions that cover all aspects of the business, from the beginning to the end of the business, it provides the most comprehensive tracking for economic business information collection, processing, and analysis.

 

From: http://blog.csdn.net/saiya_kwok/article/details/4813999