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

 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

Page Header

Toolbar Icons	Description
Edit	Opens the selected record for editing. If a record is not selected, the page will not open.
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	Clicking on the star icon when it is an outline, adds the page to the 'My Shortcuts' tab and fills in the star. Clicking on the star icon when it is filled in (solid color), removes the page from the 'My Shortcuts' tab and returns the icon to an outline.   Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.
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).  The bolded view is the default view, which will determine the view will automatically display in when opened.
Help	Opens the online WIKI help page for the current page.   This icon is only visible on pages that are documented in the online help.
New	Allows users to select the type of transaction or record they want to add. The list contains: 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.
Fields	Description
Checkbox	Error rendering macro 'excerpt-include' : No link could be created for 'Checkbox - LV'.
Currency	Error rendering macro 'excerpt-include' : No link could be created for 'Currency - LV Field'.  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	Error rendering macro 'excerpt-include' : No link could be created for 'Doc Date - List View/Inquiry Field'.  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. Database Field: ERPx_APTransactionHeader.TransactionDate
Doc Description	Database Field: ERPx_APTransactionHeader.Description
Doc No	Database Field: ERPx_APTransactionHeader.DocNumber
Extended	Database Fields: ERPx_APTransactionLine.ExtendedAmount
GL Date	Database Field: ERPx_APTransactionHeader.GLDate
GL Period	Error rendering macro 'excerpt-include' : No link could be created for 'GL Period - List View/Inquiry Field'.
GL Year	Error rendering macro 'excerpt-include' : No link could be created for 'GL Year - List View/Inquiry Field'.
Item Description	Database Field: ERPx_APTransactionLine.LineDescription
Payable Account	Database Fields: ERPx_GLAccount.AccountSK, 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 Fields: 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 Fields: ERPx_APTransactionLine.Quauntity
Status	Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK
Transaction	Database Field: ERPx_APTransactionHeader.TransactionID
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 Field: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK
Vendor Name	Database Fields: ERPx_APVendor.VendorName ,ERPx_APTransactionHeader.VendorSK

Related Topics