ACCOUNTS PAYABLE (AP) DATA AND REPORTING Jennifer Littlefield - - PowerPoint PPT Presentation

▶
accounts payable ap data and
SMART_READER_LITE
LIVE PREVIEW

ACCOUNTS PAYABLE (AP) DATA AND REPORTING Jennifer Littlefield - - PowerPoint PPT Presentation

Mar 13, 2023 123 likes •258 views

ACCOUNTS PAYABLE (AP) DATA AND REPORTING Jennifer Littlefield February 2019 AP REPORTS Circumstances Currently an AP star is on the BICCs project list, so certain fields are available in Cognos but relationships have not been established

slide-1
SLIDE 1

ACCOUNTS PAYABLE (AP) DATA AND REPORTING

Jennifer Littlefield

February 2019

slide-2
SLIDE 2

AP REPORTS

  • Currently an AP star is on the BICCs project list, so certain

fields are available in Cognos but relationships have not been established in the system

  • All the fields are available in SAP but some of the fields are not

accessible through a standard tcode

  • Both central and business offices would need access to

different reports

  • Reports were needed as soon as possible

2

Circumstances

slide-3
SLIDE 3

REPORT REQUIREMENTS

  • Needs to be used by users in the

central and business offices

  • Must include fields from multiple

locations

  • User should be able to see the

data by fiscal period and year, vendor number and vendor name, as well as by check number

3

AP Held Check

Field Desc To check no# Year Period Doc# Type Doc# Date Parked By Vendor Number Name of the payee Name of the payee1 Payment document no. (ClrngDocNo) FI Acctg Document Number PM (Payment Method) Payment Block HeldCheck (Pmt meth. supplement=01) Payment terms Check encashment date Pstng Date User Who Carried Out Printing Reference Document Header Text Line Item Text Balance sheet account Business Area Funded Program Check Amount Paid Invoice Amount

slide-4
SLIDE 4

DATA MODELING

Map out how your data is related

4

Know your data and the relationships

slide-5
SLIDE 5

DATASETS

Datasets are a way to group a customized collection of items from Boiler Insight Package or other Data Modules

5

slide-6
SLIDE 6

DATASETS

6

slide-7
SLIDE 7

UPLOADED FILES

7

Uploaded Files for this report are APReference and HeldCheck both are files from SAP

slide-8
SLIDE 8

DATA MODULES AND DATA SOURCES

8

Data Modules are source objects that contain data from data servers, uploaded files, or other data modules, and are saved in My content or Team content.

slide-9
SLIDE 9

DATA MODULES AND JOINS

9

Joins in Data Modules allow standard relationships to be established

slide-10
SLIDE 10

QUERIES

10

Joins in the data module are being used so they don’t need to be added to the queries in the report itself.

slide-11
SLIDE 11

HELD CHECK REPORT

11

A prompt page with the five filters from the requirements was added, as well as grouping on the vendor number so a reprompt could be added into the report itself.

slide-12
SLIDE 12

12

Contact Information:

JENNIFER LITTLEFIELD Accounting Services, Purdue University Office telephone (765) 494-0986 jlittlef@purdue.edu