Page Comparison

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: YYYY.MM.DD and newer

...

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

Currency

Insert excerpt

	Currency - LV
	Currency - LV
nopanel	true

This comes from the 'Currency ID' on the 'Properties' tab of the Invoice/Credit Memo Record View. This defaults from the Currency setup on the Vendor and 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

	Def Distributed To - Not DefinedLVDef
	Distributed To - Not DefinedLV
nopanel	true

This This comes from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is always editable while the transaction is in a Status of New.

Insert excerpt

	Def - Not Defined
	Def - Not Defined
nopanel	true

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

Distributed To Type

Insert excerpt

	Def - Not Defined	Def - Not DefinedDistributed To Type - LV
	Distributed To Type - LV
nopanel	true

This This is derived from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. Because this defaults from the Vendor, Employee or Project, it is not editable on the transaction. This contains the associated value in the MFDistributionType Enumeration Class.

Database Field: ERPx_APTransactionLine.ToMFDistributionTypeEN

Doc Date

Insert excerpt

	Doc Date - LV
	Doc Date - LV
nopanel	true

This comes from the 'Doc Date' on the 'Home' tab of the Invoice/Credit Memo Record View. This defaults from the current date and is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc Description

Insert excerpt

	Doc Description - LV
	Doc Description - LV
nopanel	true

This comes from the 'Description' on the 'Home' tab of the Invoice/Credit Memo Record View. This defaults as blank and is always editable, even after the transaction is Posted.

Database Field: ERPx_APTransactionHeader.Description

Doc No

Insert excerpt

	Doc No - LV
	Doc No - LV
nopanel	true

This comes 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 defaults as blank and is required. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.DocNumber

Extended

Insert excerpt

	Def - Not Defined
	Def - Not Defined
nopanel	true

This comes from the 'Extended' on the Item grid 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.

Database Fields: ERPx_APTransactionLine.ExtendedAmount

GL Date

Insert excerpt

	GL Date - LV
	GL Date - LV
nopanel	true

This comes from the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This defaults as blank and if not manually edited, 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 - LV
	GL Period - LV
nopanel	true

This is a calculated field 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 - LV
	GL Year - LV
nopanel	true

This is a calculated field 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 Description

Insert excerpt

	Def - Not Defined
	Def - Not Defined
nopanel	true

This comes from the 'Description' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is always editable while the transaction is in a Status of New or Approved.

Database Field: ERPx_APTransactionLine.LineDescription

Payable Account

Insert excerpt

	Def Payable Account - Not DefinedLVDef
	Payable Account - Not DefinedLV
nopanel	true

This 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 - Not Defined
	Def - Not Defined
nopanel	true

Database Fields: ERPx_GLAccount.AccountSK, ERPx_APVendor.APGLAcctRef

Payable Account Description

Def - Not Defined

Insert excerpt

Def - Not Defined

Payable Account Description - LV
	Payable Account Description - LV
nopanel	true

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

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 comes from the 'Pmt./Apply Hold' on the 'Properties' tab of the Invoice/Credit Memo Record View. This defaults as blank and 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 - LV
	Purchase Order - LV
nopanel	true

This comes 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 defaults as blank and is not required. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.PurchaseOrderID

Price

Insert excerpt

	Def - Not Defined
	Def - Not Defined
nopanel	true

This comes from the 'Price' on the Item grid of the Invoice/Credit Memo Record View. This defaults as "0.00" and is not required. This is always editable while the transaction is in a Status of New.

Database Fields: ERPx_APTransactionLine.Price

Purchase Account

Insert excerpt

	Def Purchase Account - Not DefinedLVDef
	Purchase Account - Not DefinedLV
nopanel	true

This comes from the 'Purchase Account' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is not required. This is always editable while the transaction is in a Status of New.

Insert excerpt

	Def - Not Defined
	Def - Not Defined
nopanel	true

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK

Purchase Account Description

Insert excerpt

	Def - Not Defined	Def - Not DefinedPurchase Account Description - LV
	Purchase Account Description - LV
nopanel	true

This This comes from the 'Purchase Account' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is not required. This is always editable while the transaction is in a Status of New.

Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK

Quantity

Insert excerpt

	Def - Not Defined
	Def - Not Defined
nopanel	true

This comes from the 'Quantity' on the Item grid of the Invoice/Credit Memo Record View. This defaults as "1.00" and is not required. This is always editable while the transaction is in a Status of New.

Database Fields: ERPx_APTransactionLine.Quauntity

Status

This needs to be updated to only have statuses of New, Approved and Ready to Post.

This comes from the 'Status' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the status of the transaction. This defaults as 'New' and is required. This is always editable while the transaction is in a Status of 'New' or 'Approved'.

Insert excerpt

	Def - Status - all exc. Sales Order
	Def - Status - all exc. Sales Order
nopanel	true

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Insert excerpt

	Transaction ID - LV
	Transaction ID - LV
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

	Def - Transaction Class
	Def - Transaction Class
nopanel	true

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

Database Fields: ERPx_APTransactionClass.TransactionClassDescription ,ERPx_APTransactionHeader.TransactionClassSK

Transaction Type

Insert excerpt

	Def - Transaction Types
	Def - Transaction Types
nopanel	true

This comes from the Transaction Type selected when starting a new transaction. This is never editable.

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

UOM

Insert excerpt

	Def Units UOM - Not DefinedLVDef
	Units UOM - Not DefinedLV
nopanel	true

This This comes from the 'UOM' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is not required. This is always editable while the transaction is in a Status of New.

Insert excerpt

	Def - Not Defined
	Def - Not Defined
nopanel	true

Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK

Vendor

Insert excerpt

	Def - Vendor ID
	Def - Vendor ID
nopanel	true

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

Database Fields: ERPx_APVendor.VendorID ,ERPx_APTransactionHeader.VendorSK

Vendor Class

Insert excerpt

	Def - Vendor Class
	Def - Vendor Class
nopanel	true

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

Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK

Vendor Name

Insert excerpt

	Def - Vendor Name
	Def - Vendor Name
nopanel	true

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

Database Fields: ERPx_APVendor.VendorName ,ERPx_APTransactionHeader.VendorSK

Versions Compared

Old Version 16

New Version 17

Key