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

...

Toolbar IconsDescription
Delete
Insert excerpt
Delete - RV Header
Delete - RV Header
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
Journal Details
Insert excerpt
Journal Details - RV Header
Journal Details - RV Header
nopaneltrue
Load from POLoads information from the specified purchase order once a PO is entered. This button is disabled once the transaction is Approved or Ready to Post

This icon is disabled until a value has been entered in the PO field that matches an open Purchase Order #. When enabled and clicked, the transaction data will auto fill from the Purchase Order. This icon is disabled once the transaction is Approved or Ready to Post.

Help
Insert excerpt
Help - Global
Help - Global
nopaneltrue
New

Insert excerpt
New - Multi-Select Trans Type - Global
New - Multi-Select Trans Type - Global
nopaneltrue

  • 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.
Notes
Insert excerpt
Notes - Global
Notes - Global
nopaneltrue
Save
Insert excerpt
Save - RV Header
Save - RV Header
nopaneltrue
View Applications
Insert excerpt
View Applications - Global
View Applications - Global
nopaneltrue

...

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 assign a 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
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'.

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

...

FieldsDescription
Created By

Insert excerpt
Created By
Created By
nopaneltrue

Database Field: ERPx_APTransactionHeader.CreatedBy

Created Date

Insert excerpt
Created
Created
nopaneltrue

Database Field: ERPx_APTransactionHeader.CreatedDate

Currency ID

Insert excerpt
Currency
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. 

Insert excerpt
Def - Currency
Def - Currency
nopaneltrue

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 DateIdentifies the date the discount expires. It is based on the number of discount days set up for the selected Payment Terms. This

Insert excerpt
Discount Date
Discount Date
nopaneltrue
 This is a text box that is calculated from taking the Doc Date and adding the number of discount days set up on the selected Payment Terms. If the assigned Payment Term does not support discounts, this will be blank. This is not required and is disabled until the transaction is Posted. Prior to Posting, this field

is

can only

editable

be changed by

changing

updating the Payment Terms assigned to the transaction. Once enabled and if the field is updated,

then

it must be on or before the Due Date. Else, the message "The Discount Date must occur on or before the Due Date." will be displayed on Save.

Insert excerpt
Def - Discount Date
Def - Discount Date
nopaneltrue

Database Field: ERPx_APTransactionHeader.DiscountDate

Due Date

Insert excerpt
Due Date
Due Date

Identifies the date payment is due. It is based on the number of days set up for the selected Payment Terms.

nopaneltrue
 This is a text box that is calculated from taking the Doc Date and adding the number of days set up on the selected Payment Terms. This field is required and is disabled until the transaction is Posted. Prior to Posting, this field

is

can only

editable

be changed by

changing

updating the Payment Terms assigned to the transaction. Once enabled and if the field is updated, then it must be on or before the Due Date. Else, the message "The Discount Date must occur on or before the Due Date." will be displayed on Save. Once enabled and if the field is updated, then it must be on or after the Discount Date. Else, the message "The Discount Date must occur on or before the Due Date." will be displayed on Save.

Insert excerpt
Def - Due Date
Def - Due Date
nopaneltrue

Database Field: ERPx_APTransactionHeader.DueDate

GL Date

Insert excerpt
GL Date
GL Date
nopaneltrue
This is a editable date picker that defaults as blank and is required. If not manually edited, will be automatically set to match the 'Doc Date' in the Home tab  when the transaction is saved with a Status of either Approved or Ready to Post.  The GL Date must be on or after the Doc 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 is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.GLDate

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue

Database Field: ERPx_APTransactionHeader.LastUpdated

Last User

Insert excerpt
Last Updated By
Last Updated By
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
Transaction Class
Transaction Class
nopaneltrue
 This is a non-editable text box that is required and defaults as 'Default'. This is not editable.

Insert excerpt
Def - Transaction Class
Def - Transaction Class
nopaneltrue

Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK

TransactionSK

Insert excerpt
Transaction SK
Transaction SK
nopaneltrue
This is a non-editable text box that is system generated, required and is not editable. This field is primarily used by support.

Database Field: ERPx_APTransactionHeader.TransactionHeaderSK

Vendor ID

Insert excerpt
Vendor ID
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.

Insert excerpt
Def - Vendor ID
Def - Vendor ID
nopaneltrue

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

...

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

true

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

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.
Insert excerpt
Def - Not DefinedDef - Not Defined
nopaneltrue
Extended

Insert excerpt
Amount - Extended
Amount - Extended
nopaneltrue
This is a non-editable textboxtext 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
Sale Purchase Account - ItemSale
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. 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 - Not DefinedGL Account - Purchases
Def - GL Account - Not DefinedPurchases
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. 
Insert excerpt
Def - Not DefinedDef - Not Definednopanel

...