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 show line item detail for all these unposted transactions.

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

...

 This

 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.

Toolbar IconsDescription
Edit
Insert excerpt
Edit - LV
Edit - LV
nopaneltrue
Excel
Insert excerpt
Excel - LV
Excel - LV
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid Layout
Insert excerpt
Grid Layout - Global
Grid Layout - Global
nopaneltrue
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.
FieldsDescription
Checkbox
Insert excerpt
Checkbox - LV
Checkbox - LV
nopaneltrue
Currency

Insert excerpt
Insert excerpt
Currency - LV
Currency - LV
nopaneltrue
 
Def - CurrencyDef - Currency
nopaneltrue
 This comes from the 'Currency ID' on the 'Properties' tab of the Invoice/Credit Memo Record View. This defaults from the Currency setup on the Vendor and is not editable on the transaction.

Insert excerpt
Def - Currency
Def - Currency
nopaneltrue

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK

Distributed To

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is always editable while the transaction is in a Status of New.

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

Distributed To Type

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This is derived from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. Because this defaults from the Vendor, Employee or Project, it is not editable on the transaction. This contains the associated value in the MFDistributionType Enumeration Class.

Database Field: ERPx_APTransactionLine.ToMFDistributionTypeEN

Doc Date

Insert excerpt
Doc Date - LV
Doc Date - LV
nopaneltrue
 This comes from the 'Doc Date' on the 'Home' tab of the Invoice/Credit Memo Record View. This defaults from the current date and is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.TransactionDate

Doc Description

Insert excerpt
Doc Description - LV
Doc Description - LV
nopaneltrue
 This comes from the 'Description' on the 'Home' tab of the Invoice/Credit Memo Record View. This defaults as blank and is always editable, even after the transaction is Posted.

Database Field: ERPx_APTransactionHeader.Description

Doc No

Insert excerpt
Doc No - LV
Doc No - LV
nopaneltrue
 This comes 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 defaults as blank and is required. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.DocNumber

Extended

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the 'Extended' on the Item grid of the Invoice/Credit Memo Record View and is calculated based on the product of the Quantity and Price of the transaction line. This can only be edited by changing the Quantity and/or Price of the transaction line.

Database Fields: ERPx_APTransactionLine.ExtendedAmount

GL Date

Insert excerpt
GL Date - LV
GL Date - LV
nopaneltrue
 This comes from the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. This defaults as blank and 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

GL Period
Insert excerpt
GL Period - LV
GL Period - LV
nopaneltrue
 This is a calculated field 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 - LV
GL Year - LV
nopaneltrue
  This is a calculated field 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.
Item Description

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the 'Description' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is always editable while the transaction is in a Status of New or Approved.

Database Field: ERPx_APTransactionLine.LineDescription

Payable Account

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the Vendor's 'Accounts Payable' on the 'Accounts' tab of the Vendors List View. Because this defaults from the Vendor, it is not editable on the transaction.

Database Fields: ERPx_GLAccount.AccountSK, ERPx_APVendor.APGLAcctRef

Payable Account Description

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the Vendor's 'Accounts Payable' on the 'Accounts' tab of the Vendors List View. Because this defaults from the Vendor, it is not editable on the transaction.

Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef

Pmt./Apply Hold

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

PO

Insert excerpt
Purchase Order - LV
Purchase Order - LV
nopaneltrue
 This comes 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 defaults as blank and is not required. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.PurchaseOrderID

Price

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the 'Price' on the Item grid of the Invoice/Credit Memo Record View. This defaults as "0.00" and is not required. This is always editable while the transaction is in a Status of New.

Database Fields: ERPx_APTransactionLine.Price

Purchase Account

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the 'Purchase Account' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is not required. This is always editable while the transaction is in a Status of New. 

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APTransactionLine.AccountSK

Purchase Account Description

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the 'Purchase Account' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is not required. This is always editable while the transaction is in a Status of New. 

Database Fields: ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK

Quantity

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the 'Quantity' on the Item grid of the Invoice/Credit Memo Record View. This defaults as "1.00" and is not required. This is always editable while the transaction is in a Status of New. 

Database Fields: ERPx_APTransactionLine.Quauntity

Status

This needs to be updated to only have statuses of New, Approved and Ready to Post.

This comes from the 'Status' on the 'Home' tab of the Invoice/Credit Memo Record View and represents the status of the transaction. This 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 - all exc. Sales Order
Def - Status - all exc. Sales Order
nopaneltrue

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Transaction

Insert excerpt
Transaction ID - LV
Transaction ID - LV
nopaneltrue

 
Insert excerpt
Def - Transaction IDDef - Transaction ID
nopaneltrue
Insert excerpt
Def - Transaction ID
Def - Transaction ID
nopaneltrue

Database Field: ERPx_APTransactionHeader.TransactionID

Transaction Class

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

Database Fields: ERPx_APTransactionClass.TransactionClassDescription ,ERPx_APTransactionHeader.TransactionClassSK

Transaction Type

Insert excerpt
Def - Transaction Types
Def - Transaction Types
nopaneltrue
 This comes from the Transaction Type selected when starting a new transaction. This is never editable.

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

UOM

Insert excerpt
Def - Not Defined
Def - Not Defined
nopaneltrue
This comes from the 'UOM' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is not required. This is always editable while the transaction is in a Status of New. 

Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK

Vendor

Insert excerpt
Def - Vendor ID
Def - Vendor ID
nopaneltrue
 This represents the ID 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.

Database Fields: ERPx_APVendor.VendorID ,ERPx_APTransactionHeader.VendorSK

Vendor Class

Insert excerpt
Def - Vendor Class
Def - Vendor Class
nopaneltrue
 This comes from the 'Vendor Class' assigned to 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 the transaction.

Database Field: ERPx_APVendorClass.ClassDescription, ERPx_APTransactionHeader.VendorSK

Vendor Name

Insert excerpt
Def - Vendor Name
Def - Vendor Name
nopaneltrue
 This 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.

Database Fields: ERPx_APVendor.VendorName ,ERPx_APTransactionHeader.VendorSK

...