AP Invoices represent transactions that carry amounts the company owes for purchasing goods or services from a Vendor. AP Credit Memos represent transactions that carry amounts owed to the company because of returns and/or credits on goods or services previously purchased from a Vendor. The purpose of this page is to show line item detail for all these transactions.
Software Version: YYYY.MM.DD and newer
Page Header
Toolbar Icons | Description |
---|---|
Excel | Export the contents of the list view to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view only the filtered contents will be exported. |
Favorites |
|
Grid Layout | Opens the Saved Grid Layout menu that allows the user to select another saved layout, create a new layout, save changes to a layout, or assign a saved layout as the default for the page. Once changes are made to a grid, such as columns are added or removed, the user can click the Saved Grid Layout icon and save the changes to the grid layout and name the new layout. The new layout can also be set as the default, instead of the System View. This is useful for creating specific views to separate master files or transaction types (i.e. Invoice specific vs. Credit Memo specific).
|
Help | Opens the online WIKI help page for the current page.
|
Inquiry Criteria | Opens Inquiry Criteria window where users can define the following criteria:
|
Refresh | Re-queries the contents of the grid/page based on the Inquiry Criteria parameters or the default parameters for grids that do not support Inquiry Criteria. |
Fields | Description |
Checkbox | Used to select one or more records. |
Currency | Error rendering macro 'excerpt-include' : No link could be created for 'Currency - LV'. The Currency identifies the kind of money used for transactions. For example, if a Customer or Vendor is setup with a Currency of "USD" then all transactions for them are stated in terms of US Dollars and all payments received or made must be in US Dollars. 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.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 To Type | Database Field: ERPx_APTransactionLine.ToMFDistributionTypeEN |
Doc Date | Database Field: ERPx_APTransactionHeader.TransactionDate |
Doc Description | Database Field: ERPx_APTransactionHeader.Description |
Doc No | Database Field: ERPx_APTransactionHeader.DocNumber |
Extended | Database Field: ERPx_APTransactionLine.ExtendedAmount |
GL Date | Database Field: ERPx_APTransactionHeader.GLDate |
GL Period | Database Fields: ERPx_MFFiscalPeriod.FiscalPeriodSK, ERPx_APTransactionHeader.GLDate |
GL Year | Database Fields: ERPx_MFFiscalPeriod.FiscalYearSK, ERPx_APTransactionHeader.GLDate |
Item Description | Database Field: ERPx_APTransactionLine.LineDescription |
Payable Account | Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.APGLAcctRef |
Payable Account Description | Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef |
Pmt./Apply Hold | Database Field: ERPx_APTransactionHeader.IsOnApplicationHold |
PO | Database Field: ERPx_APTransactionHeader.PurchaseOrderID |
Price | Database Field: ERPx_APTransactionLine.Price |
Purchase Account | Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK |
Purchase Account Description | Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK |
Quantity | Database Field: ERPx_APTransactionLine.Quantity |
Status | Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK |
Transaction | Database Field: ERPx_APTransactionHeader.TransactionHeaderID |
Transaction Class | Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK |
Transaction Type | Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK |
UOM | Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK |
Vendor | Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK |
Vendor Class | Database Fields: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK |
Vendor Name | Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK |