Insert excerpt
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
Table of Contents | ||
---|---|---|
|
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 | ||||||
---|---|---|---|---|---|---|
|
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.06.30 and newer
Table of Contents | ||
---|---|---|
|
Page Header
Toolbar Icons | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Column Filter Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||||||||||
Edit |
| ||||||||||||||||||||||||||||||||||||||||||||||||
Excel |
| ||||||||||||||||||||||||||||||||||||||||||||||||
Favorites |
| ||||||||||||||||||||||||||||||||||||||||||||||||
Group By Show/Hide |
| ||||||||||||||||||||||||||||||||||||||||||||||||
Help |
| ||||||||||||||||||||||||||||||||||||||||||||||||
More Actions |
| ||||||||||||||||||||||||||||||||||||||||||||||||
New |
Each Transaction Type (Invoice or Credit Memo) that only has one Transaction Class is displayed as just the Transaction Type Name (e.g., Invoice). Each Transaction Type that has more than one Transaction Class is displayed as Transaction Type Name-Transaction Class Name (e.g., Invoice-Home Office). The base list of Transaction Types includes:
| ||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||
Quick Column Filter |
| ||||||||||||||||||||||||||||||||||||||||||||||||
Refresh |
| ||||||||||||||||||||||||||||||||||||||||||||||||
Saved Layouts |
| ||||||||||||||||||||||||||||||||||||||||||||||||
Fields | Description | ||||||||||||||||||||||||||||||||||||||||||||||||
Checkbox |
| ||||||||||||||||||||||||||||||||||||||||||||||||
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 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 |
This lookup contains all the values in the ERPx_APTenNinetyNineType table. Database fields: ERPx_APTenNinetyNineType.TenNinetyNineTypeDescription, ERPx_APVendor.TenNinetyNineTypeSK, ERPx_APTransactionLine.TenNinetyNineTypeSK | ||||||||||||||||||||||||||||||||||||||||||||||||
Amount |
Database Field: ERPx_APTransactionLine.ExtendedAmount | ||||||||||||||||||||||||||||||||||||||||||||||||
Comment |
Database Field: ERPx_APTransactionHeader.Description | ||||||||||||||||||||||||||||||||||||||||||||||||
Currency |
Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK | ||||||||||||||||||||||||||||||||||||||||||||||||
Distributed To |
Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK | ||||||||||||||||||||||||||||||||||||||||||||||||
Distributed Type |
Insert excerpt | Def - Currency | Def - Currency | nopanel | true | Database Field: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK APTransactionLine.ToMFDistributionTypeEN | |||||||||||||||||||||||||||||||||||||||||||
Doc Date | Distributed To - LV Distributed To - LV |
Insert excerpt | Def - Not Defined | Def - Not Defined | nopanel | true | Database Field: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK APTransactionHeader.TransactionDate | ||||||||||||||||||||||||||||||||||||||||||
Doc No | Distributed To Type - LV
| Distributed To Type - LV |
|
required and can be edited from the '
Distributed ToDoc No' 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 contains the associated value in the MFDistributionType Enumeration Classand represents the transaction/Invoice # assigned by your Vendor. This is always editable while the transaction is in a Status of New.
Database Field: ERPx_
APTransactionLineAPTransactionHeader.
ToMFDistributionTypeENDocNumber
Insert excerpt |
---|
|
|
|
This is required and can be edited from the '
DocGL Date' on the '
HomeProperties' tab of the Invoice/Credit Memo Record View.
This defaults from the current date andIf 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.
TransactionDateGLDate
Doc DescriptionInsert excerpt |
---|
|
Database Field: ERPx_APTransactionHeader.Description
Insert excerpt |
---|
|
This is required and calculated using the '
GL Date' on
the '
Properties' tab of the Invoice/Credit Memo Record View
Database Field: ERPx_APTransactionHeader.DocNumber
Extended. This can only be edited by changing the GL Date.
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APTransactionLine.ItemSK, ERPx_IMItem.ItemDescription
Item ID
Insert excerpt |
---|
|
Database Fields: ERPx_APTransactionLine.ExtendedAmount
GL DateThis is required.
Database Field: ERPx_APTransactionLine.ItemSK, ERPx_IMItem.ItemID
Insert excerpt | |||||||
---|---|---|---|---|---|---|---|
|
Database Field: ERPx_APTransactionHeader.GLDate
Database Field: ERPx_APTransactionLine.LastUpdated
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APTransactionLine.LastUser
Item Type
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Line Comment
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APTransactionLine.LineComment
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
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 | ||||||
---|---|---|---|---|---|---|
|
Database Field: ERPx_APTransactionLine.
LineDescriptionLineNumber
Payable GL Account
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Not DefinedDef - Not Defined Insert excerpt Def - GL Account - Accounts Payable Def - GL Account - Accounts Payable nopanel true
Database Fields: ERPx_GLAccount.AccountSKAccountNumber, ERPx_APVendor.APGLAcctRef
Payable GL Account Description
- LV Insert excerpt Payable Account Description
- LVPayable Account Description
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.nopanel true
Insert excerpt Def - GL Account - Accounts Payable Def - GL Account - Accounts Payable nopanel true
Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef_APVendor.APGLAcctRef
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
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.
' 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 #
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. Insert excerpt Purchase Order Purchase Order nopanel true
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.
PurchaseOrderID
PO
Insert excerpt
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
editable while the transaction is in a Status of "New".
The Price and Quantity will not default from the Purchase Order line item that is selected.
Database Field: ERPx_
APTransactionLine.
POLineSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_APTransactionLine.Price
Purchase GL Account
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK
Purchase GL Account Description
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_APTransactionLine.Quantity
Reference
This is text box that is not required and is always editable even after the transaction is posted. Insert excerpt Reference Reference nopanel true
Insert excerpt Def - Reference # Def - Reference # nopanel true
- LV Insert excerpt Status
- LVStatus
This comes 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 defaults as 'New' and is required. This is always editable while the transaction is in a Status of 'New' or 'Approved'.nopanel true
The Statuses that apply to transaction transactions in this List View include: Insert excerpt Def - Status Def - Status nopanel true
Insert excerpt Def - Status - New Def - Status - New nopanel true
Insert excerpt Def - Status - Approved Def - Status - Approved nopanel true
Approved Insert excerpt Def - Status -
ApprovedReady to Post Def - Status - Ready to Post nopanel true
Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK
- LV Insert excerpt Transaction ID
- LVTransaction ID
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.nopanel true
Insert excerpt Def - Transaction ID Def - Transaction ID nopanel true
Database Field: ERPx_APTransactionHeader.TransactionID
Transaction Class ID
Insert excerpt
Transaction Class
This is required and comes from the 'Transaction Class ID' on the 'Properties' tab of the Invoice/Credit Memo Record View. This Transaction Class nopanel true
is not editable.
Insert excerpt Def - Transaction Class Def - Transaction Class nopanel true
Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK
Def - Insert excerpt
TypesTransaction
Def - Type
TypesTransaction
This is required and comes from the Transaction Type selected when starting a new transaction. This is never editable.new transaction. This is never editable.Type nopanel true
Insert excerpt Def - Transaction Types Def - Transaction Types nopanel true
Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK
Vendor Class ID
Insert excerpt
Vendor
Class
Vendor
This Class nopanel true
is required and comes from the 'Vendor Class ID' 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
Insert excerpt
Vendor
ID
Vendor
This ID nopanel true
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
Def - Insert excerpt
Def - Vendor Name
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.Vendor Name nopanel true
Insert excerpt Def - Vendor Name Def - Vendor Name nopanel true
Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK
Related Topics
Expand | ||
---|---|---|
| ||
Page Definitions |
Expand | ||
---|---|---|
| ||
Technical Details |