SpellCheck for Dynamics GP provides spell-checking on any Note, Comment, Text or String field in GP and 3rd party products. SpellCheck can be attached to any text entry field in the application.
Use SpellCheck to check spelling on:
Preactor Integration is a flexible integration utility which connects Preactor’s finite manufacturing scheduling software to Dynamics GP Manufacturing.
MO Generator provides integration utilities for building systems which connect Dynamics GP Manufacturing to external applications.
The Suite of utilities contains:
MFG Data Archive is a utility that moves historical Dynamics GP Manufacturing data to an archival company database.
A typical Advanced Management installation with GP Manufacturing will have about 2000 SQL database tables in a company database. Nearly 25% of all GP company database tables are for manufacturing data, with over 20% of those directly related to Manufacturing Orders.
LeanMFG is a complete manufacturing suite for Dynamics GP specifically designed for smaller manufacturers, and those whose processes include disassembly, batch, and multi-product production. Targeted for the Business Essentials customer, LeanMFG provides flexibility and ease-of-use that appeals to all users. It does not require Dynamics GP Manufacturing, and can be used alongside it to provide disassembly.
LabelLink provides a connection between Dynamics GP and Bar Code Printing software so you can automatically print to a bar code label printer from inside of Dynamics GP.
LabelLink prepares data from Dynamics GP so that it can be easily read by the labeling software. It simplifies the process of designing the label reports by pre-loading the required data from several locations in Dynamics GP into a single label table that is used by the label printing software. LabelLink also formats field data to so it displays nicely on the labels.
Item Process Tracking (IPT) is a configurable data collection template which can be attached to any Item-Transaction combination in Dynamics GP.
IPT is designed to address the need to record specific information about an item, or a process on or with the item, when that item is used on a specific type of transaction. For example, it can be used when receiving an item on a Service RMA to record the condition of the returned item and several return process steps. Or, IPT might be used when receiving an item on a Manufacturing Order to record a post-production checklist. IPT could also be used during Sales Invoicing to record that packing/prepping steps were completed.
EZImport solves the problem of how to retain data from a legacy system so it can be referenced from within Dynamics GP, while avoiding the time and expense to import “real” historical transactions.
While it is possible to convert legacy data and migrate it into GP, this can be very time consuming and expensive. To ensure a migrated transaction is accepted by GP, many key fields need to be mapped from the old system to the new system.
Engineer to Order (ETO) produces a Manufacturing Estimation (ME), which is the estimated cost to produce an item to a customer’s specifications. The ME is comprised of an Estimation BOM, Routing and list of Miscellaneous Costs. A tight integration to GP Manufacturing allows the ETO module to begin an estimate by importing an existing GP Manufacturing BOM and Routing, and when the ME is accepted, the ETO module transfers the ME BOM and Routing into GP Manufacturing, and creates new part numbers as needed. If the ME is linked to a Sales Quote Line, Accepting the ME can also update the Cost and Price on the sales line and change the item from a non-inventory item to a Sales Inventory item.
Consulting ToolKit is a suite of powerful tools designed to help consultants and power users. It contains Stored Queries, which allows end-users to securely execute ad-hoc tSql queries created by an admin, and Virtual Triggers, which provides the ability to quickly enhance GP functionality with small bits of dexterity code, Virtual Fields, which can add new fields to GP windows without using Modifier, and GP Report Extender, which can add nearly any field from any table to any GP report. Additionally, it contains a number of Free Tools, including a complete set of SQL Server management tools written in Dexterity and a set of GP Tools to help locate data and find resources inside GP.
CompleteCount provides the tools needed to perform a controlled cycle count in Dynamics GP using stock tags. The stock tag method of conducting a physical count provides for an audit trail of the count, ensures a higher degree of accuracy, and keeps to a minimum the downtime required to conduct the count.
CompleteCount works together with the Dynamics GP Stock Count module.
MFG Import for Dynamics GP Manufacturing contains integration utilities for Bills of Material and Routings. The utilities are designed to make it easy to perform regular imports and updates from an external file (Excel).
The Import Mapping utility allows mapping all of the Bill of Materials fields, or Routing fields, to columns in a source file. Bill of Material or Routing fields and also be populated with predefined Constants, or system provided Defaults.
During the import existing BOMs can either be revisioned (which makes a copy of the existing BOM and moves it into BOM History tables), or replaced by the imported BOM.
Existing routings are replaced by the imported routing.
Blanket PO for Dynamics GP provides the ability to create a Blanket Purchase Order with a large number of Control Lines on a single PO.
With Blanket PO you can:
Void Open Payables Transactions Filters provides a number of search/query fields to quickly locate a payables document. Saves a significant amount of time over scrolling through thousands of documents to locate the correct one.
Void Historical Payables Transactions Filters provides a number of search/query fields to quickly locate a payables document. Saves a significant amount of time over scrolling through thousands of documents to locate the correct one.
Enables changing a U of M Schedule for an item and automatically updating all affected master record and transaction tables throughout Dynamics GP, Manufacturing and Field Service. The utility automatically maps Units of Measure between the old Schedule and the new Schedule, which can have the same or large Quantity Decimals. For example, if the old Schedule has a conversion of Case = 10 Each, and the new Schedule has a conversion of CA = 10 EA, all transactions with Case will be updated to CA. Normally GP does not roll changes through the system, requiring a manual fix to the Unit of Measure on each transaction or master record. The utility also keeps the Purchasing Options, Price List, and Extended Price List by converting it to mapped units of measure. See more about how it works.
Quickly lock all users out of one or more company databases during closing procedures or maintenance. Display a custom warning message if users attempt to log-in to a locked company. Specify which users are allowed to log-in during the lock out.
System Access Lock has been part of GP PowerPack since GP version 8. Recently (GP2013) Microsoft added a utility called “Take Company Offline”:
The primary difference between the two is in how each permit or prevents user access to the Offline/Locked company.
WilloWare’s System Access Lock gives access to SA and DYNSA, and allows granting access to specific User IDs.
The GP “Take Company Offline” utility gives access to SA, all Power Users, and a single user with “Offline Access” specified on the Company Setup window.
Enables tracking customer requested product revision levels in Sales Transaction Entry. Track initial requested level, changes, and reasons for the change. Add Revision Level to any existing core GP report, or modified SOP Report.
Eliminates the need to manually select bins in Sales Transaction Entry by automatically fulfilling an order from available inventory across multiple bins. If Bin Priorities are specified for an item, bins will be used in order of priority, otherwise they are used in alphanumeric order.
The bin information on Item Site Default Bins determines how SOP Auto-Select Bins will move through the bins to allocate inventory.
SmartList Analyzer adds mathematical and statistical functions to SmartList. Perform quick count on the number of invoices created this week, or add a calculated column to find the total value of inventory in a site. Functions include:
Site To Bin Migration is a tool to aid in quickly making a transition from multiple Location Codes to Multi-Bins. Site to Bin Migration allows mapping of the AUTOCREATE bin in source Sites, to destination Bins in a master site. It then creates an inventory transfer to move all inventory out of AUTOCREATE into the target bins.
Shortage Inquiry provides a consolidated view of inventory shortages for an Item from Sales Backorders, Manufacturing Picklists, and Service Call Parts. When receiving inventory know immediately where that inventory is needed. For Manufacturing Shortages, immediately see the MO Status and Work Center requiring the inventory.
Add multiple Batch selection criteria to the Series Post windows in Financials, Receivables, Payables and Inventory. Quickly locate a sub-set of Batches, such as all Financials Batches originating in Manufacturing, so that they can be marked and posted as a group. Series Filter Post saves a significant amount of time over manually marking batches to post one at a time.
Dramatically reduce the time it takes to build a Check Batch by identifying the documents to include in the Batch with Select Checks Filters. The sophisticated query builder window can store an unlimited number of Filter Criteria and save the Filter for repeated use.
The Import Utility can bring in documents to pay from Excel or SmartList.
Create and save complex Filters with unlimited search criteria:
Find which documents to pay using searches on:
Preview the documents returned by the Filter, and manually add single documents to the Filter before creating the Check Batch:
SalesPro provides order entry personnel with quick access to the information they need to identify sales patterns, suggest up-sells and add-ons, and quickly answer customer inquiries. The SalesPro Item Lookup is a turbo-charged Item Lookup for Sales Transaction Entry which provides easy access to:
Control posting throughout GP with an allowed maximum dollar amount that a user is allowed to approve/post. Posting Controls are set on a per-user, per-document basis, and are available for virtually every window in Dynamics GP with a Post button. For example, set a dollar amount limit for a User on transaction level posting of Invoices, then any transaction above that amount must be saved into a batch for manager approval.
Create an unlimited number of PO Document IDs with associated numbering sequences (similar to SOP Document IDs). Use different, system incremented PO Numbers to easily track orders for special projects. Integrates with PO Entry, SOP PO Preview, PO Generator, Manufacturing MRP Planned Orders (POs generated from MRP), and Manufacturing MOP-POP Link (Outsourcing POs).
Enables locking of all Notes in Dynamics GP, including Form-level and Record-level notes. Use a “soft lock” (no password) to prevent accidental changes to or deletion of a record-level note on a Sales Transaction. Or, use a “hard lock” (requires system password to unlock), on a Customer Note that should never be changed. When a note is locked, the text field is disabled, as are the Attach and Delete buttons.
Create system maintained numbering sequences for ID fields in GP and 3rd Party Products. When creating a new master record, create the ID by selecting the Next Number from the Next Number Lookup. Next Number Generator supports an unlimited number of ID sequences, so you could have one numbering sequence for Office Supply items, one for Samples, and another for Raw Materials.
Automatically generate IDs for:
Most Recently Used is a Pop-up window that shows your last 50 viewed purchase orders or sales transactions. With just a click you can re-open documents you have recently worked on. This is a great time saver for busy purchasing agents and order entry personnel.
Mass Batch Change quickly moves documents to a new Batch. Use Query Builder to create and save a query to identify target documents to transfer, or create your own Custom Query in tSql. If you transfer documents between batches to track work flow, speed the process by saving the query and reusing it. Mass Batch Change works for the following documents:
Kit Transactions will add all of the components of a kit to an Inventory Transaction without having to individually select each component. Kit Transactions calculates the quantity needed for each component and checks for available inventory before adding any components to the transaction. If there are any shortages, or components are not assigned to the destination site, an error log report prints showing all of the exceptions. Kit Transactions works with Transfers, Adjustments and Variances, and In-Transit Transfers.
Login Monitor has several features to help improve security and make full use of Dynamics GP user licenses.
Login Monitor can remove ‘inactive’ users either on an as-needed basis, or when they have been inactive for a certain amount of time. In the first method, when a new user attempts to log-in, if there is not an available user seat, Login Monitor will check for inactive users and remove one from the system so the new user can get in. In the second method, security is enhanced by automatically removing users once their ‘inactivity time’ has exceeded a threshold and closing the GP client.
Login Monitor supports a system-wide inactivity time, which can be superseded by user-specific inactivity time settings. Additionally, individual users can be excluded from the inactivity control.
Reserved Seats provides control over a number of users seats set aside for groups of users (by User Class). For example, an ADMIN could be assigned 2 seats, which can then only be consumed by users in the ADMIN User Class. If there are 30 user licenses, reserving 2 for ADMIN will make Dynamics GP behave as if there are 28 seats available for all other users.
IV Mass Transaction creates an Inventory Transfer or Adjustment of all inventory in a selected “From Site” and “From Bin”.
Create an Adjustment to remove everything from a specified Site/Bin (it works with or without Multi-bins enabled).
The IV Mass Adjustment utility creates the Inventory Adjustment by selecting all available inventory in the From Site/Bin. Serial/Lot controlled inventory is also added to the Adjustment.
IV Mass Adjustment can be used, for example, to quickly remove all inventory from a Returns-Rejects Site/Bin.
IV Mass Transfer can be used together with WilloWare’s Bin-to-Bin Transfer enhancement (as shown above). The IV Mass Transfer utility adds all inventory from a selected From Site/Bin to the Inventory Transfer.
The To Site is either entered by the user, or in the case of Bin-to-Bin Transfers it is automatically set to match the From Site. In either case, the To Bin can either use a Default Bin entered by the user, or a To Bin assigned to the Item-Site in the Item Site Default Bins window.
As shown above, the Default To Bin is “TEST”, and the To Bin Source is the Purchase Receipts Bin. With these options, the transfer will pull all inventory from WAREHO– USE Bin A, and put the inventory into each Item’s respective Purchase Receipts Bin (if there is one), or into TEST.
In this example, the Transfer allocates all inventory in the From Site/Bin, including serial/lot controlled inventory, and adds it to the Transfer. The To Bin is retrieved from the Item’s Purchase Receipts Bin.
IV Mass Transfer can be used to support an incoming inspection routine where PO Receipts initially go into a Pending Inspection Bin. After Inspection the inventory is moved into a Released Bin, and from there the Mass Transfer can create a “directed put-away” transfer pulling all inventory from the Released Bin and placing it into each Item’s Stocking Bin.
idModifier is a utility for updating ID fields (strings) in the Dynamics GP Company database. idModifier takes a novel approach in that it can be “trained” to update ANY string field, so it can handle updates beyond just the core Dynamics GP tables. It can handle Field Service, Manufacturing, Human Resources, and Project Accounting. It can also update 3rd Party Products and customizations.
The first step is to “training” idModifier by providing it sample data. For example, to develop an Item Number modifier profile, you would have it search for representative samples such as “128 SDRAM”, “256 SDRAM” and “100 XLG”. It searches ALL string fields in ALL tables in the company database looking for the sample data.
The ID Add window provides 1-click access to view data in a selected table.
When the update profile is complete it is ready to be used in idModifier.
The update process first confirms that the target new value (i.e. the “new” Item Number) does not exist in any of the update tables. If it does not, the update proceeds, and if not, all errors are reported.
GPTalk is a free text messaging utility that runs securely inside of Dynamics GP. Enable quick communication between users, or send a broadcast message to all users. The broadcast function is password controlled. GPTalk is free! Just register and then download the software.
Extended Lot Attributes track an unlimited number of user-defined lot attributes beyond the normal five provided by Dynamics GP. The ELA fields are “attached” to the Lot Number, so they are available no matter where the Lot Number is used. The ELA fields can be of any datatype, have one or more set as required and have pre-defined values accessed from a Lookup.
Create an unlimited number of Lot Attributes using string fields, dates, numbers, checkboxes and lookups.
The ELA Lot Attribute Entry window shows required fields with a Red Dot.
Color Settings is a free utility for tweaking the GP user interface. Color Settings provides a very detailed level of control over the appearance of the line color on scrolling windows, text, window backgrounds, buttons, column headings, tools bars, and more. Some uses for Color Settings are:
Client Version Tracking is a free utility for managing the configuration of every Dynamics GP client in your system. When each client connects to the server, Client Version Tracking records the version information of every dexterity product installed on the client. Version information for all clients can be viewed in the Client Version Information window, where the view can be restricted by client computer or module, or a “Conflicts Only” view that just shows client/modules with version conflicts. An optional setting prevents GP clients with conflicts from logging-in to GP until the conflicts are resolved.
The GP PowerPack Bin-to-Bin Transfers module creates a regular inventory transfer transaction to move inventory between bins. Unlike the bin-to-bin functionality provided with out of the box Dynamics GP, the WilloWare Bin-to-Bin Transfer can be saved in a batch, posted as a batch, have posting security applied, and it appears in all normal GP Inventory Transaction inquiries and reports. Please see the chart below for a full comparison.
GP PowerPack’s Banking Enhancements for Dynamics GP add a number of features to several areas of the GP Banking functionality which make it quicker and easier to use.
Advanced Filters provide several additional methods for searching, sorting, and restricting the list of deposits. You can quickly sort deposits by dollar amount (as shown above), or display only AMEX deposits with the Credit Card restriction.
To help find a specific deposit, when a document is selected in the scrolling window, the Transaction Description will display in the title bar.
The Deposit Slip Preview window shows only the receipts marked for deposit. This provides a quick way to confirm the deposit in GP matches your deposit slip. The window can remain open and refreshes automatically as you mark receipts.
The number of codes displayed in the TYPE column is expanded to provide more detail about deposits. Rather than simply showing DEP for each deposit, the Type field contains a code indicating the type of cash receipt(s) contained in the deposit.
K = Checks
S = Cash
C = Credit Cards
When a deposit contains only credit cards, the first letter of each Card Name will be displayed, up to three cards. As shown above, using the Fabrikam data, the code BGP indicates a deposit containing:
Bankcard
Gold Credit
Platinum Credit
Advanced Filters provide the ability to restrict the Bank Rec window by any of the Type codes. Use Filter to quickly restrict the window to show only credit card deposits.
To speed research, selecting a document in the scrolling window displays the Transaction Description in the title bar.
Auto-Zoom automatically refreshes an open zoom window when you click on a new document. For example, once the Bank Deposit Entry Zoom window is open, each time you click on a deposit in the Bank Rec window, the zoom window will re-display to show the newly selected deposit. This saves a lot of clicks over having to repeatedly select a document then click the Zoom button.
The Excel Solver integration provides a solution for a very complicated problem–how to find a set of deposits which total a specific amount. You might have individual Credit Card deposits recorded in GP, but the bank reports a single deposit amount. The Excel Solver integration sends the contents from the Bank Rec window out to a Solver template, and launches the Excel Solver Add-In. Solver examines all of the documents to find a combination which totals the amount you specify.
The number of codes displayed in the TYPE column is expanded to provide more detail about deposits. Rather than simply showing DEP for each deposit, the Type field contains a code indicating the type of cash receipt(s) contained in the deposit.
K = Checks
S = Cash
C = Credit Cards
When a deposit contains only credit cards, the first letter of each Card Name will be displayed, up to three cards. As shown above, using the Fabrikam data, the code BGP indicates a deposit containing:
Bankcard
Gold Credit
Platinum Credit
Advanced Filters provide the ability to restrict the Checkbook Register Inquiry window by any of the Type codes. Use the Filters to quickly restrict the window to show only credit card deposits. Additional filters provide the ability to perform a “contains search” on the Paid To/Receive From and Description fields.
To speed research, selecting a document in the scrolling window displays the Transaction Description in the title bar.
Auto-Zoom automatically refreshes an open zoom window when you click on a new document. For example, once the Bank Deposit Entry Zoom window is open, each time you click on a deposit in the Checkbook Register Inquiry window, the zoom window will re-display to show the newly selected deposit. This saves a lot of clicks over having to repeatedly select a document then click the Zoom button.
Sticky Notes for GP! Add a pop-up sticky note to many master records (items, vendors, equipment, etc) and transactions (sales transactions, service calls, etc). An Alert attached to a Customer will pop-up wherever the Customer ID is used in GP. Use Alerts to remind users to include additional items on a sale, suggest add-ons, or to order a specific revision level of a part from a Vendor, or to provide special customer requests. Now with Alert Builder you can create new alerts attached to any GP window, or 3rd party or custom window.
GP PowerPack Tweaks includes enhancements for all parts of Dynamics GP. The General Ledger Tweaks are:
GP PowerPack Tweaks includes enhancements for all parts of Dynamics GP. The Inventory Tweaks are:
GP PowerPack Tweaks includes enhancements for all parts of Dynamics GP. The Purchase Order Processing Tweaks are:
GP PowerPack Tweaks includes enhancements for all parts of Dynamics GP. The Payroll Tweaks are:
GP PowerPack Tweaks includes enhancements for all parts of Dynamics GP. System Tweaks covers a wide range of enhancements to GP, such as Note Locking, SmartList Tools, Cache System Password, and more. The System Tweaks are:
GP PowerPack Tweaks includes enhancements for all parts of Dynamics GP. The Receivables Tweaks are:
GP PowerPack Tweaks includes enhancements for all parts of Dynamics GP. The Sales Order Processing Tweaks are:
