| 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....
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: YYYY2023.MM.DD and 06.30 and newer
| Toolbar Icons | Description |
|---|
| Column Filter Show/Hide | | Insert excerpt |
|---|
| Column Filter Show/Hide - Global |
|---|
| Column Filter Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Edit | | Insert excerpt |
|---|
| Edit - LV 3.0 |
|---|
| Edit - LV 3.0 |
|---|
| 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 |
|---|
|
|
Grid LayoutGrid Layout | Group By Show/Hide - Global |
|---|
|
|
Grid Layout | 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 Receipts with this Purchase Order assigned.
- RV: Transaction - Opens the Transaction Record View.
- 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."
- View in PaperVision - This option is only visible when the preferences for PaperVision are configured.
|
| New | | Insert excerpt |
|---|
| New - Multi-Select Trans Type - Global |
|---|
| New - Multi-Select Trans Type - Global |
|---|
| nopanel | true |
|---|
|
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: - 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.
|
| 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 3.0 |
|---|
| Refresh - Global 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Saved Layouts | | Insert excerpt |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| nopanel | true |
|---|
|
|
| Fields | Description |
| Checkbox | |
- LVCheckbox - LV | | nopanel | true |
|---|
Currency | |
| 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 |
|---|
| Comment - Header |
|---|
| Comment - Header |
|---|
| 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 |
DescriptionDatabase Field: ERPx_APTransactionHeader.Description | Doc No| No | 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 |
| Extended | Database Fields: ERPx_APTransactionLine.ExtendedAmount |
GL Date |
| GL Date | | Insert excerpt |
|---|
| GL Date |
|---|
| GL Date |
|---|
| nopanel | true |
|---|
|
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 | |
- List View/Inquiry Field - List View/Inquiry Field| 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 | |
- List View/Inquiry FieldGL Year - List View/Inquiry Field | | nopanel | true |
|---|
Item Description 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 Description | | Insert excerpt |
|---|
| Item Description |
|---|
| Item Description |
|---|
| nopanel | true |
|---|
|
This is required.Database Field: ERPx_APTransactionLine.ItemSK, ERPx_IMItem.ItemDescription |
Item ID
| | Insert excerpt |
|---|
| Item ID |
|---|
| Item ID |
|---|
| nopanel | true |
|---|
|
This is required.Database Field: ERPx_APTransactionLine.ItemSK, ERPx_IMItem.ItemID |
| Item Last Updated | | Insert excerpt |
|---|
| Item Last Updated (Date & Time) |
|---|
| Item Last Updated (Date & Time) |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionLine.LastUpdated |
| Item Last Updated By | | Insert excerpt |
|---|
| Last Updated By |
|---|
| Last Updated By |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_APTransactionLine.LastUser |
Item Type
| | Insert excerpt |
|---|
| HELP:Item Type: Inventory |
|---|
| HELP:Item Type: Inventory |
|---|
| nopanel | true |
|---|
|
This is required. |
Line Comment
| | Insert excerpt |
|---|
| Line Item Comment |
|---|
| Line Item Comment |
|---|
| nopanel | true |
|---|
|
This is not required and is always editable even after the transaction is posted.Database Field: ERPx_APTransactionLine.LineComment |
| Line Description | | Insert excerpt |
|---|
| Line Description |
|---|
| Line Description |
|---|
| nopanel | true |
|---|
|
This is a textbox 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. |
LineDescriptionLineNumber |
Payable GL Account | | Insert excerpt |
|---|
| Payable Account |
|---|
| Payable Account |
|---|
| nopanel | true |
|---|
|
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 |
|---|
| nopanel | true |
|---|
|
Database Fields: ERPx_GLAccount. |
AccountSKAccountNumber, 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 '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 |
|---|
| 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 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.
Image Added 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 |
.PurchaseOrderIDPrice |
PO 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 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 that is selected. Database Field: ERPx_APTransactionLine.POLineSK |
| Price | 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 GL Account
| | Insert excerpt |
|---|
| Purchase Account - Item |
|---|
| Purchase Account - Item |
|---|
| nopanel | true |
|---|
|
This is required and can be edited from the 'Purchase GL 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 GL Account Description | | Insert excerpt |
|---|
| Purchase Account Description |
|---|
| Purchase Account Description |
|---|
| nopanel | true |
|---|
|
This is required and can be edited from the 'Purchase GL 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 |
|---|
| nopanel | true |
|---|
|
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. |
QuauntityStatus | |
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 | 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 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 |
|---|
|
| Insert excerpt |
|---|
| Def - Status - Ready to Post |
|---|
| Def - Status - Ready to Post |
|---|
| 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.TransactionID |
Transaction Class ID
| | Insert excerpt |
|---|
| Transaction Class |
|---|
| 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 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 only editable while the transaction is in a Status of New. Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK |
Vendor Class ID
| | Insert excerpt |
|---|
| Vendor Class |
|---|
| Vendor Class |
|---|
| nopanel | true |
|---|
|
This 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.
|
Database Fields | Def - Vendor Class |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_ |
APVendorVendorID ClassDescription, ERPx_APTransactionHeader.VendorSK |
| Vendor ID | | 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.
|
Vendor Class | Def - Vendor ID |
|---|
| nopanel | true |
|---|
|
Database |
FieldAPVendorClassClassDescriptionVendorID, 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 |
Related Topics