Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 15 Next »

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 IconsDescription
ExcelExport 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. 

(lightbulb) Users must log out and back in before the pages will be visible in the 'My Shortcuts' tab.

Grid LayoutOpens 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).

(lightbulb) The bolded view is the default view, which will determine the view will automatically display in when opened. 

HelpOpens the online WIKI help page for the current page. 

(lightbulb) This icon is only visible on pages that are documented in the online help.

Inquiry Criteria

Opens Inquiry Criteria window where users can define the following criteria: 

  • Date From: a text box to enter a starting Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
  • Date To: a text box to enter an ending Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
  • Status: a multi-select check box to limit the data that is returned to one or more selected Statuses. Options include: New, Approved, Ready To Post, Posted, Void, Deleted, Replaced. The default values are "New, Approved, Ready To Posted and Posted".
RefreshRe-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. 
FieldsDescription
CheckboxUsed 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 ToDatabase Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK
Distributed To TypeDatabase Field: ERPx_APTransactionLine.ToMFDistributionTypeEN
Doc DateDatabase Field: ERPx_APTransactionHeader.TransactionDate
Doc DescriptionDatabase Field: ERPx_APTransactionHeader.Description
Doc NoDatabase Field: ERPx_APTransactionHeader.DocNumber
Extended 

Database Field: ERPx_APTransactionLine.ExtendedAmount

GL DateDatabase Field: ERPx_APTransactionHeader.GLDate
GL PeriodDatabase Fields: ERPx_MFFiscalPeriod.FiscalPeriodSK, ERPx_APTransactionHeader.GLDate
GL YearDatabase Fields: ERPx_MFFiscalPeriod.FiscalYearSK, ERPx_APTransactionHeader.GLDate
Item DescriptionDatabase Field: ERPx_APTransactionLine.LineDescription
Payable AccountDatabase Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.APGLAcctRef
Payable Account DescriptionDatabase Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef
Pmt./Apply HoldDatabase Field: ERPx_APTransactionHeader.IsOnApplicationHold
PODatabase Field: ERPx_APTransactionHeader.PurchaseOrderID
PriceDatabase Field: ERPx_APTransactionLine.Price
Purchase AccountDatabase Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK
Purchase Account DescriptionDatabase Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK
QuantityDatabase Field: ERPx_APTransactionLine.Quantity
StatusDatabase Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK
TransactionDatabase Field: ERPx_APTransactionHeader.TransactionHeaderID
Transaction ClassDatabase Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK
Transaction TypeDatabase Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK
UOMDatabase Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK
VendorDatabase Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK
Vendor ClassDatabase Fields: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK
Vendor NameDatabase Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

Related Topics



 Page Definitions

Page Definitions


 Technical Details

Technical Details

  • No labels