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

Software Version: YYYY.MM.DD and newer

Table of Contents

type	flat

Page Header

...

Date From: a text box to enter a starting Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
Date To: a text box to enter an ending Transaction 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".

...

Insert excerpt

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

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

Software Version: 2023.08.31 and newer

Table of Contents

type	flat

Page Header

Search

Filter Items

Description

Auto Hide Filters

Insert excerpt

	Auto Hide Filters
	Auto Hide Filters
nopanel	true

Auto Refresh on Open

Insert excerpt

	Auto Refresh on Open
	Auto Refresh on Open
nopanel	true

Also Include

Insert excerpt

	Inq - Include
	Inq - Include
nopanel	true

Voids & Replaced
Unposted Transactions

Date Option

Insert excerpt

	Date Type Lookup
	Date Type Lookup
nopanel	true

Doc Date
GL Date

Date Range

Insert excerpt

	Date Control Text Box
	Date Control Text Box
nopanel	true

Saved Searches

Insert excerpt

	Search Options for Framework 3.0 - Global
	Search Options for Framework 3.0 - Global
nopanel	true

Search

Insert excerpt

	Search - Search Options
	Search - Search Options
nopanel	true

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

Transaction Class

Insert excerpt

	Inq - Transaction Class
	Inq - Transaction Class
nopanel	true

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

Database Fields: ERPx_MFCurrency.CurrencyID, 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.CurrencySKDocNumber

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

IQ: PO Linked Lines -Opens an inquiry with all the Purchase Orders, AP Invoices, AP Credit Memos, and Inventory Receipt lines with this Purchase Order assigned.
RV: Transaction. Opens the Transaction Record View in a new Tab.
RV: Purchase Order - Opens the record view of the Purchase Order. If there is not a linked PO, a message will appear indicating "There is no Purchase Order for this transaction."
Void Transaction: Opens the Void Transaction Window.
View in PaperVision - This option is only visible when the preferences for PaperVision are configured.

Print

Insert excerpt

	Print - LV 3.0
	Print - LV 3.0
nopanel	true

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 Options

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.

1099 Amount

Identifies the amount applicable to the Vendor's 1099 statement amount. This is a numeric text box that is not required and defaults as follows:

If the 1099 Type is set to "No 1099", the 1099 Amount is blank and not editable
If the 1099 Type is set to any value other than "No 1099" the 1099 Amount will default to the "Amount" value for the corresponding line item but can be overwritten to a value less than the "Amount" value. If a value is entered that is more than this amount, it will default back to the "Amount" value for the line item. This is always editable even after the transaction is posted.

If the 1099 Type value is updated to "No 1099", the 1099 Amount value will be cleared, and if a 1099 Amount is entered manually by the user when the line item is added, the 1099 Amount will not default from or be updated to the line "Amount".

Database Field: ERPx_APTransactionLine.TenNinetyNineAmount

1099 Type

Insert excerpt

	Def - 1099 Type
	Def - 1099 Type
nopanel	true

This is a single-select lookup that defaults from the 1099 Type of the Vendor assigned to the transaction. This is required and is always editable even after the transaction is posted.

This lookup contains all the values in the ERPx_APTenNinetyNineType table.

Database fields: ERPx_APTenNinetyNineType.TenNinetyNineTypeDescription, ERPx_APVendor.TenNinetyNineTypeSK, ERPx_APTransactionLine.TenNinetyNineTypeSK

Amount

Insert excerpt

	Amount - Extended
	Amount - Extended
nopanel	true

This is required and is calculated as [Quantity] * [Price] for each 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

Comment

Insert excerpt

	Line Item Comment
	Line Item Comment
nopanel	true

This is not required and can be edited from the 'Comment' 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

Currency

Insert excerpt

	Currency
	Currency
nopanel	true

This is required and comes from the 'Currency' 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 Type

Insert excerpt

	Distributed To Type
	Distributed To Type
nopanel	true

(Project, Fisherman, Tender or Loan). This is not required and is derived from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. This 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 can be edited from the 'Doc Date' 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.TransactionDate

Doc No

Insert excerpt

	Doc No
	Doc No
nopanel	true

This is required and can be edited from the 'Doc No' on the 'Home' 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

nopanel

true

Distributed ToGL Date

Distributed To

Insert excerpt

Distributed To

GL Date
	GL Date
nopanel	true

This

comes

is required and can be edited from the '

Distributed To

GL Date' on the

Item grid of the Invoice/Credit Memo Record View. This defaults as blank and

'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 PeriodDef - Not Defined

Insert excerpt

Def - Not Defined

GL Period
	GL Period
nopanel	true

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

Distributed To Type

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

	Distributed To Type	Distributed To TypeGL Year
	GL Year
nopanel	true

This is derived from This is required and calculated using the 'Distributed ToGL Date' on the Item grid the 'Properties' 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 contains the associated value in the MFDistributionType Enumeration ClassThis can only be edited by changing the GL Date.

Item Description

Insert excerpt

	Item Description
	Item Description
nopanel	true

This is required.

Database Field: ERPx_APTransactionLine.ToMFDistributionTypeEN

Doc Date

ItemSK, ERPx_IMItem.ItemDescription

Item ID

Doc Date

Insert excerpt

Doc Date

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

This is required.

Database Field: ERPx_

APTransactionHeader.TransactionDateDoc Description

APTransactionLine.ItemSK, ERPx_IMItem.ItemID

Item Last UpdatedDoc Descriptionnopaneltrue 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.

Insert excerpt

Doc Description

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

Database Field: ERPx_

APTransactionHeader

APTransactionLine.

DescriptionDoc No

LastUpdated

Item Last Updated Bynopaneltrue 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.

Insert excerpt

Doc NoDoc No

Last Updated By
	Last Updated By
nopanel	true

Database Field: ERPx_

APTransactionHeader

APTransactionLine.

DocNumber

LastUser

Extended

Item Type

Extended

Insert excerpt

Extended

HELP:Item Type: Inventory
	HELP:Item Type: Inventory
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 Field: ERPx_APTransactionLine.ExtendedAmount

GL Date

This is required.

Line Comment

GL Date

Insert excerpt

GL Date

Line Item Comment
	Line Item Comment
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

This is not required and is always editable even after the transaction is posted.

Database Field: ERPx_

APTransactionHeader

APTransactionLine.

GLDate

LineComment

GL PeriodLine Description

GL Period

Insert excerpt

GL Period

Line Description
	Line Description
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 excerptGL YearGL Yearnopaneltrue 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 excerptDescription - ItemDescription - Itemtextbox that defaults to Item Description for the corresponding Item and is editable from the record view while in 'New' status.

Image Added When AP Invoices, Credit Memos are loaded from a PO, this will default as the 'Line Description' on those transactions.

Database Fields: ERPx_IMItem.ItemDescription, ERPx_APTransactionLine.LineDescription, ERPX_APPoLine.LineDescription

Ln.

Insert excerpt

	Ln. - RV Items Grid
	Ln. - RV Items Grid
nopanel	true

This is not required

Database Field: ERPx_APTransactionLine.LineNumber

Payable GL Account

Insert excerpt

	Payable Account
	Payable Account
nopanel	true

This is required and comes from the Vendor'

Description

s 'Accounts Payable' on the

Item grid

'GL Accounts' tab of the

Invoice/Credit Memo Record

Vendors List 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

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.AccountNumber, ERPx_APVendor.APGLAcctRef

Payable GL 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 'GL 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

GL Account - Accounts Payable
	Def -

Not Defined

GL Account - Accounts Payable
nopanel	true

Database Fields: ERPx_GLAccount

.AccountNumber, ERPx_APVendor.APGLAcctRefPayable Account Description Insert excerptPayable Account DescriptionPayable Account DescriptionnopaneltrueThis 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 HoldDisplays 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

.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

. 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

and represents the purchase order you used when making the purchase. This is always editable while the transaction is in a Status of New.

This field is only used for Purchase Orders setup in NorthScope. The 'Reference' field should be used to record a PO# on a transaction when the PO# does not exist in NorthScope.

Database Field: ERPx_APTransactionHeader.

IsOnApplicationHold

PurchaseOrderID

PO

Insert excerptPurchase OrderPurchase Ordernopaneltrue 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 Ln.

Identifies the Purchase Order line item that the AP Invoice/Credit Memo line item is linked to. This is a single-select lookup that is not required. This is

always

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

Image Added The Price and Quantity will not default from the Purchase Order line item.

Database Field: ERPx_

APTransactionHeader

APTransactionLine.

PurchaseOrderID

POLineSK

Price

Insert excerpt

	Price
	Price
nopanel	true

This comes is required and can be edited from the 'Price' on the Item grid of the Invoice/Credit Memo Record View. This defaults as "0.00" and is required when the Status is set to Approvedgrid 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 GL Account

Insert excerpt

	Purchase Account - Item
	Purchase Account - Item
nopanel	true

This comes is required and can be edited from the 'Purchase GL Account' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is required when the Status is set to Approved. This is always editable while the transaction is in a Status of New. Insert excerptDef - Not DefinedDef - Not Definednopaneltrue

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK

Purchase GL Account Description

Insert excerpt

	Purchase Account Description
	Purchase Account Description
nopanel	true

This

comes

is required and can be edited from the 'Purchase GL Account' on the Item grid of the Invoice/Credit

Memo Record View. This defaults as blank and is not required

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

comes

is required and can be edited 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

Field

Fields: ERPx_APTransactionLine.Quantity

Reference

Insert excerpt

	Reference
	Reference
nopanel	true

This is text box that is not required and is always editable even after the transaction is posted.

Insert excerpt

	Def - Reference #
	Def - Reference #
nopanel	true

Status

Insert excerpt

	Status
	Status
nopanel	true

This comes

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

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

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

Insert excerpt

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

Insert excerpt

	Def - Status - Approved
	Def - Status - Approved

nopaneltrueexcerpt-includeDef - Status - Ready to Post

Def - Status - Ready to Post

nopanel	true

Insert excerpt

	Def - Status - Posted
	Def - Status - Posted
nopanel	true

Insert excerpt

	Def - Status - Void
	Def - Status - Void
nopanel	true

Insert excerpt

	Def - Status -

DeletedDef - Status - Deletednopaneltrue Insert excerptDef - 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.

TransactionHeaderID

TransactionID

Transaction Class ID

Insert excerpt

Def -

	Transaction Class

Def -

	Transaction Class
nopanel	true

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

defaults as 'Default' and is not editable.

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

Def -

	Transaction

Types

Type

Def -

	Transaction

Types

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

comes

is not required and can be edited 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

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

Insert excerptDef - Not DefinedDef - Not Definednopaneltrue

Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK

Vendor Class ID

Insert excerpt

Def -

	Vendor

ID

Class

Def -

	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 transaction.Database Fields: ERPx_APVendor.VendorID

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 ClassID

Insert excerpt

Def -

	Vendor

Class

ID

Def -

	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. Because this defaults from the Vendor, it is not editable on 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_APVendorClassAPVendor.ClassDescriptionVendorID, ERPxERPx_APTransactionHeader.VendorSK

Vendor Name

Insert excerpt

Def -

	Vendor Name

Def -

	Vendor Name
nopanel	true

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

New Version Current

Key

Page Header

Page Header

Search

Page Detail

Related Topics

Page Definitions

Page Comparison

Versions Compared

Old Version 19

New Version Current

Key

Page Header

Page Header

Search

Page Detail

Related Topics

Page Definitions