SpeedTypes

You can specify a SpeedType for a spreadsheet journal entry line. You can also copy the SpeedType to subsequent journal lines that you insert by selecting the copy down check box below SpeedType on the spreadsheet lines interface.

A spreadsheet journal user might specify a SpeedType, to which the user does not have access. At load time, the SpeedType that is entered on the Spreadsheet Journal is validated against the valid list of SpeedTypes available for the user ID that is specified in the Spreadsheet Journal Header.

If the user ID is not specified on the spreadsheet journal header, then the SpeedType is validated against the valid list of SpeedTypes available for the user ID of the user that imports the spreadsheet journal.

An error message is logged if an invalid SpeedType is specified on the Spreadsheet Journal. The error message is logged at import time for batch and online import.

At import, the system first populates the ChartField values based on the SpeedType but then can override a generated ChartField value with a ChartField value that is specified in the spreadsheet. For example, consider the SpeedType, Peripheral, which is available in the demo data that is defined to specify account 500000, department 212000, and product Config. If you populate a spreadsheet journal line using this SpeedType, Peripheral, but enter a department 10000, at import time the system populates the ChartFields with account 500000, department 10000, product Config.

Note:

If the SpeedType is created under One User ID or One Permission list, the Spreadsheet will not differentiate, unlike the online journal where the selection is limited by Type of SpeedTypes. This is due to the fact that a prompt table (which is equivalent to a dropdown box in Excel) could potentially create a performance bottleneck due to the large volume of data that would have to be retrieved and displayed in the Spreadsheet.