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

...

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

...

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

 

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

Software Version: 2023.06.30 and newer

Table of Contents
type flat

Page Header

Distributed To TypeDoc NoDistributed To Type

Insert excerpt

Distributed To Type

Doc No Doc No nopanel true

 This is

not

required and

is derived

can be edited from the '

Distributed To

Doc No' 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

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_

APTransactionLine

APTransactionHeader.

ToMFDistributionTypeEN

DocNumber

Doc GL Date

Insert excerpt

Doc

GL Date

Doc

GL Date nopanel true

This is required and can be edited from the '

Doc

GL Date' on the '

Home

Properties' tab of the Invoice/Credit Memo Record View.

This is always editable

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.

TransactionDate

GLDate

Doc DescriptionGL PeriodDescription - Header

Insert excerpt

Description - Header

GL Period GL Period nopanel true

This is not required and can be edited from calculated using the 'DescriptionGL Date' on the the 'HomeProperties' tab of the Invoice/Credit Memo Record View. This is always editable, even after the transaction is Posted.

Database Field: ERPx_APTransactionHeader.Description

Doc Nocan only be edited by changing the GL Date.GL YearDoc NoDoc No can be edited from Doc No the Home and represents the transaction/Invoice # assigned by your Vendor. This is always editable while the transaction is in a Status of NewItem DescriptionAPTransactionHeaderDocNumberExtended

Item ID

Amount - Extended

Insert excerpt

Amount - Extended

Item ID Item ID nopanel true

 This is required

and comes from the 'Extended' 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 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

.ExtendedAmountGL Date

.ItemSK, ERPx_IMItem.ItemID

Item Last Updated

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 excerptGL PeriodGL Period

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

Database Field: ERPx_APTransactionLine.LastUpdated

Item Last Updated By

Insert excerpt
Last Updated By Last Updated By nopanel true

Database Field: ERPx_APTransactionLine.LastUser

Item Type

Line Comment

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 YearLine DescriptionItem Description

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

not required.

Database Field: ERPx_APTransactionLine.

LineDescription

LineNumber

Payable GL Account

Payable GL Account Description

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 #

This always editable while the transaction is in a Status of New.PurchaseOrderIDPrice Insert excerptPricePricenopaneltrue This is required and can be edited from the 'Price' on the Item grid of the Invoice/Credit Memo Record View. This is always

PO Ln.

PricePurchase Account

Purchase GL Account

Description

Quantity

Purchase GL Account Description

QuantityStatus

Reference

Def - Status - New

Insert excerpt

Def - Status - New

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 -

Status - ApprovedDef - Status - Approvednopaneltrue

Database Fields: ERPx_APTransactionStatus.StatusName, ERPx_APTransactionHeader.TransactionStatusSK

Trans Created 

Reference # Def - Reference # nopanel true

StatusCreatedCreated

Linked Database Field: ERPx_APTransactionHeader.CreatedDate

Trans Created ByCreated ByCreated By

Linked Database Field: ERPx_APTransactionHeader.CreatedBy

Trans Last UpdatedLast UpdatedLast Updated

Linked Database Field: ERPx_APTransactionHeader.LastUpdated

Trans Last Updated ByLast Updated ByLast Updated ByLinked Field: LastUserTransaction

Transaction Class ID

Transaction 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

UOM

Vendor Class ID

ID IDThis represents ID of This is only editable by changing the Vendor assigned to the 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