Database Fields: ERPx_MFCurrency.CurrencyID, Database Field: ERPx_APTransactionHeader.CurrencySKTransactionDate

Toolbar Icons	Description
Column Filter Show/Hide	Insert excerpt Column Filter Show/Hide - Global Column Filter Show/Hide - Global nopanel true
Edit	Insert excerpt Edit - LV 3.0 Edit - LV 3.0 nopanel true
Excel	Insert excerpt Excel - LV 3.0 Excel - LV 3.0 nopanel true
Favorites	Insert excerpt Favorites Add/Remove - Global Favorites Add/Remove - Global nopanel true
Group By Show/Hide	Insert excerpt Group By Show/Hide - Global Group By Show/Hide - Global nopanel true
Help	Insert excerpt Help - Global 3.0 Help - Global 3.0 nopanel true
More Actions	Insert excerpt More Actions - Global 3.0 More Actions - Global 3.0 nopanel true   IQ: PO Linked Lines - Opens an inquiry with all the Purchase Orders, AP Invoices, AP Credit Memos, and Inventory Receipts with this Purchase Order assigned.  RV: Transaction - Opens the Transaction Record View. RV: Purchase Order - Opens the record view of the Purchase Order. If there is not a linked PO, a message will appear indicating "There is no Purchase Order for this transaction."  View in PaperVision - This option is only visible when the preferences for PaperVision are configured.
New	Insert excerpt New - Multi-Select Trans Type - Global New - Multi-Select Trans Type - Global nopanel true   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 nopanel true
Quick Column Filter	Insert excerpt Quick Column Filter Quick Column Filter nopanel true
Refresh	Insert excerpt Refresh - Global 3.0 Refresh - Global 3.0 nopanel true
Saved Layouts	Insert excerpt Column Layouts for Framework 3.0 - Global Column Layouts for Framework 3.0 - Global nopanel true
Fields	Description
Checkbox	Insert excerpt Checkbox Checkbox nopanel true
1099 Amount	Identifies the amount applicable to the Vendor's 1099 statement amount.  This is a numeric text box that is not required and defaults as follows: If the 1099 Type is set to "No 1099", the 1099 Amount is blank and not editable If the 1099 Type is set to any value other than "No 1099" the 1099 Amount will default to the "Amount" value for the corresponding line item but can be overwritten to a value less than the "Amount" value. If a value is entered that is more than this amount, it will default back to the "Amount" value for the line item.  This is always editable even after the transaction is posted. If the 1099 Type value is updated to "No 1099", the 1099 Amount value will be cleared, and if a 1099 Amount is entered manually by the user when the line item is added, the 1099 Amount will not default from or be updated to the line "Amount".   Database Field: ERPx_APTransactionLine.TenNinetyNineAmount
1099 Type	Insert excerpt Def - 1099 Type Def - 1099 Type nopanel true  This is a single-select lookup that defaults from the 1099 Type of the Vendor assigned to the transaction. This is required and is always editable even after the transaction is posted.   This lookup contains all the values in the ERPx_APTenNinetyNineType table. Database fields: ERPx_APTenNinetyNineType.TenNinetyNineTypeDescription, ERPx_APVendor.TenNinetyNineTypeSK, ERPx_APTransactionLine.TenNinetyNineTypeSK
Amount	Insert excerpt Amount - Extended Amount - Extended nopanel true  This is required and is calculated as [Quantity] * [Price] for each transaction line. This can only be edited by changing the Quantity and/or Price of the transaction line. Positive lines represent a purchase and negative lines represent a purchase credit. Database Field: ERPx_APTransactionLine.ExtendedAmount
Comment	Insert excerpt Comment - Header Comment - Header nopanel true  This is not required and can be edited from the 'Comment' 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.Description
Currency ID	Insert excerpt Currency Currency nopanel true  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 nopanel true Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK
Distributed To	Insert excerpt Distributed To - Vendor Distributed To - Vendor nopanel true This is not required and can be edited from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. This 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 Type	Insert excerpt Distributed To Type Distributed To Type nopanel true  (Project, Fisherman, Tender or Loan). This is not required and is derived from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View and is calculated by multiplying the Quantity and Price of the transaction line. This can is only be edited editable by changing the Quantity and/or Price of Distributed To field on the transaction line. Positive lines represent a purchase and negative lines represent a purchase credit. This contains the associated value in the MFDistributionType Enumeration Class. Database Field: ERPx_APTransactionLine.ExtendedAmountToMFDistributionTypeEN
Currency IDDoc Date	Insert excerpt CurrencyDoc DateCurrency Doc Date nopanel true  This is required and comes can be edited from the 'Currency IDDoc Date' on the 'PropertiesHome' tab of the Invoice/Credit Memo Record View. This is not always editable on , even after the transaction is Posted.
Insert excerpt
Def - Currency	Def - Currency
nopanel	true
DescriptionDoc No	Comment - Header Insert excerpt	Comment - Header

Doc No Doc No nopanel true

 This is not required and can be edited from the 'DescriptionDoc 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 , even after while the transaction is Postedis in a Status of New.

Database Field: ERPx_APTransactionHeader.DescriptionDocNumber

Distributed ToGL DateDistributed To - Vendor

Insert excerpt

Distributed To - Vendor

GL Date GL Date nopanel true

This is

not

required and can be edited from the '

Distributed To' on the Item grid of the Invoice/Credit Memo Record View. This

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

Fields

Field: ERPx_

APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APTransactionLine.ToDistributionAccountSKDistributed Type

APTransactionHeader.GLDate

GL PeriodDistributed To Type

Insert excerpt

Distributed To Type

GL Period GL Period nopanel true

 This This is not required and is derived from the 'Distributed To' on the Item grid calculated using the 'GL Date' on the 'Properties' tab of the Invoice/Credit Memo Record View. Because this defaults from the Project, Employee, Fisherman, Tender or Loan, it is only editable by changing the Distributed To field on the transaction. This contains the associated value in the MFDistributionType Enumeration Class.

Database Field: ERPx_APTransactionLine.ToMFDistributionTypeEN

Doc DateThis can only be edited by changing the GL Date.GL YearItem AddedDoc NoItem Added Bynopaneltrue 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.Doc NoDoc NoAPTransactionHeaderDocNumberGL DateItem DescriptionGL DateGL DateThis 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

Item ID

Insert excerpt
Item ID Item ID nopanel true

 This is required.

Database Field: ERPx_APTransactionHeader.GLDate

GL Period

APTransactionLine.ItemSK, ERPx_IMItem.ItemID

Item Last UpdatedGL Year

Insert excerpt

GL PeriodGL Periodnopaneltrue 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.

Item Last Updated (Date & Time) Item Last Updated (Date & Time) nopanel true

Database Field: ERPx_APTransactionLine.LastUpdated

Item Last Updated ByGL Yearnopaneltrue 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.Item Added

Insert excerpt

GL Year

Last Updated By Last Updated By nopanel true

Database Field: ERPx_APTransactionLine.LastUser

Item Type

Added (Date/Time) Added (Date/Time)Item Added By

Line Comment

Insert excerpt
Line Item

Added By

Comment

Item Added BynopaneltrueItem Description

Line Item Comment nopanel true

This is not required and is always editable even after the transaction is posted.

Database Field: ERPx_APTransactionLine.LineDescription

Ln.

Description - Item

Insert excerpt

Description - Item

Ln. - RV Items Grid Ln. - RV Items Grid nopanel true

This is

required and can be edited from the 'Description' on the Item grid of the Invoice/Credit Memo Record View. This is always editable even after the transaction is posted

not required.

Database Field: ERPx_APTransactionLine.

LineDescriptionItem Last Updated

LineNumber

Payable GL Account

Item Last Updated (Date & Time)Item Last Updated (Date & Time)Item Last Updated ByLast Updated ByLast Updated By

Payable GL Account Description

Payable Account Description Insert excerptPayable Account DescriptionPayable Account DescriptionnopaneltrueThis is required and 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. Insert excerptDef - GL Account - Accounts PayableDef - GL Account - Accounts Payablenopaneltrue

Database Fields: ERPx_GLAccount.Description, ERPx_APVendor.APGLAcctRef

Pmt./Apply HoldDisplays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold.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 #

Pmt./Apply Hold the Properties 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 InvoiceIsOnApplicationHold

PO

Insert excerptPurchase OrderPurchase Ordernopaneltrue 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 Ln.

APTransactionHeaderPurchaseOrderIDPrice

Purchase GL Account

Purchase GL Account Description

Quantity

Reference

Insert excerpt
Reference Reference nopanel true

This is text box that is not required and is always editable even after the transaction is posted.

Insert excerpt
Def - Reference # Def - Reference # nopanel true

StatusTransaction

Transaction Class ID

Transaction Type

Insert excerpt
Transaction Type Transaction Type nopanel true

 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 nopanel true

Database Fields: ERPx_APTransactionType.TransactionName, ERPx_APTransactionHeader.TransactionClassSK

UOM

Vendor Class ID

Vendor ID

Insert excerpt
Vendor ID Vendor ID nopanel true

 This is required and 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.

Insert excerpt
Def - Vendor ID Def - Vendor ID nopanel true

Database Fields: ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSK

Vendor Name

Insert excerpt
Vendor Name Vendor Name nopanel true

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 nopanel true

Database Fields: ERPx_APVendor.VendorName, ERPx_APTransactionHeader.VendorSK