Insert excerptDef - Trans - AP Invoice/Credit MemoDef - Trans - AP Invoice/Credit Memonopaneltrue The purpose of this page is to show line item detail for all these unposted transactions.

 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: 2020.06.05 and newer

Table of Contents
type flat

Page Header

...

Insert excerpt
Def - Trans - AP Invoice/Credit Memo Def - Trans - AP Invoice/Credit Memo nopanel true

 The purpose of this page is to show line item detail for all these unposted transactions.

 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: 2020.06.05 and newer

Table of Contents
type flat

Page Header

Distributed To TypeDescriptionDistributed To Type

Insert excerpt

Distributed To Type

Description - Header Description - Header nopanel true

 This is not required and

is derived

can be edited from the '

Distributed To

Description' on the

Item grid

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

This is always editable, even after the transaction is Posted.

Database Field: ERPx_

APTransactionLine

APTransactionHeader.

ToMFDistributionTypeEN

Description

Doc DateDistributed ToDoc DescriptionDistributed TypeDescription - HeaderDescription - HeaderThis can be edited Description 'Home' tab This is always editable, even after the transaction is PostedAPTransactionHeaderDescriptionDoc NoDate No NoThis No and represents the transaction/Invoice # assigned by your Vendor while the transaction is in a Status of NewDocNumberExtendedDoc NoAmount - Extended

Insert excerpt

Amount - Extended

Doc No Doc No nopanel true

This

 This is required and

comes

can be edited from the '

Extended

Doc No' on the

Item grid

'Home' tab of the Invoice/Credit Memo Record View and

is calculated by multiplying the Quantity and Price of the 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

represents the transaction/Invoice # assigned by your Vendor. This is always editable while the transaction is in a Status of New.

Database Field: ERPx_

APTransactionLine

APTransactionHeader.

ExtendedAmount

DocNumber

GL Date

Insert excerpt
GL Date GL Date nopanel true

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

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 YearItem DescriptionAddedDescription - Item

Insert excerpt

Description - Item

Item Added (Date/Time) Item Added (Date/Time) 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.

Database Field: ERPx_APTransactionLine.LineDescription

Payable AccountItem Added By

Insert excerpt
Item Added By Item Added By nopanel true

Item DescriptionPayable Account DescriptionItem Last Updated

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

Item Last Updated By

Insert excerpt
Last Updated By Last Updated By nopanel true

Payable AccountPmt./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 excerptPurchase OrderPurchase OrdernopaneltrueThis Payable Account DescriptionPmt./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 '

PO

Pmt./Apply Hold' on

the

the '

Home

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

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.

PurchaseOrderID

IsOnApplicationHold

PricePO

Insert excerpt

Price

Purchase Order

Price

Purchase Order nopanel true

This

 This is not required and can be edited from the '

Price

PO' on the

Item grid

'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

Fields

Field: ERPx_

APTransactionLine

APTransactionHeader.PurchaseOrderID

PricePurchase AccountPurchase Account DescriptionQuantityPurchase Account DescriptionQuantityStatusStatusTrans Created CreatedCreated

Linked Database Field: ERPx_APTransactionHeader.CreatedDate

Trans Created ByCreated ByCreated Bynopaneltrue

Linked Database Field: ERPx_APTransactionHeader.CreatedBy

Trans Last UpdatedLast UpdatedLast UpdatedLinked Database Field: ERPx_APTransactionHeader.LastUpdatedTrans Last Updated ByLast Updated ByLast Updated ByLinked Field: LastUserTransactionTransaction ClassTransaction Type

Insert excerpt
Transaction Type Transaction Type nopanel true

This  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

UOMVendor Class ID IDThis represents the ID of This is only editable by changing the Vendor assigned to ID ID FieldsAPVendorVendorID Vendor ClassID

Insert excerpt
Vendor

Class

ID Vendor

Class

ID nopanel true

This

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

Database

Field

Fields: ERPx_

APVendorClass

APVendor.

ClassDescription

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