Read the original article here: AppolisAnnouncement (site link)
Appolis, a Warehouse Management Solutions provider, and WilloWare, announce release of Dynamics GP wireless manufacturing solution.
Read the original article here: AppolisAnnouncement (site link)
Appolis, a Warehouse Management Solutions provider, and WilloWare, announce release of Dynamics GP wireless manufacturing solution.
Read the original article here: AgriCover
North Dakota grain truck cover manufacturer runs more efficiently with MFG PowerPack and custom solutions from WilloWare.
If you would like to receive immediate updates regarding product releases, please follow us on Facebook , LinkedIn, or Twitter.
You have two boxes of 14-mm nuts. One box has a gold-chrome finish, and the other has a black-chrome finish. Other than the color difference, they are physically identical and can be used interchangeably. The black-chrome item is slightly more expensive, and is required for one of your products, so you do not order it often, and usually end-up having to order more than you need.
Keeping those black-chrome nuts around ties-up capital in inventory, occupies storage space, and incurs a little bit of additional labor expense each time they are cycle counted. If only there way a good way to use them up.
There is! Since they are equivalent to the gold-chrome nuts, they can be added as a BOM Alternate Item to the Dynamics GP Manufacturing Bills of Material which use the gold-chrome nuts. This setup is shown below:
Once the Alternate Item relationship is created, MFG PowerPack’s BOM Alternates enhancement jumps in to help you use those alternates.
First, when a Manufacturing Order is created, if there is a shortage of the Primary Item on the Picklist, the BOM Alternates enhancement will suggest using the Alternate.
As shown above, an MO is created for SHIFT ASSEMBLY and there is a shortage of the Primary Item, NUT-GCHROME. The BOM Alternates enhancement checks if there are alternates specified for that Item on the Picklist, and if so, it checks for available inventory. Here there are 10 available, and the MO needs 4. Double-clicking on the item automatically updates the Picklist to swap the alternate in for the primary item.
Second, the BOM Alternates enhancement integrates with MRP where it automatically adjusts suggested POs for the primary item based on availability of alternates.
The BOM Alternates enhancements pegs each Suggested PO to locate Picklist shortages which can be met with an assigned alternate. When there is available inventory of the alternate, it adjusts the Suggested PO quantity accordingly. As shown above, a shortage of the Gold Chrome Nuts was adjusted down from 4 to 2 because of available inventory of the Black Chrome Nuts.
The BOM Alternates enhancements adds a lot of useful life to the BOM Alternates setup available on the Dynamics GP Manufacturing Bill of Materials. It will help you keep production moving by quickly swapping alternates for primary items when there is a Picklist shortage, and it will reduce inventory carrying costs by driving usage of alternates before re-ordering primary items.
Blanket PO
BOM Import
Consulting Toolkit
Engineer to Order
EZImport
GP PowerPack
Item Process Tracking
LabelLink
LeanMFG
MFG Data Archive
MFG PowerPack
MOGenerator
Preactor Integration
SpellCheck
The BOM Alternates enhancement provides the ability to automatically use Alternate Items when there is a shortage of the Primary Item.
The GP Manufacturing Bill of Materials provides the ability to assign one or more Items as Alternates for a Primary Item.
As shown above, LEG-S is an Alternate for the Primary Item, LEG. When a Manufacturing Order is created, the Alternates appear on the Picklist, but Manufacturing does not use them if there is a shortage of the Primary Item, and MRP does not consider inventory of Alternates before suggesting buying more of the Primary Item.
The BOM Alternates enhancement in MFG PowerPack addresses both of these needs.
When a Manufacturing Order is created, the BOM Alternates enhancement will check if there is a shortage of the Primary Item, and then if there is available inventory of one or more Alternates. If it determines that Alternates could be used, the Picklist Alternates window automatically opens:
Alternate Quantities can be easily swapped by double-clicking an Alternate Item in the Picklist Alternates window. Additionally, if quantity changes are manually entered on the Picklist (i.e. increasing the quantity of an Alternate), MFG PowerPack will check that the Primary Item quantity has been reduced first. This ensures that a shortage is not left on the Picklist which could either cause MRP to order more, and that the Primary is not accidentally issued.
The BOM Alternates enhancement also integrates with Materials Requirements Planning (MRP), where it checks for Alternates on Picklists and adjusts Suggested POs downwards to account for usage of Alternates.
The MRP integration checks for Suggested POs which can be pegged to Picklist shortages. If there is available inventory of Alternates, it will decrease the Suggested PO accordingly.
Time Card provides an easy to use time entry module for GP Manufacturing. Many manufacturers would like to track information about actual labor and machine time so they can analyze performance against standards, however many do not do this because using the GP Manufacturing WIP Data Collection creates financial transactions which impact product costing. WilloWare’s Time Card provides the data recording capability without the financial impact on manufacturing orders.
Time Card has an optional integration into GP Manufacturing’s data collection so that Time Card can be used to record WIP labor and machine time rather than the Manufacturing Data Collection window.
Time Card is very flexible, allowing you to record as much, or as little information as you need. It has a start/stop timer so you can clock-in and clock-out of a sequence and have the elapsed time calculated automatically. Or, you can simply enter a total number of Labor Hours.
Time Card was designed with barcode scanner use in mind. It will automatically move to the next field after scanning data, and can be configured to execute some functions automatically making data entry even faster. The tabbing sequence through the fields is configurable, so it only moves into the fields you need. If the tab sequence is set to move to the “Start Button” and then “Stop Button”, Time Card will automatically run the Start Button and then save the transaction. When the user scans again to clock-out, Time Card automatically matches to the “start transaction”, tabs directly to the “Stop Button”, automatically clicks the Stop Button, and then saves the transaction. In other words, a user can scan a start and stop transaction by scanning only three pieces of information: MO Number, Routing Sequence, and Employee ID.
MFG PowerPack is a Suite of modules for enhancing GP Manufacturing and its connections to Field Service, Inventory, Purchase and Sales. Within MFG PowerPack is a collection of Manufacturing Tweaks, which are smaller enhancements.
Manufacturing Tweaks:
Price $1200
Where Used Inquiry displays the position of any component in a graphical, multi-level, indented bill of materials.
The Where Used Inquiry shows each BOM which contains the given item. The BOMs are exploded to the level where the item occurs, and highlights the item with a red dot.
Vendor Pricing supports Item-Vendor Price Lists with Quantity Breaks. It maintains a Current Price List, as well as an unlimited number of Pending Price Lists based on Effective Dates. It also provides the ability to pull a default Unit Cost, when a Vendor Price List does not exist, from Actual Cost or Standard Cost rather than the Originating Invoice Cost.
A Custom Pricing method provides the ability to generate pricing based on business rules, or driven off a custom SQL table.
Vendor Pricing can be used with or without GP Manufacturing, and integrates with the following windows:
Vendor Pricing’s import utility allows you to create and manage price lists in Excel before bringing them into Dynamics GP.
Download the Vendor Pricing Import Template
SO-MO Delete automatically breaks an SO-MO Link when the sales line is deleted, and if possible, it also deletes the linked Manufacturing Order.
SmartParts is a “logical” ID Number generating tool to assist users in creating ID Numbers where each segment of the ID Number has coded meaning. For example, an Item Number might consist of several segments with each segment representing different attributes of the item. CU-RD-12 could be Copper, Round, 12″ pipe.
SmartParts allows creating an unlimited number of Masks, each having up to 30-segments, with a list of defined codes for each Segment. A Mask is the set of Segments and Codes used to create a particular type of ID Number (such as Metal Pipe). The user creates a new ID Number by selecting from the list of Codes for each Segment within the type of ID Mask they are using.
SmartParts creates ID Numbers for Item Numbers, Customer Numbers, Vendor Numbers, and WennSoft Job IDs. The SmartParts Lookup available in Sales and Purchase enables retrieval of complex part numbers by selecting coded segments from drop-down lists.
The Service Equipment Suite consists of:
Serial Number Mass Entry is a copy-paste utility for entering large amounts of serial numbers into GP from an external source. With Serial Number Mass Entry you can copy a list of serial numbers from an external source (Excel, text file, email), and paste them into any Serial Number entry window in Dynamics GP. Save time and reduce errors over manual entry. Serial Number Mass Entry works with:
The Pre-Assign Serial/Lot Numbers module in MFG PowerPack automatically pre-assigns serial/lot numbers when a manufacturing order is created.
The next serial or lot number can be generated using the Serial/Lot Mask, or custom numbering logic can be added. For example, the Serial or Lot Number could be based on the MO Number, the date, or virtually any other business rule.
This is especially useful when Sales Configurator is being used to create manufacturing orders, since the sales user normally does not have access to MO Entry. A manufacturing Planner must then remember to open each MO and create serial numbers. Automatic Pre-Assignment of serial numbers saves a time-consuming step, and prevents errors and delays in manufacturing due to incorrect or missing serial numbers.
Serial/Lot Auto-Generate enhances the Lot AND Serial numbering functionality in GP. Use the Serial/Lot Mask to auto-generate serial numbers and lot numbers on any GP transaction. Serial/Lot Mass Generate extends automated serial numbering AND lot numbering to the following transactions (where it would not otherwise be present):
Serial/Lot Mass Generate also provides support for global serial/lot numbering. Use a single Lot or Serial Mask to generate the serial or lot numbers for all serial or lot controlled inventory.
The Scrap Reporting module in MFG PowerPack tracks, reports on, and costs scrap. It integrates with GP Manufacturing Component Transactions to adjust the cost of scrap out of Manufacturing WIP and into dedicate Scrap GL accounts.
Removing the cost of scrap from WIP can improve manufacturing variance reporting that might inflate the per-piece variance if it is skewed by labor, machine and materials associated with scrap.
Sales Forecast Integration provides a two-way link between GP Manufacturing Sales Forecasting and Microsoft Excel. With SFI all forecasting can be done outside of GP in Excel, in multiple spreadsheets with multiple users, and the complete forecast imported back into GP. With SFI you can take advantage of “cloud” computing to make the forecast spreadsheet available to multiple users for simultaneous forecasting. When the forecasting project is complete, pull down the final copy from the cloud and use SFI to import the forecast.
QuickWIP provides simple WIP data recording when manufacturing is set up to use Backflushing. Even though you may be backflushing labor and machine time, you still might want to track progress on the MO–When did a sequence start? When did it finish? Is it done? QuickWIP provides this basic tracking functionality without the overhead of performing actual WIP Data Collection inside GP Manufacturing.
Price $1200 Demo Manual
Quick Disassembly uses the GP Manufacturing Bill of Materials, or the Picklist from a Manufacturing Order, to disassemble finished good items into component parts. This tool creates a simple disassembly transaction based on an Inventory Adjustment, and is ideal for manufacturers needing an easy method to take apart an item and put components back into inventory.
When disassembling using a BOM, and of the BOM Types can be used as a source of components.
When disassembling from an MO, the Quick Disassembly window will show only MOs that made the finished good, and if the finished good is serial or lot tracked, it will show only the MO (or MOs) that made the selected serial or lot numbers.
Reverse Issue Date Override changes the date on which inventory is re-added to the system when posting a Reverse Issue Transaction.
The normal behavior of GP is to put the inventory back on the Original Receipt Date, which can cause problems with inventory usage reports because it overstates the amount of inventory received on the Original Receipt Date, and overstates the amount of inventory consumed on the Issue Date.
To address this, Reverse Issue Date Override adds several other options for the “return to inventory date”, such as Reverse Issue Transaction Date, Issue Transaction Date, User Date and System Date.
Price $2400 Demo Manual
PO Revision Levels tracks a Revision Level for each PO Line, and automatically adds that information to the Purchase Order so it can be sent to your Vendor. The PO Rev Level is visible on all Purchase Order and Receiving windows and reports.
PO Revision Levels maintains a change history of Item Engineering Rev Level, and a history of Rev Levels assigned to each PO Line.
You can select a prior rev from Rev History when creating a PO it a part needs to be re-ordered at an earlier rev.
Since the Rev Level is attached to each PO Line, a reprinted Purchase Order will show the historically correct Rev Level, rather than the current Item Engineering Rev.
Price $900 Demo Manual
Proposed Cost Update automates setting a new Standard Cost for Buy Items. Proposed Cost Update provides several methods for calculating a new Standard Cost for a range of Items or Item Classes.
Update methods include setting the new Standard equal to the Current Cost, the Average/Mode/Minimum/Maximum of the Receipt Cost over a range of dates, and increasing/decreasing by a fixed percent.
The new cost can also be imported from an Excel spreadsheet.
Fixed Overhead and Variable Overhead can be updated/imported too.
PowerATP adds numerous enhancements to the Dynamics GP Inventory Available to Promise window which take it to a whole new level. The PowerATP window…
Outsourced Purchase Order Enhancements (OPOE) modify the Outsourced Purchase Order so that the Description, Quantity Ordered and Cost provide more meaningful information to the Vendor, rather than reflecting “internal” information from the manufacturing routing.
OPOE adds an Outsourcing Description to the Manufacturing Routing, as shown below. The Outsourcing Description is used to record a description of the service that will be meaningful to your vendor. Rather than the PO showing your internal Routing Sequence Description (i.e. “Paint Chair”), it might say “Ultra Hard Enamel, Fabrikam Color #227”.
OPOE changes the Quantity and Cost to be per-unit shipped to the Vendor, rather than reflecting the hours and labor cost of the routing sequence. As shown below, an MO has an outsourced routing sequence for a Painting Service provided by an external supplier. Manufacturing is set up to use Machine Variable Overhead as the Outsourcing Cost Bucket, and the PAINT Machine assigned to this routing sequence has an Overhead cost of $15.30 per hour. Painting takes two hours.
GP Manufacturing’s suggested Outsource PO is for Item SERVMO0026-200 (a combination of “SERV”, plus the MO Number and the Routing Sequence), for a quantity of 2. The Extended Cost is therefore $30.60.
OPOE changes the PO so that Quantity to Order is 1 (because 1 CHAIR is being sent for painting), at a total cost of $30.60, and the Item Description is changed to the Outsourcing Description.
OSRC (Outsourced PO) Add To PO enables adding lines for outsourced services to an existing Regular PO. Often a single vendor is used for many processes across multiple Manufacturing Orders, and GP will create separate POs to the vendor. The Add To PO feature enables consolidation of purchasing so that then vendor receives one PO.
OSRC Add To PO can also add a new Release Line to a Blanket PO.
MO Split breaks a Manufacturing Order for a large quantity into any number of MOs of smaller quantity.
MO Document Types provides the ability to have unlimited Manufacturing Order document numbering sequences maintained by Dynamics GP.
Lead Time Inquiry calculates the minimum time needed to produce a specified quantity of a made item considering manufacturing and vendor lead times and inventory shortages. It calculates a “mini-MRP” on the entire exploded Bill of Materials to arrive at an accurate assessment of how long it will take to make the top-level finished good given the time required to make sub-assemblies and purchase raw materials.
The lead time calculation can be performed either including, or ignoring, available inventory. If you include available inventory, LTI tracks the total requirement of each item as it works its way up from the lowest level of the BOM to the top, and subtracts that from Available Inventory for each part.
For example, if a screw is needed at multiple levels in the BOM, LTI subtracts from the Available Inventory the required quantity needed at the lowest level. If there is a shortage at that point, it calculates how long it will take to order the screw.
However, if there is enough inventory, it moves up to the next level. Perhaps the screw is also needed at this level, and since we already used some screws at the lower level, there would now be a shortage. Purchasing the screw for use at this level may, or may not, affect the overall lead time. If it takes 10-days to make the lower level sub-assembly, but only 3 days to receive a Purchase Order for screws, the shortage does not affect the lead time for the top-level item.
At any level, the lead time to make a sub-assembly is the time required to make the item, plus the longest lead time for its components. As shown above, the lead time to make BA100G is 4.656 days. The total lead time is:
3.376 days to make CBA100
1.25 days of Manufacturing Variable Lead Time (BA100G)
0.03 days of Manufacturing Fixed Lead Time (BA100G)
Other components, such as FTRUB have zeros days lead time because there is not a shortage of those items (or no Lead Time is specified).
Lead Time can also be calculated without considering available inventory, which results in a calculation of the maximum finished good lead time that would be needed to order all raw materials and build all sub-assemblies.
Item Valuation Update sets the Valuation Method of non-Sales Inventory type items so they can be used on the GP Bill of Materials for a Standard Cost item.
For example, some items may be have so little value that you do not want to track inventory, but they do need to be recorded on the BOM. As shown above, and item for WASHERS is set up as the “Services” type item so that GP does not track inventory quantities of Washers, but using the Item Type of Services causes the window to blank-out the Valuation Method. All three non-inventory Item Types (Misc Charges, Services and Flat Fees) all behave the same way.
When you attempt to add WASHER to the BOM for 100XLG (a Standard Cost item), GP presents the warning message shown above. It will only allow Standard Cost components on the BOM of a Standard Cost parent.
Item Valuation Update is used to set the Valuation Method of WASHERS to FIFO Periodic (Standard Cost), which allows the WASHERS item to now be added to the BOM.
WilloWare’s Item Copy provides for quick setup of new inventory items by copying all of the setup from an existing item to a new item. Our Item Copy includes Manufacturing and Field Service tables, which are not copied by the regular Dynamics GP Copy utility, and it can also copy Notes (creating a new copy of the Note attached to the new master record).
The Item Copy utility in GP covers 16 tables, while the WilloWare Item Copy covers more than twice that.
Among the records copied by the WilloWare Item Copy are:
Item Copy can also mass create, and mass update, items via an Excel spreadsheet or a SQL staging table.
Item Class Serial/Lot Mask supports defining a single serial or lot number mask which applies to all serial or lot numbers generated for the items with an Item Class. Each serial number generated will be unique for the entire class of items. One item in the Item Class is selected as the Master Item. Its Serial/Lot Number Mask is used as the Mask for all Serial/Lot Numbered Items in the Class. An Item Class can have either Class-level serial numbering, or lot numbering, but not both.
Configured BOM Auto-Naming automatically generates a BOM Name in Sales Configurator based on the SOP Number and SOP Line Number (such as STDORD2234-02, where 02 is the second line on the order). This tool provides an automated naming convention for Configured BOMs that ties the BOM and the MO back to the sales line.
Require Included Configuration Options (part of MFG PowerPack) prevents unmarking configuration options in Sales Configurator that have been set as “Included” options. Normally Configurator will “include” items marked as Included in the default configured BOM, however the user can easily unmark these items and remove them from the configuration. By making these items “Required”, they are both included in the Configuration and cannot be removed from the Configuration.
Options Category Maintenance is used to specify the relationship between the various Cofiguration Otptions. As shown above, the 40XIDE CDROM option “includes” the 2GPROC option.
When the Manufacturing Configurator is launched from Sales Transaction Entry, the 40XIDE CDROM option is selected.
Since 40XIDE “includes” the 2GPROC option, that Computer Processor is selected automatically.
Require Included Configuration Options prevents changing the Processor option. As shown above, if you attempt to select 1GPROC, you receive a warning explaining why it cannot be selected, and the original Processor selection remains marked.
Commodity Surcharge tracks the spot price of commodities, and adds surcharges during invoicing to cover the difference in the spot price between the date on which a price was quoted and the date of invoicing.
Create an unlimited number of Commodity records, and track the spot price of each commodity. A predefined Threshold determines the price variance which triggers the module to add a surcharge, so that minor variations in price do not result in adding a surcharge for an insignificant dollar amount.
An Item in GP is assigned one or more commodity codes, and the amount of the commodity contained in the item. A single item can contain an unlimited number of commodities, such as copper and gold in a wiring harness.
During transfer of a sales document to an invoice the Commodity Surcharge module examines each document for items containing commodities. If the difference in spot price between the quote date and the invoice date for the commodities in the item result in a price difference which exceeds the predefined threshold, the Commodity Surcharge module will add a surcharge to the document.
Capable To Promise Inquiry calculates the maximum quantity of an item that could be made immediately given available inventory, and ranks the component items based on inventory availability to give the user a quick overview of which components are build-limiting factors. CTP can use the Manufacturing Bill of Materials, Inventory Assembly Bill of Materials, or Inventory Kit Components.
BOM Type Security provides control over access to Bills of Material at the User ID – BOM Type level. Restrict access to Engineering BOMs to engineering users, and Manufacturing BOMs to production users. If a user attempts to access a restricted BOM in Bill of Materials Entry, they will be switched automatically into the Bill of Materials View window, where they can VIEW any BOM Type. The control is also applied to the Manufacturing BOM Copy window, and our own BOM Archive window.
BOM Archive creates a snapshot of the entire, exploded, Bill of Materials structure (the top level of the BOM, and also the Bills of allsubassemblies), and stores it as a series of named Archived BOMs. The archival process can also capture a similar snapshot of all associated Routings (the parent routing, and all subassembly routings).
The image above shows 100XLG archived by BOM Archive. It creates an ARCH BOM named 100XLG160722 for 100XLG, and each of its subassemblies. The result is a complete copy of the entire exploded BOM at the moment the snapshot is taken. Since it is an active, ARCH BOM, it can still be used on an MO to create an assembly at a specific revision level.
This contrasts to the BOM Copy or BOM Revisioning in GP Manufacturing which capture only the top-level components.
The BOM Revision functionality in GP Manufacturing captures only the top-level BOM. As shown above, both Rev 1 and Rev 2 for 100XLG still link to the current MFG BOM for BA100G, so any changes in BA100G are incorrectly shown in this historical Rev 1 BOM.
BOM Archive can auto-generate an Archive Name using several different naming methods (such as YYYYMMDD), or you can manually enter one.
Batch Processing adds the ability to record routing steps based on batch size or processing capacity of a machine. A process which can handle a certain quantity, such as an oven being able to handle 200 bricks per cycle, can now be recorded and correctly scheduled in GP.
Without Batch Processing, routings must be set up based on a “full cycle”. For example, if the oven can handle 200 bricks, and a brick needs to be dried for 10 hours, this would be recorded as 0.05 hours of machine time. When exactly 200 bricks are made, this results in the correct machine time calculation of 10 hours. However, if the batch size is not always the same, this calculation does not result in the correct machine time—for 1 brick or 200 bricks you still need 10 hours.
Batch Processing supports recording batch time/capacity for both labor and machine. Since GP Manufacturing ‘thinks’ in terms of per-piece labor and machine time, when an MO is scheduled the Batch Processing enhancement recalculates the per-piece time based on the quantity being made and the capacity per cycle for the labor and machine. So if the Batch Time is 10 hrs in the Kiln for each batch of 200 bricks, and you make 500 bricks, that is a total of three batches (one is partial) for 30 hrs of Kiln time. That works out to a per-piece time of 0.06 so that 500 x 0.06 causes GP to schedule 30 hrs in the Kiln.
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.