Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Def - Trans - AP Invoice/Credit Memo
Def - Trans - AP Invoice/Credit Memo
nopaneltrue
 The purpose of this page is to show line item detail for all these transactions.

...

Table of Contents
typeflat

Page Header

Filter ItemsDescription
Also Include

Insert excerpt
Inq - Include
Inq - Include
nopaneltrue

  • Voids & Replaced
Date Option

Insert excerpt
Date Type Lookup
Date Type Lookup
nopaneltrue

  • Doc Date
  • GL Date
Date Range
Insert excerpt
Date Control Text Box
Date Control Text Box
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue
 

  • View in PaperVision

This toolbar icon is only visible when the preferences for PaperVision are configured.

Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

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

Insert excerpt
Inq - Transaction Class
Inq - Transaction Class
nopaneltrue
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
nopaneltrue

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
nopaneltrue

The lookup contains a list of all 'Active' Vendors

Vendor Class

Insert excerpt
Inq - Vendor Class
Inq - Vendor Class
nopaneltrue
 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
nopaneltrue

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

Page Detail

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue

  • RV: Transaction. Opens the Transaction Record View.
  • Void Transaction. 
    Insert excerpt
    Void - Global
    Void - Global
    nopaneltrue
     
Print

Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
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
nopaneltrue
Refresh
Insert excerpt
Refresh - Global
Refresh - Global
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
Search Option
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue
FieldsDescription
CheckboxUsed to select one or more records.
Amount

Insert excerpt
Amount - Extended
Amount - Extended
nopaneltrue
This is required and comes from the 'Extended' column on the Item grid of the Invoice/Credit Memo Record View 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


Insert excerpt
Currency
Currency
nopaneltrue
 This is required and comes from the 'Currency ID' on the 'Properties' tab of the Invoice/Credit Memo Record View. This is not editable on the transaction.

Insert excerpt
Def - Currency
Def - Currency
nopaneltrue

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK

Description

Insert excerpt
Description Comment - HeaderDescription
Comment - Header
nopaneltrue
 This is not required and can be edited from the 'Description' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable, even after the transaction is Posted.

Database Field: ERPx_APTransactionHeader.Description

Distributed To

Insert excerpt
Distributed To - Vendor
Distributed To - Vendor
nopaneltrue
This is not required and can be edited from the 'Distributed To' 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 Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK

Distributed Type

Insert excerpt
Distributed To Type
Distributed To Type
nopaneltrue
 This is not required and is derived from the '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_APTransactionLine.ToMFDistributionTypeEN

Doc Date

Insert excerpt
Doc Date
Doc Date
nopaneltrue
 This is required and can be edited from the 'Doc Date' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
 This is required and can be edited from the 'Doc No' 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.DocNumber

GL Date

Insert excerpt
GL Date
GL Date
nopaneltrue
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
nopaneltrue
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
nopaneltrue
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.

Item Added
Insert excerpt
Item Added (Date/Time)
Item Added (Date/Time)
nopaneltrue
Item Added By
Insert excerpt
Item Added By
Item Added By
nopaneltrue
Item Description

Insert excerpt
Description - Item
Description - Item
nopaneltrue
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 even 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)
nopaneltrue
Item Last Updated By
Insert excerpt
Last Updated By
Last Updated By
nopaneltrue
Payable Account

Insert excerpt
Payable Account
Payable Account
nopaneltrue
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
nopaneltrue

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.APGLAcctRef

Payable Account Description

Insert excerpt
Payable Account Description
Payable Account Description
nopaneltrue
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
nopaneltrue

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
nopaneltrue
 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
nopaneltrue
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 Fields: ERPx_APTransactionLine.Price

Purchase Account

Insert excerpt
Purchase Account - Item
Purchase Account - Item
nopaneltrue
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. 

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK

Purchase Account Description

Insert excerpt
Purchase Account Description
Purchase Account Description
nopaneltrue
 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. 

Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK

Quantity

Insert excerpt
Quantity
Quantity
nopaneltrue
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 Fields: ERPx_APTransactionLine.Quantity

Status

Insert excerpt
Status
Status
nopaneltrue
 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 excerpt
Def - Status
Def - Status
nopaneltrue
 The Statuses that apply to transaction in this List View include:

Insert excerpt
Def - Status - Posted
Def - Status - Posted
nopaneltrue

Insert excerpt
Def - Status - Void
Def - Status - Void
nopaneltrue

Insert excerpt
Def - Status - Replaced
Def - Status - Replaced
nopaneltrue

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
 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
nopaneltrue

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Class

Insert excerpt
Transaction Class
Transaction Class
nopaneltrue
 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
nopaneltrue

Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK

Transaction Type

Insert excerpt
Transaction Type
Transaction Type
nopaneltrue
 This is required and comes from the Transaction Type selected when starting a new transaction. This is never editable.

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

UOM

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

Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK

Vendor Class

Insert excerpt
Vendor Class
Vendor Class
nopaneltrue
 This 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. Because this defaults from the Vendor it is not editable on the transaction.

Insert excerpt
Def - Vendor Class
Def - Vendor Class
nopaneltrue

Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK

Vendor ID

Insert excerpt
Vendor ID
Vendor ID
nopaneltrue
 This is required and represents the ID 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 ID
Def - Vendor ID
nopaneltrue

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

Vendor Name

Insert excerpt
Vendor Name
Vendor Name
nopaneltrue
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
nopaneltrue

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

...