Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Def - Trans - AP Invoice/Credit Memo
Def - Trans - AP Invoice/Credit Memo
nopaneltrue
 The purpose of this page is to view, add, edit, remove, and post AP Invoices and Credit Memos. Additionally, users can Mass Update the GL Date, Pmt/Apply Hold, and Status of multiple transactions at once.

(lightbulb) 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

...

Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV
Delete - LV
nopaneltrue
Edit
Insert excerpt
Edit - LV
Edit - LV
nopaneltrue
Excel
Insert excerpt
Excel - LV
Excel - LV
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
Mass Update

Insert excerpt
Mass Update - Global
Mass Update - Global
nopaneltrue

  • GL Date: A date field that defaults to "(No Change)", but also allows users to select a date from the calendar. Assigns the selected date to the selected/filtered transactions when Apply is clicked.
  • Pmt./Apply Hold: A single-select lookup that defaults to "(No Change)", but also has options for (blank) and "Yes". Assigns the selected value to selected/filtered transactions when Apply is clicked.
  • Status: A single-select lookup that defaults to "(No Change)", but also has options for "New", "Approved" and "Ready to Post". Assigns the selected Status to selected/filtered transactions when Apply is clicked.
New

Insert excerpt
New - Multi-Select Trans Type - Global
New - Multi-Select Trans Type - Global
nopaneltrue

  • 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
Print - LV
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Amount

Insert excerpt
Amount - Transaction
Amount - Transaction
nopaneltrue
 This comes from the 'Amount' on the 'Home' tab of the Invoice/Credit Memo Record View and is calculated based on the sum of all transaction lines. This is required and can only be edited by changing the quantity and/or price of one or more transaction lines.

Database Field: ERPx_APTransactionHeader.ExtendedAmount

Created

Insert excerpt
Created
Created
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CreatedDate

Created By

Insert excerpt
Created By
Created By
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CreatedBy

Currency

Insert excerpt
Currency
Currency
nopaneltrue
 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
nopaneltrue

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK

Doc Date

Insert excerpt
Doc Date
Doc Date
nopaneltrue
 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.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc Description

Insert excerpt
Description - Header
Description - Header
nopaneltrue
 This is not required and can be edited from the 'Description' 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

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
 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

GL Date

Insert excerpt
GL Date
GL Date
nopaneltrue
 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

Insert excerpt
GL Period
GL Period
nopaneltrue
 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
GL Year
GL Year
nopaneltrue
  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.

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue
 

Linked Database Field: ERPx_APTransactionHeader.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue
 

Linked Database Field: ERPx_APTransactionHeader.LastUser

Payment Terms

Insert excerpt
Payment Terms
Payment Terms
nopaneltrue
 This is required and can be edited from the 'Payment Terms' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New. If the Payment Terms are changed, the 'Due Date' and 'Discount Date' values will be automatically updated based on the new Payment Terms.

Insert excerpt
Def - Payment Terms
Def - Payment Terms
nopaneltrue

Database Fields: ERPx_MFPaymentTerms.PaymentTermName, ERPx_APTransactionHeader.PaymentTermSK

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

Database Field: ERPx_APTransactionHeader.PurchaseOrderID

Status

Insert excerpt
Status
Status
nopaneltrue
 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
nopaneltrue
 The Statuses that apply to transactions in this List View include:

Insert excerpt
Def - Status - New
Def - Status - New
nopaneltrue

Insert excerpt
Def - Status - Approved
Def - Status - Approved
nopaneltrue

Insert excerpt
Def - Status - Ready to Post
Def - Status - Ready to Post
nopaneltrue

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
 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
nopaneltrue

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Class

Insert excerpt
Transaction Class
Transaction Class
nopaneltrue
 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
nopaneltrue

Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK

Transaction Type

Insert excerpt
Transaction Type
Transaction Type
nopaneltrue
 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
nopaneltrue

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

Vendor

Insert excerpt
Vendor ID
Vendor ID
nopaneltrue
 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
nopaneltrue

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

Vendor Class

Insert excerpt
Vendor Class
Vendor Class
nopaneltrue
 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
nopaneltrue

Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK

Vendor Name

Insert excerpt
Vendor Name
Vendor Name
nopaneltrue
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
nopaneltrue

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

...