How to Setup an Optional Field for Use in Accounts Payable Sage 300

Steps:

  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.
    • 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. Use the Finder to select 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:
    • Double-click in the Value Set column to set the field to “Yes” for a selected optional field.
    • In the Default Value field, enter or select the value that the program will display as the default for the optional field.
      • If the optional field you selected requires validation, select a value that is defined for the optional field 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 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 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 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 Settings button, if it is available, to specify additional settings for the optional field.
    • The account groups for which values pass to General Ledger 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 to include the optional field.
      • Whether Accounts Payable passes optional field information for job related transactions to Project and Job Costing, if you use Safe 300 Project and Job Costing.
        • Note: If the optional fields in the posted transactions match the optional fields defined for billings in Project and Job Costing, the optional field information is sent to that program.
  8. Click Add (or Save)