Menu Path: Purchasing Module Setup Purchasing Control Maintenance
Define purchasing options.
Define account resolution.
Define lead-time characteristics.
Use Purchasing Control Maintenance to set up various defaults for the Purchasing module. The purchase order options define miscellaneous fields to make the purchase order system more streamlined and consistent. You can also set up how various accounts are derived in the Purchasing module.
To set up default settings for the Purchasing module:
Click the Update button in the ribbon.
Select default settings.
Click the OK button in the ribbon. The module settings are updated.
Button |
Description |
Exit |
Click this button to close the Purchasing Control Maintenance window. |
Update |
Click this button to update purchasing options. |
OK |
Click this button to accept changes to purchasing options. This button is only available after you click the Update button in the ribbon. |
Cancel |
Click this button to reject changes to purchasing options. This button is only available after you click the Update button in the ribbon. |
Field or Button |
Description |
Enter the weight unit of measure in which to display total purchase order weight. |
|
Enter the volume unit of measure in which to display total purchase order volume. |
|
Select whether the next purchase order number is based on the ship-to, bill-to, or buyer's location. Each location has a separate purchase order numbering sequence with the location prefix preceding the number. Select one of the following:
Example If the ship-to location is NJ for a purchase order, the purchase order number is NJ00000001.
Example: If the bill-to location is 100 for a purchase order, the purchase order number is 10000000001.
Note The ship-to location selected during purchase order entry remains on the purchase order and cannot be changed in Edit mode. If you do require a change to the ship-to location, see Change Ship-To Location/Address on a Purchase Order FAQ. The bill-to location can be changed in Edit mode irrespective of the option selected for assigning purchase order numbers. |
|
Select this check box to create an audit trail for purchase orders. If this check box is selected, an audit increment is created each time a purchase order is updated. If this check box is selected, users can cancel purchase order line items and enter a purchase order line cancellation reason code and remark. |
|
Select this check box to allow purchase orders with a status of Fully Received to be updated. Even if this check box is selected, you cannot lower the purchase order quantity below what has already been received. Note To update fully received purchase orders, the Can Update Ordered PO's check box must also be selected for your user ID in User Extended Options. |
|
Select one of the following options for increasing amendment codes when purchase orders are edited:
The Ask radio button is selected by default. |
|
Select this check box to display a warning when a cost is entered on a purchase order that varies from the actual product cost by the cost variance percentage entered in the Cost Variance % field. |
|
Enter the acceptable percentage of a product’s cost that is used to determine if a purchase order's supplier has overcharged on an item. This field is only enabled if you select the Perform Sanity Check on Product Cost check box. If that check box is selected, you should define the acceptable variance percentage in this field. |
|
Enter the alpha factor used for moving average calculation for lead times. Moving averages provide trend information that a simple average of all historical data would mask, therefore an alpha factor is necessary. This field is used in lead-time averaging and is used in calculations in Lead Time Management. The date a purchase order was entered compared to the date of receipt of the purchase order includes a period of time that is calculated based on a weight average on inventory. This is the functionality of lead-time averaging. The alpha parameter is used in the following equation to recalculate the lead time: New Lead Time = Alpha Parameter * New Receipt Actual Lead Time + (1 - Alpha Parameter) * Old Lead Time The value of the alpha parameter should be between 0 and 1. Example If a received purchase order has a receipt date of 02/28/2020 and a purchase order date of 02/01/2020, the new receipt actual lead time is 27. If the old lead time is 40 and the alpha parameter is 0.2, then the new lead time is calculated as: New Lead Time = 0.2 * 27 + (1-0.2) * 40 = 37.4 You can use the alpha parameter to determine whether the old lead time or recent actual lead time has more effect on the calculation of new lead time. Increase the alpha parameter to increase the impact of the new receipt actual lead time on the calculation. |
|
Enter a receipt days deviation percentage for when the receipt days is over "Y" days. This field is used in lead-time averaging and is used in calculations in Lead Time Management. The date a purchase order was entered compared to the date of receipt of the purchase order includes a period of time that is calculated based on a weight average on inventory. This is the functionality of lead-time averaging. |
|
Enter a receipt days deviation percentage for when the receipt days is below "Y" days. This field is used in lead-time averaging and is used in calculations in Lead Time Management. The date a purchase order was entered compared to the date of receipt of the purchase order includes a period of time that is calculated based on a weight average on inventory. This is the functionality of lead-time averaging. |
|
Select this check box to use a check digit for license plates. |
|
Select this check box to allow containers to be created in Container Management. |
|
Select this check box to require a reason to be entered when users change dates on purchase orders. This check box is cleared by default. |
|
Select this check box to require a reason to be entered when users change dates for shipments or containers. This check box is cleared by default. |
|
Select this check box to post royalties to the general ledger for supplier receipts in Inventory Receipt Post and customer invoices in Invoice Post. If you select this check box, you must enter a default royalty expense and accrual account in the Royalty Expense Account and Royalty Accrual Account fields. If you do not select this check box and you track royalties, you must manually create journal entries to post royalties. |
|
Select this check box to create a supplier production monitoring workflow for a purchase order when the order is marked as ordered. If this check box is cleared, the workflow is created when the purchase order is created. Note Supplier production monitoring workflows are only automatically created for purchase orders if a workflow supplier production monitoring rule is set up. For information on setting up workflow supplier production monitoring rules, see Creating Supplier Production Monitoring Rules. |
|
Select this check box to display a warning if a purchase order includes a product that is not set up for the supplier. |
|
Select this check box to display a warning if a purchase order is changed after the date entered in the Final Change Date field in Purchase Order Maintenance. |
|
Select one of the following options:
|
|
Select whether the default cost for purchase order line items is the last cost or zero if no purchase cost matrix is set up. |
|
Select this check box to allow the receipt of purchase orders with additional charges distributed by weight, cube, units, or cost when the weight, cube, units, or cost for the purchase orders is zero. If this check box is cleared, such purchase orders cannot be received. Example A purchase order includes an additional charge that is distributed by cube value, but the cube value of products on the purchase order is zero. If this check box is cleared, the purchase order cannot be received until the cube value or additional charge is updated. |
|
Enter the default container type, or click the Lookup button to select a container type. |
|
Select this check box if you want to limit the number of attachments that users can send with a purchase order when emailing the purchase order, and then enter the maximum number of attachments. If you enter 0, no attachments can be sent. |
|
Enter a default royalty expense account, or click the Lookup button to select an account. This account is used for posting royalties if a royalty expense account is not specified for a supplier. This field is only enabled if you select the Post Royalties to G/L check box. Note The account entered in this field must be different from the account entered in the Royalty Accrual Account field. You cannot enter an A/P Trade, A/P Clearing, A/R Trade, or A/R Clearing category account in this field. |
|
Enter a default royalty accrual account, or click the Lookup button to select an account. This account is used for posting royalties if a royalty accrual account is not specified for a supplier. This field is only enabled if you select the Post Royalties to G/L check box. Note The account entered in this field must be different from the account entered in the Royalty Expense Account field. You cannot enter an A/P Trade, A/P Clearing, A/R Trade, or A/R Clearing category account in this field. |
|
Select one of the following as the default for the Release Method option in Blanket Purchase Order Release Entry.
Note This default is not used when accessing Blanket Purchase Order Release Entry from Order Entry or Order Edit, because when entering a sales order, it is assumed that the release is a direct-ship release. This default setting can be overridden for individual users in User Extended Options. |
Field or Button |
Description |
Enter up to four user-defined group labels. These labels appear in the four groups of user-defined fields on the Other Information tab in Product Maintenance. |
|
Include Week Numbers in Column Label |
Select this check box to include a sequential number (1 through 52) in DRP column labels for weeks. If you select this check box, 1 represents the first week in the year and 52 represents the last week in the year. |
Enter up to 10 labels for the life cycle of your products. You can mark products as completed for each of these cycles on the Status tab in Product Maintenance. |
Field or Button |
Description |
Enter the default shipment status for new shipments, or click the Lookup button to select a shipment status. For information on setting up shipment statuses, see Shipment Status Maintenance. |
|
Enter the default container status for new containers, or click the Lookup button to select a container status. For information on setting up container statuses, see Shipment Status Maintenance. |
|
Enter the default status to assign to completely received containers, or click the Lookup button to select a container status. For information on setting up container statuses, see Shipment Status Maintenance. |
|
Enter the default status to assign to partially received shipments, or click the Lookup button to select a shipment status. For information on setting up shipment statuses, see Shipment Status Maintenance. |
|
Enter the default status to assign to completely received shipments, or click the Lookup button to select a shipment status. For information on setting up shipment statuses, see Shipment Status Maintenance. |
Field or Button |
Description |
This grid displays the accounts used for purchasing account resolution. Select an account to display the hierarchy for account mask lookup in the Mask List grid. Example The A/P account used in purchase orders may be stored in the supplier record, the shipping location, or the purchase order class. The software will look at the three records in the sequential order you select here, and will attempt to group together a full general ledger account number based on the masks stored in each. If the same part of the general ledger account is found in more than one place, the first one found is used. For more information, see Purchasing Account Resolution. |
|
This grid displays the hierarchy for account mask lookup for the account selected in the Accounts grid. You can select an account mask and use the arrow buttons to increase or decrease the mask's priority. For more information, see Purchasing Account Resolution. |