Commodity

The Commodity tab on the Invoice (IN) transaction is used to record all information pertaining to a particular commodity line of the Vendor’s Invoice such as the quantity and the unit price.

This tab records the reference information for the award transaction. Because this information is at the commodity level it allows the IN to reference more than one award transaction. All commodity information will initially default from the referenced Award transaction; however, this information may be changed to reflect the actual values invoiced by the vendor. In addition, Discount Terms may also be supplied for individual commodity lines.

Freight can be applied to an Invoice in ONLY one way. Freight must be added to the Invoice using a separate Commodity Line. Referencing an Award with an Invoice that has added Freight charges can be done with either a ’Partial’, ’Final’, or ’Memo’ reference. For more information refer to the ”Adding Freight on an Invoice” topic in this user guide.

Additionally, on the Invoice-Transaction Type transactions (IN and IS) the Commodity Code pick field that contains the Commodity Code information also includes the Extended Description field on the grid section, which displays a maximum of the first 255 characters of the Extended Description for the Commodity.

Procurement Folder LogicProcurement Folder Logic

If this transaction is associated with another procurement transaction and that transaction was the first transaction within the Procurement Folder, then Procurement Folder, Procurement Type ID and Procurement Type fields are populated with inferred values on copy forward. When the Procurement Folder ID field is populated indicating that it is associated with a folder, the View Procurement Folder action is activated on the transaction Header allowing users to transition to the Procurement Management page to review other Procurement Folder information associated with this selected folder. Once the user has transitioned to the Procurement Management page a Back link is displayed allowing the user to transition back to the transaction Header where the transition began.

Invoice-Electronic RulesInvoice-Electronic Rules

If the UTILITY_ENABLED flag on the Integration Parameters (INTCTRL) table (for Resource Name IE) is set to TRUE for any of the following combinations, then the IE must reference a unique record on the Electronic Account Profile (EAPRO) page, and the Data Source ID field must be populated with a value that is valid on the Electronic Billing Data Source (EBDS) page.

  • Specific Department (Transaction Department), Specific Unit (Transaction Unit), and Transaction Code (Resource Name);

  • If not found, then a Specific Department (Transaction Department), Unit of ALL, and Transaction Code (Resource Name);

  • If not found, then perform the lookup again with a Department of ALL, Unit of ALL, and Transaction Code (Resource Name).

Special Notes:

  • The Electronic Account and Data Source ID fields cannot be changed on modification versions of the IE transaction.

  • Since the IE transaction is used for credit transactions, a negative Invoiced Service Contract Amount is allowed.

  • The Summary Account field is inferred from matching record on EAPRO based on the Electronic Account, Vendor Code, Address ID, and Commodity Code.

  • Upon successful submission to Final, the IE transaction will insert one record per Commodity line onto the Electronic Billing Inquiry (EBIT) page, if the Electronic Account fields are populated. If the IE transaction is being cancelled, then the IE removes the associated record(s) from the EBIT page for all Commodity lines that are not marked as closed (that is, the Closed Date and Closed Amount are not populated). Modifications and Cancellations are not allowed if the Payment Request Generated Date field is populated on EBIT.

Required/Conditionally Required FieldsRequired/Conditionally Required Fields

The following fields are required:

  • Referenced Transaction Code

  • Referenced Transaction Department

  • Referenced Transaction ID

  • Referenced Commodity Line

  • Reference Type

  • Line Type

  • Vendor Invoice Line

The following fields are required if the Line Type is Item:

  • Invoiced Quantity

  • Invoiced Unit Price

The following field is required if the Line Type is Service:

  • Invoiced Service Contract Amount

The Line Type of Cost Plus is not allowed on the IN Transaction Type.

The following field is conditionally required, based on site specific setup on the Transaction Control table:

  • Commodity Line Description

The following field is conditionally required, based on site specific setup on the Procurement Transaction Control table:

  • Commodity

The Condition field and Reason field are required if any of the following are true:

  • The Invoiced Quantity does not match the Ordered Quantity.

  • The Invoiced Service Contract Amount does not match the Order Service Contract Amount.

  • The Reference Type is Partial.

If the Enforce Transaction Department Validation field on the Transaction Control (DCTRL) page is selected, the values entered in the following field are validated against the Transaction Department to verify that the value entered is authorized for that specific Transaction Department:

  • Referenced Transaction Department

Tax AdjustmentsTax Adjustments

When sales or use tax is recorded for a purchase, the amount calculated by the vendor may be a couple of cents different from what is calculated in Advantage. An optional Tax Adjustment feature exists to ensure the vendor is paid the amount of tax expected. Three commodity fields exist for this feature:

  • Tax Adjustment is an indication of the commodity line that received the tax difference value when the Calculated Tax Before Adjustment and Total Vendor Invoice Tax Amount on the deader did not equal. By default, the Tax Adjustment was made to the first commodity line with tax. If desired, that indication can be manually transferred to another commodity line, but can only be selected on one commodity line.

  • The Tax Adjusted Amount is the amount of tax difference between the user entered Total Vendor Invoice Tax Amount and the Calculated Tax Before Adjustment amount. The adjustment amount is combined with the previously calculated tax amount to become the final Tax Amount.

  • The Referenced Tax Adjusted Amount indicates the amount of tax referenced by Payment Request transactions.

This tab contains the following actions/links:

Page-Level ActionsPage-Level Actions

Refer to the "Transaction Actions" topic in the Transactions User Guide for information on common actions that apply to the entire transaction.

Tab-Level actions/linksTab-Level actions/links