Insert excerpt

	Def - Trans - AP Invoice/Credit Memo
	Def - Trans - AP Invoice/Credit Memo
nopanel	true

The purpose of this page is to show line item detail for all these transactions.

...

Table of Contents

type	flat

Page Header

...

Search

Filter Items	Description

Excel

Also Include

Insert excerpt

Excel

	Inq -

LV

Include

Excel

	Inq -

LV

Include
nopanel	true

FavoritesFavorites Add/Remove - Global

Voids & Replaced

Date Option

Insert excerpt

Favorites Add/Remove - Global

Date Type Lookup
	Date Type Lookup
nopanel	true

Grid LayoutGrid Layout - Global

Doc Date
GL Date

Date Range

Insert excerpt

Grid Layout - Global

Date Control Text Box
	Date Control Text Box
nopanel	true

Help

Search

Insert excerpt

Help

	Search -

Global

Search Options

Help

	Search -

Global

Search Options
nopanel	true

Inquiry Criteria

Description
Doc No
Item Description
Purchase Order
Transaction
Vendor ID
Vendor Name

Transaction Class

Insert excerpt

Inquiry Criteria

	Inq -

Global

Transaction Class

Inquiry Criteria

	Inq -

Global

Transaction Class
nopanel	true

Date From: a text box to enter a starting Doc Date. If entered, this must be in a valid date format. A blank assumes All.
Date To: a text box to enter an ending Doc Date. If entered, this must be in a valid date format. A blank assumes All.
Status: a multi-select check box to limit the data that is returned to one or more selected Statuses. Options include: New, Approved, Ready To Post, Posted, Void, Deleted, Replaced. The default values are "New, Approved, Ready To Posted and Posted".

RefreshRe-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria.

The values in this lookup are listed alphabetically. If there is more than one Transaction Class for the Transaction Type, then the value in the lookup will display as [Transaction Type] - [Transaction Class]. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt

	Def - Transaction Class - General
	Def - Transaction Class - General
nopanel	true

The lookup contains a list of all 'Active' AP Transaction Classes.

Vendor

Used to select one or more Vendors. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt

	Def - Vendor
	Def - Vendor
nopanel	true

The lookup contains a list of all 'Active' Vendors.

Vendor Class

Insert excerpt

	Inq - Vendor Class
	Inq - Vendor Class
nopanel	true

This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt

	Def - Vendor Class
	Def - Vendor Class
nopanel	true

The lookup contains a list of all 'Active' AP Vendor Classes.

Page Detail

Toolbar Icons

Description

Column Filter Show/Hide

Insert excerpt

	Column Filter Show/Hide - Global
	Column Filter Show/Hide - Global
nopanel	true

Excel

Insert excerpt

	Excel - LV 3.0
	Excel - LV 3.0
nopanel	true

Favorites

Insert excerpt

	Favorites Add/Remove - Global
	Favorites Add/Remove - Global
nopanel	true

Group By Show/Hide

Insert excerpt

	Group By Show/Hide - Global
	Group By Show/Hide - Global
nopanel	true

Help

Insert excerpt

	Help - Global 3.0
	Help - Global 3.0
nopanel	true

More Actions

Insert excerpt

	More Actions - Global 3.0
	More Actions - Global 3.0
nopanel	true

RV: Transaction. Opens the Transaction Record View.
Void Transaction.
Insert excerpt
Void - Global
Void - Global
nopanel true

Print

Insert excerpt

	Print - LV 3.0
	Print - LV 3.0
nopanel	true

When clicked, all the Reports assigned to the Functional Area of Purchasing, that launch from the Print Dialog, are assigned to this page, and that the user has rights to (if Report Data Access is enabled) are displayed.

Quick Column Filter

Insert excerpt

	Quick Column Filter
	Quick Column Filter
nopanel	true

Refresh

Insert excerpt

	Refresh - Global
	Refresh - Global
nopanel	true

Saved Layouts

Insert excerpt

	Column Layouts for Framework 3.0 - Global
	Column Layouts for Framework 3.0 - Global
nopanel	true

Search Option

Insert excerpt

	Search Options - Inquiry Grid 3.0
	Search Options - Inquiry Grid 3.0
nopanel	true

Fields

Description

Checkbox

Used to select one or more records.

CurrencyAmount

Currency

Insert excerpt

Currency

Amount - Extended
	Amount - Extended
nopanel	true

This

This is required and comes from the

'Currency ID

'Extended' column on the

'Properties' tab

Item grid of the Invoice/Credit Memo Record View

. This is not editable on the transaction. Insert excerptDef - CurrencyDef - Currencynopaneltrue

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK

Distributed To

and is calculated by multiplying the Quantity and Price of the transaction line. This can only be edited by changing the Quantity and/or Price of the transaction line. Positive lines represent a purchase and negative lines represent a purchase credit.

Database Field: ERPx_APTransactionLine.ExtendedAmount

Currency ID

Distributed To - Vendor

Insert excerpt

Distributed To - Vendor

Currency
	Currency
nopanel	true

This can be edited This is required and comes from the 'Distributed ToCurrency ID' on the Item grid 'Properties' tab of the Invoice/Credit Memo Record View. This is always not editable while on the transaction is in a Status of New..

Insert excerpt

	Def - Currency
	Def - Currency
nopanel	true

Database Fields: ERPx_APVendorMFCurrency.VendorNameCurrencyID, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK

Distributed To Type

APTransactionHeader.CurrencySK

DescriptionDistributed To Type

Insert excerpt

Distributed To Type

Description - Header
	Description - Header
nopanel	true

This is

derived

not required and can be edited from the '

Distributed To

Description' on the

Item grid

'Home' tab of the Invoice/Credit Memo Record View.

Because this defaults from the Vendor, Employee or Project, it is not editable on the transaction

This is always editable, even after the transaction is Posted.

Database Field: ERPx_

APTransactionLine

APTransactionHeader.

ToMFDistributionTypeEN

Description

Doc DateDistributed To

Doc Date

Insert excerpt

Doc Date

Distributed To - Vendor
	Distributed To - Vendor
nopanel	true

This This is not required and can be edited from the 'Doc DateDistributed To' on the 'Home' tab Item grid of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc Description

Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK

Distributed Type

Description - Header

Insert excerpt

Description - Header

Distributed To Type
	Distributed To Type
nopanel	true

This can be edited is not required and is derived from the 'Description' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable, even after the transaction is Posted'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. Because this defaults from the Project, Employee, Fisherman, Tender or Loan, it is only editable by changing the Distributed To field on the transaction. This contains the associated value in the MFDistributionType Enumeration Class.

Database Field: ERPx_APTransactionHeaderAPTransactionLine.DescriptionToMFDistributionTypeEN

Doc NoDate

Insert excerpt

	Doc

No

Date
	Doc

No

Date
nopanel	true

This is required and can be edited from the 'Doc NoDate' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the transaction/Invoice # assigned by your Vendor. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.DocNumberTransactionDate

Extended Doc NoAmount - Extended

Insert excerpt

Amount - Extended

Doc No
	Doc No
nopanel	true

This comes

This is required and can be edited from the '

Extended

Doc No' on the

Item grid

'Home' tab of the Invoice/Credit Memo Record View and

is calculated based on the product of the Quantity and Price of the transaction line. This can only be edited by changing the Quantity and/or Price of the transaction line

represents the transaction/Invoice # assigned by your Vendor. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_

APTransactionLine

APTransactionHeader.

ExtendedAmount

DocNumber

GL Date

Insert excerpt

	GL Date
	GL Date
nopanel	true

This This is required and can be edited from the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. If not manually edited, this will be automatically set to match the 'Doc Date' when the transaction is saved with a Status of either Approved or Ready to Post. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.GLDate

GL Period

Insert excerpt

	GL Period
	GL Period

GL Period


nopanel	true

This is required and calculated using the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This can only be edited by changing the GL Date.

GL Year

Insert excerpt

	GL Year
	GL Year
nopanel	true

This is required and calculated using the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This can only be edited by changing the GL Date.

GL Year

Item Added

Insert excerpt

	Item Added (Date/Time)
	Item Added (Date/Time)
nopanel	true

Item Added ByGL Year

Insert excerpt

GL Year

Item Added By
	Item Added By
nopanel	true

This can only be edited by changing the GL Date.

Item Description

Insert excerpt

	Description - Item
	Description - Item
nopanel	true

This is required and can be edited from the 'Description' on the Item grid of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New or Approved.Database Field: ERPx_APTransactionLine.LineDescriptioneven after the transaction is posted.

Database Field: ERPx_APTransactionLine.LineDescription

Item Last Updated

Insert excerpt

	Item Last Updated (Date & Time)
	Item Last Updated (Date & Time)
nopanel	true

Item Last Updated By

Insert excerpt

	Last Updated By
	Last Updated By
nopanel	true

Payable Account

Insert excerpt

	Payable Account
	Payable Account
nopanel	true

This is required and comes from the Vendor's 'Accounts Payable' on the 'Accounts' tab of the Vendors List View. Because this defaults from the Vendor, it is not editable on the transaction.

Insert excerpt

	Def -

Posting

GL Account -

A/P Account

Accounts Payable
	Def -

Posting

GL Account -

A/P Account

Accounts Payable
nopanel	true

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.APGLAcctRef

Payable Account Description

Insert excerpt

	Payable Account Description
	Payable Account Description
nopanel	true

This is required and comes from the Vendor's 'Accounts Payable' on the 'Accounts' tab of the Vendors List View. Because this defaults from the Vendor, it is not editable on the transaction..

Insert excerpt

	Def - GL Account - Accounts Payable
	Def - GL Account - Accounts Payable
nopanel	true

Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef

Pmt./Apply Hold

Displays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold. This is not required and can be edited from the 'Pmt./Apply Hold' on the 'Properties' tab of the Invoice/Credit Memo Record View. This is always editable, even for posted transactions as long as they have not yet been fully applied.

Invoices on hold will not be selected for payment when building AP Check Batches.
Credit Memos on hold cannot be selected to apply to open Invoice

Database Field: ERPx_APTransactionHeader.IsOnApplicationHold

PO

Insert excerpt

	Purchase Order
	Purchase Order
nopanel	true

This is not required and can be edited from the 'PO' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the purchase order you used when making the purchase. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.PurchaseOrderID

Price

Insert excerpt

	Price
	Price
nopanel	true

This is required and can be edited from the 'Price' on the Item grid of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New.

Database FieldFields: ERPx_APTransactionLine.Price

Purchase Account

Insert excerpt

	Purchase Account - Item
	Purchase Account - Item
nopanel	true

This is required and can be edited from the 'Purchase Account' on the Item grid of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New. Insert excerptDef - Posting GL Account - Purchase AccountDef - Posting GL Account - Purchase Accountnopaneltrue

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK

Purchase Account Description

Insert excerpt

	Purchase Account Description
	Purchase Account Description
nopanel	true

This is not editable, it only changes if required and can be edited from the 'Purchase Account' on the Item grid of the Invoice/Credit Memo Record View is changedthe Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New.

Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK

Quantity

Insert excerpt

	Quantity
	Quantity
nopanel	true

This is required and can be edited from the 'Quantity' on the Item grid of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New.

Database FieldFields: ERPx_APTransactionLine.Quantity

Status

Insert excerpt

	Status
	Status
nopanel	true

This can be edited from the 'Status' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the status of the transaction. This is always editable while the transaction is in a Status of 'New' or 'Approved'. Insert excerptDef - StatusDef - Statusnopaneltrue The Statuses that apply to transaction in this List View include: Insert excerptDef - Status - NewDef - Status - Newnopaneltruein a Status of 'New' or 'Approved'.

Insert excerpt

	Def - Status - Approved
	Def - Status - Approved
nopanel	true

Insert excerpt

Def - Status - Ready to Post

nopanel

true

Insert excerpt

Def - Status - Posted

nopanel

true

The Statuses that apply to transaction in this List View include:

Insert excerpt

	Def - Status - VoidPosted
	Def - Status - VoidPosted
nopanel	true

Insert excerpt

	Def - Status - DeletedVoid
	Def - Status - DeletedVoid
nopanel	true

Insert excerpt

	Def - Status - Replaced
	Def - Status - Replaced
nopanel	true

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Insert excerpt

	Transaction ID
	Transaction ID
nopanel	true

Clicking on this link opens the AP Invoice / Credit Memo Record View for the selected record. This is a system assigned number that comes from the 'Transaction Class' and is required but is not editable by users.

Insert excerpt

	Def - Transaction ID
	Def - Transaction ID
nopanel	true

Database Field: ERPx_APTransactionHeader.TransactionHeaderIDTransactionID

Transaction Class

Insert excerpt

	Transaction Class
	Transaction Class
nopanel	true

This is required and comes from the 'Transaction Class' on the 'Properties' tab of the Invoice/Credit Memo Record View. This is not editable.

Insert excerpt

	Def - Transaction Class
	Def - Transaction Class
nopanel	true

Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK

Transaction Type

Insert excerpt

	Transaction Type
	Transaction Type
nopanel	true

This is required and comes from the Transaction Type selected when starting a new transaction (Invoice or Credit Memo). This is not never editable.

Insert excerpt

	Def - Transaction Types
	Def - Transaction Types
nopanel	true

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

UOM

Insert excerpt

	UOM - Units
	UOM - Units
nopanel	true

This is not required and can be edited from the 'UOM' on the Item grid of the Invoice/Credit Memo Record View. This is always only editable while the transaction is in a Status of New. Insert excerptDef - UOMDef - UOMnopaneltrue

Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK

Vendor Class

Insert excerpt

	Vendor

ID

Class
	Vendor

ID

Class
nopanel	true

This

represents the ID of

is required and comes from the 'Vendor Class' assigned to the 'Vendor' that is selected on the 'Home' tab of the Invoice/Credit Memo Record View.

This is only editable by changing the Vendor assigned to the

Because this defaults from the Vendor it is not editable on the transaction.

Insert excerpt

	Def - Vendor

ID

Class
	Def - Vendor

ID

Class
nopanel	true

Database

Fields

Field: ERPx_

APVendor

APVendorClass.

VendorID

ClassDescription, ERPx_APTransactionHeader.VendorSK

Vendor ClassID

Insert excerpt

	Vendor

Class

ID
	Vendor

Class

ID
nopanel	true

This comes from the 'Vendor Class' assigned to is required and represents the ID of the 'Vendor' that is selected on the 'Home' tab of the Invoice/Credit Memo Record View. This is only editable by changing the Vendor assigned to the transaction.

Insert excerpt

	Def - Vendor

Class

ID
	Def - Vendor

Class

ID
nopanel	true

Database Fields: ERPx_APVendorClassAPVendor.ClassDescriptionVendorID, ERPxERPx_APTransactionHeader.VendorSK

Vendor Name

Insert excerpt

	Vendor Name
	Vendor Name
nopanel	true

This is required and represents the name of the 'Vendor' on the 'Home' tab of the Invoice/Credit Memo Record View. This is only editable by changing the Vendor assigned to the transaction.

Insert excerpt

	Def - Vendor Name
	Def - Vendor Name
nopanel	true

Database Fields: ERPx_APVendor.VendorName, ERPxERPx_APTransactionHeader.VendorSK

Versions Compared

Old Version 28

New Version 29

Key

Page Header

Search

Page Detail

Related Topics

Page Definitions

Page Comparison

Versions Compared

Old Version 28

New Version 29

Key

Page Header

Search

Page Detail

Related Topics

Page Definitions