Versions Compared

Old Version 41

changes.mady.by.user Emma Greenwood

Saved on

compared with

New Version 42

changes.mady.by.user Emma Greenwood

Saved on

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 AP Invoices and Credit Memos. Additionally, users can Mass Update the GL Date, Pmt/Apply Hold, and Status of multiple transactions at once.

(lightbulb) This list view also contains columns for each Attribute that is set up for the 'AP Purchasing' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. AP Purchasing attributes are not included in the help documentation.

Software Version: 20202021.0607.0523 and newer

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Delete

Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue

Edit

Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
nopaneltrue

Excel

Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue

Favorites

Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue

Grid Layout

 

Group By Show/Hide
Insert excerpt
Grid Layout
Group By Show/Hide - Global
Grid Layout
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
Mass Update

Insert excerpt
Mass Update - Global 3.0
Mass Update - Global 3.0
nopaneltrue

  • GL Date: A date field that defaults to "(No Change)", but also allows users to select a date from the calendar. Assigns the selected date to the selected/filtered transactions when Apply is clicked.
  • Pmt./Apply Hold: A single-select lookup that defaults to "(No Change)", but also has options for (blank) and "Yes". Assigns the selected value to selected/filtered transactions when Apply is clicked.
  • Status: A single-select lookup that defaults to "(No Change)", but also has options for "New", "Approved" and "Ready to Post". Assigns the selected Status to selected/filtered transactions when Apply is clicked.
More Actions

Insert excerpt
More Actions - Global 3.0
More Actions - Global 3.0
nopaneltrue
 

  • View in PaperVision
New

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

Each Transaction Type (Invoice or Credit Memo) that only has one Transaction Class is displayed as just the Transaction Type Name (e.g. Invoice).  Each Transaction Type that has more than one Transaction Class is displayed as Transaction Type Name-Transaction Class Name (e.g. Invoice-Home Office). The base list of Transaction Types includes:

  • 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.
Print
Insert excerpt
Print - LV 3.0
Print - LV 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Refresh
Insert excerpt
Refresh - Global 3.0
Refresh - Global 3.0
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
Amount

Insert excerpt
Amount - Transaction
Amount - Transaction
nopaneltrue
 This comes from the 'Amount' on the 'Home' tab of the Invoice/Credit Memo Record View and is calculated based on the sum of all transaction lines. This is required and can only be edited by changing the quantity and/or price of one or more transaction lines.

Database Field: ERPx_APTransactionHeader.ExtendedAmount

Created

Insert excerpt
Created
Created
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CreatedDate

Created By

Insert excerpt
Created By
Created By
nopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CreatedBy

Currency ID

Insert excerpt
Currency
Currency
nopaneltrue
 This is required and comes from the 'Currency ID' on the 'Properties' tab of the Invoice/Credit Memo Record View. This is not editable on the transaction.

Insert excerpt
Def - Currency
Def - Currency
nopaneltrue

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK

Doc DateDescriptionDoc Date

Insert excerpt

Doc Date

Description - Header
Description - Header
nopaneltrue
 This is not required and can be edited from the '

Doc Date

Description' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable, even after the transaction is Posted.

Database Field: ERPx_APTransactionHeader.

TransactionDate

Description

Doc DescriptionDate

Insert excerpt
Description - HeaderDescription - HeaderDoc Date
Doc Date
nopaneltrue
 This is not required and can be edited from the 'DescriptionDoc Date' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable, even after the transaction is Posted.

Database Field: ERPx_APTransactionHeader.DescriptionTransactionDate

Doc No

Insert excerpt
Doc No
Doc No
nopaneltrue
 This is required and can be edited from the 'Doc No' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the transaction/Invoice # assigned by your Vendor. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.DocNumber

GL Date

Insert excerpt
GL Date
GL Date
nopaneltrue
 This is required and can be edited from the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. If not manually edited, this 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

GL Period

Insert excerpt
GL Period
GL Period
nopaneltrue
 This is required and calculated using the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This can only be edited by changing the GL Date.

GL Year

Insert excerpt
GL Year
GL Year
nopaneltrue
  This is required and calculated using the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This can only be edited by changing the GL Date.

Last Updated

Insert excerpt
Last Updated
Last Updated
nopaneltrue
 

Linked Database Field: ERPx_APTransactionHeader.LastUpdated

Last Updated By

Insert excerpt
Last Updated By
Last Updated By
nopaneltrue
 

Linked Database Field: ERPx_APTransactionHeader.LastUser

Payment Terms

Insert excerpt
Payment Terms
Payment Terms
nopaneltrue
 This is required and can be edited from the 'Payment Terms' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable while the transaction is in a Status of New. If the Payment Terms are changed, the 'Due Date' and 'Discount Date' values will be automatically updated based on the new Payment Terms.

Insert excerpt
Def - Payment Terms
Def - Payment Terms
nopaneltrue

Database Fields: ERPx_MFPaymentTerms.PaymentTermName, ERPx_APTransactionHeader.PaymentTermSK

Pmt./Apply Hold

Displays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold. This is not required and can be edited from the 'Pmt./Apply Hold' on the 'Properties' tab of the Invoice/Credit Memo Record View. This 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

PO

Insert excerpt
Purchase Order
Purchase Order
nopaneltrue
 This is not required and can be edited from the 'PO' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the purchase order you used when making the purchase. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.PurchaseOrderID

Status

Insert excerpt
Status
Status
nopaneltrue
 This is required and can be edited from the 'Status' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the status of the transaction. 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

Transaction

Insert excerpt
Transaction ID
Transaction ID
nopaneltrue
 Clicking on this link opens the AP Invoice / Credit Memo Record View for the selected record. This is a system assigned number that comes from the 'Transaction Class' and is required but is not editable by users.

Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Class

Insert excerpt
Transaction Class
Transaction Class
nopaneltrue
 This is required and comes from the 'Transaction Class' on the 'Properties' tab of the Invoice/Credit Memo Record View. This is not editable.

Insert excerpt
Def - Transaction Class
Def - Transaction Class
nopaneltrue

Database Fields: ERPx_APTransactionClass.TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSK

Transaction Type

Insert excerpt
Transaction Type
Transaction Type
nopaneltrue
 This is required and comes from the Transaction Type selected when starting a new transaction. This is never editable.

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

Vendor Class

Insert excerpt
Vendor

ID

Class
Vendor

ID

Class
nopaneltrue
 This is required and

represents the ID of

comes from the 'Vendor Class' assigned to the 'Vendor' that is selected on the 'Home' tab of the Invoice/Credit Memo Record View.

This is only editable by changing the Vendor assigned to

Because this defaults from the Vendor it is not editable on the transaction.

Insert excerpt
Def - Vendor

ID

Class
Def - Vendor

ID

Class
nopaneltrue

Database

Fields

Field: ERPx_

APVendor

APVendorClass.

VendorID

ClassDescription, ERPx_APTransactionHeader.VendorSK

Vendor ClassID

Insert excerpt
Vendor

Class

ID
Vendor

Class

ID
nopaneltrue
 This is required and

comes from the 'Vendor Class' assigned to

represents the ID of the 'Vendor'

that is selected

on the 'Home' tab of the Invoice/Credit Memo Record View.

Because this defaults from the Vendor it is not editable on

This is only editable by changing the Vendor assigned to the transaction.

Insert excerpt
Def - Vendor

Class

ID
Def - Vendor

Class

ID
nopaneltrue

Database

Field

Fields: ERPx_

APVendorClass

APVendor.

ClassDescription

VendorID, ERPx_APTransactionHeader.VendorSK

Vendor Name

Insert excerpt
Vendor Name
Vendor Name
nopaneltrue
This is required and represents the name of the 'Vendor' on the 'Home' tab of the Invoice/Credit Memo Record View. This is only editable by changing the Vendor assigned to the transaction.

Insert excerpt
Def - Vendor Name
Def - Vendor Name
nopaneltrue

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK

...