The SOV import has the following special rules or conditions:
Importing is accomplished with the Import button on the SOV Setup Headings and Heading Items tabs.
When using unit price SOVs, the amount field will be calculated upon import based on the Quantity and Unit Price.
Leaving the Record State blank will result in Active records.
The Heading Items must be keyed to a Heading No. If more than one Heading has the same number, the first one found will be used.
Leave Included After blank unless you want to hide the item until after a certain date.
The import can be used for adding new items or for modifying existing items
The import template provided is dependent on whether the SOV is a Percent Complete or Units Complete SOV.
Headings Field Information
A for Active, V for Void. Leave blank to assume A
Heading Items Field Information
Currency (applies only to Percent Complete type of SOV)
Number (applies only to Units Complete type of SOV)
Text (will be matched to the Unit Type Lookup Table) (applies only to Units Complete type of SOV)
Unit Price *
Currency (applies only to Units Complete type of SOV)
Date (blank unless you want to hide the item until after a certain date)
“A” for Active, “V” for Void. Leave blank to assume A
The Budget Code to be used on Cost Items associated with the Pay App.
Note: Budget Codes will be imported only if the Allow Cost Item Creation option is enabled in Module Customization. If this option is not enabled, any budget codes in the Import spreadsheet will be ignored. See Module Customization for Pay Apps for more information.