Versions Compared

Version Old Version 1 New Version Current
Changes made by

Emma Greenwood

Tom Williams

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 MemonopaneltrueInventory Transactions are used to manage perpetual item and lot balances. The purpose of this page is to view, add, edit, remove, and post AP Invoices and Credit Memos. Inventory Adjustment, Production, Receipt, Transfer and Transfer Receipt Transactions.  Additionally, users can Mass Update the GL Date, Pmt/Apply Hold, and Status of multiple transactions at once, view Shipment Details for Transfer transactions and Void/Correct transactions.

(lightbulb) This  This list view also contains columns for each Attribute that is set up for the 'AP PurchasingInventory' attribute type. Because these are user defined, they are not included in the default view but can be added a saved layout. AP Purchasing  Inventory attributes are not included in the help documentation.

Software Version: 20202021.0611.0524 and newer

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Edit
Insert excerpt
Edit - LV 3.0
Edit - LV 3.0
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
Grid Layout
Group By Show/Hide
Insert excerpt
Grid Layout
Group By Show/Hide - Global
Grid Layout
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
Mass Update

Insert excerpt
Mass Update - Global 3.0
Mass Update - Global 3.0
nopaneltrue

  • GL Date: A date field that defaults to "(No Change)", but also allows users to select a date from the calendar. Assigns the selected date to the selected/filtered transactions when Apply is clicked.
  • Pmt./Apply Hold: A single-select lookup that defaults to "(No Change)", but also has options for (blank) and "Yes". Assigns the selected value to selected/filtered transactions when Apply is clicked.
    • Status: A single-select lookup that defaults to "(No Change)", but also has options for "New", "Approved" and "Ready to Post". Assigns the selected Status to selected/filtered transactions when Apply is clicked.
    More Actions

    Insert excerpt
    More Actions - Global
    More Actions - 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
    • Adjustment: A transaction to adjust the On Hand balances of items.
    • Production: A transaction to record production, both for items consumed (Inputs) and items created (Output).
    • Receipt: A transaction to record the receipt of inventory purchased.
    • Transfer: A transaction to record the transfer of inventory items between Sites.
    Print
    Insert excerpt
    Print - LV 3.0
    Print - LV 3.0
    nopaneltrue
    FieldsDescriptionCheckboxCheckbox
    Quick Column Filter
    Insert excerpt
    Quick Column Filter
    Quick Column Filter
    nopaneltrue
    Refresh
    Insert excerpt
    Refresh - Global 3.0
    Refresh - Global 3.0
    nopaneltrue
    Saved Layouts
    Insert excerpt
    Checkbox
    Column Layouts for Framework 3.0 - Global
    Column Layouts for Framework 3.0 - Global
    nopaneltrue
    AmountAmount - Transaction
    View

    Insert excerpt

    Amount - Transaction

    Database Field: ERPx_APTransactionHeader.ExtendedAmount

    Currency

    View - Inquiry Grid 3.0
    View - Inquiry Grid 3.0
    nopaneltrue

     This comes from the 'Amount' on the 'Home' tab of the Invoice/Credit Memo Record View and is calculated based on the sum of all transaction lines. This is required and can only be edited by changing the quantity and/or price of one or more transaction lines.
    • Shipment Details - Opens the Shipment Record View, in a new tab, for a selected record with a Transaction Type of: SO Shipment, Transfer, or Transfer Receipt.
    FieldsDescription
    Checkbox
    Insert excerpt
    Currency
    Checkbox
    Currency
    Checkbox
    nopaneltrue
     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
    BOL

    Identifies the Bill of Lading reference/ID that was entered on the corresponding Transfer transaction. If no value was entered by the user, this field is populated with the Transaction ID of the corresponding Transfer when the record is saved.  This is not required and can be edited on the 'Home' tab of the record view.  This field is always editable while the transaction is in a status of New.

    Insert excerpt
    Def -

    Currency

    Bill of Lading
    Def -

    Currency

    Bill of Lading
    nopaneltrue

    Database

    Fields

    Field:

    ERPx

     ERPx_

    MFCurrency.CurrencyID, ERPx_APTransactionHeader.CurrencySKDoc DateDoc Date

    IMTransactionHeader.BOL

    Comment

    Insert excerpt
    Comment - Header
    Comment - Header
    nopaneltrue

    Database Field: ERPx_IMTransactionHeader.Description

    Corrected From

    Insert excerpt

    Doc Date

    Corrected From
    Corrected From
    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.

    field only displays a value when the transaction was corrected and is never editable.  

    Database Field:

    ERPx

     ERPx_

    APTransactionHeader

    IMTransactionHeader.

    TransactionDate

    CorrectedFromTransactionHeaderSK

    Doc DescriptionDescription - Header
    Created 

    Insert excerpt

    Description - Header

    Created
    Created
    nopaneltrue

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

     

    Database Field:

    ERPx

     ERPx_

    APTransactionHeader

    IMTransactionHeader.

    Description

    CreatedDate

    Doc NoDoc No
    Created By

    Insert excerpt

    Doc No

    Created By
    Created By
    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 is always editable while the transaction is in a Status of New.

     

    Database Field:

    ERPx

     ERPx_

    APTransactionHeader

    IMTransactionHeader.

    DocNumber

    CreatedBy

    GL Date

    Insert excerpt
    GL Date
    GL Date
    nopaneltrue
     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 PeriodGL Period

    on the Transfer transaction record view.  If no value is specified, this field will be populated with the transaction date on save. 

    Database Field: ERPx_IMTransactionHeader.GLDate

    Last Updated

    Insert excerpt

    GL Period

    GL Year

    Last Updated
    Last Updated
    nopaneltrue

     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 Year

    Database Field: ERPx_IMTransactionHeader.LastUpdated

    Last Updated By

    Insert excerpt

    GL Year

    Payment Terms

    Last Updated By
    Last Updated By
    nopaneltrue

      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.Payment Terms

    Database Field: ERPx_IMTransactionHeader.LastUser

    PO #

    Insert excerpt

    Payment Terms

    Purchase Order
    Purchase Order
    nopaneltrue

     This is required and can be edited from the 'Payment Terms' on the 'Home' tab of the Invoice/Credit Memo Record View. This is always editable while

    Database Field: ERPx_IMTransactionHeader.POHeaderSk

    Received From

    Identifies the name of the entity (Vendor, Fisherman, Grower, etc.) the product was received from. 

    This is only required if a PO # has been entered on the transaction. This is editable when the transaction is in a Status of "New

    . If the Payment Terms are changed, the 'Due Date' and 'Discount Date' values will be automatically updated based on the new Payment Terms. Insert excerptDef - Payment TermsDef - Payment Termsnopaneltrue

    Database Fields: ERPx_MFPaymentTerms.PaymentTermName, ERPx_APTransactionHeader.PaymentTermSK

    Pmt./Apply HoldDisplays as "Yes" for AP Invoices and Credit Memos that are on a Payment or Application hold.

    " for Receipts that are not linked to a PO #. For Receipts that are linked to a PO #, this is not editable.

    Database Field: ERPx_IMTransactionHeader.ReceivedFrom

    Reference

    Insert excerpt
    Reference
    Reference
    nopaneltrue
     This is not required and can be edited from the '

    Pmt./Apply Hold

    Home'

    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

    POPurchase Order

    tab on the record view while in the status of New. 

    Database Field: ERPx_IMTransactionHeader.Reference

    Site ID

    Insert excerpt

    Purchase Order

    Site ID
    Site ID
    nopaneltrue
     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 editable while the transaction is in a Status of New.Database Field: ERPx_APTransactionHeader.PurchaseOrderID

    on the record view while in the status of New prior to Save. 

    Insert excerpt
    Def - Site
    Def - Site
    nopaneltrue

    Database Fields: ERPx_MFSite.SiteID, ERPx_IMTransactionHeader.SiteSK

    Site Name

    Insert excerpt
    Site Name - LV
    Site Name - LV
    nopaneltrue

    Database Fields: ERPx_MFSite.SiteName, ERPx_IMTransactionHeader.SiteSK

    Status

    Insert excerpt
    Status
    Status
    nopaneltrue
     This is required and can be edited from the 'Status' on the 'Home' tab of the

    Invoice/Credit Memo

    Adjustment, Production, Receipt and Transfer Record View and represents the status of the transaction. 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 transactions 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 Post
    Def - Status - Ready to Post
    nopaneltrue

    Database

    Fields

    Field:

    ERPx

     ERPx_

    APTransactionStatus

    IMTransactionStatus.

    StatusName

    TransactionStatusName, ERPx_

    APTransactionHeader

    IMTransactionHeader.TransactionStatusSK

    Transaction
    To Site ID

    Insert excerpt

    Transaction

    To Site ID

    Transaction

    To Site 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.

     This is required and can be edited from the 'Home' tab on the record view while in the status of New prior to Save.  This field is only visible on Transfer type transactions. 

    Insert excerpt
    Def -

    Transaction ID

    Site
    Def -

    Transaction ID

    Site
    nopaneltrue

    Database Field: ERPx_MFSite.SiteID, ERPx_

    APTransactionHeader

    IMTransactionHeader.

    TransactionIDTransaction ClassTransaction Class

    ToSiteSK

    To Site Name

    Insert excerpt

    Transaction Class

    To Site Name
    To Site Name
    nopaneltrue
     This is required and

    comes

    can be edited from the '

    Transaction Class

    Home' tab on the

    'Properties' tab of the Invoice/Credit Memo Record View. This is not editable.

    record view while in the status of New prior to Save.  This field is only visible on Transfer type transactions. 

    Insert excerpt
    Def -

    Transaction Class

    Site
    Def -

    Transaction Class

    Site
    nopaneltrue

    Database

    Fields

    Field: ERPx_

    APTransactionClass

    MFSite.

    TransactionClassDescription, ERPx_APTransactionHeader.TransactionClassSKTransaction Type

    SiteName, ERPx_IMTransactionHeader.ToSiteSK

    Trans Date

    Insert excerpt
    Doc Date
    Doc Date
    nopaneltrue
     This is not required and can be edited from the 'Home' tab on the record view while in the status of New.  For Transfer type transactions this is the 'Transferred On' date. 

    Database Field: ERPx_IMTransactionHeader.TransactionDate

    Transaction Class

    Insert excerpt
    Transaction

    Type

    Class
    Transaction

    Type

    Class
    nopaneltrue
     This is required and

    comes from the Transaction Type selected when starting a new transaction. This is never editable.

    is a system assigned value based on which transaction class the user created the transaction in.  It is never editable by a user. 

    Insert excerpt
    Def - Transaction

    Types

    Class - General
    Def - Transaction

    Types

    Class - General
    nopaneltrue

    Database

    Fields

    Field:

    ERPx

    ERPX_

    APTransactionType

    IMTransactionClass.

    TransactionName

    TransactionClassID,ERPx_

    APTransactionHeader

    IMTransactionHeader.TransactionClassSK

    Vendor
    Transaction ID

    Insert excerpt

    Vendor

    Transaction ID

    Vendor

    Transaction ID
    nopaneltrue

     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.

     Clicking on the link opens the corresponding transaction record view.  This is a system assigned value and is never editable by a user. 

    Insert excerpt
    Def -

    Vendor

    Transaction ID
    Def -

    Vendor

    Transaction ID
    nopaneltrue

    Database

    FieldsVendor Class

    Field:

    ERPx_APVendor.VendorID, ERPx_APTransactionHeader.VendorSKVendor Class

     ERPx_IMTransactionHeader.TransactionID

    Transaction Type

    Insert excerpt
    Transaction Type
    Transaction Type
    nopaneltrue
     This is a system assigned value and is never editable by a user.  The transaction types are: Adjustment, Production, Receipt and Transfer. 

    Insert excerpt
    Def - Transaction Types
    Def - Transaction Types
    nopaneltrue

    Database Field: ERPx_IMTransactionType.TransactionTypeDescription, ERPx_IMTransactionHeader.TransactionTypeSK

    Via Site ID

    Insert excerpt

    Vendor Class

    Via Site ID
    Via Site ID
    nopaneltrue
     This is not required and

    comes

    can be edited 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.

    Home' tab on the record view while in the status of New prior to Save.  This field is only visible on Transfer type transactions. 

    Insert excerpt
    Def -

    Vendor Class

    Site
    Def -

    Vendor Class

    Site
    nopaneltrue

    Database Field: ERPx_

    APVendorClass

    MFSite.

    ClassDescription

    SiteID, ERPx_

    APTransactionHeader

    IMTransactionHeader.

    VendorSK

    ViaSiteSK

    Vendor
    Via Site Name

    Insert excerpt

    Vendor

    Via Site Name

    Vendor

    Via Site Name
    nopaneltrue

    This

     This is not 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.

    can be edited from the 'Home' tab on the record view while in the status of New prior to Save.  This field is only visible on Transfer type transactions. 

    Insert excerpt
    Def -

    Vendor Name

    Site
    Def -

    Vendor Name

    Site
    nopaneltrue

    Database

    Fields

    Field: ERPx_

    APVendor

    MFSite.

    VendorName

    SiteName, ERPx_

    APTransactionHeader

    IMTransactionHeader.

    VendorSK

    ViaSiteSK

    Related Topics



    Expand
    titlePage Definitions

    Page Definitions


    ...