Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
5 Suppliers
A supplier is a person or entity that provides merchandise to a retailer resulting in an invoice. You can maintain a variety of information about suppliers such as financial arrangements, inventory management parameters, types of EDI transactions, and invoice matching attributes. Suppliers are typically created in a financial system and interfaced into Merchandising. Supplier enrichment can be maintained in Merchandising.
Supplier sites are physical locations of a supplier that also define the business relationship between supplier and the retailer. The supplier site captures business terms and conditions as negotiated by the retailer with the supplier. Supplier sites can be locations from which orders are placed, remittances made, or both; however it is assumed to represent a single location for the supplier, so all address types for a particular site must have the same address information. Most transactions between the supplier and the retailer occur at the supplier site level, with the exception of deals which occur at the supplier level.
The supplier structure can be extended to supplier-parent and supplier-site relationships, to accommodate financial systems that support this configuration. A supplier site is a location from which the supplier ships merchandise.
The supplier management feature allows you to add, edit, and view the following information about suppliers:
-
Multiple contact persons and addresses: You can enter multiple addresses of different types, such as business, invoice, order, postal, remittance, and returned goods.
-
Financial arrangements : You can indicate the payment terms, freight terms, currency, settlement code, and payment method.
-
Inventory management parameters: You can set up a replenishment cycle, order attributes, scaling attributes and constraints, order minimum constraints, and due order processing. You can also indicate whether quality control checking is required and what percentage of the received goods must be checked.
-
Return to vendor (RTV) requirements: You can indicate whether returns are allowed, whether an authorization number is required, the minimum value of a return, the preferred courier, and the handling charge.
-
Required documents: You can select which documents, if any, are required by the supplier.
-
Expense profiles: You can enter the supplier’s costs by country or by cost zone.
-
Types of electronic data interchange (EDI) transactions: You can indicate which EDI transactions the supplier can process.
-
Generic attributes: You can indicate which attributes apply to the supplier, such as co-op agreement terms, volume rebate terms, whether a PO is required, or whether items are pre-ticketed.
-
Import attributes: You can enter import-related information such as agent, advising and issuing banks, lading and discharge ports, manufacturer ID, and beneficiary.
-
Invoice matching attributes: You can indicate when debit memos are sent, whether invoices and debit memos are approved automatically, whether the supplier is allowed to
charge freight, and whether invoices are pre-paid. (Oracle Retail Invoice Matching must be installed.)
-
Supplier traits: You can select the traits by which you want to group the supplier with other suppliers.
-
Payment types by store: You can select the methods by which the supplier can be paid, such as cash, money order, and by invoice. You can also indicate the payment type by store.
-
Delivery schedules at stores and warehouses: After you create a delivery schedule, you can specify which items are not to be delivered to the location on a specific delivery day.
-
Vendor managed inventory (VMI): Use VMI to allow a supplier to manage the inventory levels of designated product at the warehouse. Inventory data is shared with the supplier, who uses the information to create inbound purchase orders, which will achieve and/or maintain budgeted inventory and service levels in the warehouse.
Create a Supplier
The Supplier/Supplier Site page allows you to create, edit, and view suppliers and supplier sites. Suppliers are vendors that provide your stores and warehouses with merchandise.
Depending on how you enter the page, the label varies.
-
If you enter the page for a parent supplier, the page is labeled Supplier. For more information about how to create a supplier, see the Creating a Supplier section.
-
If you enter the page for another supplier site of a supplier, the page is labeled Supplier Site. For more information about how to create a supplier site, see the Creating a Supplier/ Supplier Site section.
You can indicate whether the supplier/supplier site is active or inactive. You can also enter the primary contact, financial, shipping, and payment information.
Table 5-1 Header - Fields and Description
| Fields | Description |
|---|---|
| Supplier | The supplier ID is generated automatically. Enter the supplier name. This field is a required field. |
| Payment Terms | Enter, select or search for the supplier’s payment terms. This field is a required field. |
| Freight Terms | Enter, select or search for the supplier’s freight terms. This field is a required field. |
| VAT Region | Enter, select or search for the supplier’s VAT region. This field is a required field. |
| Status | Select, if the current supplier is an active or inactive supplier. This field is a required field. |
| Secondary Name | Enter the secondary name for the supplier. |
| Currency | Enter, select or search for the supplier’s currency. This field is a required field. |
| Language | Select the supplier’s language from the list. |
| Tax ID | Enter the Tax Identification Number to be associated with the supplier site. |
Contact Information
In the Contact Information section enter the name, phone number, email address, fax, telex and pager for the primary contact person at the supplier’s location.
Name and Phone are required fields.
Comments
In the Comments section you can enter any comments relevant for the supplier.
Ordering
The Ordering section contains the following fields and checkboxes.
Table 5-2 Ordering - Fields/Checkboxes and Description
| Fields/Checkboxes | Description |
|---|---|
| Deal Status for Uploads | Select the status (worksheet, submitted or approved) in which the deal needs to be uploaded into the system as part of the batch process for a specific supplier. |
| Inventory Management Level | Select an inventory management level from the list. This field is a required field. |
| Ship Method | Select a shipping method for the supplier from the list. |
Table 5-2 (Cont.) Ordering - Fields/Checkboxes and Description
| Fields/Checkboxes | Description |
|---|---|
| Lead Time | Enter the amount of time a supplier needs between receiving an order and having the order ready to ship. This value will be defaulted to item/supplier relationships. |
| Delivery Policy | Select a delivery policy from the list. This field is a required field. |
| Quantity Level | Select a quantity level from the list to indicate purchase order quantities that are communicated to the supplier in multiples of units (eaches) or cases. This field is a required field. |
| DSDcheckbox | Select the checkbox to indicate that the supplier can provide direct store deliveries. |
| Premarkcheckbox | Select the checkbox to indicate that the supplier will break orders into separate, marked boxes that can be shipped directly to stores. |
| Bracket Costingcheckbox | Select the checkbox to indicate that the supplier uses bracket costing in its pricing. |
| Back Orderscheckbox | Select the checkbox to indicate the supplier accepts back orders. |
| EDI: | |
| Orderscheckbox | Select the checkbox to indicate that the orders are transmitted electronically. |
| Order Changescheckbox | Select the checkbox to indicate that order changes are transmitted electronically. |
| Order Acknowledgments checkbox | Select the checkbox to indicate that order acknowledgments are transmitted electronically. |
Contracts and Replenishment
The Contracts and Replenishment section contains the following fields and checkboxes.
Table 5-3 Contracts and Replenishment - Fields/Checkboxes and Description
| Fields/Checkboxes | Description |
|---|---|
| Scale AIP Orderscheckbox | Select the checkbox to indicate that AIP (Advanced Inventory Planning) is allowed to do order scaling. Order scaling refers to the increase and decrease of the order quantity within constraints to meet purchasing objectives and increase efficiency. |
| VMI Order Status | Select the VMI order status from the list. |
| VMI Channel | Enter, select or search for the VMI channel. |
| EDI Availabilitycheckbox | Select the checkbox to indicate that the supplier processes orders through EDI (Electronic Data Interchange). |
| EDI Contractscheckbox | Select the checkbox to indicate that the supplier process contracts through EDI. |
| Auto Contract Approval checkbox | Select the checkbox to indicate that contract orders are created in Approved status. |
Receiving
The Receiving section contains the following fields and checkboxes.
Table 5-4 Receiving - Fields/Checkboxes and Description
| Fields/Checkboxes | Description |
|---|---|
| QC Requiredcheckbox | Select the checkbox to indicate that goods received from the supplier must be inspected for quality. |
| QC% | Enter what percentage of the goods must be inspected. |
| QC Frequency | Enter how often the items will be inspected. |
| EDI ASNcheckbox | Select the checkbox to indicate that the advanced shipping notice (ASN) is transmitted electronically. |
| Vendor Control Required checkbox | Select the checkbox to indicate that orders from this supplier require vendor control by default. |
| Vendor Control% | Displays the percentage of items per receipt that are marked for vendor checking. |
| Vendor Control Frequency | Displays the frequency in which items per receipt are marked for vendor checking. |
Invoicing
This section contains the following fields and checkboxes.
Table 5-5 Invoicing - Fields/Checkboxes and Description
| Fields/Checkboxes | Description |
|---|---|
| Settlement Code | Select the settlement code from the list. This field is a required field. |
| Payment Method | Select the payment method from the list. |
| Send Debit Memos | Select how often debit memos should be sent to the supplier. |
| Receive Invoice | Select where invoices from this supplier are received, either at the store or centrally through corporate accounting. This field is only enabled, if invoice matching is used. |
| Pay Invoice | Indicates where invoices from this supplier are paid, either at the store or centrally through corporate accounting. Valid values are S (paid at the store) and C (paid centrally). This field only displays Store, if Sales Audit is used to accept payment at the store level. Additionally, the field is only enabled, if invoice matching is used. |
| Invoice at | Select, if invoice amounts are net or gross values. |
| Default Pay Site | The Default Pay Site is an optional field. The field will only display on Purchasing Supplier Sites. When populated, the Default Pay Site will override the standard logic for assigning a pay site to documents sent to the financial system by Invoice Matching. |
| Final Match Destination checkbox | Select this checkbox to indicate that the supplier can ship to the final destination as per allocation. |
Table 5-5 (Cont.) Invoicing - Fields/Checkboxes and Description
| Fields/Checkboxes | Description |
|---|---|
| EDI Invoicecheckbox | Select the checkbox to indicate that the invoices are transmitted electronically. |
| Auto-approve Invoices checkbox | Select this checkbox to indicate that the supplier’s invoice matches can be automatically approved for payment. This field is only enabled, if invoice matching is used. |
| Auto-approve Debit Memos checkbox | Select this checkbox to indicate that debit memos sent to the supplier can be automatically approved on creation. This field is only enabled, if invoice matching is used. |
| Allow Supplier to Charge- Freightcheckbox | Select this checkbox to indicate that the supplier is allowed to charge freight costs to the client. This field is only enabled, if invoice matching is used. |
| Invoices Pre-paid for Suppliercheckbox | Select this checkbox to indicate that all invoices for the supplier can be considered pre-paid invoices. This field is only enabled, if invoice matching is used. |
| Services Performed Confirmation Required checkbox | Select this checkbox to indicate that all suppliers services, for example shelf stocking, must be confirmed before the invoice can be paid. |
| Generate Consignment Orders | Select this checkbox to indicate that Merchandising should automatically create Consignment Purchase Orders based on underlying consignment sales data. If unchecked, Merchandising will not create Consignment Orders and it will be expected that such orders will be created by an external process (using staged consignment transaction data) and interfaced into Merchandising. |
| Consignment Self Invoicing | Select this checkbox to indicate that Merchandising should automatically create invoice documents (matched invoices) against consignment POs. If unchecked, it will be assumed that invoices for consignment POs will come from the vendor and will be subject to matching in Invoice Matching. This field will be disabled and unselected when the Generate Consignment Orders option is unchecked. |
Returns
The Returns section contains the following fields and checkboxes.
Table 5-6 Returns - Fields/Checkboxes and Description
| Fields/Checkboxes | Description |
|---|---|
| Returns Allowedcheckbox | Select the checkbox to indicate that this supplier allows returns. |
| Authorization Required checkbox | Select the checkbox to indicate that returns must be accompanied by an authorization number when sent back to the vendor. |
| Maximum Return Amount | Enter the maximum amount allowed for returns. |
| Courier | Enter the courier for the returns. |
| Handling% | Enter the handling percentage. |
Other Attributes
The Other Attributes section contains the following fields
Table 5-7 Other Attributes - Fields and Description
| Fields | Description |
|---|---|
| DUNS Number | Enter the appropriate Dun and Bradstreet codes to identify the supplier. |
| DUNS Location Number | Enter the appropriate Dun and Bradstreet codes to identify the supplier location. |
| EDI Sales | Select the EDI Sales from the list. |
| External Ref. ID | Displays the external reference ID, if available. |
| Default Pricing Control | Select the default pricing control from the list. This is an optional field and only displayed for Supplier Sites if the Allow Supplier-Controlled Pricing system option is set to Yes. Valid values are Retailer and Supplier. |
| Cost Change Variance: | |
| Amount | This field displays the cost change variance as amount. |
| Percent | This field displays the cost change variance in percent. |
Creating a Supplier
To create a supplier, follow the steps below.
1. From the Tasks menu, select Foundation Data > Suppliers and Partner Foundation > Create Supplier . The Supplier page appears.
2. The supplier ID is generated automatically. Enter the necessary information in the individual sections.
For more information about the available sections of the Supplier page, see the Create a Supplier section.
3. Then choose one of the following options.
-
Click Save to save the supplier.
-
Click Save and Close to save the supplier and close the page.
-
Click Save and Create Another to save the current supplier and create additional supplier entries.
-
Click Cancel to reject all entries and close the page.
Note
You can also create a supplier in the Supplier Search screen, for more information about this function, see the Creating a Supplier/Supplier Site section.
Adding Importers/Exporters
To add importers/exporters to a supplier site, follow the steps below.
1. In the Importers/Exporters section, select Actions > Add or use the Add icon. The Add Importer/Exporter page appears.
2. In the Type field, select if you want to add an importer or exporter. This field is a required field.
3. In the Importer/Exporter field, enter, select or search for the importer/exporter ID and description. This field is a required field.
4. Select the Default checkbox to indicate that the current importer/exporter is the supplier’s default importer/exporter.
5. Then choose one of the following options.
-
Click OK to add the importer/exporter and close the page.
-
Click OK and Add Another to add additional importers/exporters.
-
Click Cancel to reject all entries and close the page.
Editing Importers/Exporters
To edit importers/exporters for a supplier site, follow the steps below.
1. In the Importers/Exporters section, select Actions > Edit or use the Edit icon. The Edit Importer/Exporter page appears.
2. Change the Type and Importer/Exporter field as well as the Default checkbox, as necessary.
3. Then choose one of the following options.
-
Click OK to save your changes and close the page.
-
Click Cancel to reject all entries and close the page.
Adding Routing Locations
To add routing locations to a supplier site, follow the steps below.
1. In the Routing Locations section, select Actions > Add or use the Add icon. The Add Routing Locations page appears.
2. In the Routing Location field, enter, select or search for the location ID. This field is a required field.
3. Select the Default checkbox to indicate that the current routing location is the supplier’s default routing location.
4. Then choose one of the following options.
-
Click OK to add the routing location and close the page.
-
Click OK and Add Another to add additional routing locations.
-
Click Cancel to reject all entries and close the page.
Editing Routing Locations
To edit routing locations for a supplier site, follow the steps below.
1. In the Routing Locations section, select Actions > Edit or use the Edit icon. The Edit Routing Locations page appears.
2. Change the Routing Location field and Default checkbox, as necessary.
Import Attributes
The Import Attributes section contains the following fields.
Table 5-8 Import Attributes - Fields and Description
| Fields | Description |
|---|---|
| Agent | Enter, select or search for the agent ID. |
| Factory | Enter, select or search for the factory ID. |
| Advising Bank | Enter, select or search for the ID of the advising bank. |
| Issuing Bank | Enter, select or search for the ID of the issuing bank. |
| Lading Port | Enter, select or search for the ID of the lading port. |
| Discharge Port | Enter, select or search for the ID if the discharge port. |
| Manufacturer | Enter the manufacturer. |
| Supplier Related to Manufacturercheckbox | Select the checkbox to indicate that the supplier is related to the manufacturer. |
| Partner | Select a partner type from the list. In the field next to the partner type, enter, select or search for the partner ID. You can add up to three partners in this page. |
Beneficiary Attributes
The Beneficiary Attributes section contains the following fields.
Table 5-9 Beneficiary Attributes - Fields and Description
| Fields | Description |
|---|---|
| Beneficiarycheckbox | Select the checkbox to indicate that the supplier can be a beneficiary in a Letter of Credit transaction. |
| With Recoursecheckbox | Select the checkbox to indicate that the paying bank will be able to claim refunds from the beneficiary in case the letter of credit documents are not paid by the issuing bank. |
| Revocablecheckbox | Select the checkbox to indicate that the Letter of Credit is revocable. If the LC is revocable, it can be amended or cancelled by the buyer or buyers bank at any time. If the LC is not revocable, the buyer as well as seller must approve any changes. |
| Place of Expiry | Enter, select or search for the place of expiry. |
| Drafts At | Select the drafts at entry from the list. |
| Payment Terms | Select the appropriate payment terms from the list. |
| Variance Percent | Enter the variance in percent. |
| LC Negotiation Days | Enter the negotiating days for the LC. |
Add Supplier Expense Profiles
See Expense Profiles for information.
Table 5-10 Replenishment - Fields and Description
| Fields | Description |
|---|---|
| Order Control | Select how the POs are processed for the supplier from the list. |
| Review Cycle | Select how often the items are reviewed for replenishment from the list. |
| Single Loc on Ordercheckbox | Select the checkbox, if only one location can be on an order. |
| Maximum Order Cost for Auto Approval | Enter the maximum allowed value for which an order can be auto approved. If the total order cost is less than or equal to the ‘Maximum Order Cost for Auto Approval’, and if the order passes all other rules, then the order will be automatically approved. If the total order cost is greater than the ‘Maximum Order Cost for Auto Approval’, the automatic approval should fail with an appropriate error message and the order is set aside for manual review. If the value is left blank, then all orders are eligible for auto approval. If the value is 0, then no orders could be automatically approved unless the cost of the order was actually 0. |
| Item/Location Quantity Variance Threshold | Allows the retailer to define a variance percentage between the prescale recommended order quantity (ROQ) and the final order quantity, which has had rounding rules, scaling, and other adjustments made. When approving an order, if any item/location combinations on the order exceed (+/-) the quantity variance threshold, an error should be generated, the order should remain in worksheet status requiring a manual review. If this field is left blank, then no validation is performed. |
| Weekdayscheckboxes | Select the day on which the items are reviewed. • If the review cycle is every day, all days of the week are selected automatically. • If the review cycle is every week, select the days of the week the items are reviewed for replenishment. You may select more than one day. • If the review cycle is over two or more weeks, select the day of the week. |
Due Order Processing
The Due Order Processing section contains the following fields.
Table 5-11 Due Order Processing - Fields and Description
| Fields | Description |
|---|---|
| Due Order Processing checkbox | Select the checkbox to have due order processing performed for replenishment items from the supplier. |
| Create Non-Due Orders checkbox | Select the checkbox to have purchase orders created in Worksheet status for items that are not due to be ordered. |
| Due Order Level | Select the level at which the due order processing is based from the list. |
| Service Basis | Select the parameter that is used in calculating the stock out level from the list |
Investment Buy
The Investment Buy section contains the following fields.
Table 5-12 Investment Buy - Fields and Description
| Fields | Description |
|---|---|
| Investment Buy Eligibility | Select the checkbox to enable investment buy attributes. |
| Order Control | Select how POs are processed for the investment buy orders. |
Scaling
The Scaling section contains the following fields.
Table 5-13 Scaling - Fields and Description
| Fields | Description |
|---|---|
| Scale Orders to Constraints checkbox | Select the checkbox to enable the scaling constraints area. |
| Multiple Vehiclescheckbox | Select the checkbox to indicate that multiple vehicles may be used when delivering the order. |
| Scaling Objective | Select whether purchase orders are scaled to the minimum or maximum values of the scaling constraints. |
| Scaling Level | Select the level at which the scaling is performed. |
| Primary: | In the Scaling Constraints Primary column, complete the following fields. |
| Type | Select the primary type of constraint to use when scaling orders. |
| UOM | If you select Mass or Volume as the primary type, enter, select or search for the unit of measure. |
| Currency | If you select Amount as the primary type, the currency code is displayed in this field. |
| Maximum Value | Enter the maximum value of the constraint. |
| Tolerance | Enter the percentage tolerance for the maximum value of constraint. |
| Minimum Value | Enter the minimum value of the constraint. |
| Tolerance | Enter the percentage tolerance for the minimum value of the constraint. |
| Secondary: | In the Scaling Constraints Secondary column, complete the following fields. |
| Type | Select the secondary type of constraint to use when scaling orders. The secondary type cannot be the same as the primary type. |
| UOM | If you select Mass or Volume as the secondary type, enter, select or search for the unit of measure. |
| Currency | If you select Amount as the secondary type, the currency code is displayed in this field. |
| Maximum Value | Enter the maximum value of the constraint. |
| Tolerance | Enter the percentage tolerance for the maximum value of the constraint. |
Table 5-13 (Cont.) Scaling - Fields and Description
| Fields | Description |
|---|---|
| Minimum Value | Enter the minimum value of the constraint. |
| Tolerance | Enter the percentage tolerance for the minimum value of the constraint. |
Rounding
The Rounding section contains the following fields.
Table 5-14 Rounding - Fields and Description
| Fields | Description |
|---|---|
| Rounding Level | Select the level to which quantities should be rounded. |
| Rounding to Inner Threshold | Enter the percent of the inner needed to round to an additional inner. |
| Round to Case Threshold | Enter the percent of the case needed to round to an additional case. |
| Round to Layer Threshold | Enter the percent of the layer needed to round to an additional level. |
| Round to Pallet Threshold | Enter the percent of the pallet needed to round to an additional pallet. |
Supplier Minimums
The Supplier Minimums section contains the following fields.
Table 5-15 Supplier Minimums - Fields and Description
| Fields | Description |
|---|---|
| Purge Orders Failing Minimumcheckbox | Select the checkbox to create POs that meet the supplier minimum. |
| Minimum Level | Select the minimum order quantity at which the supplier accepts orders. |
| Conjunction | When you define two minimum order requirements, select the relationship between the requirements in the Conjunction field. |
| Minimum 1: | In the Minimum 1 column, complete the following fields. |
| Type | Select the type for the first minimum order requirement. |
| UOM | If you select Mass or Volume as the first minimum order requirement type, enter, select or search for the unit of measure |
| Currency | If you select Amount as the first minimum order requirement type, the currency code is displayed in this field. |
| Value | Enter the value of the first minimum order requirement for the supplier. |
| Minimum 2: | In the Minimum 2 column, complete the following fields. |
| Type | Select the second type for the minimum order requirement. |
| UOM | If you select Mass or Volume as the first minimum order requirement type, enter, select or search for the unit of measure. |
| Currency | If you select Amount as the first minimum order requirement type, the currency code is displayed in this field. |
Table 5-15 (Cont.) Supplier Minimums - Fields and Description
| Fields | Description |
|---|---|
| Value | Enter the value of the first minimum order requirement of the supplier. |
Truck Splitting
The Truck Splitting section contains the following fields.
Table 5-16 Truck Splitting - Fields and Description
| Fields | Description |
|---|---|
| Split Orders into Truckloads checkbox | Select the checkbox to enable the truck splitting constraints. |
| Auto Approve LTL Orders checkbox | Select the checkbox to allow Less than a Truckload (LTL) orders. |
| Truck Split Method | Select the method of truck splitting used with this supplier. |
| Constraint 1: | In the Constraint 1 column, complete the following fields. |
| Type | Select the primary type of constraint to use when splitting orders into truckloads. |
| UOM | If you select Mass or Volume as the primary type, enter, select or search for the unit of measure. |
| Value | Enter the value of the constraint. |
| Tolerance | Enter the percentage tolerance for the maximum value of the constraint. |
| Constraint 2: | In the Constraint 2 column, complete the following fields. |
| Type | Select the secondary type of constraint to use when splitting orders into truckloads. The second constraint type cannot be the same as the first constraint type. |
| UOM | If you select Mass or Volume as the secondary type, enter, select or search for the unit of measure. |
| Value | Enter the value of the constraint. |
| Tolerance | Enter the percentage tolerance for the maximum value of the constraint. |
Bracket Constraints
The Bracket Constraints section contains the following fields.
Table 5-17 Bracket Constraints - Fields and Description
| Fields | Description |
|---|---|
| Threshold % | Enter the percentage of the bracket value that the order must meet in order to be rounded up to that bracket. |
| Primary: | In the Primary column, complete the following fields. |
| Type | Select the type of the primary bracket costing constraint. |
ee
a
Editing Bracket Values
To edit bracket values for a supplier site, follow the steps below.
1. From the Tasks menu, select Foundation Data > Suppliers and Partner Foundation > Manage Suppliers . The Supplier Search page appears.
2. Restrict your search to suppliers with enabled Bracket Costing.
3. Click Search . The suppliers that match the search criteria are displayed in the Results section.
4. In the Supplier Site column, click the supplier site ID link, or mark a record and select Actions > Edit , or use the Edit icon. The Supplier Site page appears.
5. Select More Actions > Inventory Management . The Supplier Inventory Management page appears.
6. Select More Actions > Bracket Costing . The Supplier Brackets page appears.
Note
The Bracket Costing checkbox must be selected in the Supplier/Supplier Site page in order to access the Supplier Brackets page.
7. Select a record in the table.
8. Then select Actions > Edit , or use the Edit icon. The Edit Bracket page appears.
-
a. In the Primary Bracket Value and Secondary Bracket Value field, edit the values as necessary.
-
b. Select/deselect the Default checkbox to indicate that the bracket value is a default value for this bracket structure.
-
c. Select/deselect the Pickup checkbox to indicate that the bracket pricing uses pickup prices.
-
d. Then choose one of the following options.
-
Click OK to save your changes value and close the page.
-
Click Cancel to reject all entries and close the page.
-
Add Org Units
In the Supplier Site Org Unit page you can add, edit, delete and view organizational unit information for the selected supplier site. Supplier Sites are initially created with a single Org Unit and normally only a single Org Unit is associated with any Supplier Site. However, the Supplier Site Org Unit page allows the association of multiple Org Units with a Supplier Site if a retailer needs to do this.
6. Then select Actions > Edit , or use the Edit icon. The Edit Ord Unit ID page appears.
-
a. In the Org Unit field, change the org unit, if necessary.
-
b. Select/deselect the Primary Pay Site to indicate that the current org unit is the primary pay site.
-
c. Then choose one of the following options.
-
Click OK to save your changes and close the page.
-
Click Cancel to reject all entries and close the page.
-
Add Traits
The Supplier Traits page allows you to add, delete and view supplier traits. After you create supplier traits, you can then associate suppliers with a trait or associate traits with a supplier.
You can also use traits to indicate which of your suppliers have a master supplier. A master supplier is an outside source that provides merchandise to one or more of your suppliers, such as a manufacturer or distributor. You can enter an external ID for the master supplier as well.
Adding Supplier Traits
To add supplier traits, follow the steps below.
1. From the Tasks menu, select Foundation Data > Suppliers and Partner Foundation > Manage Suppliers . The Supplier Search page appears.
2. Enter or select search criteria as desired to make the search more restrictive.
3. Click Search . The suppliers that match the search criteria are displayed in the Results section.
4. In the Supplier Site column, click the supplier site ID link, or mark a record and select Actions > Edit , or use the Edit icon. The Supplier Site page appears.
5. Select More Actions > Supplier Traits . The Supplier Traits page appears.
6. Then select Actions > Add , or use the Add icon. The Add Supplier Traits page appears.
-
a. In the Supplier Trait field, enter, select or search for the supplier trait you want to associate with the supplier.
-
b. Select the Master Supplier checkbox to indicate that the current trait is a master supplier trait.
-
c. Then choose:
-
Click OK to add the supplier trait and close the page.
-
Click OK and Add Another to add additional supplier traits.
-
Click Cancel to reject all entries and close the page.
-
Manage Supplier Traits
Within Merchandising, there is the ability to define information about supplier traits which can later be associated with one or more suppliers. Supplier Traits can be useful for defining specific attributes of suppliers for purposes of reporting, regulatory compliance, and mass maintenance. The specific implementation of supplier traits is to be defined by each retailer however. This functionality is accessed from the main Merchandising task list under Foundation Data > Download Foundation Data and Foundation Data > Upload Foundation Data.
To add, update, or remove supplier trait information, you will need to select the template type of Foundation from the Download Data screen and then the template Supplier Traits. Click the Download button and when prompted, choose to either open the .ods file that is generated or save the file and open it separately in the spreadsheet application of your choice.
Add Supplier Trait
To add a new supplier trait, select the action type of Create on the Supplier Traits tab. Next, enter the trait ID and its description. You can also indicate which of your suppliers have a master supplier, who is an outside source such as a manufacturer or distributor that provides merchandise to one or more of your suppliers. The translations tab will hold the supplier trait details in the specified language.
Update Supplier Trait
If you would like to update a supplier trait, then a similar process will have to be followed to that described above for entering new trait information. First, download the spreadsheet, and then find the supplier trait that you want to update. In that row select the action type of Update, and then update the current details in the spreadsheet.
Delete Supplier Trait
If you wish to delete a supplier trait, update the action column to select Delete in each of the rows you want to delete.
Uploading Changes
For all actions defined above, once all the updates have been made to the data in the spreadsheet, save the file and close it. Then, return to the Merchandising screens and select Foundation Data > Upload Foundation Data from the main task list. In this screen, select the template type Foundation and the template Supplier Traits. This will generate a process description automatically, but this can be updated if desired. Lastly, select the Browse button and navigate to the directory where you saved the updated spreadsheet. To review the status of the upload and check whether any errors occurred, select the Foundation Data > Review Status task from the main task list.
See also Download/Upload Data from Spreadsheets and View Data Loading Status.
Update a Supplier
The Manage Suppliers option opens the Supplier Search page. In this page you can perform the following actions.
-
Search for suppliers by various search criteria
-
View the search results
-
View supplier information
-
Create supplier information
-
Edit supplier information
-
Edit supplier sites
-
View supplier sites
You can access the Supplier Search page from the Task menu, select Foundation Data > Suppliers and Partner Foundation > Manage Suppliers . The Supplier Search page appears.
|
Table 5-19 (Cont.) Supplier Search - Basic Search Criteria and Description
| Fields | Description |
|---|---|
| Supplier Site Name | Enter the supplier site name. |
| Status | Select the status of the supplier. |
| Item | Enter, select or search for the supplier’s items. |
| Order | Enter, select or search for the supplier’s orders. |
2. Click the Saved Search list to select one of the saved search criteria. Selecting a saved search populates the search section with the saved search criteria. If the run automatically function is enabled for the search, the search is executed immediately.
You can also personalize your saved searches by selecting Personalize . The Personalized Saved Searches page appears.
For more information about the Personalized Saved Search, see Personalize Saved Search in the Oracle® Retail Merchandising Do the Basics User Guide .
3. Click Search . The suppliers that match the search criteria are displayed in the Results section.
4. Click Reset to clear the search section and results.
5. Click Save As… to save the current search criteria. The Create Saved Search page appears.
For more information about how to save your search criteria, see Create Saved Search in the Oracle® Retail Merchandising Do the Basics User Guide .
6. Click Done to close the page.
Searching for a Supplier Through Advanced Search Criteria
To search for a supplier by using advanced search criteria:
1. To search by using advanced search criteria, enter or select one or all of the advanced search criteria.
Table 5-20 Supplier Search - Advanced Search Criteria and Description
| Fields | Description |
|---|---|
| Matchoption | Check radio button All or Any. All - only suppliers matching all entered search criteria are shown. Any - suppliers matching any of the entered search criteria are shown. |
| Supplier | Enter the supplier ID. |
| Supplier Name | Enter the supplier name. |
| Supplier Site | Enter the supplier site ID. |
| Supplier Site Name | Enter the supplier site name. |
| Status | Select the status of the supplier. |
| Division | Enter, select or search for the division. |
| Group | Enter, select or search for the group. |
| Department | Enter, select or search for the department. |
Table 5-20 (Cont.) Supplier Search - Advanced Search Criteria and Description
| Fields | Description |
|---|---|
| Class | Enter, select or search for the class. |
| Subclass | Enter, select or search for the subclass. |
| Item | Enter, select or search for the supplier’s items. |
| Order No. | Enter, select or search for the order number. |
2. To narrow down the search, use the list next to the search fields. For example, determine if the entered value should be equal or not equal to the search result.
3. Click the Saved Search list to select one of the saved search criteria. Selecting a saved search populates the search section with the saved search criteria. If the run automatically function is enabled for the search, the search is executed immediately.
You can also personalize your saved searches by selecting Personalize . The Personalized Saved Searches page appears.
For more information about the Personalized Saved Search, see Personalize Saved Search in the Oracle® Retail Merchandising Do the Basics User Guide .
4. Click Search . The suppliers that match the search criteria are displayed in the Results section.
5. Click Reset to clear the search section and results.
6. Click Save As… to save the current search criteria. The Create Saved Search page appears.
For more information about how to save your search criteria, see Create Saved Search in the Oracle® Retail Merchandising Do the Basics User Guide .
7. Click Add Fields to add more fields for the advanced search. To remove the field from the search, click the x right next to the field.
8. Click Reorder to change the order of the available search fields. The Reorder Search Fields page appears.
-
Select the desired search field and use the up and down arrows to rearrange the order of the fields.
-
Click OK to confirm the new order of the fields and close page.
-
Click Cancel to reject any changes and close the page.
9. Click Done to close the page.
Results
The Results section lists the retrieved suppliers and supplier sites.
Creating a Supplier/Supplier Site
To create a supplier or supplier site in the Supplier Search page, follow the steps below.
1. From the Tasks menu, select Foundation Data > Suppliers and Partner Foundation > Manage Suppliers . The Supplier Search page appears.
2. Enter or select search criteria as desired to make the search more restrictive.
3. Click Search . The suppliers/supplier sites that match the search criteria are displayed in the Results section.
4. Then select Actions > Create Supplier , or use the Create Supplier icon. The Create Supplier page appears.
-
a. In the Supplier Level field, select supplier or supplier site from the list. This field is a required field.
-
b. In the Supplier field, enter, select or search for the supplier you want to create the site for. If you selected supplier as the supplier level, this field is disabled.
-
c. Click OK . The Supplier/Supplier Site page appears.
5. Enter the necessary information in the individual sections.
For more information about the available sections of the Supplier/Supplier Site page, see the Create a Supplier section.
6. Then choose one of the following options.
-
Click Save to save the supplier/supplier site.
-
Click Save and Close to save the supplier/supplier site and close the page.
-
Click Save and Create Another to save the current supplier/supplier site and create additional entries.
-
Click Cancel to reject all entries and close the page.
Editing a Supplier
To edit a supplier, follow the steps below.
1. From the Tasks menu, select Foundation Data > Suppliers and Partner Foundation > Manage Suppliers . The Supplier Search page appears.
2. Enter or select search criteria as desired to make the search more restrictive.
3. Click Search . The suppliers that match the search criteria are displayed in the Results section.
4. Select a supplier in the Results section.
5. Then select Actions > Edit Supplier , use the Edit Supplier icon, or click on the supplier link. The Supplier page appears.
6. Edit the information in the individual sections.
For more information about the available sections of the Supplier/Supplier Site page, see the Create a Supplier section.
7. Then choose one of the following options.
-
Click Save to save your changes.
-
Click Save and Close to save your changes and close the page.
-
Click Save and Edit Another to your changes and edit additional suppliers.
-
Click Cancel to reject all entries and close the page.
Editing a Supplier Site
To edit a supplier site, follow the steps below.
1. From the Tasks menu, select Foundation Data > Suppliers and Partner Foundation > Manage Suppliers . The Supplier Search page appears.
2. Enter or select search criteria as desired to make the search more restrictive.
3. Click Search . The suppliers that match the search criteria are displayed in the Results section.
4. Select a supplier site in the Results section.
5. Then select Actions > Edit Supplier Site , or click on the supplier site link. The Supplier Site page appears.
6. Edit the information in the individual sections.
For more information about the available sections of the Supplier Site page, see the Create a Supplier section.
7. Then choose one of the following options.
-
Click Save to save your changes.
-
Click Save and Close to save your changes and close the page.
-
Click Save and Edit Another to your changes and edit additional supplier sites
-
Click Cancel to reject all entries and close the page.
In this guide
- Guide: Foundation Data User Guide — Use Merchandising
- Previous: 4 Merchandise Hierarchy
- Next: 6 Partner