Versions Compared

Key

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

Insert excerptDef - Trans - AP Invoice/Credit MemoDef - Trans - AP Invoice/Credit Memonopaneltrue The purpose of this page is to view, add, edit, remove, and post individual AP Invoices and Credit Memo transactions.

Software Version: YYYY.MM.DD and newer

Table of Contents
typeflat

Page Header

Header Toolbar

...

  • 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.

...

Home Tab 

...

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: YYYY.MM.DD and newer

Table of Contents
typeflat

Page Header

Header Toolbar

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

Home Tab 

Database Field: ERPx_APTransactionHeader.TransactionDate

 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.Doc No - RVa 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.

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 "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 linesblank 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.ExtendedAmountDocNumber

DescriptionPayment TermsDoc No

Insert excerpt
Description
Payment Terms -
RV
LV
Description
Payment Terms -
RV
LV
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 - RVDoc Date - RV
nopaneltrue

Insert excerpt
Doc No - RV
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 document number purchase order to the a invoice/credit memo. This defaults to blank and is not required. If missing, the message "Doc No is required." will be displayed on Save, but if entered, it must be <=50 characters. This is always editable while in a status of New.

Database Field: ERPx_APTransactionHeader.DocNumberPurchaseOrderID

Payment TermsStatus

Insert excerpt
Payment Terms
Status - LV
Payment Terms
Status - LV
nopaneltrue
This  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.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 -
Payment Terms
New
Def - Status -
Payment Terms
New
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

Purchase Order - LV

Insert excerpt
Purchase Order - LV
Def - Status - Approved
Def - Status - Approved
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
Def - Status - Ready to Post
Def - Status - Ready to Post
nopaneltrue

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Vendor

Insert excerpt
Status
Def -
LV
Vendor Name
Status
Def -
LV
Vendor Name
nopaneltrue
 This is a single-select standard lookup that defaults as 'New' and is required 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' or 'Approved'. Insert excerptDef - StatusDef - Statusnopaneltrue The Statuses that apply to transactions in this List View include:

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

Properties Tab 

FieldsDescription
Created ByDef - Status - New

Insert excerpt

Def - Status - New

Created By- RV
Created By- RV
nopaneltrue

Insert excerptDef - Status - ApprovedDef - Status - Approvednopaneltrue

Database Field: ERPx_APTransactionHeader.CreatedBy

Created DateDef - Status - Ready to Post

Insert excerpt

Def - Status - Ready to Post

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

Database

Fields: ERPx_APTransactionStatus.StatusName,

Field: ERPx_APTransactionHeader.

TransactionStatusSK

CreatedDate

VendorCurrency IDFieldsDescriptionCreated By Insert excerptCreated By- RVCreated By- RVnopaneltrue

Database Field: ERPx_APTransactionHeader.CreatedBy

Created Date Insert excerptCreated (Date & Time) - RVCreated (Date & Time) - RVnopaneltrue

Insert excerpt
Def -

Vendor Name

Currency
Def -

Vendor Name

Currency
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

Properties Tab 

FieldsDescriptionAttributesThe Attributes displayed are determined by the Attribute Setup and the Assign Attribute Rules. The Attributes can be setup and assigned to the transaction type in the Attributes section of the Company module (Company → Setup → Attributes).AvailableThis field displays whether or not the attribute is available and required. Only available attributes will be displayed with a 'Yes' followed by whether or not it is a required attribute. Required attribute values must be entered before saving the transaction as 'Approved' or 'Ready to Post'.ValueThe values in each attribute lookup are determined by the values created for the attribute, as set up in the Attributes setup in the Company module. This Due Date_APTransactionHeader.TransactionClassSK.VendorSK

 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.CreatedDateDiscountDate

Currency ID
Insert excerpt
Def - CurrencyDef - Currency
nopaneltrue

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

defaults

is calculated from

the Currency assigned to the 'Vendor Class'

taking the Doc Date and adding the number of days set up on the selected Payment Terms. 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 not editable. 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 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.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 not editable.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.DueDateIsOnApplicationHold

GL DateDatabase Field: ERPx_APTransactionHeader.GLDate
Last UpdatedDatabase Field: ERPx_APTransactionHeader.LastUpdated
Last UserDatabase Field: ERPx_APTransactionHeader.LastUser
Pmt./Apply HoldDatabase Field: ERPx_APTransactionHeader.IsOnApplicationHold
Transaction ClassTransaction 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

TransactionSK

_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_APTransactionHeader

Attributes Tab

.VendorSK

Attributes Tab

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.

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
DescriptionDatabase 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

...