Versions Compared

Old Version 20

changes.mady.by.user Janice Dannenberg

Saved on

compared with

New Version Current

changes.mady.by.user Emma Greenwood

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Software Version: YYYY.MM.DD and newer

Table of Contents
typeflat

Page Header

...

  • Date From: a text box to enter a starting Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
  • Date To: a text box to enter an ending Transaction Date. If entered, this must be in a valid date format. A blank assumes All.
  • Status: a multi-select check box to limit the data that is returned to one or more selected Statuses. Options include: New, Approved, Ready To Post, Posted, Void, Deleted, Replaced. The default values are "New, Approved, Ready To Posted and Posted".

...

Insert excerpt
Def - Trans - AP Invoice/Credit Memo
Def - Trans - AP Invoice/Credit Memo
nopaneltrue
 

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.08.31 and newer

Table of Contents
typeflat

Page Header

Filter ItemsDescription
Auto Hide Filters
Insert excerpt
Auto Hide Filters
Auto Hide Filters
nopaneltrue
Auto Refresh on Open
Insert excerpt
Auto Refresh on Open
Auto Refresh on Open
nopaneltrue
Also Include

Insert excerpt
Inq - Include
Inq - Include
nopaneltrue

  • Voids & Replaced
  • Unposted Transactions
Date Option

Insert excerpt
Date Type Lookup
Date Type Lookup
nopaneltrue

  • Doc Date
  • GL Date
Date Range
Insert excerpt
Date Control Text Box
Date Control Text Box
nopaneltrue
Saved Searches
Insert excerpt
Search Options for Framework 3.0 - Global
Search Options for Framework 3.0 - Global
nopaneltrue
Search

Insert excerpt
Search - Search Options
Search - Search Options
nopaneltrue

  • Doc No
  • Item & Doc Description
  • Purchase Order
  • Transaction
  • Vendor ID
  • Vendor Name
Transaction Class

Insert excerpt
Inq - Transaction Class
Inq - Transaction Class
nopaneltrue
The values in this lookup are listed alphabetically. If there is more than one Transaction Class for the Transaction Type, then the value in the lookup will display as [Transaction Type] - [Transaction Class]. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Transaction Class - General
Def - Transaction Class - General
nopaneltrue

The lookup contains a list of all 'Active' AP Transaction Classes.

Vendor

Used to select one or more Vendors. This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Vendor
Def - Vendor
nopaneltrue

The lookup contains a list of all 'Active' Vendors. 

Vendor Class

Insert excerpt
Inq - Vendor Class
Inq - Vendor Class
nopaneltrue
 This is a multi-select standard lookup that is not required to return results. It defaults as blank.

Insert excerpt
Def - Vendor Class
Def - Vendor Class
nopaneltrue

The lookup contains a list of all 'Active' AP Vendor Classes.

Page Detail

Database Fields: ERPx_MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySK

Distributed To

is always editable while the transaction is in a Status of New.

Database Field: ERPx_APTransactionHeader.DocNumber

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
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
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
More Actions

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

  • IQ: PO Linked Lines -Opens an inquiry with all the Purchase Orders, AP Invoices, AP Credit Memos, and Inventory Receipt lines with this Purchase Order assigned. 
  • RV: Transaction. Opens the Transaction Record View in a new Tab.
  • 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." 
  • Void Transaction: Opens the Void Transaction Window.
  • View in PaperVision - This option is only visible when the preferences for PaperVision are configured.
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
Refresh - Global
nopaneltrue
Saved Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
Search Options
Insert excerpt
Search Options - Inquiry Grid 3.0
Search Options - Inquiry Grid 3.0
nopaneltrue
FieldsDescription
CheckboxUsed to select one or more records.
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
nopaneltrue
 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
nopaneltrue
 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
Line Item Comment
Line Item Comment
nopaneltrue
 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


Insert excerpt
Currency
Currency
nopaneltrue
 This is required and comes from the 'Currency' 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

Distributed To

Insert excerpt
Distributed To - Vendor
Distributed To - Vendor
nopaneltrue
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
nopaneltrue
 (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. This 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 Date

Insert excerpt
Doc Date
Doc Date
nopaneltrue
 This is required and can be edited from the 'Doc 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.TransactionDate

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 defaults from the Currency setup on the Vendor and is not editable on the transaction.
Insert excerpt
Def - CurrencyDef - Currency
nopaneltrue
GL DateDistributed To

Insert excerpt

Distributed To

GL Date
GL Date
nopaneltrue
This

comes from the 'Distributed To' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and

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.

Insert excerptDef - Not DefinedDef - Not DefinednopaneltrueDatabase Fields

Database Field: ERPx_

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

APTransactionHeader.GLDate

GL Period

Insert excerpt
Distributed To TypeDistributed To TypeGL Period
GL Period
nopaneltrue
 This is derived from This is required and calculated using the 'Distributed ToGL Date' on the Item grid the 'Properties' tab 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

This can only be edited by changing the GL Date.

GL YearDoc Date

Insert excerpt

Doc Date

GL Year
GL Year
nopaneltrue

 This comes from

This is required and calculated using the '

Doc

GL Date' on

the

the '

Home

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

can only be edited by changing the GL Date.

Item Description

Insert excerpt

Doc

Item Description

Doc

Item Description
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

 This is required.

Database Field: ERPx_

APTransactionHeader.DescriptionDoc No

APTransactionLine.ItemSK, ERPx_IMItem.ItemDescription

Item ID


Insert excerpt
Doc NoDoc NoItem ID
Item ID
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 This is required.

Database Field: ERPx_APTransactionLine.ItemSK, ERPx_APTransactionHeaderIMItem.DocNumberItemID

Extended Item Last UpdatedExtended

Insert excerpt

Extended

Item Last Updated (Date & Time)
Item Last Updated (Date & Time)
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 Field: ERPx_APTransactionLine.

ExtendedAmountGL Date

LastUpdated

Item Last Updated By

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.

Insert excerpt
GL DateGL Date
Last Updated By
Last Updated By
nopaneltrue

Database Field: ERPx_APTransactionHeaderAPTransactionLine.GLDateLastUser

GL Period

Item Type


GL Period

Insert excerpt

GL Period

HELP:Item Type: Inventory
HELP:Item Type: Inventory
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

required.

Line Comment


Insert excerpt
Line Item Comment
Line Item Comment
nopaneltrue
This is not required and is always editable even after the transaction is posted.

Database Field: ERPx_APTransactionLine.LineComment

Line DescriptionGL Year

Insert excerpt

GL Year

Line Description
Line Description
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

 This is a textbox that defaults to Item Description for the corresponding Item and is editable from the record view while in 'New' status. 

Image Added When AP Invoices, Credit Memos are loaded from a PO, this will default as the 'Line Description' on those transactions.

Database Fields: ERPx_IMItem.ItemDescription, ERPx_APTransactionLine.LineDescription, ERPX_APPoLine.LineDescription

Ln.

Description - Itemnopaneltrue 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.

Insert excerpt
Description - Item
Ln. - RV Items Grid
Ln. - RV Items Grid
nopaneltrue
This is not required

Database Field: ERPx_APTransactionLine.LineDescriptionLineNumber

Payable GL Account

Insert excerpt
Payable Account
Payable Account
nopaneltrue
This is required and comes from the Vendor's 'Accounts Payable' on the 'GL Accounts' tab of the Vendors List View. Because this defaults from the Vendor, it is not editable on the transaction.

Insert excerpt
Def -

Not Defined

GL Account - Accounts Payable
Def -

Not Defined

GL Account - Accounts Payable
nopaneltrue

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_APVendor.APGLAcctRef

Payable GL Account Description

Insert excerpt
Payable Account Description
Payable Account Description
nopaneltrue
This is required and comes from the Vendor's 'Accounts Payable' on the 'GL Accounts' tab of the Vendors List View. Because this defaults from the Vendor, it is not editable

on the transaction.

on the transaction.

Insert excerpt
Def - GL Account - Accounts Payable
Def - GL Account - Accounts Payable
nopaneltrue

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 'Propertiesfor 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

. 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

    and represents the purchase order you used when making the purchase. This is always editable while the transaction is in a Status of New.

    (lightbulb) This field is only used for Purchase Orders setup in NorthScope. The 'Reference' field should be used to record a PO# on a transaction when the PO# does not exist in NorthScope. 

    Database Field: ERPx_APTransactionHeader.

    IsOnApplicationHold

    PurchaseOrderID 

    PO

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


    Identifies the Purchase Order line item that the AP Invoice/Credit Memo line item is linked to. This is a single-select lookup that is not required. This is

    always

    editable while the transaction is in a

    Status of New.

    Status of "New". 

    Image Added The Price and Quantity will not default from the Purchase Order line item. 

    Database Field: ERPx_

    APTransactionHeader

    APTransactionLine.

    PurchaseOrderID

    POLineSK

    Price

    Insert excerpt
    Price
    Price
    nopaneltrue
    This comes is required and can be edited from the 'Price' on the Item grid of the Invoice/Credit Memo Record View. This defaults as "0.00" and is required when the Status is set to Approved. This is always editable while the transaction is in a Status of New.

    Database FieldFields: ERPx_APTransactionLine.Price

    Purchase GL Account


    Insert excerpt
    Purchase Account - Item
    Purchase Account - Item
    nopaneltrue
    This comes is required and can be edited from the 'Purchase GL Account' on the Item grid of the Invoice/Credit Memo Record View. This defaults as blank and is required when the Status is set to Approved. This is always editable while the transaction is in a Status of New.  Insert excerptDef - Not DefinedDef - Not Definednopaneltrue 

    Database Fields: ERPx_GLAccount.AccountNumber,   ERPx_APTransactionLine.AccountSK

    Purchase GL Account Description


    Insert excerpt
    Purchase Account Description
    Purchase Account Description
    nopaneltrue
     This

    comes

    is required and can be edited from the 'Purchase GL 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
    Quantity
    Quantity
    nopaneltrue
    This

    comes

    is required and can be edited 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 Field: ERPx_APTransactionLine.Quantity

    New. 

    Database Fields: ERPx_APTransactionLine.Quantity

    Reference


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

    Insert excerpt
    Def - Reference #
    Def - Reference #
    nopaneltrue

    Status

    Insert excerpt
    Status
    Status
    nopaneltrue
     This

    comes

    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

    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
    Def - Status
    nopaneltrue
     The Statuses that apply to transaction 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 PostDef - Status - Ready to Postnopaneltrue Insert excerptDef - Status -

    Posted
    Def - Status - Posted

    nopaneltrue Insert excerptDef - Status - VoidDef - Status - Void

    nopaneltrue

    Insert excerpt
    Def - Status -

    Deleted

    Void
    Def - Status -

    Deleted

    Void
    nopaneltrue

    Insert excerpt
    Def - Status - Replaced
    Def - Status - Replaced
    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.

    TransactionHeaderID

    TransactionID

    Transaction Class ID


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

    defaults as 'Default' and

    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

    UOM

    Insert excerpt
    UOM - Units
    UOM - Units
    nopaneltrue
     This

    comes

    is not required and can be edited 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

    is only editable while the transaction is in a Status of New. 

    Insert excerptDef - Not DefinedDef - Not Definednopaneltrue

    Database Fields: ERPx_IMUOM.UOMID, ERPx_APTransactionLine.QuantityUOMSK

    Vendor Class ID


    Insert excerpt
    Vendor

    ID

    Class
    Vendor

    ID

    Class
    nopaneltrue
     This

    represents the ID of

    is required and 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 the

    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     comes from the 'Vendor Class' assigned to is required and 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 Fields: ERPx_APVendorClassAPVendor.ClassDescriptionVendorID,  ERPxERPx_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,  ERPxERPx_APTransactionHeader.VendorSK

    Related Topics



    Expand
    titlePage Definitions

    Page Definitions


    ...