ERPstuff - Oracle EBS Community

Hi to all
How can we record employee expenses in Oracle Payable Module i was create the employee as supplier and punch the the prepayment invoice against him does the payment of this invoice.
First advance payment is submitting to employee and then how we can adjust this prepayment invoice against the employee. that is to say the employee day to day purchasing some items from this advance where he is record these expenses through these expense booked time to time these expenses are adjusted by advance payment to employee.
Is any one know about this procedure then please told me about if i am not going to right direction any other direction then tell.

how we create a advance payment to employee
employee doest some expense from this amount where is it adjusted and how ?
if any one know the solution as well as the reports of all expense that are done by the employee also tell

Thanks and Regards
Fayyaz Tak

Hi,

Use the Expense Report window to enter all expenses incurred by the employee. Also check the 'Apply Advances' checkbox and enter the prepayment invoice details if any, to apply adance to employee.

Use Payable Invoice Import to import and create invoices for these expense reports so that it will be available for approval and payment to employee.

Rgds,
Jayasree

Create employees as supplier in AP and then process prepayments (advances) and payments as normal. While nature of expenses you can capture using DFF. This will not be helpful if you want to keep limits controls.

thanks

1 Create the employee as suppliers
2 Create the prepayment invoice to employee that is defined in Supplier window.
3 Using the Expense Report window to enter all expenses incurred by the employee. Also check the 'Apply Advances' check box
4 Then run the Payable open interface Invoice Import Program run
5 Then run the expense report export program.

all are done successfully but the

i run this program invoice is not create

how invoice is created on this report run expense report export program it will not create the invoice automatically

Hello Fayyaz,

You should run 'Payables Invoice Import program 'to have Payables automatically create invoices from the expense reports.

Payables Open Interface Import program is run to import invoices created through Invoice Gateway/Quick Invoices and all other invoices uploaded to Open Interface table from Legacy system.

Expense report created are not saved to Open Interface table, but they are saved to Expense Report Headers and Lines tables which in turn will get imported as invoices by running 'Payables Invoice Import program .

Just wondering what is this 'expense report export program'..? Have you customized any report and what is its purpose..?

Hope it is clear.
rgds
Jayasree

Expense Report Export Program is the program which create invoice automatically INVOICE TYPE is automatically set as Expense report you Create the Expense Report Template from Payable Setup then set this template to Payable options if you want to apply advance then also check on it. check on create employee as supplier.
You will create employee from supplier window
Then from Invoice options you have Expense Report also you will create expense Report from there then you will record all the expense done by the employee from there.
if you submit the report 'Expense Report Import Program' it will create the Invoice automatically.

Hi fayyaz,

You mentioned the correct process for expense report for employee but the concurrent program correct name is... <b>"Expense Report Import"</b> Program.

thanks,

Aman

Mr. Aman You are right
Thanks for the Correction

Expense Report Import is obsolete in release 12