display recurring entry document list - home, home€¦ · web viewrecurring entry functionality...

15
Work Instruction Functional Area: Accounts Receivable Display Recurring Entry Document List Purpose Use this procedure to run a report to view the recurring documents that are in the system. This report can be run to see all recurring documents or it can be run based on the criteria that is selected. Trigger None Prerequisites A billing agreement has been established where the same entity (customer) will be billed for the same amount according to a periodic billing schedule. And as a result the recurring document is set up in the system. Menu Path Use the following menu path to begin this transaction: Select Financial Account Financial Accounting Accounts Receivable Periodic processing Recurring entries Lists to go to the Recurring Entry Documents screen. Transaction Code F.15 Business Process Information Recurring invoicing functionality is used to automatically post business transactions that are repeated regularly such as rent or insurance. To establish a recurring entry agreement in the system, a recurring entry document must first be defined. The recurring entry document represents details of the billing agreement such as billing amounts, general ledger/accounting information, payment terms, posting schedule, etc. The recurring entry document is defined in the system using transaction code FBD1. Recurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable (AP) and General Ledger Accounting (GL). One way the University will use this functionality is in the AR Depart for office space rental and salary and benefits consultant billing. For example, in the case of salary and benefits consultant billing, personnel in the Financial Services department will enter the recurring entry document based on data in the contracts for IPA agreements. These agreements are received by

Upload: others

Post on 05-Apr-2020

1 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

Purpose

Use this procedure to run a report to view the recurring documents that are in the system. This report can be run to see all recurring documents or it can be run based on the criteria that is selected.

Trigger

None

Prerequisites

A billing agreement has been established where the same entity (customer) will be billed for the same amount according to a periodic billing schedule. And as a result the recurring document is set up in the system.

Menu Path

Use the following menu path to begin this transaction:

Select Financial Account  Financial Accounting  Accounts Receivable  Periodic processing  Recurring entries  Lists to go to the Recurring Entry Documents screen.

Transaction Code

F.15

Business Process Information

Recurring invoicing functionality is used to automatically post business transactions that are repeated regularly such as rent or insurance. To establish a recurring entry agreement in the system, a recurring entry document must first be defined. The recurring entry document represents details of the billing agreement such as billing amounts, general ledger/accounting information, payment terms, posting schedule, etc. The recurring entry document is defined in the system using transaction code FBD1. Recurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable (AP) and General Ledger Accounting (GL).

One way the University will use this functionality is in the AR Depart for office space rental and salary and benefits consultant billing. For example, in the case of salary and benefits consultant billing, personnel in the Financial Services department will enter the recurring entry document based on data in the contracts for IPA agreements. These agreements are received by Financial Services from departments throughout the University for the salary and benefits of consultants that are paid through UC payroll. The University bills an agency in order to be reimbursed for the payroll expense. Recurring invoices will also be used to bill Practice Plan entities and other areas that rent office space from the University.

If there is a inquiry from either inside or outside of the University that requires a review of the recurring entry documents a report or list can be generated using transaction F.15. This reporting transaction can also be used to review which contracts are about to expire in the system, which documents have an upcoming invoice posting, etc.

The data maintenance of the recurring entry documents (creation, updates (changes), deletions, etc. will be centrally maintained at the Financial Services departments. Accordingly, this reporting transaction will

Page 2: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

be centrally maintained at the Financial Services departments.

Helpful Hints

The R/O/C column in the field description tables below defines whether the field is required (R), optional (O), or conditional (C).

On certain screens you may have to scroll to view some data entry fields. If the selection criteria on this report is used repeatedly, it can be saved as a reporting variant

by entering the data on the Recurring Entry Documents screen and click  .

Name your variant and enter a short description. Click   to save the variant.

To access your variant at a later time click  and choose your variant.

Page 3: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

Procedure

1. Start the transaction using the menu path or transaction code.

Recurring Entry Documents

2. As required, complete/review the following fields:

Field R/O/C Description

Company code Optional Organizational unit within Financial Accounting

Example:UC

    A single value or a range of values can be entered.

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  3/13

Page 4: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

Field R/O/C Description

Document number Optional The unique identification value assigned to a business event as it is processed in SAP. Cash management: Accounting document number(s) that should be deleted. This data is used to limit the data selection.

Example:1

    This is the recurring entry SAP document number. A single value or a range of values can be entered.

Fiscal year Optional State of Ohio mandated fiscal year (accounting period) running from July 1st of one year to June 30th of the following year

Example:2005

    A single value or a range of values can be entered.

Posting date Optional The date on which a transaction in SAP will be posted to the appropriate accounts; SAP will default this field to be the current date, but changes are allowed. For items to be posted in a future or past period, you must enter the posting date

Example:

    A single value or a range of values can be entered.

Reference number Optional Indicator used to specify that the reference document field will be used as a criteria for selecting open items for payment

Example:

    A single value or a range of values can be entered.

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  4/13

Page 5: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

Any of the fields in the Further selections section can be used to limit your search to only recurring documents that you want to see. It can be run for example by the person who entered the document, the start or end date of the document, or the document number.

To expand the selection criteria (to include fields on the document header), click    .

If all data selection fields are left blank, the system will include all recurring entry documents on the reporting output.

3. Perform one of the following:If ThenYou want to control how the data is selected/read for the report to control runtime efficiency

Select   to the left of Read items sequentially.

    This option should only be selected if the report is running in ‘batch’. Typically, this report will be executed online, leave blank.

4. As required, complete/review the following fields:

Field R/O/C Description

CPU date Optional Description of the CPU date

Example:

    A single value or a range of values can be entered.

Entered by Optional Person entering the information

Example:

    This field contains the SAP user ID. A single value or a range of values can be entered.

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  5/13

Page 6: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

Field R/O/C Description

Start date Optional Commencement date of activity or business event

Example:

    A single value or a range of values can be entered.

End date Optional Key that identifies any constraints placed on the end date for an operation

Example:

    A single value or a range of values can be entered.

Run schedule Optional A predetermined schedule for posting recurring entries

Example:

    A single value or a range of values can be entered.

Deletion indicator Optional Description of the Deletion indicator.

Example:X - Yes

    A single value or a range of values can be entered.

5.Select  to the left of Documents from next run.

6. As required, complete/review the following fields:

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  6/13

Page 7: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

Field R/O/C Description

Calculation period Conditional Period in which document is posted

Example:

    Data in this field is required if the selection criteria above is activated.

7. Perform one of the following:If You Want To Then Go ToLimit the reporting output to recurring entry documents for specific customer account(s)

Select   to the left of Customer accounts.

Step 8

Include the customer’s address information on the output of the report

Select   to the left of Customer address output.

Step 8

8. As required, complete/review the following fields:

Field R/O/C Description

Customer account Conditional Account assigned to each customer; Invoices to the customer and payments from the customer are recorded in this account. Each accounts receivable account is a sub-ledger account that rolls up to a general ledger reconciliation account

Example:

    Data in this field is required if the ‘Customer accounts’ selection criteria above is activated.

9. Perform one of the following:If You Want To Then Go ToLimit the output of the report to specific vendor account(s) Select   to the left of Vendor accounts. Step 10

Include the vendor’s address information on the output of the report

Select   to the left of Vendor address output.

Step 10

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  7/13

Page 8: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

10. As required, complete/review the following fields:

Field R/O/C Description

Vendor account Conditional Account assigned to each vendor; Invoices from the vendor and payments to the vendor are recorded in this account. Each accounts payable account is a sub-ledger account that rolls up to a general ledger reconciliation account.

Example:

    Data in this field is required if the ‘Vendor accounts’ selection criteria above is activated.

11.Select  to the left of Display G/L accounts.

12. As required, complete/review the following fields:

Field R/O/C Description

G/L account Conditional Code identifying the account in the general ledger where this line item will post

Example:

    Data in this field is required if the ‘G/L accounts’ selection criteria above is activated.

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  8/13

Page 9: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

Recurring Entry Documents

13. Perform one of the following:If You Want Then

The report to replace the general ledger account number with another account number defined in configuration

Select   to the left of Alternative account number.

    This functionality is not being used, leave blank.

The report separated by company code or another list separation criteria defined in configuration

Select   to the left of List separation.

    This functionality is not being used, leave blank.

The report to include microfiche film relevant information on the top of every page Select   to the left of Print microfiche line.

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  9/13

Page 10: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

    This functionality is not being used, leave blank.

To limit the report to only those recurring entry documents that have not yet been executed Select   to the left of Non-filled documents.

This is a continuation of the previous screen after scrolling.

14. As required, complete/review the following fields:

Field R/O/C Description

Additional header Optional Description of Additional header

Example:

15.Click  .

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  10/13

Page 11: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

Recurring Entry Documents (2)

16. Perform one of the following:If You Want To ThenPrint a hard copy of the report Click or select menu path List  Print.

Save the report to an computer or external disk

Click or select menu path List  Save/Send  File.

    Enter a directory and file name.

Exit the report Click  .

Review the displayed information.

17.Click  until you return to the SAP Easy Access screen.

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  11/13

Page 12: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

18. You have completed this transaction.

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  12/13

Page 13: Display Recurring Entry Document List - Home, Home€¦ · Web viewRecurring entry functionality can be used in the following SAP modules: Accounts Receivable (AR), Accounts Payable

Work InstructionFunctional Area: Accounts Receivable  Display Recurring Entry Document List

Result

You have run the Recurring Document List.

Comments

None

9/14/2017Ver:

33_AR_F.15_Disp Recur Entry Doc List_R1_CustBillThruPaym.udc© University of Cincinnati  13/13