SMART Messages

SMART Logo

 
MESSAGE 080910-02
DATE August 9, 2010
AUTHOR Purchasing
Subject AP Data Warehouse Information

Message Text: The Accounts Payable subject area in the SMART Data Warehouse now includes all payment rows. This enables you to report on cancelled payments. When reporting on overall AP expenditures, please remember that you will need to exclude any cancelled payments from your request. To exclude cancelled payments, you must add a filter to the AP Payment Transaction Status dimension in your request. Some the most common values you will use for excluding cancelled payments are:

  • V (Void)
  • S (Stop)
  • X (Delete)

TIP: to add a filter to a request without adding the column, hold down the CTRL key while clicking on the column. The Create/Edit Filter box will pop-up to allow you to create a filter without the column displaying on your request.


Filterable Accounts Payable Values in SMART Data Warehouse

AP Payment Transaction Status Description

AP Payment Transaction Status

AP Payment Transaction Status ID

ACH/EFT Prenote

Prenote

E

Alignment

Alignment

A

Deleted

Deleted

X

Escheated Check

Escheated

W

Not Available

NA

-

Overflow

Overflow

O

Paid

Paid

P

Replaced

Replaced

R

Reprinted with same reference number

Same Ref

N

Stale Dated Payment

Stale

L

Stopped

Stop

S

Undo Cancel

Undo

U

Undo Escheatment

Undo

T

Void

Void

V


 

Quick Links

Search the Site

Contact Us

Send us an email

Sign Up

Sign up for the SMART InfoList