Streamline Purchasing: Leverage UOM from Sales Orders in Dynamics GP PO Generation

Table of Contents

Generating purchase orders directly from sales orders within Microsoft Dynamics GP offers a powerful way to streamline procurement processes. A critical element in this automation is ensuring the correct Unit of Measure (UOM) is applied to the purchase order line item. This article delves into how the settings within the Sales Order Processing Setup Options, Item Purchasing Options Maintenance, and Item Vendors Maintenance windows interact to determine the default UOM when you generate a purchase order preview from a sales order in Dynamics GP (including older versions like Great Plains 8.0). Understanding this logic is essential for accurate purchasing, inventory management, and supplier communication.

Accurate UOM management is more than just a technical detail; it directly impacts your business’s efficiency and profitability. Using the wrong UOM can lead to ordering incorrect quantities, resulting in excess inventory or stockouts, difficulties during receiving, discrepancies with supplier invoices, and wasted time resolving errors. By correctly configuring the UOM defaults within Dynamics GP, you ensure that the automated PO generation process reflects your actual purchasing needs and supplier agreements. This precision reduces manual adjustments, minimizes errors, and improves the overall procurement cycle.

The system follows a specific hierarchy when determining the default UOM for a purchase order line generated from a sales order. It doesn’t simply pick a UOM at random or always use the UOM from the sales line. Instead, it evaluates settings configured at different levels within the system, starting with the most specific configuration: the relationship between a particular item and a particular vendor. This tiered approach provides flexibility, allowing businesses to define purchasing UOMs that vary depending on the supplier, even for the same item.

Item Vendors Maintenance: The First Check¶

The primary place Dynamics GP looks to determine the default purchasing UOM when generating a PO from a sales order is the Item Vendors Maintenance window. This window allows you to define specific purchasing options for each item and vendor combination that your company uses. It’s here that you establish vendor-specific details that can override more general item-level settings, reflecting potentially different pricing, lead times, or, importantly, units of measure that a specific vendor uses when selling a particular item.

To access and review the settings in the Item Vendors Maintenance window, navigate through the Dynamics GP menus. This is the initial point of configuration the system checks during the PO generation process initiated from a sales transaction. The options configured here hold significant weight in the UOM determination logic.

Follow these steps to view the Item Vendors Maintenance window options:

1. On the Cards menu, point to Inventory.
2. Select Vendors.
3. In the Item Number list, choose the specific item number for which you are checking the UOM settings.
4. In the Vendor ID list, select the relevant vendor ID associated with that item.

Within the Item Vendors Maintenance window, pay close attention to the Default Purchasing U of M section. This setting provides a crucial decision point for the system. It determines whether the UOM should be pulled directly from this vendor-specific setting or from a more general item-level configuration.

Here’s how the Default Purchasing U of M setting in the Item Vendors Maintenance window influences the process:

• If From Item Vendor is selected, the UOM specified directly within this window for this specific Item/Vendor combination will be the default UOM populated in the Purchase Order Preview window. This is the most specific setting and takes precedence if selected.
• If From Item is selected, the system will not use the UOM specified directly in the Item Vendors window. Instead, it defers the decision to a setting configured at the item level, which is controlled by the Sales Order Processing Setup Options window. This option tells Dynamics GP to look elsewhere for the default purchasing UOM.

Understanding this initial check is vital. If the Item Vendor setting is configured to ‘From Item Vendor’, the UOM is determined here, and the system does not need to look at the other windows. Only if it is set to ‘From Item’ does the system proceed to evaluate the next level of default settings.

Sales Order Processing Setup Options: The Next Layer¶

If the Item Vendors Maintenance window is set to derive the default purchasing UOM ‘From Item’, Dynamics GP then consults the Sales Order Processing Setup Options window. This window contains various default settings that apply to the sales order processing module as a whole, including how certain fields should be populated when generating downstream documents like purchase orders from sales orders. It provides a system-wide or module-wide default logic for UOM derivation when the item-vendor specific setting defers the decision.

The path to access the Sales Order Processing Setup Options window varies slightly depending on your version of Microsoft Dynamics GP. It is typically found within the Sales module setup options. Accessing this window requires appropriate security permissions within the GP environment.

Follow the appropriate step for your Dynamics GP version to view the Sales Order Processing Setup Options window:

• For Microsoft Dynamics GP 9.0 and earlier versions: On the Tools menu, point to Setup, point to Sales, and then select Sales Order Processing.
• For Microsoft Dynamics GP 10.0 and later versions: On the Microsoft Dynamics GP menu, point to Tools, point to Setup, point to Sales, and then select Sales Order Processing.

Once you are in the Sales Order Processing Setup window, you need to access the specific options related to purchase order generation defaults. This is typically done by selecting an ‘Options’ button or tab within the main setup window. This section groups various settings that control the behavior of PO generation from sales orders.

After opening the Sales Order Processing Setup window, select Options.

Within the Sales Order Processing Setup Options window, locate the Defaults for Purchase Order section. In this section, there is a field specifically for controlling the default U of M when a PO is generated from a sales order, provided the Item Vendor setting is ‘From Item’. This field offers two primary choices for how the system should determine the UOM in this scenario.

Note the value selected in the U of M field within the Defaults for Purchase Order section:

• If Sales Line Item’s U of M is selected, the UOM that was originally entered on the sales order line item for the item being purchased will be used as the default UOM in the Purchase Order Preview window. This option directly links the purchasing UOM to how the item was sold to the customer.
• If Item’s Default Purchasing U of M is selected, the system will not use the UOM from the sales line. Instead, it will look for a different default UOM setting configured specifically for the item in another window: the Item Purchasing Options Maintenance window. This option defers the UOM decision to a general purchasing default defined at the item level.

This layer of settings in Sales Order Processing Setup provides a fallback or alternative logic when the item-vendor combination doesn’t dictate the UOM directly. It allows a business to decide whether the purchasing UOM should follow the sales UOM or refer to a dedicated item purchasing default. If the ‘Item’s Default Purchasing U of M’ option is chosen here, the system then proceeds to check the final configuration window in the hierarchy.

Item Purchasing Options Maintenance: The General Item Default¶

The third window in the hierarchy, accessed if the Item Vendors setting is ‘From Item’ and the Sales Order Processing Setup is set to ‘Item’s Default Purchasing U of M’, is the Item Purchasing Options Maintenance window. This window is where you define general purchasing default settings for an item that are not specific to any single vendor. It serves as a general fallback for the purchasing UOM when more specific settings don’t apply or defer the decision.

This window is dedicated to consolidating purchasing-related defaults for inventory items. It’s where you might configure things like default lead times, minimum order quantities, or, in this context, a standard UOM that you typically use when purchasing this item, regardless of the vendor (unless overridden by the Item Vendor setting).

To view the settings in the Item Purchasing Options Maintenance window, follow these steps:

1. On the Cards menu, point to Inventory.
2. Select Item Purchasing Options.
3. In the Item Number list, select the specific item number you are interested in.

Within the Item Purchasing Options Maintenance window, there is a field specifically for the default purchasing unit of measure for that item. This is the setting that Dynamics GP will use if the conditions from the previous two windows point here. It represents the most general purchasing UOM default for the item.

Note the value in the Default Purchasing U of M field. The unit of measure selected here will be the unit of measure that defaults in the Purchase Orders Preview window if the Item/Vendor combination in the Item Vendors Maintenance window is set to From Item, and if the U of M field in the Defaults for Purchase Order section of the Sales Order Processing Setup Options window is set to Item’s Default Purchasing U of M. This setting acts as the final fallback in the UOM determination hierarchy.

Summary of the UOM Hierarchy¶

To recap the logic, when generating a purchase order preview from a sales order for a specific item and vendor, Dynamics GP determines the default UOM by following a specific path:

1. Check Item Vendors Maintenance: Does the setting for the specific Item/Vendor combination use ‘From Item Vendor’?
   • Yes: Use the UOM defined in that Item Vendor window. Stop here.
   • No (Set to ‘From Item’): Proceed to step 2.
2. Check Sales Order Processing Setup Options: The Item Vendor setting defers to the item level. Does the ‘Defaults for Purchase Order - U of M’ setting use ‘Sales Line Item’s U of M’?
   • Yes: Use the UOM from the original Sales Order Line Item. Stop here.
   • No (Set to ‘Item’s Default Purchasing U of M’): Proceed to step 3.
3. Check Item Purchasing Options Maintenance: Both previous settings defer the decision. Use the Default Purchasing U of M defined in the Item Purchasing Options Maintenance window for the item. This is the final default.

Understanding this hierarchy allows you to troubleshoot why a particular UOM is defaulting on your purchase order previews and configure the system to match your business processes and supplier agreements. Proper configuration ensures that the system automates the UOM selection correctly, reducing the need for manual intervention.

Modifying the Default UOM¶

While the system provides a default UOM based on these settings, it’s important to note that the default is not always final. In the Purchase Order Preview window, before actually generating the purchase order, you have the opportunity to review and modify the proposed details, including the unit of measure. This flexibility is crucial for handling exceptions or specific purchasing scenarios that might not align with the established defaults.

In the Purchase Order Preview window, you can typically select the line item and access its details (often via an ‘Item’ tab or similar control). Here, you will see the default UOM that the system has determined based on the hierarchy described above. You can manually change this UOM to any other valid purchasing UOM defined for that item.

The unit of measure that appears in the U of M field after any manual adjustments (or if no adjustment is made to the default) is the value that will be carried over to the actual purchase order when you select the option to Generate the PO. This final check allows users to ensure accuracy before the purchase order is formally created and potentially sent to a vendor. Making corrections at this stage is far more efficient than dealing with errors on a generated PO or, worse, after the order has been placed or received.

Maintaining accurate and logical UOM settings across all relevant windows in Dynamics GP is a key part of optimizing the procure-to-pay cycle when leveraging the sales order-to-purchase order generation functionality. It requires coordination between inventory, sales, and purchasing departments to ensure the settings reflect current business practices and vendor relationships. Regularly reviewing these configurations, especially after adding new items or vendors or changing purchasing agreements, can prevent downstream issues and enhance operational efficiency.

What are your experiences managing UOMs during PO generation in Dynamics GP? Have you encountered specific challenges related to these settings? Share your thoughts and tips in the comments below!