Practice - Running the Create Accounting Program for Payables

Distribution

R12 Oracle Subledger Accounting

Job Title*

Ownership

The Job Title [?Subject=LABxxxxx] is responsible for ensuring that this document is necessary and that it reflects actual practice.

Practice - Running the Create Accounting Program for Payables

Overview

In this practice, you will do the following:

Enter an invoice
Run the Create Accounting program in draft mode from the Invoices Workbench or alternatively from the Requests window

Assumptions

Replace XX with your terminal number or initials.
You must have access to an Oracle Application Vision database or comparable training or test instance at your site on which to complete this practice.
Responsibility selected to complete this practice is Payables, Vision Operations (USA).

Tasks

Log on to the system

User Name = operations
Password = welcome
Responsibility = Payables, Vision Operations (USA)

Enter an invoice

In the Invoices window, create an invoice based on the following information:

Trading Partner: IBM Corporation
Invoice number: XX5000
Invoice amount: 15000
Description: Promotional Giveaway
Payment method: Electronic
Enter 2 lines, one for 10,000 and another for 5,000.
Use distribution account: 01-402-7710-0000-000 for the first line and 01-402-7120-0000-000 for the second line.

Run the Create Accounting program:

- for invoices up to and including today’s date

- in draft mode

- don’t include events with an Error status

- generate a detailed report

- don’t display user identifiers

Solution –Running the Create Accounting Program for Payables

Log on to the system

User Name = operations
Password = welcome
Responsibility = Payables, Vision Operations (USA)

Entering an invoice

1.Navigate to the Invoice Workbench:

(N) Invoices > Entry > Invoices

2.In the Trading Partner field, select IBM Corporation.

3.In the Invoice Number field, enter XX5000.

4.In the Invoice Amount field, enter 15,000.

5.In the Description field, enter Promotional Giveaway.

6.In the Payment Method field, select Electronic.

7.Select the Lines tab.

8.In the Amount field, enter 10000.

9.In the Product Type field, select Goods.

10.In the Distribution Account field, enter 01-402-7710-0000-000.

11.Enter a second line, where the amount is 5000 for Goods and use the distribution account 01-402-7120-0000-000.

12.To validate the invoice, (B)Actions.

13.Select the Validate check box and (B) OK.

You can now generate draft accounting from the Invoice Workbench (proceed to step 14) or you can submit the Create Accounting program (proceed to step 16) from the Requests window. If you generate the draft accounting from the Invoice Workbench then you are just generating accounting for that particular transaction. If you generate accounting from the Requests window then you will generate accounting for any outstanding transactions, including the transaction you just entered.

Note: If you have recently made changes to the Subledger Accounting setup you may find that you are unable to generate accounting from the Invoice Workbench. If you receive a message indicating that accounting cannot be generated then you should submit a request via the Requests window.

Generating Draft Accounting from the Invoice Workbench

14.(B) Actions

15.Select the Create Accounting check box.

16.Select the Draft radio button.

17.(B) OK.

Generating Draft Accounting from the Requests window

18.Navigate to the Submit a New Request window.

(N) Other > RequestsRun

19.(B) Single Request

20.(B) OK

21.In the Name field, select Create Accounting. The Parameters dialog box appears.

22.In the Ledger field, select Vision Operations (USA). This is a required field and limits accounting events selected for processing to those of a particular ledger.

23.In the Process Category field, select Invoices. This is an optional field and restricts the events selected for accounting to a particular process category.

24.In the End Date field, enter today’s date. This is a required field and processes only those events with event dates on or before the end date.

25.In the Mode field, select Draft.This is a required field and determines whether the subledger journal entries are created in draft or final mode.

26.In the Errors Only field, select No. This is a required field and limits the creation of accounting to those events for which accounting has previously failed. If you selected Yes, then the Create Accounting processes all events with a status of Error.

27.In the Report field, select Detail. This is a required field and determines whether to generate a report showing the results of the Subledger Accounting program in summary or detail format.

28.Leave the General Ledger Batch Name field blank. This is an optional field and is the user-entered batch name that appears on the transferred General Ledger subledger journal entries. The Transfer to GL option must be set to Yes.

29.In the Include User Transaction Identifiers field, select No. This is a required field and controls whether the report displays user identifiers’ names and values.

30.(B) OK

31.(B) Submit

32.(M) View – Requests,to check the request status.

Inquire on the journal entry

33.Navigate to the Subledger Journal Entries window.

(N) Accounting > Subledger Accounting > Journal Entries

34.Ensure that the Headers tab is selected.

35.In the Advanced Search window, enter the following search information:

Ledger: Vision Operations (USA)

From GL Date: <today’s date>

To GL Date: <today’s date>

36.(B) Go

The subledger journal entries are displayed in the Results region.

37.To view the details of the entry you just created, click on the appropriate ledger link to display the Subledger Journal Entry window.

Practice - Running the Create Accounting Program for Payables LAB3F1CY.DOC

Effective 10/29/2018Page 1 of 10Rev 1