Update Item and Category for External Purchase Price Lines
Use the Update Item and Category for External Purchase Prices to automatically update the external purchase price lines with the item and purchasing category, based on the trading partner relationship.
When a trading partner relationship doesn’t exist, the process checks if a purchasing category mapping exists for the manufacturer part number. If the mapping is available, the process updates the external purchase price lines with the purchasing category.
When to Use
Run this scheduled process when the item or purchasing category mapping are available for external purchase price lines that were imported without an item or category. This process updates the item and category for these lines. You can also include lines for purchasing using the Include for Purchasing option in the scheduled process.
Privileges Required
- Manage External Purchase Prices (SCH_MANAGE_EXTERNAL_PURCHASE_PRICES_PRIV)
Specifications
Review these specifications before you set up the scheduled process:
| Specification | Description |
|---|---|
| Job Type | Scheduled. The process can also be submitted manually to process the records with errors after correcting the errors. |
| Frequency | The process is recommended to be scheduled to run automatically according to the frequency of item or category mappings created for new manufacturer part numbers. |
| Time of Day | Scheduled for the end of the day, preferably after work hours at 00:00 AM. |
| Duration | Typically less than 5 minutes. |
| Compatibility | There should be only one instance of the scheduled process
running at any time and there is no current functional need to run
multiple instances of this process at the same time. This process is
automatically placed on hold when any of these other external
purchase prices scheduled processes are running:
|
Parameters
| Parameter | Optional or Required | Description | Parameter Values | Special Combinations Required |
|---|---|---|---|---|
| Requisitioning BU | Optional | To run this update only for a specific requisitioning business
unit, select a requisitioning business unit from the drop-down
list. When no requisitioning business unit is selected, all the requisitioning business units will be considered. |
Requisitioning BU | No |
| Include for Purchasing | Optional | To automatically include for purchasing, external purchase price
lines for which an item or a purchasing category mapping was found.
Include for Purchasing=Yes or it's left blank. To not include for purchasing, external purchase price lines for which an item or a purchasing category mapping was found. Include for Purchasing =No |
Yes or No | No |
| Include Lines with Purchasing Category | Optional | To convert description-based external purchase price lines into
lines with item number, Include Lines with Purchasing Category =
Yes. The process checks for items that are created for manufacturer
parts without an item number even if they are enabled for. If a
trading partner relationship exists, the existing line in the
external purchase price is canceled and a new line is created for
the manufacturer part number along with the item number. If the
external purchase price line exists in a purchase agreement, the
purchasing agreement line is also updated with the item number.
To not convert description-based external purchase price lines into lines with item number, Include Lines with Purchasing Category =No or if it's left blank. |
Yes or No |
Troubleshooting Information
- You can view the status of the Update Item and Category for External Purchase Prices process in the Scheduled Processes work area.
- The validation errors and warning messages about what prevented the Update Item and Category for External Purchase Prices from completing are displayed in the error log.
- Any interactive warning validations aren't performed.
- When the program is submitted, you can Resubmit, Put on Hold, Cancel Process, Release Process as provided by the Scheduled Processes work area.