Item Stock Inquiry

Summary of Requirement

ACME Co. is a Contract Research Organization (CRO) who utilizes Dynamics GP as its ERP system. ACME’s Supply Chain group frequently utilizes the Item Stock Inquiry window. The Item Stock Inquiry window defaults the quantities displayed to the Item Number’s Base UOM. Users must switch the display to the Primary Vendor’s Purchased UOM each time they view an Item Number.  ACME would like the Item Stock Inquiry window to display quantities in the following manner:

  • If an Item Number AND Site ID are entered, set the “Display Unit of Measure” to the Item’s Primary Vendor’s Default Purchased UOM.
  • If a Primary Vendor does not exist for the Item Number/Site combination, then set the “Display Unit of Measure” to the Item Number’s Default Purchased UOM.
  • If an Item Number is entered only, then set the “Display Unit of Measure” to the Item Number’s Default Purchased UOM.

 

Design Specification

View design specification: DS0680

Select Checks Automation

DS0683

Select Checks Automation

Problem Definition

ACME Co. is a Connecticut-based ticket software company which connects thousands of live entertainment fans to the vast network of independent sellers that list tickets for sale on the TicketNetwork Online Exchange.

ACME Co. utilizes Dynamics GP as their ERP system. While Vendor’s Invoices are held within GP, it is their POS system which details which Vendor Invoices should be paid on a weekly basis. The POS system provides a list of brokers (Vendors) and documents to be selected for payment. The ACME Co. A/P group must manually select each document in the Select Checks window. This manual process takes hours to complete each week.

ACME Co. requires a solution where they can import a .csv file obtained from their POS system directly into GP to auto-create the weekly check batch. The .csv file will contain the following columns:

  1. Vendor ID
  2. Document Number
  3. Amount

Design Features

Select Checks Filter Setup

Using the standard functionality within the GP PowerPack Select Checks Filter module from WilloWare, the user will create a Filter ID entitled IMPORT. The filter must match the example below which has been setup to include all Payables Documents where the Due Date is less than 12/31/9999.

PLEASE NOTE: The IMPORT Filter ID will be utilized in the Select Checks Filter Import Process. Setting up or updating the IMPORT Filter ID so that it does not exactly match the above screen shot will impact the enhancement’s ability to import documents.

Select Checks Filter Integration

The user will enter the Select Checks Filter window.

The user will then navigate to AdditionalSelect Checks Import to open the Select Checks Import window. The Select Checks Import window is used to select a Source File to import:

C:\Users\Karen\Documents\Clients\ALTICO\Ticket Network\Select Checks Import.jpg

Field Function
Import Button The user will click on the IMPORT button to initiate the import process. A Source File must be selected prior to clicking the IMPORT button.

Please see below for details on the Source File and Import Process.

Clear Button The user may click on the CLEAR button to clear the window.
Source File The user will select a file to load into Dynamics GP. Please see below for details on the Source File.
Status message During the import process, a status message will display. The status message will read DONE when the import process has completed.

Source File

The Source file will always have the same format and will be a .csv file. The first row will contain headers. Documents to be included in the Select Checks Filters batch will begin in row 2.

  • Column A will contain the Vendor ID. ACME Co.’s Vendor IDs are 5 digits in length. Column A will contain 1, 2, 3, 4, or 5 digits. Records with 1 digit should have 4 zeroes added as a prefix; Records with 2 digits should have 3 zeroes added as a prefix; Records with 3 digits should have 2 zeroes added as a prefix; Records with 4 digits should have 1 zero added as a prefix. Records which are 5 digits in length should not be altered.
  • Column B will contain the Document Number to be included in the check batch. This is the GP Document Number, not the GP Voucher Number.
  • Column C will contain the Amount to be paid. The Source file will only contain Payment Documents (Invoices, Finance Charges and Misc Charge documents). No Credits or Return documents will be in the Source file.

Import Process

When the IMPORT button is clicked, the enhancement will do the following:

  1. Get the first record in the Source File:
  • Update the Vendor ID to 5 digits (as described in the section entitled Source File),
  • Validate that the Vendor ID/Document Number combination exists as an open Payables document which is a Payment Document Type (such as Invoices, Finance Charges and Misc Charge documents) with a current transaction amount not equal to 0. If this is not true, the enhancement will move to the next record in the Source File.
  • Validate the Document’s current transaction amount is equal to the amount provided in Column C. If the amount does NOT equal, the Document will still be selected to be included in the check batch, however, the Document number will appear on the Error Report.
  1. Import all validated records into the Select Checks Filters window. All Documents will be marked. The Filter ID of “IMPORT” will be used during the Import Process.

  1. Print an Error Report if any records in the Source File could NOT be imported. The Error Report will contain the following the fields:
  • Vendor ID
  • Document Number
  • Error Message

The Error Message which prints will be one of the following:

  • Vendor ID/Document ID does not exist
  • Document Amount does not match file

The user will then utilize the Select Checks Filters standard functionality to complete the Check Batch process. The user may de-select Document numbers and/or add additional Vouchers to the selection. When ready, the user will select the APPLY button which will return them to the Select Payables Checks window:

The user will then select the BUILD BATCH button on the Select Payables Checks window to build the Check Batch. Only those documents marked in the Select Checks Filters window will be added to the batch.

PLEASE NOTE: A Document may appear marked in the Select Checks Filters window after the import has completed. Until Documents have been added to the Check Batch by clicking on the BUILD BATCH button on the Select Payables Checks window, another user may create a Check Batch or create a Manual Check for the Document. It is recommended that ACME Co. implement internal process controls to ensure that other users are NOT creating Check Batches or Manual Payments as the enhancement will NOT prevent users from doing so.

Microsoft President’s Club 2016

Microsoft President’s Club 2016

Congratulations to our 2016 President’s Club Members

Microsoft recognizes WilloWare for outstanding performance.

WilloWare has been named to the 2016 President’s Club for Microsoft Dynamics. This achievement is a direct result of WilloWare’s outstanding dedication to customer satisfaction through the delivery of innovative business solutions.  WilloWare specializes in productivity enhancements for Microsoft Dynamics GP, focusing on Manufacturing, Field Service, and Distribution.

President’s Club honors high-performing partners for their commitment to customers, which is reflected in their business success and growth. This prestigious group represents the top 5 percent of Microsoft Dynamics partners worldwide. Membership is granted based on their continual, committed efforts aimed at offering solutions that meet the needs of their customers.

This recognition of President’s Club for Microsoft Dynamics came during Microsoft Worldwide Partner Conference (WPC) 2016, the annual premier partner event, which took place July 10-14 in Toronto, Ontario. WPC provides the Microsoft partner community with the opportunity to learn about the company’s road map for the upcoming year, establish connections, share best practices, experience the latest product innovations and learn new skills.

 

Newsletter June 2016

WilloWare_logo

If you would like to receive immediate updates regarding product releases, please follow us on Facebook , LinkedIn, or Twitter.

 

leaf_iconProduct Highlights

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:
BOMAltBOM
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.
BOMAltPL
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.

BOMAltMRP
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.

leaf_iconProduct Updates

Blanket PO

  • No changes

BOM Import

  • Added checks to confirm Excel is installed and that the import file is not read only
  • Fixed Create BOM Lines routine which was incorrectly setting the QTYBSUOM to 1 rather than the conversion to base when the component quantity was specified in a U of M other than the base.

Consulting Toolkit

  • No changes

Engineer to Order

  • Minor bug fixes regarding window redisplay issues
  • Fixed issue with Overhead Costing calculation.  In the process we discovered that GP Manufacturing does not calculate Overhead correctly, so ETO defaults to use the Manufacturing logic so that the ETO costing matches what Manufacturing will calculate, but ETO also includes an option to use the “correct” calculation so that the two can be compared.  Please see the updated ETO documentation for a full explanation.

EZImport

  • No changes

GP PowerPack

  • Login Monitor: with GP2015 and later, if a user has access to only one company, the login process bypasses the Select Company window, which bypassed Login Monitor’s “During Login” check on the maximum user count.  The During Login check was rewritten to account for this.
  • Extended Lot Attributes: fixed error caused by closing a transaction window before saving the Lot Attributes.
  • Next Number Generator: fixed issue that prevented using a numbering scheme if it did not have an alpha-prefix.

Item Process Tracking

  • No changes

LabelLink

  • No changes

LeanMFG

  • No changes

MFG Data Archive

  • No changes

MFG PowerPack

  • NEW: BOM Alternates enhancements
  • NEW: BOM Archive- added additional naming conventions
  • Sales Forecast Integration: added cheks to the Export to Excel process to verify that Excel is installed and that it is able to create a new Workbook.
  • Setup: added check to Setup window to ensure the installation has been run to prevent errors when a user opens the window via a shortcut.
  • PowerATP: fixed error caused by changing the Option Set properties while focus is on a line in the ATP window.

MOGenerator

  • Added check that Excel is installed (for the Excel import methods)
  • Added deadlock handling to the Allocate All routine
  • Core Utilities: fixed issue in the “Create MO” utilities where if the import data for the first MO to be created has an error, it caused the remaining items to also fail to generate MOs but produce no error messages.
  • MO Receipt Integration: added check that MO Receipt Quantity is not zero
  • MO Receipt Integration: fixed issue that caused the MO Receipt to post without consuming components when (1) it is a complete receipt against an existing MO, (2) it is marked as the final receipt, and (3) the picklist is being imported.

Preactor Integration

  • No changes

SpellCheck

  • No changes

MFG PowerPack BOM Alternates

Price $2400 Demo Manual

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.

Click to Enlarge

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:

Click to Enlarge
Click to Enlarge

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.

Click to Enlarge
Click to Enlarge

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.

Click to Enlarge
Click to Enlarge

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.

MFG PowerPack Time Card

Price $2400 Demo Manual

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.

TimeCard

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 Tweaks

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

  • Auto-Create Routing Header: after entering the Item Number in the Routing Sequence Entry window, the system will auto-create a Primary Routing Header if one does not exist.
  • BOM Entry GoTo Standard Cost Changes: adds an option to the GoTo Menu on BOM Entry to access the Standard Cost Changes window.
  • Default Primary Routing: after entering the Item Number in the Routing Sequence Entry window the Primary Routing will display automatically.
  • Edit MO Status Allocation Override: Automatically override shortages (if system setup allows for this), when Releasing Manufacturing Orders.
  • Edit MO Status Options: When working with MO Planned Orders in the Edit MO Status window, this Tweak adds the ability to (1) Select which Scheduling Preference to use when Creating MOs, and (2) Override the default MO Description (which normally is set to the MRP-MO Number) with a user entered value.
  • Equipment Zooms: If Field Service is installed, Additional Menus are added to several Serial Number Inquiry windows to provide quick access to the Field Service Equipment Record.
  • Force Reschedule: The Manufacturing Order Entry window only allows Scheduling/Rescheduling an MO if the MO Status is Quote or Open.  When an MO is Released (Hold or Partially Received) it will not allow Rescheduling unless the Status is changed back to Open, and that cannot be done if there is activity on the MO such as a Component Issue.  This Tweak overrides those controls and allows Rescheduling an MO in Released, Hold or Partially Received Status.
  • Indented BOM Report:  creates an exploded Bill of Materials report from the BOM Maintenance window, showing each subassembly indented below its parent.
Click to Enlarge
Click to Enlarge
  • Item LLC Recalc: adds the ability to perform a single item LLC recalculation from Item Engineering, and also automatically recalculates the Item used in a BOM Mass Update.
  • Item Maintenance GoTo BOM: adds a GoTo menu option on Item Maintenance to open the Manufacturing Bill of Materials.
  • MO Date Default: Automatically populates the Start Date (or End Date) on the MO Entry window based on per-item settings so that it does not always default to 00/00/0000.
  • MFG Note Fix: The Manufacturing module has two procedures for getting the “next note index” when you add notes in different locations.  Depending on which window you are on this will create a duplicate note index.  The MFG Note Fix ensures that the MFG module always uses the correct method to get the next note index and therefore prevents creating duplicate notes.
  • MO Receipt Outsourcing Warning: when creating an MO Receipt, it checks for Outsourcing Purchase Orders that have not been received, and warns the user if one exists.
  • MO-SO Receipt Warning: This tweak is intended to address an issue with the Manufacturing Order Receipt Entry window where is does not consider MOP-SOP Links and will post a receipt when the SOP Document is in use.
  • MRP Query Default: Create an MRP Quantities Query to store values such as the MRP Quantity (i.e. ATP Total), a Site restriction and a Planner ID, and have that Query pull-up automatically when the MRP Quantities Query window opens.
  • PO Gen Integration: PO Generator suggests purchase orders based on quantities in the Item Quantities Master table.  However, there are modules, such as GP Manufacturing and Field Service, that create transactions which do not update the Item Quantities until after the transaction posts (for example, unallocated Manufacturing Picklists or unreceived Inter-Site Transfers).  PO Gen Integration can pull additional sources of inventory supply and demand into the PO Gen calculation to arrive at more accurate purchasing suggestions.
  • PO Gen Remove MO: PO Generator does not consider quantities being made on Manufacturing Orders when it creates PO suggestions.  This tweak provides an integration between PO Generator and Manufacturing so that the Quantities on MO are visible in PO Generator, and also can be automatically subtracted from suggested PO quantities.
  • Post Data Collection Journal Entries: Data Collection, Automated Data Collection, and data collection integrated into the ADC_Input_Records (SF010500) table all create Journal Entries that need to be manually posted through the GL Batch or Financials Series Post windows.  This Tweak will automatically post those Journal Entries.  Posting Journal printing is suppressed so the posting can happen in the background without user interaction.  This is particularly important when using the ADC Processor.
  • Posting Journal Settings: adds setup options to control whether or not the posting journals print when posting an Manufacturing Component Transaction (Issue/Reverse Issue), a Manufacturing Order Receipt, or Manufacturing Order Close.
  • Purchase Request Resolution GoTo MRP Workbench: Adds an item to the GoTo button on Purchase Request Resolution that opens the MRP Workbench window.  The Item Number and Site ID selected in the Purchase Request window will be display in the MRP Workbench window.
  • Prevent MO Delete: ensure a contiguous sequence of MO Numbers by preventing users from deleting MOs.
  • Remember MO: remembers the last used MO Number on MO Entry so you can use the GoTo to access multiple windows without having to re-enter the MO Number.
  • SOP Copy Create MOP-SOP Links: The GP SOP Copy utility does not create default MOP-SOP Records (IS01001) which prevents the copied transactions from being visible to MRP.  This tweak creates the default MOP-SOP Records when SOP Copy adds lines to a document.
  • SOP Transfer – Keep Date: normally when a sales document is transferred, GP resets the In-House Due Date and Customer Promise Date to be the same as the Requested Ship Date.  This Tweak ensures the dates retain their original values during document transfer.
  • SVC RMA Rolldown Site: adds an option, when changing the Site ID on the RMA Header, to roll-down the new Site to all of the lines on the RMA.
  • Turn Off Job Cost Menus: The Job Costing module in GP Manufacturing adds right-click menus to many windows in GP which replace the normal right-click menus that provide access to Insert Row, Delete Row, Cut, Copy, Paste, etc. This Tweak turns off the Job Cost Right-Click Menus so that GP can display the normal menus.
  • Unlink MO from SOP: The normal process required to unlink an MO from a Sales Line requires several steps and must be performed one MO at a time.  This tweak adds an Additional Menu to Sales Transaction Entry that allows quickly unlinking one MO from a line, or all MOs from the document.
  • Use MO Number for IV Doc Number: causes Manufacturing to create Inventory Transactions using the MO Number for the IV Document Number.  For example, the first Receipt of MO1234 will create Inventory Adjustment MO1234*1.
  • Use SOP Number for MO Number: causes Manufacturing to create Manufacturing Orders from Sales Transaction Entry using the SOP Number for the MO Number.  For example, the first line item on ORDST2237 would result in MO Number ORDST2237#0001.

MFG PowerPack Vendor Pricing

Price $1800 Demo Manual

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:

  • MRP-Planned Orders
  • Purchase Request Resolution
  • PO Generator
  • Manufacturing Outsourced POs (MOP-POP Link)
  • Purchase Order Entry
  • PowerATP Create PO function
  • SOP Purchase Order Preview
VendorPricing2
Click to enlarge

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

 

MFG PowerPack SmartParts

Price $2400 Manual

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.

MFG PowerPack Service Equipment Suite

Price $2400 Manual

The Service Equipment Suite consists of:

  • Automated Configuration Builder – when an Equipment Record is created from Sales Transaction Entry, the Configuration Builder will automatically create a Configuration record using the SOP Number, add the Equipment Record to the Configuration, then search for all linked serial numbers in the MOP Serial-Lot linking and create Equipment Records for those linked serials.  These new Equipment Records are also added to the Service Configuration.
  • Customer Class Extensions – provides the ability to specify warranty codes at the Customer Class level which override the default warranty codes specified in Service Setup.
  • Equipment Customer Changer – swap the Customer assigned to an Equipment Record, and automatically roll that change through all levels in the Configuration.

MFG PowerPack Serial Number Mass Entry

Price $600 Manual

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:

    • Item Transaction Entry
    • Item Transfer Entry
    • Item Bin To Bin Transfer Entry
    • Inventory Assembly Entry
    • SOP Non-Inventory Serial/Lot Entry (GP PowerPack)
    • Purchasing Order Receipt
    • Purchasing Returns
    • Sales Transaction Entry
    • Manufacturing Order Entry
    • Manufacturing Component Transaction Entry
    • Manufacturing Receipt Entry
    • Service Intransit-Transfer Entry
    • Service RMA Entry
    • Service Internal RMA Entry
    • Service RTV Entry
    • Service Depot Entry
    • WilloWare’s LeanMFG Module

MFG PowerPack Pre-Assign Serial & Lot Numbers

Price $600 Manual

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.

MFG PowerPack Serial/Lot Auto-Generate

Price $1800 Demo Manual

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):

  • Inventory Transactions
  • Inventory Assembly Transactions
  • PO Receipts
  • Sales Transactions
  • MO Entry (for pre-entry of serial & lot numbers)
  • MO Receipts
  • Quick MOs
  • LeanMFG from WilloWare

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.

Click to Enlarge
Click to Enlarge

MFG PowerPack Scrap Reporting

Price $1800 Manual

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.

Scrap

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.

MFG PowerPack Sales Forecast Integration

Price $1800 Demo Manual

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.

Click to Enlarge

MFG PowerPack QuickWIP

Price $1800 Manual

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.

Click to Enlarge

MFG PowerPack Quick Disassembly

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.

 

MFG PowerPack Reverse Issue Date Override

Price $1200 Demo Manual

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.

MFG PowerPack PO Revision Levels

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.

Click to Enlarge
Click to Enlarge

Click to Enlarge
Click to Enlarge

MFG PowerPack Proposed Cost Update

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.

Click to Enlarge
Click to Enlarge

MFG PowerPack PowerATP

Price $2400 Demo Manual

PowerATP adds numerous enhancements to the Dynamics GP Inventory Available to Promise window which take it to a whole new level.  The PowerATP window…

  • Includes MRP Planned MOs and POs
  • Includes In Transit Transfers
  • Includes Service Call and Depot Work Order requirements
  • Includes Manufacturing Sales Forecasts
  • Color codes the ATP calculation to make it easy to spot shortages
  • Performs virtual changes to dates to see impact of rescheduling an MO or PO
  • Performs virtual changes to quantities to see impact of bumping up or down an MO or PO
  • Includes multiple sites at one time in the ATP calculation
  • Creates Manufacturing Orders and Purchase Orders directly from the ATP window
  • Includes Lot Number expiration in the ATP calculation

MFG PowerPack Outsourced PO Enhancements

Price $1800 Manual

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”.

OSRC1

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.

OSRC2

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.

OSRC3

MFG PowerPack Outsourced PO-Add to Existing PO

Price $1800 Manual

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.

Click to Enlarge

MFG PowerPack MO Split

Price $2400 Manual

MO Split breaks a Manufacturing Order for a large quantity into any number of MOs of smaller quantity.

  • MO Split divides one large order into smaller orders that fit better with work center capacity.
  • The split MOs are still linked to the Sales Order.
  • A new SOP-MOP Inquiry window shows a complete Sales Transaction with all of its linked manufacturing orders.

Click to Enlarge

Click to Enlarge

 

MFG PowerPack MO Document Types

Price $600 Manual

MO Document Types provides the ability to have unlimited Manufacturing Order document numbering sequences maintained by Dynamics GP.

    • MO Document Types enables creating a Document Type (such as “PROTO” for prototype manufacturing orders) and a Document Number (such as “PROT0001”).
    • MO Document Types makes it easy to group particular types of orders together.
    • The “Remember My Doc Type” feature enables default MO Numbering sequences per User.
    • Select MO Numbers from Manufacturing Order Entry, Quick MOs, MRP-Planned Orders, and Edit MO Status.
Click to Enlarge

 

MFG PowerPack Lead Time Inquiry

Price $1200 Manual

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.

Click to Enlarge
Click to Enlarge

 

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.

Click to Enlarge
Click to Enlarge

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.

MFG PowerPack Item Valuation Update

Price $600 Manual

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.

Click to enlarge

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.

ItemValUpdate2

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.

ItemValUpdate3ItemValUpdate4

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.

ItemValUpdate5

MFG PowerPack Item Copy

Price $2400 Demo Manual

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 Maintenance (Item Vendors, Item Sites, Price List, Extended Pricing, etc)
  • Assembly BOM & Kits
  • Item Alternates & Manufacturers Item Numbers
  • Manufacturing Bill of Materials (Mfg BOM, Eng BOM, Arch BOM, Config BOM, and Super BOM)
  • Routings
  • Sales Configurator setup
  • Quality Assurance setup
  • Standard Cost Information
  • Field Service Item Extension

Item Copy can also mass create, and mass update, items via an Excel spreadsheet or a SQL staging table.

 

MFG PowerPack Item Class Serial/Lot Mask

Price $1800 Manual

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.

MFG PowerPack Require Included Configuration Options

Price $600 Manual

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.

RICO_1

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.

RICO_2

When the Manufacturing Configurator is launched from Sales Transaction Entry, the 40XIDE CDROM option is selected.

RICO_3

Since 40XIDE “includes” the 2GPROC option, that Computer Processor is selected automatically.

RICO_4

 

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.

 

MFG PowerPack Commodity Surcharge

Price $1800 Manual

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.

Click to Enlarge

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.

Click to Enlarge

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.

 

MFG PowerPack Capable to Promise Inquiry

Price $1200 Manual

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.

Click to Enlarge
Click to Enlarge

MFG PowerPack BOM Type Security

Price $1200 Manual

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.

Click to Enlarge

MFG PowerPack BOM Archive

Price $3000 Demo Manual

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).

BOMArchive1
Click to Enlarge

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.

BOMArchive2
Click to Enlarge

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.

 

Click to Enlarge

BOM Archive can auto-generate an Archive Name using several different naming methods (such as YYYYMMDD), or you can manually enter one.

MFG PowerPack Batch Processing

Price $2400 Manual

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.

Click to Enlarge
Click to Enlarge

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.