Versions Compared

Key

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

Def - Trans -
Insert excerpt
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 individual AP Invoices and Credit Memo transactions.

...

FieldsDescription
Amount

Insert excerpt
Amount (Transaction Amount) - LV
Amount (Transaction Amount) - LV
nopaneltrue
 This is a non-editable text box that displays the total amount based on the sum of all transaction lines on the invoice/credit memo. This defaults to "0.00" and is not required. This field is never editable by the user, but can be changed by updating the quantity and/or price of one or more transaction lines.

Database Field: ERPx_APTransactionHeader.ExtendedAmount

Description

Insert excerpt
Description - RV
Description - RV
nopaneltrue
This is text box to assign a description to the invoice/credit memo. This defaults to blank and is not required, but if entered, it must be <=60 characters. This is always editable.

Database Field: ERPx_APTransactionHeader.Description

Doc Date

Insert excerpt
Doc Date - RV
Doc Date - RV
nopaneltrue
 This is a text box to assign/edit a date for the invoice/credit memo. This defaults to today's date is required. If missing, the message "Doc Date is required." will be displayed on Save. This is always editable while in a status of New.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc No

Insert excerpt
Doc No - RV
Doc No - RV
nopaneltrue
This is a text box to assign a document number to the invoice/credit memo. This defaults to blank and is required. If missing, the message "Doc No is required." will be displayed on Save. This is always editable while in a status of New.

Database Field: ERPx_APTransactionHeader.DocNumber

Payment Terms

Insert excerpt
Payment Terms - LV
Payment Terms - LV
nopaneltrue
This is a single-select standard lookup that defaults from the Payment Terms assigned to the 'Vendor Class' of the selected Vendor. This is required and if missing, the message "Payment Terms are required when approving or posting transactions." will be displayed on Save. This is editable on an invoice while in a status of New, but not editable on a credit memo.

Insert excerpt
Def - Payment Terms
Def - Payment Terms
nopaneltrue

The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Payment Terms.

Database Fields: ERPx_MFPaymentTerms.PaymentTermName, APTransactionHeader.PaymentTermSK

PO

Insert excerpt
Purchase Order - LV
Purchase Order - LV
nopaneltrue
This is a text box to assign a purchase order to a invoice/credit memo. This defaults to blank and is not required, but if entered, it must be <=50 characters. This is always editable while in a status of New.

Database Field: ERPx_APTransactionHeader.PurchaseOrderID

Status

Insert excerpt
Status - LV
Status - LV
nopaneltrue
 This is a single-select standard lookup that defaults as 'New' and is required. 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

Vendor

Insert excerpt
Def - Vendor Name
Def - Vendor Name
nopaneltrue
This is a single-select standard lookup to assign a Vendor to the invoice/credit memo. This defaults as blank and is required. If not assigned, the message "A Vendor is required." will be displayed on Save. This is always editable while the transaction is in a Status of 'New'.

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

...

FieldsDescription
Created By

Insert excerpt
Created By- RV
Created By- RV
nopaneltrue

Database Field: ERPx_APTransactionHeader.CreatedBy

Created Date

Insert excerpt
Created (Date & Time) - RV
Created (Date & Time) - RV
nopaneltrue

Database Field: ERPx_APTransactionHeader.CreatedDate

Currency ID

Insert excerpt
Def - Currency
Def - Currency
nopaneltrue
 This is a non-editable text box that defaults from the Currency assigned to the 'Vendor Class'. This is required and not editable from this page. Even though this field is required, it is currently for information only and does not drive any functionality. 

The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Company Currencies.

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK

Discount Date

The Discount Date is the date the discount expires. It is based on the number of discount days set up for the selected Payment Terms. This is a non-editable text box that is calculated from taking the Doc Date and adding the number of discount days set up on the selected Payment Terms. This is not required and only editable by changing the Payment Terms assigned to the transaction.

Database Field: ERPx_APTransactionHeader.DiscountDate

Due Date

The Due Date is the date payment is due. It is based on the number of days set up for the selected Payment Terms. This is a non-editable text box that is calculated from taking the Doc Date and adding the number of days set up on the selected Payment Terms. This is required and only editable by changing the Payment Terms assigned to the transaction.

Database Field: ERPx_APTransactionHeader.DueDate

GL Date

Insert excerpt
GL Date - LV
GL Date - LV
nopaneltrue
This is a editable text box date picker that defaults as blank and is required. If not manually edited, 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

Last Updated

Insert excerpt
Last Updated (Date & Time) - RV
Last Updated (Date & Time) - RV
nopaneltrue

Database Field: ERPx_APTransactionHeader.LastUpdated

Last User

Insert excerpt
Last Updated By- RV
Last Updated By- RV
nopaneltrue

Database Field: ERPx_APTransactionHeader.LastUser

Pmt./Apply Hold

Displays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold. This is an editable text box that defaults as blank and 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

Transaction Class

Insert excerpt
Def - Transaction Class
Def - Transaction Class
nopaneltrue
 This is a non-editable text box that defaults as 'Default' and is not editable.

Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK

TransactionSK

Insert excerpt
TransactionSK - RV
TransactionSK - RV
nopaneltrue
This is a non-editable text box that is system generated, required and is not editable.

Database Field: ERPx_APTransactionHeader.TransactionHeaderSK

Vendor ID

Insert excerpt
Def - Vendor ID
Def - Vendor ID
nopaneltrue
This is a non-editable text box that defaults as the Vendor ID of the selected Vendor. This is required and only editable by changing the Vendor assigned to the transaction.

Database Fields: ERPx_APVendor.VendorID, ERPx ERPx_APTransactionHeader.VendorSK

Attributes Tab

  This Company 
FieldsDescription
Attributes

Insert excerpt
Attribute - Attribute - RV
Attribute - Attribute - RV
nopaneltrue
 The Attributes displayed here are setup and assigned in the Attributes section of the Company module (Company

 → Setup → Attributes → AP Purchasing). 

Available

Insert excerpt
Attribute - Available - RV
Attribute - Available - RV
nopaneltrue

 This value is only editable from the 'Assign Attribute Rules' page (

Company → Setup → Attributes → AP Purchasing → Transactions hyperlink). 

Value
Insert excerpt
Attribute - Value - RV
Attribute - Value - RV
nopaneltrue

Page Detail

Items Grid

The purpose of the Items grid is to add, edit and delete the line items for the Invoice and Credit Memo transaction.

)- RV
Toolbar IconsDescription
Delete
Insert excerpt
Delete - RV Grid
Delete - RV Grid
nopaneltrue
Excel
Insert excerpt
Excel - RV Grid
Excel - RV Grid
nopaneltrue
New

Insert excerpt
New - multi blank rows - RV Grid
New - multi blank rows - RV Grid
nopaneltrue

FieldsDescription
Checkbox
Insert excerpt
Checkbox (Tag)- RV
Checkbox (Tag
)- RV
nopaneltrue
Description

Insert excerpt
Item Description (user entered) - LV
Item Description (user entered) - LV
nopaneltrue
This is a text box that defaults as blank, is required and must be <= 200 characters. If missing, the message "A Description is required for all line items." will be displayed on Save. This field is always editable while the transaction is in a Status of New or Approved.

Database Field: ERPx_APTransactionLine.LineDescription

Distributed ToDatabase Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK
ExtendedDatabase Field: ERPx_APTransactionLine.ExtendedAmount
PriceDatabase Field: ERPx_APTransactionLine.Price
Purchase AccountDatabase Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK
QuantityDatabase Fields: ERPx_APTransactionLine.Quantity
UOMDatabase Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK

...