in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.
Use this screen to load new vendor quotes into Costpoint with up to five price breakpoints and up to three line charges each. You cannot delete or change existing vendor quotes; however, you can update the item vendor and alternate part tables with information provided in the input file. Only one user can access this application at a given time.
You can view the quotes loaded by this preprocessor in the Manage Vendor Quotes by Vendor or Manage Vendor Quotes by Item screens in Costpoint Procurement Planning.
in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.If the Separate Items by Company check box is selected in the Corporate Settings block of the Configure Product Definition Settings screen in Costpoint Product Definition, Costpoint will filter field validations by the user's company ID, item, and part tables. The company ID of the user executing the process triggers the validation of all company tables. When a new vendor quote record is saved, Costpoint automatically assigns it the user's company ID and search parameters. All company-related tables and Lookup-related valid values (or search parameters in 
) are validated using the user's company ID. Uploads can be processed for only one company at a time (the user's company).
The following tables are validated against the user's company ID:
|
Table Name |
Table Description |
Notes |
|
VEND |
Vendor |
|
|
RFQ_SETTINGS |
Request for Quote Settings |
|
|
EMPL |
Employee |
|
|
LN_CHG_TYPE |
Line Charge Type |
|
|
ITEM_VEND |
Item Vendor |
For updates. |
Multicurrency features, which, in addition to requiring additional calculations, add fields to the input files. The input fields are in the same format as the Quote Header and Quote Line Record.
With the multicurrency feature, all amount fields in the input file are in the transactional currency (which may or may not be the same as the functional currency). Vendor quote information is entered primarily in the transactional currency (i.e., the quote's currency, per the vendor), and Costpoint calculates the corresponding amounts for the related functional currency fields in accordance with exchange rate information in other tables. Data is stored in both currencies in Costpoint.
If exchange rate information does not exist, Costpoint will assume that the transactional and functional currencies are the same (1:1). All currency-related columns will still be populated with default values, the system exchange rate will be "1," and amount columns will therefore have the same values for transactional and functional currencies.
To select transactional currencies, calculate exchange rates, and validate customs information, the multicurrency functionality relies on data in the following tables (which must exist in Costpoint before you process any transactions).
|
Table Name |
Table Description |
Definition |
|
MU_SETTINGS |
Multicurrency Settings |
Sets default multicurrency information. Validate by the user's company ID. |
|
MU_CRNCY_STATUS |
Currency Status |
Stores status on currency and/or Euro information. Used to validate exchange rates. |
|
RT_GRP |
Rate Group |
Stores rate group information. Used for exchange rate information. |
|
RT_GRP_CRNCY |
Rate Group Currency |
Contains a list of From/To currencies for valid rate groups. Used for exchange rate information. |
|
RT_SRCE |
Rate Source |
Stores exchange rate source information. |
|
RT_BY_DT |
Rate by Date |
Stores exchange rates for valid From/To currency sets by start/end dates. |
|
RT_BY_PD |
Rate by Period |
Stores exchange rates for valid From/To currency sets by FY/PD. |
|
CURRENCY |
Currencies |
Stores information for currencies used in the database. |
The following tables/input columns support multicurrency specifically for vendor quotes.
|
Table Name |
Table Description |
|
QT_HDR |
Quote Header |
|
EUR_TO_FUNC_RT |
Euro to Functional Rate |
|
RATE_GRP_ID |
Rate Group |
|
TRN_CRNCY_CD |
Transaction Currency Code |
|
TRN_FREEZE_RT_FL |
Transaction Freeze Rate Flag |
|
TRN_TO_EUR_RT |
Transaction to Functional Currency Rate |
|
TRN_TO_EUR_RT_FL |
Transaction to Functional Currency Rate Flag |
|
QT_LN |
Quote Line |
|
TRN_DFLT_GR_UN_AMT |
Default Gross Unit Amount - Transaction |
|
TRN_DFLT_NT_UN_AMT |
Default Net Unit Amount - Transaction |
|
TRN_QT_LN_CHG_AMT |
Quote Line Charge Amount - Transaction |
|
QT_LN_BRK |
Quote Line Break |
|
TRN_GR_UN_CST_AMT |
Gross Unit Cost Amount - Transaction |
|
TRN_NT_UN_CST_AMT |
Net Unit Cost Amount – Transaction |
|
QT_LN_CHG |
Quote Line Charge |
|
TRN_QT_LN_CHG_AMT |
Quote Line Charge Amount - Transaction |
Once you have copied the new files onto your system and executed the script file, establish default settings in the Manage Vendors screen in Costpoint Procurement Planning, Purchasing, and/or Accounts Payable, including setting up the appropriate quote header, quote line, and vendor ID information. You must apply the following custom files and stored procedures files to the database to run the Import Vendor Quote preprocessor:
AOPQTV.EXE — Vendor Quote Preprocessor application executable
AOPQTV.ORA — Oracle stored procedures for the Vendor Quote Preprocessor
Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.
Enter, or click to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.
You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Use this group box to specify input file and quote ID settings.
Use this group box to specify the input file you want to use, its format, and the delimiter used in the file.
Enter the location of the input file you are importing. There are two ways to do this:
In the File Location field, enter, or click to select, the alternate file location where the input file is located. Alternate file locations are set up in the Manage Alternate File Locations screen.
or
From the Global Menu, click Process » File Upload. On the File Upload Manager dialog box, click Browse and use the dialog box to select the file you want to import. If you select the Overwrite? check box, Costpoint will overwrite any file of the same name that already exists in the Costpoint database. Click Upload when you are finished. If you use this method, leave the File Location field blank. For more information about the File Upload Manager, see the File Upload Manager topic in the Getting Started Guide.
Use this field to enter, or use to select, the name of the input file you want to use.
Use this drop-down list to select the file format of the input file. Compatible file formats are:
Delimited — Select this option if the input file has delimiters as field separators. This is the default.
Fixed Length — Select this option if the input file contains fields that start and end in a specified column. If the input file is a fixed-length format file, you must fill every position with the appropriate number of either characters or spaces for a given column before entering data for the next column. It is not necessary to zero fill numbers; you can use spaces to maintain the proper format. Numeric fields should be right justified; character fields should be left justified. Once you have entered the last character of meaningful data for the input file, you need not fill the remaining column lines with spaces.
For example, if the Vendor Quote Header record format's maximum line length (i.e., the entire input file) is a total of 467 characters and the last character of meaningful data is in position 36 (Buyer), you do not need to add the remaining 431 spaces. However, if the Vendor (beginning at position 12 on the input file) is only five characters long, you must include the Vendor ID plus seven additional spaces before entering the Quote Type (if applicable) in position number 24. See Processing Details for additional information.
If you selected Delimited from the File Format drop-down list, use this drop-down list to select the delimiter used in the input file. Choose one of the following options:
Comma — Select this option if the delimiter used in the input file is a comma (,).
Other — Select this option if the delimiter used in the input file is other than a comma. You must then specify the delimiter in the adjacent field.
Depending on which input file is being loaded, select one of two options in this group box to designate the method of quote numbering for this preprocessor.
Select this option to use the input file quote ID as the vendor quote ID in Costpoint. If you select this option, you must populate the Quote field in the input file.
Select this option if the Auto-Assign Quotes check box is selected in the Configure Vendor Quote Settings screen in Costpoint Procurement Planning. If you select this option, all quote lines for a given vendor will be grouped together. To use this option, you must provide the vendor ID for all Vendor Quote Line input files.
Costpoint will automatically assign a quote line number, incrementing the line number one per quote line input file row.