Streamline Sales Orders & POs: Dynamics GP Tools for Efficient Processing

Table of Contents

Microsoft Dynamics GP is a robust ERP system that provides comprehensive modules for managing business operations, including Sales Order Processing (SOP) and Purchase Order Processing (POP). While GP offers a wide range of standard features, the Professional Services Tools Library (PSTL) provides additional utilities designed to enhance functionality and efficiency in specific areas. This article explores several key tools within the PSTL that are particularly beneficial for optimizing SOP and POP workflows, helping businesses to improve accuracy, reduce manual steps, and gain better control over their order and procurement processes.

The tools available cover various aspects, from handling unique transaction requirements like negative line items or partial kit transfers in sales to refining purchase order entry and receipt tolerances. Leveraging these tools can significantly streamline daily operations for sales and purchasing teams, allowing them to process transactions more quickly and with greater precision. Some of these tools are available at no additional cost with Dynamics GP, while others are add-ons that require purchase. Understanding the capabilities of each tool is the first step toward identifying which ones can bring the most value to your organization’s specific needs and processes.

It is important to note that the availability and licensing of these tools can vary. Some tools are considered part of the standard PSTL package and are free to use for licensed Dynamics GP customers. Other tools, often those marked with an asterisk (*), may be premium tools requiring a separate purchase or a specific type of support plan. Companies should consult with their Dynamics GP partner to determine which tools they have access to and the process for acquiring any paid tools that could benefit their operations. This ensures compliance and proper licensing while unlocking the full potential of the Professional Services Tools Library.

More Information on SOP and POP Tools¶

The Professional Services Tools Library offers a diverse collection of utilities, and specifically for Sales Order Processing and Purchase Order Processing, there are several noteworthy additions. These tools address common business challenges and provide functionalities that extend the capabilities of the standard GP modules. Implementing the right combination of these tools can lead to significant improvements in efficiency, data accuracy, and overall control within your sales and purchasing departments. The following sections detail some of the most impactful tools available for these areas.

It is crucial to reiterate that the tools marked with an asterisk (*) below require a separate purchase. Tools not marked with an asterisk are generally available at no additional cost as part of the core Professional Services Tools Library. Businesses should prioritize reviewing their current processes and pain points to determine which of these tools offer the most relevant solutions. A phased approach to implementing these tools, starting with the free ones or those addressing the most critical needs, can be an effective way to integrate them into your existing Dynamics GP environment.

Sales Order Processing Negative Line Items¶

This tool provides flexibility in adjusting the total value of a sales invoice. In standard Sales Order Processing, adding a line item typically increases the invoice total. However, this tool allows users to add a non-inventoried item with a negative unit price. This functionality is particularly useful for applying discounts, allowances, or adjustments directly on a line item without needing to use complex pricing structures or overall document discounts.

By using a negative line item, the total invoice amount is reduced accordingly. It’s important to note that this type of line item is typically non-taxable, ensuring that tax calculations remain accurate based on the actual goods or services sold. Additionally, commissions are calculated based on the adjusted line item total, ensuring sales compensation reflects the final value of the transaction after the negative adjustment has been applied. This offers a transparent and straightforward method for managing specific types of price reductions within the sales document itself.

*Sales Order Processing Lot Number Overrides¶

Managing lot-numbered inventory requires strict control over quantities and tracking. This tool is invaluable for businesses that deal with lot-tracked items, especially in scenarios where sales occur before the physical inventory or its corresponding lot number receipt has been fully processed in the system through typical purchasing or manufacturing workflows. It addresses the challenge of selling items for which the lot information isn’t yet officially recorded in inventory.

The tool facilitates this by creating a temporary lot number receipt when a sales transaction involving a lot-tracked item is entered, even if the physical receipt hasn’t been recorded. This temporary receipt allows the system to accurately track the committed or sold quantity against a specific, albeit temporary, lot. Once the actual lot-controlled inventory is received through Purchase Order Processing, Bill of Materials, or a direct Inventory transaction, the temporary receipt is automatically removed. The actual lot receipt is then updated to reflect that a portion of its quantity has already been allocated or sold via the earlier sales order, maintaining data integrity. This prevents overselling and ensures accurate visibility of future inventory availability based on incoming lots.

*Sales Order Processing Partial Kit Transfer¶

Kit items in Dynamics GP are groups of components sold as a single unit under a kit item number. Standard SOP processing typically requires transferring the entire kit item, including all its components, from an order to an invoice. This tool provides flexibility for businesses that need to partially invoice a large order containing kit items, allowing only a subset of the kit components or a fraction of the total kit quantity to be moved to an invoice.

This utility specifically supports the transfer of kit items from a sales order to a sales invoice. It does not currently support transferring partial kits to back orders. When using this tool, the system treats the kit items and their underlying components more like standard line items for the purpose of transfer. It accurately maintains the “Quantity Previously Invoiced” value for both the main kit line and its individual component lines. This ensures that when subsequent partial transfers or the final transfer occur, the system correctly tracks how much of the kit and its components have already been billed, preventing billing discrepancies on large or staged orders involving kits.

Sales Order Processing to Purchase Order Processing Line Recording Utility¶

The integration between SOP and POP allows businesses to automatically generate purchase orders for items needed to fulfill sales orders (e.g., drop-ship items or build-to-order scenarios). By default, when this transfer happens, the order of line items on the generated purchase order might not necessarily match the original sequence on the sales order document. This can create difficulties for businesses that need to reconcile purchase order printouts with the original sales order, packing lists, or picking tickets where the original line sequence is critical.

This tool addresses this by preserving the original line item order from the sales order document when generating the purchase order through the SOP to POP transfer process. Although preview reports or inquiry windows might display items sorted alphabetically or by item number, the actual line items recorded within the purchase order document maintain the sequence defined on the source sales order. This seemingly simple function is vital for operational efficiency, ensuring that receiving, stocking, and billing processes align seamlessly with the customer’s original order structure and supporting documentation.

Purchase Order Processing Cost Defaulter¶

When entering a new purchase order in Dynamics GP, the system defaults the unit cost for an item based on a hierarchy, often favoring the vendor-specific Last Invoice Cost recorded for that item and vendor combination. While this is useful in many cases, some businesses prefer to default the cost based on other valuation methods, such as the item’s Standard Cost or its current valuation layer’s Current Cost.

This tool provides the option to override the default behavior and configure the Purchase Order Entry window to use either the Standard Cost or the Current Cost value from the item’s inventory record as the default unit cost. This gives purchasing departments more control over the initial cost populated on purchase orders, potentially leading to more accurate cost tracking or better adherence to internal pricing policies from the outset. It simplifies data entry by automatically populating the desired cost type, reducing the need for manual overrides based on the Last Invoice Cost.

Customer PO Number Check¶

Maintaining unique customer purchase order numbers is essential for accurate record-keeping, order tracking, and matching payments. Duplicate customer PO numbers can lead to confusion, processing errors, and difficulties in reconciling accounts receivable. The standard Dynamics GP system does not inherently prevent the use of duplicate customer PO numbers across different sales documents.

This tool adds a validation check for the “Customer PO Number” field. As a user enters or modifies data in this field within the Sales Transaction Entry window or the SOP Customer Detail Entry window, the tool examines existing sales documents to determine if the entered PO number has already been used. If a duplicate is detected, the tool can alert the user, prompting them to verify the number or enter a unique one. This proactive check significantly reduces the likelihood of creating sales documents with identical customer PO numbers, improving data integrity and simplifying downstream processes like invoicing and cash application.

Default Add Item for POP/SOP¶

When adding new line items to sales or purchase transactions, users often need to interact with the item lookup window or manually type item numbers. If a particular item is frequently added, or if the workflow often involves adding items quickly, reducing the steps to select an item can save time. The “Add Item” option in item lookups or related windows helps streamline this process by quickly bringing up the item selection interface.

This tool automatically selects the “Add Item” option in key transaction entry windows for both Sales Order Processing and Purchase Order Processing. Specifically, it impacts the behavior within the Sales Transaction Entry, Purchase Order Entry, Receivings Transaction Entry, and Purchasing Invoice Entry windows. By pre-selecting the “Add Item” option, it prepares the system for item selection, potentially speeding up the process for users who primarily add items via lookup rather than direct entry of the item number. This subtle automation can contribute to faster data entry for high-volume users.

PO Returns¶

Processing returns to vendors is a critical part of the procurement cycle. Ensuring that you do not invoice more than the net quantity received after returns is vital for accurate inventory and accounts payable management. The standard POP system tracks quantities received, invoiced, and returned.

This tool enhances the control during the invoicing of receipts in Purchase Order Processing. It adds a validation check that considers both the quantity previously invoiced and the quantity already returned for a specific line item on a purchase order receipt. The tool enforces a limit on the quantity that can be invoiced based on the simple calculation: Quantity Shipped - (Previous Quantity Invoiced + Quantity Returned). By preventing users from invoicing a quantity greater than this calculated maximum, the tool ensures that businesses only pay for the net quantity of goods retained, after accounting for any returns made against that specific receipt line. This helps maintain accurate inventory valuation and prevents overpayment to vendors.

POP Over Receipt Tolerance¶

Receiving goods exactly as ordered isn’t always possible; sometimes vendors ship slightly more or less than the quantity specified on the purchase order. While under-receipts often require follow-up, allowing for minor over-receipts within a predefined limit can streamline the receiving process and avoid unnecessary exceptions. Standard Dynamics GP requires exact quantity matching unless manual adjustments are made.

This tool introduces a configurable receipt tolerance percentage for purchase order line items. Within a setup window, administrators can define a percentage threshold. When receiving goods against a purchase order, the system will allow receiving a quantity up to the original quantity ordered plus the allowed percentage of that quantity. For instance, if an order is for 10 units and the tolerance is set to 20%, the system will allow receiving up to 12 units (10 + 20% of 10 = 10 + 2 = 12). This tool simplifies receiving by automatically accommodating small over-shipments within an acceptable range, reducing the need for manual overrides or separate purchase order amendments for minor quantity variances.

Shipment Notification¶

Handling drop-ship sales orders involves coordinating between a sales transaction and a corresponding purchase order to the vendor who ships directly to the customer. Standard practice often dictates that the purchase order must be invoiced before the related sales order can be invoiced to the customer, ensuring that the cost is recorded before the revenue. However, business processes might require invoicing the customer as soon as the vendor confirms shipment, even if the vendor’s invoice hasn’t arrived or been processed yet.

This tool provides the flexibility to transfer drop-ship sales orders to a sales invoice before the corresponding purchase order receipt has been invoiced. This allows businesses to invoice their customers promptly upon confirmation of shipment from the vendor, aligning billing cycles with shipping events rather than vendor invoicing cycles. While providing this flexibility, businesses must ensure their internal controls and processes account for potentially invoicing customers before the vendor cost is finalized and recorded, to maintain accurate financial reporting.

SOP Default Site per Line¶

In Dynamics GP Sales Order Processing, the system typically defaults the inventory Site ID for line items from the Default Site specified at the document header level or from the customer’s record. However, businesses often store the same item in multiple warehouse locations (sites), and the preferred site for fulfilling orders for a particular item might be defined at the item level rather than being consistent across an entire order or customer.

This tool allows the system to default the Site ID for each line item on a sales transaction based on the item’s specific configuration. Instead of inheriting the site from the header or customer, it first checks the “Default Site ID” field within the Item Quantities Maintenance window for that specific item. If a default site is specified there, that site will be used for the line item. If that field is empty, the tool will then default to the first site assigned to the item in the Item Quantities window. This ensures that inventory allocation and fulfillment are more accurately aligned with the item’s designated primary storage or shipping location, improving warehouse efficiency and inventory visibility.

*SOP Return Account Default¶

When processing customer returns in Sales Order Processing, a corresponding credit memo or return transaction is created. For accounting purposes, the system generates distribution lines, including one for the “Sales” account, which typically represents a reduction in sales revenue due to the return. Standard GP might use the original sales account from the invoice or a default setup account for this distribution.

This tool specifically populates the ‘Sales’ distribution type account for return transactions based on a designated account. When a return is initiated in the Sales Transaction Entry window using the “Create Return” option, this tool ensures that the account used for the SALES distribution line defaults to the account specified in the “Sales Order Returns” field within the Customer Account Maintenance window. This provides better control and consistency over how customer returns are accounted for, allowing businesses to track sales returns separately from gross sales if desired, directly linking the return account to the customer record involved in the transaction.

SOP Sort Line Items¶

The order in which line items appear in the Sales Transaction Entry window usually reflects the sequence in which they were added to the document. While this is straightforward for data entry, users might prefer to view the line items sorted by other criteria (e.g., item number, description, or requested ship date) for easier review or editing. The standard display does not offer dynamic sorting within the entry window itself.

This tool provides users with the ability to define custom sorting options for how line items are displayed within the Sales Transaction Entry window. For example, a user can configure the tool to sort lines by item number. When viewing a sales document, the line items will then be presented in item number order, regardless of their original input sequence. It is important to understand that this sorting only affects the display within the entry window; it does not physically reorder the records in the underlying database tables. Furthermore, this tool does not affect the order in which line items print on sales documents like orders, picking tickets, or invoices, which is typically controlled by report definitions. This display-only sorting feature primarily serves to improve the usability and review process within the data entry screen itself.

Summary of Key SOP & POP Tools¶

To help visualize the different tools and their functions, the following table provides a quick overview of the tools discussed for Sales Order Processing (SOP) and Purchase Order Processing (POP).

Tool Name	Category	Primary Function	Free/Paid*
Sales Order Processing Negative Line Items	SOP	Allow negative line items for discounts/adjustments on invoices.	Free
Sales Order Processing Lot Number Overrides	SOP	Create temporary lot receipts to allow selling unreceived lot items.	Paid*
Sales Order Processing Partial Kit Transfer	SOP	Allow partial transfer of kit items from order to invoice.	Paid*
Sales Order Processing to Purchase Order Processing Line Recording Utility	SOP/POP	Preserve sales order line sequence when creating purchase orders.	Free
Purchase Order Processing Cost Defaulter	POP	Default PO cost to Standard or Current Cost instead of Last Invoice Cost.	Free
Customer PO Number Check	SOP	Check for duplicate customer PO numbers during sales entry.	Free
Default Add Item for POP/SOP	SOP/POP	Auto-select “Add Item” option in transaction windows.	Free
PO Returns	POP	Limit PO invoicing quantity based on received and returned quantities.	Free
POP Over Receipt Tolerance	POP	Allow receiving over the ordered quantity within a defined percentage tolerance.	Free
Shipment Notification	SOP/POP	Allow invoicing drop-ship sales orders before invoicing the related purchase order.	Free
SOP Default Site per Line	SOP	Default sales line item site based on the item’s preferred site.	Free
SOP Return Account Default	SOP	Default the ‘Sales’ distribution account for return transactions based on customer.	Paid*
SOP Sort Line Items	SOP	Allow defining custom sort order for line items display in Sales Entry window.	Free

Tools marked with an asterisk () may require a separate purchase or specific licensing.

Streamlining SOP and POP Workflows¶

Implementing tools from the Professional Services Tools Library can significantly impact the efficiency and accuracy of your Sales Order Processing and Purchase Order Processing workflows in Microsoft Dynamics GP. By addressing specific pain points like managing lot numbers before receipt, handling partial kit shipments, controlling purchase order costs, or enforcing customer PO uniqueness, businesses can reduce manual workarounds and potential errors.

Consider the typical flow of a sales order: from creation, allocation, fulfillment, to invoicing. Tools like ‘SOP Default Site per Line’ can ensure stock is allocated from the correct location from the start, while ‘SOP Partial Kit Transfer’ allows for flexible billing. Integrating with purchasing, the ‘SOP to POP Line Recording Utility’ maintains consistency when drop-shipping or back-to-backing orders.

Similarly, in procurement, from requisition to receiving and invoicing, tools like ‘POP Over Receipt Tolerance’ smooth out the receiving process for minor discrepancies, and ‘PO Returns’ ensures accurate vendor invoicing based on net received quantities. The ‘Purchase Order Processing Cost Defaulter’ helps ensure costs are recorded consistently from the moment the PO is created.

Using these tools effectively requires understanding how they fit into your existing business processes. It’s often beneficial to review your current SOP and POP procedures, identify bottlenecks or areas prone to error, and then see which PSTL tools offer a direct solution. Training users on the functionality of these tools is also key to successful adoption and realizing their full benefits.

```mermaid
graph TD
A[Sales Order Creation] → B{Line Item Entry};
B – Item Type/Site → C{Apply SOP Tools};
C – Negative Item → C1[Adjust Invoice Value];
C – Lot Number* → C2[Manage Unreceived Lots];
C – Kit Item* → C3[Handle Partial Kit];
C – Item Site → C4[Default Site per Line];
B – Customer PO → C5[Check Customer PO Number];
A – Needs Purchase → D[Generate Purchase Order];
D – Line Sequence → D1[Apply POP Tools];
D1 – SOP Order → D2[Maintain Line Sequence];
D1 – Cost → D3[Default Cost Type];
D1 – Item → D4[Default Add Item];
D – Send to Vendor → E[Vendor Ships];
E – Ship Direct to Customer → F[Apply Shipment Notification];
F – Invoice Customer Early → G[Invoice Sales Order];
E – Ship to Own Warehouse → H[Receive Goods];
H – Quantity → H1[Apply Over Receipt Tolerance];
H – Return Goods → H2[Apply PO Returns Tool];
H → I[Invoice Vendor];
I → J[Accounts Payable];
G → K[Accounts Receivable];
G – Customer Returns → L[Process Sales Return];
L – Accounting → L1[Apply SOP Return Account Tool*];

click C2 "https://example.com/lot-override" tooltip "More info on Lot Number Overrides"
click C3 "https://example.com/partial-kit" tooltip "More info on Partial Kit Transfer"
click L1 "https://example.com/return-account" tooltip "More info on SOP Return Account Default"

style C1 fill:#f9f,stroke:#333,stroke-width:2px
style C2 fill:#ccf,stroke:#333,stroke-width:2px
style C3 fill:#ccf,stroke:#333,stroke-width:2px
style C4 fill:#f9f,stroke:#333,stroke-width:2px
style C5 fill:#f9f,stroke:#333,stroke-width:2px
style D2 fill:#acf,stroke:#333,stroke-width:2px
style D3 fill:#acf,stroke:#333,stroke-width:2px
style D4 fill:#aaf,stroke:#333,stroke-width:2px
style F fill:#acf,stroke:#333,stroke-width:2px
style H1 fill:#acf,stroke:#333,stroke-width:2px
style H2 fill:#acf,stroke:#333,stroke-width:2px
style L1 fill:#ccf,stroke:#333,stroke-width:2px

```
Note: The Mermaid diagram illustrates conceptual process flow points where these PSTL tools (highlighted with different fill colors) can intervene to streamline or enhance standard Dynamics GP operations. Tools marked with ‘’ in the diagram or table are typically paid add-ons.*

Implementing these tools effectively can transform tedious, error-prone manual steps into automated, controlled processes. This leads to faster transaction processing, reduced data entry errors, improved inventory accuracy, and better alignment between sales and purchasing activities. Ultimately, streamlining these core operational areas contributes significantly to a company’s overall efficiency and profitability.

What are your thoughts on the most impactful SOP or POP tools in Microsoft Dynamics GP? Share your experiences or questions in the comments below!