Page Comparison

Add Item

Add Vendor Item

Column Filter Show/Hide

Excel

Group By Show/Hide

Item Notes

More Actions

• IQ: Item Purchase Order History - Opens the "Purchase Order Lines History" Inquiry showing all the Purchase Order Lines for the Vendor.

• IQ: Line Item History - Opens the "Invoice Lines History" Inquiry showing all the AP Invoice and AP Credit Memo lines for the Vendor.

• IQ: PO Linked Lines - Opens the "PO Linked Lines" inquiry showing the Purchase Order and all the AP Invoice, AP Credit Memo, and Inventory Receipt lines associated with this Purchase Order Item.

• RV: Item - Open the item Record View for the selected item.

Quick Column Filter

Saved Layouts

Remove Items

Fields

Description

Transaction Line Items and quantities can be manually added or auto-added if they reference a valid Purchase Order.

1. AP Invoices with a valid PO# will auto-add all line items with a "remaining quantity" >0 that are not already on the Invoice Transaction. The 'Quantity' will default from the remaining quantity and the 'Price' from the current price saved on the Purchase Order for the Item.

2. Credit Memos with a valid PO# will auto-add all Purchase Order items that are not already on the Credit memo. The 'Quantity' will default as 0.00 and the 'Price' from the current price saved on the Purchase Order for the Item.

Checkbox

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

This lookup contains all the values in the ERPx_APTenNinetyNineType table.

Database fields: ERPx_APTenNinetyNineType.TenNinetyNineTypeDescription, ERPx_APVendor.TenNinetyNineTypeSK, ERPx_APTransactionLine.TenNinetyNineTypeSK

Amount

Database Field: ERPx_APTransactionLine.ExtendedAmount

Distributed To

For AP Invoices/Credit Memos that are not linked to a Purchase Order this defaults as blank but can be overwritten.

For AP Invoices/Credit Memos assigned with a PO #, this will default from the Purchase Order Items 'Distributed To' value but can be overwritten.

The lookup contains a blank value, the current assigned value, and a list of all the 'Active' Fishermen, Tenders, Loans, and Projects.

Database Fields: ERPx_APVendor.VendorName, ERPx_MFEmployee.EmployeeName, ERPx_GLProject.ProjectDescription, ERPx_APPoLine.ToDistributionAccountSK

Item Description

ERPx_IMItem.ItemDescription, ERPX_APTransactionLine.ItemSK

Item ID

When the 'Add Item' icon is clicked, users may enter all or part of an Item ID or Description and hit the Enter key on the keyboard. If a complete Item ID was entered, the line item will be saved, if not, the Item Lookup dialog will open with a list of items containing the data entered. From the 'Item Lookup' dialog, users may check the checkbox next to one or multiple item(s) to add to the transaction using the Save & Close button.

Database Fields: ERPx_IMItem.ItemID, ERPX_APTransactionLine.ItemSK

Item Type

This defaults from the Item Type assigned to the Item ID and is not editable.

For transaction items that are linked to a PO#:

• All line items with an 'Item Type' of "Inventory" must be received on an Inventory Receipt transaction.

AP Invoice/Credit Memo, only line items with an 'Item Type' of "Inventory" will be included.

Database Fields: ERPx_IMItemType.Description, ERPx_IMItem.ItemTypeSK, ERPX_APTransactionLine.ItemSK

Line Comment

This is not required and is always editable, even after the transaction is posted. If entered, it must be <=100 characters.

For transactions auto-generated from a Grower Ticket, this defaults as follows:

• If the line is from a Ticket Item this defaults as 'Grower Ticket Item'

• If the line is from a Charge this defaults as 'Grower Ticket Item Charge'

• If the line is from an Accrual this defaults as 'Grower Ticket Item Accrual’

When AP Invoices, Credit Memos, and IM Receipts are loaded from a PO, this will default as the 'Line Comment' on those transactions.

Database Field: ERPx_APTransactionLine.LineComment

Line Description

For transactions auto-generated from a Grower Ticket, this defaults as follows:

• If the line is from a Ticket Item this defaults as the Ticket Item Description

• If the line is from a Charge this defaults as '[Ticket Item ID] – Charge: [ChargeID]'

• If the line is from an Accrual this defaults as ‘[Ticket Item ID] – Accrual: [AccrualID]’

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

Line Source

A non-editable textbox that displays where the corresponding line item originates from. This is required and never editable. The available options include:

1. Manual: The line item was manually added by a user.

2. Freight: The line item was auto-added to reflect the Freight + Surcharge amount of a Shipment Leg.

3. Freight - Handling: The line item was auto-added to reflect the Handling amount of a Shipment Leg.

4. Freight - Other: The line item was auto-added to reflect an Other Charge amount of a Shipment Leg.

5. Vendor Item: The line item was added from the 'Find Vendor Items' Record View.

Database Field: ERPx_APPoLine.LineSourceEN

Ln.

For example, if you had line items 10, 20, and 30 and you wanted the last one (Ln. 30) to be second, you could edit the value to any number between 10 and 20 (i.e., 15) and on save the lines would be sorted in the new sequence (10, 15, and 30) and then all Ln.'s would be re-set to base 10 numbers (10, 20, 30).

Database Field: ERPx_APTransactionLine.LineNumber

PO 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. If a 'PO #' is entered/selected for this transaction, as line items are added to the AP Invoice/Credit Memo, if they are also on the Purchase Order, this will default from the header PO#'s Purchase Order's 'Ln.' as [PO#]: [Ln]. This is editable while the transaction is in a Status of "New".

The lookup contains a blank value, the current assigned value, and a list of all 'Open' Purchase Order Line Numbers that match the selected transaction line's Item ID and that are assigned to the transaction Vendor.

When AP Invoices, Credit Memos, and IM Receipts are loaded from a PO, this will default from the 'Ln.' of the Purchase Order Item.

Database Field: ERPx_APTransactionLine.POLineSK,

Price

For transaction lines that are not linked to a Purchase Order this defaults to 0 and is formatted, after save, to the Item's 'Price Decimals'.

For transaction lines that are assigned to a PO #, this will default from the current price saved on the Purchase Order Item.

For transactions auto-generated from a Grower Ticket, this defaults as follows:

• If the line is from a Ticket Item this defaults as the Price on the ticket item

• If the line is from a Charge this defaults as the Gross Amount of the Charge

• If the line is from an Accrual this defaults as Gross Amount of the Accrual

Database Field: ERPx_APTransactionLine.Price

Purchase GL Account

1. For line items that are NOT distributed to a Fisherman, Tender, or Loan, this is editable while the transaction is in a Status of "New" and defaults in the following sequence (but can be overridden):

   1. From the 'Purchase GL Account' assigned to the Purchase Order Line if a Purchase GL Account was specified on the PO.

   2. Defaults from the Vendor's default "Purchases" account if one has been setup.

   3. Otherwise, it defaults from the Item's default "Purchases" account if one has been setup, else it will be blank for the user to select an account.

2. For line items distributed to a Fisherman, Tender, or Loan this is NOT editable and defaults in the following sequence (but can be overridden):

   1. From the Fishermen, Tender, or Loans default "Settlement Accrual" account if one has been setup

   2. From the Fisherman Accounting Preferences default "Settlement Accrual" account

3. For transactions auto-generated from a Grower Ticket, this defaults as follows:

   • If the line is from a Ticket Item this defaults as the Ticket Item Purchase Account

   • If the line is from a Charge this defaults as the Charge GL Account

   • If the line is from an Accrual this defaults as follows:

     • Farmer Transaction

       1. A negative quantity line will default the Accrual Account from the Accrual record

       2. A Positive quantity line will default the Expense Account from the Accrual record

     • Accrual Transaction

       1. This will default the Accrual Account from the Accrual record

The Account can be easily updated using the quick replacement feature, for information on how this works please see this FAQ.

When AP Invoices and/or Credit Memos are loaded from a PO, the 'Purchase Account' will default from the current Purchase Account assigned to the Purchase Order Item.

Database Fields: ERPx_GLAccount.AccountNumber - ERPx_GLAccount.Description, ERPx_APTransactionLine.AccountSK, ERPx_APPoLine.AccountSK

Quantity

For transaction lines that are not linked to a Purchase Order this defaults to 0 and is formatted, after save, to the Item's 'Unit Decimals' or 'Weight Decimals' depending on the line items UOM. If the line item is a Fixed Weight item that requires whole units, then on Save:

1. If a user enters a quantity and a weight UOM we check all conversions back to unit UOMs to verify that the weight value can actually convert back when we create a receipt.

2. If no conversions are found then the following alert will be displayed to the user but will still allow the line item to save.

   1. Alert “Warning: Item [ItemID]: Qty does not convert to any UOMs on the [UOMScheduleID] UOM Schedule.”

3. If a user enters a fractional quantity and selects a unit UOM the following alert will be displayed to the user but will still allow the line item to save.

   1. Alert “Warning: Item [ItemID]: Requires whole units and you have saved a fractional unit.”

These alerts are only displayed where applicable for new lines being added, or if an existing line Quantity or UOM are being updated.

An Item is a 'Fixed Weight' item that requires whole units when the following properties are set as:

• Manage Items By = "Units and Weight"

• Variable Weight = "No"

• Require Whole Units = "Yes"

For transaction lines that are assigned to a PO #, this will default as [PO Line Ordered Qty] - [AP Posted Quantity] - [AP UnPosted Quantity] or 0.00 whichever is greater.

• The [AP Posted Quantity] refers to the Quantity from "Posted" AP Invoices and Credit Memo lines.

• The [AP UnPosted Quantity] refers to the Quantity from "UnPosted" AP Invoices and Credit Memo lines.

For AP Invoice transactions, a positive 'Quantity' represents a purchase and a negative quantity represents a credit. Negative quantities are allowed provided the transactions total 'Amount' is greater than or equal to 0.00. A Quantity of 0.00 can be used for a line item that was not included on the Invoice.

For AP Credit Memo transactions, a positive 'Quantity' represents a credit and a negative quantity represents a purchase. Negative quantities are allowed provided the transactions total 'Amount' is greater than or equal to 0.00. A Quantity of 0.00 can be used for a line item that was not included on the Credit Memo.

Database Field: ERPx_APTransactionLine.Quantity

UOM

For transaction lines that are not linked to a Purchase Order this defaults from the Item's default "Purchasing UOM", but can be changed to any valid UOM that exists on the Items UOM Schedule and is editable while the transaction is in a Status of "New" .

For transaction lines that are linked to a Purchase Order this defaults from Purchase Order Item's UOM but can be overwritten while the transaction is in a Status of "New".

The lookup contains a blank value and all 'Active' UOMs on the selected Item's UOM Schedule.

When AP Invoices and Credit Memos are loaded from a PO, the 'UOM' will default from the Purchase Order Item's UOM.

Database Fields: ERPx_IMUOM.UOMName, ERPx_APPoLine.QuantityUOMSK