Accounts Payable > Setting Up Accounts Payable > Setting Up and Maintaining Processing Records > Adding or Modifying an Optional Field

Adding or Modifying an Optional Field

Learn more

A/P Optional Fields Screen

Optional Fields let you store custom information with records and transactions. You can define an unlimited number of optional fields for each type of Accounts Payable record or transaction, providing the optional fields are set up on the Optional Fields screen in Common Services.

You can change the default value and Auto Insert status for an optional field at any time. If the field is validated, you must select a value that is defined on the Optional Fields screen in Common Services.

Any change you make to an optional field affects only records or transactions added after you make the change.

Note: After making changes to program options (on Options screens) or optional fields (on Optional Fields screens), you and all other users must sign out and sign in again to apply the changes.

ClosedBefore you start
  • Make sure that the optional field you want to use in Accounts Payable is set up for system-wide use on the Optional Fields screen in Common Services.
  • If an optional field you want to delete is assigned to a record or a transaction, edit the record or transaction to remove the optional field, or post the batch that contains the transaction.
  • After making changes to program options (on Options screens) or optional fields (on Optional Fields screens), you and all other users must sign out and sign in again to apply the changes.

To set up an optional field for use in Accounts Payable:

  1. Open Accounts Payable > A/P Setup > Optional Fields.

  2. In the Optional Fields For field, select the type of record or transaction for which you are defining the optional field. More...

    You can set up optional fields for use in the following types of records or transactions:

    • Vendors And Vendor Groups
    • Remit-to Locations
    • Invoices (associated with document headers—optional fields for document details are defined separately)
    • Invoice Details
    • Adjustments
    • Payments
    • Revaluation

  3. In the Optional Field field of the detail table, specify the optional field code or codes you want to use for the selected type. The program displays the description for the optional field you select.

    Note: If you want to retain Accounts Payable optional field information when you create batches for General Ledger, you must use the same optional fields for transactions in Accounts Payable as you use in General Ledger.

  4. If you want to specify a default value for the optional field:

    1. Select the Value Set column, and set the field to “Yes” for a selected optional field.

    2. In the Default Value field, specify the value that the program will display as the default for the optional field. More...

      If the optional field you selected requires validation, select a value that is defined for the optional field on the Optional Fields screen in Common Services. If the optional field allows blanks, you can leave the default value field blank.

      If the optional field does not use validation, you can do one of the following:

      • Select a value that is defined for the optional field on the Optional Fields screen in Common Services.
      • Leave the field blank.

      • Enter a combination of alphanumeric or special characters and spaces. The entry must be consistent with the type of field (text, number, date, amount, and so on), and must not exceed the number of characters specified for the optional field on the Optional Fields screen in Common Services.

        Examples:
        • In a Yes/No field, you can enter only Yes or No.
        • In an Integer field you can enter any integer with an absolute value less than 2,147,483,647.

      When you specify a value from the Optional Fields screen in Common Services., the program displays the description for the value.

  5. To indicate that the optional field must be used in the records and transactions for which it is created, double click the Required field.

    During data entry, if an optional field is required and does not have a default value, you must fill in the field before you can proceed.

  6. To display the optional field and its default value when you set up new records or enter transactions on the screen for which you are defining the optional field, select Yes in the Auto Insert field.

  7. Click the Edit icon in the Settings field to specify additional settings for the optional field.

    A separate screen appears, listing all the groups of accounts that are affected when you post transactions of the type for which you are defining the optional field. Use the screen to specify the account groups for which values pass to General Ledger when you post transactions that include the optional field.

  8. Click Save.

To edit an optional field:

  1. Open Accounts Payable > A/P Setup > Optional Fields.

  2. In the Optional Fields For field, select the type of record or transaction for which you are defining the optional field.
  3. Make the changes you need on the table.
  4. Click the Edit icon in the Settings field to select the type of General Ledger accounts to which optional field information can be passed.
  5. Click Save.

To delete an optional field:

  1. Open Accounts Payable > A/P Setup > Optional Fields.

  2. In the Optional Fields For field, select the type of record or transaction for which you want to delete an optional field.
  3. On the table, select (highlight) the optional field that you want to remove.

  4. Click Delete.

    If a message appears asking you to confirm the deletion, click Yes.

ClosedAfter adding, editing, or deleting optional fields

After making changes to program options (on Options screens) or optional fields (on Optional Fields screens), you and all other users must sign out and sign in again to apply the changes.

Last published: 4/8/2016