Insert excerptDef - Trans - AP Invoice/Credit MemoDef - Trans - AP Invoice/Credit Memonopaneltrue The purpose of this page is to show line item detail for all these unposted transactions.

This list view also contains columns for each Attribute that is set up for the 'AP Purchasing' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. AP Purchasing attributes are not included in the help documentation.

Software Version: 2020.06.05 and newer

Table of Contents

type	flat

Page Header

...

Invoice: A transaction to record a purchase you are making from a Vendor.
Credit Memo: A transaction to record a return/refund you are getting from Vendor.

...

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 unposted transactions.

This list view also contains columns for each Attribute that is set up for the 'AP Purchasing' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. AP Purchasing attributes are not included in the help documentation.

Software Version: 2020.06.05 and newer

Table of Contents

type	flat

Page Header

Database FieldsDatabase Field: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySKTransactionDate

Toolbar Icons

Description

Edit

Insert excerpt

	Edit - LV
	Edit - LV
nopanel	true

Excel

Insert excerpt

	Excel - LV
	Excel - LV
nopanel	true

Favorites

Insert excerpt

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

Grid Layout

Insert excerpt

	Grid Layout - Global
	Grid Layout - Global
nopanel	true

Help

Insert excerpt

	Help - Global
	Help - Global
nopanel	true

New

Insert excerpt

	New - Multi-Select Trans Type - Global
	New - Multi-Select Trans Type - Global
nopanel	true

Invoice: A transaction to record a purchase you are making from a Vendor.
Credit Memo: A transaction to record a return/refund you are getting from Vendor.

Fields

Description

Checkbox

Insert excerpt

	Checkbox
	Checkbox
nopanel	true

Currency

Insert excerpt

	Currency
	Currency
nopanel	true

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
nopanel	true

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK

Distributed To

Insert excerpt

	Distributed To - Vendor
	Distributed To - Vendor
nopanel	true

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 To Type

Insert excerpt

	Distributed To Type
	Distributed To Type
nopanel	true

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
nopanel	true

This is required and comes can be edited from the 'Currency IDDoc Date' on the 'PropertiesHome' tab of the Invoice/Credit Memo Record View. This is not always editable on the transaction.excerpt-include

Def - Currency

nopanel

true

Distributed ToDoc Description

Insert excerpt

Distributed To

	Description -

Vendor

Header

Distributed To

	Description -

Vendor

Header
nopanel	true

This is not required and can be edited from the '

Distributed To

Description' on the

Item grid

'Home' tab of the Invoice/Credit Memo Record View. This is always editable

while

, even after the transaction is

in a Status of New

Posted.

Database

Fields

Field: ERPx_

APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSKDistributed To Type

APTransactionHeader.Description

Doc No

Distributed To Type

Insert excerpt

Distributed To Type

Doc No
	Doc No
nopanel	true

This

This is

not

required and

is derived

can be edited from the '

Distributed To

Doc No' on the

Item grid

'Home' tab 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

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_

APTransactionLine

APTransactionHeader.

ToMFDistributionTypeEN

DocNumber

Doc DateExtended

Insert excerpt

	Doc Date	Doc DateAmount - Extended
	Amount - Extended
nopanel	true

This is required and can be edited comes from the 'Doc DateExtended' on the 'Home' tab Item grid of the Invoice/Credit Memo Record View . This is always editableand 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_APTransactionHeaderAPTransactionLine.TransactionDateExtendedAmount

Doc DescriptionGL Date

Insert excerpt

	Description - Header	Description - HeaderGL Date
	GL Date
nopanel	true

This is not required and can be edited from the 'DescriptionGL Date' on the 'HomeProperties' tab of the Invoice/Credit Memo Record View. This . 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 , even after the transaction is Postedwhile the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.DescriptionGLDate

Doc NoGL PeriodDoc No

Insert excerpt

Doc No

GL Period
	GL Period
nopanel	true

This is required and can be edited from calculated using the 'Doc NoGL Date' on the the 'HomeProperties' 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

Extended. This can only be edited by changing the GL Date.GL Year

Insert excerpt

	Amount - Extended	Amount - ExtendedGL Year
	GL Year
nopanel	true

This is required and comes from calculated using the 'Extended' on the Item grid of the Invoice/Credit Memo Record View and is calculated by multiplying the Quantity and Price of the transaction lineGL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. 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

GL Date

GL Date.

Item DescriptionGL Date

Insert excerpt

GL Date

Description - Item
	Description - Item
nopanel	true

This is required and can be edited from the '

GL Date

Description' on the

'Properties' tab

Item grid 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

This is always editable.

Database Field: ERPx_

APTransactionHeader

APTransactionLine.

GLDate

LineDescription

GL PeriodPayable AccountGL Period

Insert excerpt

GL Period

Payable Account
	Payable Account
nopanel	true

This is required and

calculated using the 'GL Date' on the 'Properties

comes from the Vendor's 'Accounts Payable' on the 'Accounts' tab of the

Invoice/Credit Memo Record View. This can only be edited by changing the GL Date.GL Year

Vendors List View. Because this defaults from the Vendor, it is not editable on the transaction.

GL Year

Insert excerpt

GL Year

Def - GL Account - Accounts Payable
	Def - GL Account - Accounts Payable
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.

Item

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.APGLAcctRef

Payable Account Description

Insert excerpt

	Payable Account Description

- Item


	Payable Account Description

- Item


nopanel	true

This is required and can be edited comes from the Vendor's 'DescriptionAccounts Payable' on the Item grid 'Accounts' tab of the Invoice/Credit Memo Record View. This is always editable.

Database Field: ERPx_APTransactionLine.LineDescription

Payable Account

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

Payable Accountnopaneltrue 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 excerptDef - GL Account - Accounts PayableDef - GL Account - Accounts Payablenopaneltrue

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.APGLAcctRef

Payable Account Description

Insert excerptPayable Account DescriptionPayable Account Description

- 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

comes

can be edited from the

Vendor

'

s

PO'

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 excerptDef - GL Account - Accounts PayableDef - GL Account - Accounts Payablenopaneltrue

Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef

Pmt./Apply HoldDisplays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold. This is not

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 '

Pmt./Apply Hold

Price' on

the 'Properties' tab

the Item grid 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

is always editable while the transaction is in a Status of New.

Database Fields: ERPx_APTransactionLine.Price

Purchase Account

Insert excerpt

	Purchase

Order

Account - Item
	Purchase

Order

Account - Item
nopanel	true

This is

not

required and can be edited from the '

PO

Purchase Account' on the

'Home' tab

Item grid 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:

Fields: ERPx_GLAccount.AccountNumber, ERPx_

APTransactionHeader.PurchaseOrderIDPrice

APTransactionLine.AccountSK

Purchase Account Description

Insert excerpt

	Price	PricePurchase Account Description
	Purchase Account Description
nopanel	true

This This is required and can be edited from the 'PricePurchase 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.PriceAccountSK

Purchase AccountQuantity

Insert excerpt

	Purchase Account - Item	Purchase Account - ItemQuantity
	Quantity
nopanel	true

This is required and can be edited from the 'Purchase AccountQuantity' 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.AccountSKQuantity

Purchase Account DescriptionStatusQuantityQuantitynopaneltrue 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

	Purchase Account Description	Purchase Account DescriptionStatus
	Status
nopanel	true

This This is required and can be edited from the 'Purchase AccountStatus' on the Item grid '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.

Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK

Quantity Insert excerpt

Insert excerptStatusStatusnopaneltrue This is required and 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 transactions in this List View include: Insert excerptDef - Status - NewDef - Status - Newnopaneltrue Insert excerptDef - Status - ApprovedDef - Status - ApprovednopaneltrueDatabase Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSKeditable while the transaction is in a Status of 'New' or 'Approved'.

Insert excerpt

	Def - Status
	Def - Status
nopanel	true

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

Insert excerpt

	Def - Status - New
	Def - Status - New
nopanel	true

Insert excerpt

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

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Trans Created

Insert excerpt

	Created
	Created
nopanel	true

Linked Database Field: ERPx_APTransactionHeader.CreatedDate

Trans Created By

Insert excerpt

	Created By
	Created By
nopanel	true

Linked Database Field: ERPx_APTransactionHeader.CreatedBy

Trans Last Updated

Insert excerpt

	Last Updated
	Last Updated
nopanel	true

Linked Database Field: ERPx_APTransactionHeader.LastUpdated

Trans Last Updated By

Insert excerpt

	Last Updated By
	Last Updated By
nopanel	true

Linked Database Field: ERPx_APTransactionHeader.LastUser

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.TransactionID

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. This is 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 editable while the transaction is in a Status of New.

Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK

Vendor

Insert excerpt

	Vendor ID
	Vendor ID
nopanel	true

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
nopanel	true

Database Fields: ERPx_APVendor.VendorID ,ERPx_APTransactionHeader.VendorSK

Vendor Class

Insert excerpt

	Vendor Class
	Vendor Class
nopanel	true

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
nopanel	true

Database Field: ERPx_APVendorClass.ClassDescription, ERPx_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 ,ERPx_APTransactionHeader.VendorSK

...

Versions Compared

Old Version 32

New Version 33

Key

Page Header

Page Header

Page Comparison

Versions Compared

Old Version 32

New Version 33

Key

Page Header

Page Header