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

Software Version: YYYY2020.MM06.DD 05 and newer

Table of Contents
typeflat

...

FieldsDescription
Amount

Insert excerpt
Amount - Transaction
Amount - Transaction
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 Comment - HeaderDescription
Comment - Header
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
Doc Date
nopaneltrue
 This is a text box to assign/edit a date for the invoice/credit memo. This defaults to today's date and is required. If missing, the message "Doc Date is required." will be displayed on Save. The Doc Date must be on or before the GL Date when Approving or Posting the Invoice/Credit Memo. If not, the message "The GL Date must be on or after the Doc Date." will be displayed on Save. This field is always editable.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
This is a text box to enter the document number your Vendor assigned to the invoice/credit memo. This defaults to blank and is required and must be <= 50 characters. 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
Payment Terms
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
Purchase Order
nopaneltrue
This is a text box to assign a purchase order to an 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
Status
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
Vendor Name (ID)
Vendor Name (ID)
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'.

Insert excerpt
Def - Vendor Name
Def - Vendor Name
nopaneltrue

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

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

...

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
Checkbox
nopaneltrue
Description

Insert excerpt
Description - Item
Description - Item
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 To

Insert excerpt
Distributed To - Vendor
Distributed To - Vendor
nopaneltrue
This is a single-select standard lookup that defaults as blank and is not required. This is always editable while the transaction is in a Status of New.

The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Vendors, Employees and Projects.

Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSK

Extended

Insert excerpt
Amount - Extended
Amount - Extended
nopaneltrue
This is a non-editable text box that defaults as "0.00" and is required. This can only be edited by changing the Quantity and/or Price of the transaction line. It is calculated as [Quantity of line item] * [Price of line item].

Database Field: ERPx_APTransactionLine.ExtendedAmount

Price

Insert excerpt
Price
Price
nopaneltrue
This is a text box that defaults as "0.00" and is required when the Status is set to Approved. If missing, the message "Price is required and must be greater than zero." will be displayed on Save. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionLine.Price

Purchase Account

Insert excerpt
Purchase Account - Item
Purchase Account - Item
nopaneltrue
This is a single-select standard lookup that defaults as blank and is required when the Status is set to Approved. If missing, the message "A Purchase Account is required for all lines." will be displayed on Save. This is always editable while the transaction is in a Status of New unless the line is being distributed to a Fishing Account. For lines distributed to fishing accounts, the Purchase Account is set to the Settlement Accrual Account for the assigned account and is disabled. 

Insert excerpt
Def - GL Account - Purchases
Def - GL Account - Purchases
nopaneltrue

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

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK

Quantity

Insert excerpt
Quantity
Quantity
nopaneltrue
This is a text box that defaults as "1.00" and is required. This can be a positive or negative value. This is always editable while the transaction is in a Status of New. 

Database Field: ERPx_APTransactionLine.Quantity

UOM

Insert excerpt
UOM - Units
UOM - Units
nopaneltrue
This is a single-select standard lookup that defaults as blank and is not required. This is always editable while the transaction is in a Status of New. 

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

Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK

...