MFG PowerPack 2021-02-26

Release Date: 7-APR-2021
GP Versions: 12/14/16/18
MFG PowerPack Build: 7.170
* Vendor Pricing: (1) The GP POP module uses the “last unit cost” of an item, and multiplies UP to arrive at the UofM Cost (i.e. calculating a CASE cost based on the EACH cost). Since Vendor Pricing supports pricing at different UofMs, this could result in a loss of accuracy at 5-decimals when calculating DOWN from a UofM Price to the Base Unit Price needed by POP. This release addresses that situation by checking that POP arrives at the correct UofM Price and fixing it if necessary. (2) Zooms now pull through the UofM along with the Vendor and Item. (3) The Select Cost window now shows the cost in the Item’s Currency Decimals.

GP PowerPack 2021-03-30

Release Date: 30-MAR-2021
GP Versions: 12/14/16/18
GP PowerPack Build: 5.152
* BE-Bank Deposit Filters: The Save, Clear, Delete, Post and Print buttons are now locked while the Advanced Filters window is open. This addresses an issue where the deposit number can be cleared from all records in CM30200 if (1) filters are selected in the Advanced Filters window, (2) The Redisplay button is clicked, and then (3) the Delete button is clicked on the Deposit Entry window (#202100425). Further testing found that other combinations of actions involving the toolbar buttons while Advanced Filters was open could result in either clearing or overwriting the deposit number.

MOGenerator 2021-03-26

Release Date: 26-MAR-2021
GP Versions: 12/14/16/18
MOGenerator Build: 3.99

* MOGen status table: update frequency increased so that time/date stamp updates with each MO processed rather than each processing “loop”.
* Fixed issue with registration key that prevented MORI – Excel from appearing in the dropdown list
* Added check that fiscal periods are open before attempting to create/post MO Receipts

LeanMFG 2021-03-06

Release Date: 6-MAR-2021
GP Versions: 12/14/16/18
LeanMFG Build: 3.49
* MOEntry: Adjusted calculations performed when allocating costs to multiple outputs to improve accuracy when percentages extend to 5 decimals. The calculation change affects allocation by Quantity, Shipping Weight, and Fixed Percentage.

MFG PowerPack 2021-02-26

Release Date: 25-FEB-2021
GP Versions: 12/14/16/18
MFG PowerPack Build: 7.169
* Vendor Pricing: (1) Added option to use Future Price Lists. Disabled by default so normal functionality is not affected. When enabled, Vendor Pricing will pull pricing from a future price list based on the Release By Date. (2) Added User Defined Fields to Price List Maintenance. Each Price List can now have 8 string fields, 4 numeric fields and 4 date fields.
* FULL INSTALLATION PROCESS REQUIRED WITH THIS BUILD

LeanMFG 2021-02-22

Release Date: 22-FEB-2021
GP Versions: 12/14/16/18
LeanMFG Build: 3.48
* MOEntry: (1) changed behavior of Output QTY field for Lot Controlled items. Previously if a Lot Number had been entered for the Output QTY, and the QTY was subsequently changed, it would remove the Lot Number(s) and require re-entry. Now if there is only one Lot Number, it will keep the Lot Number and adjust the Lot Quantity automatically. (2) Fixed Output line ser/lot indicator so it does not disappear after changing the Output Qty.

MFG PowerPack SOP Backorder All

Price $1500

 

SOP Backorder All overrides the normal document allocation and fulfillment logic on Sales Orders so that regardless of any available inventory, the Quantity Ordered is set to Backordered.  This is particularly useful with GP Manufacturing when all finished goods are made to order as it prevents GP from allocating available inventory produced for another Order.  For the same reason, it can also be helpful when Orders are entered with a long lead time before shipment.

When enabled, all Sales Inventory items on all Sales Orders will have the Quantity Backordered set automatically to the Sales Line Quantity.  Setup options for the module provide the ability to restrict the Backorder All functionality by:

  • SOP Order ID
  • SOP Batch ID
  • Site ID
  • Item Class
  • Item Number
  • Customer Class
  • Customer Number

The CUSTOM option can be used to add your own business rules to control which items are backordered.  For example, you could have it only backorder items that have a GP Manufacturing Bill of Materials and are set to Make To Order on Item Engineering.

MFG PowerPack 2021-02-16

Release Date: 16-FEB-2021
GP Versions: 12/14/16/18
MFG PowerPack Build: 6.168
* NEW: SOP Backorder All- Automatically set the QTY on a Sales Order to Backordered regardless of available inventory. Control when this happens by Site, SOP Order ID, SOP Batch ID, Item, Item Class, Customer or Customer Class. You can also create your own custom logic to control Backorder All using whatever criteria are required.

CompleteCount 2021-02-13

Release Date: 13-FEB-2021
GP Versions: 12/14/16/18
CompleteCount Build: 1.49
* GP Stock Calendar year fix: Microsoft released a fix for the Stock Count Calendar window but it only covers GP2016 and GP2018. Our fix addresses the same issue for GP2013 and up. This release addresses another script on that window that has a hard-coded date that we did not address in the first release of this fix on 17-NOV-2020.

GP PowerPack 2021-02-11

Release Date: 11-FEB-2021
GP Versions: 12/14/16/18
GP PowerPack Build: 5.151
* INV Tweak-Stock Calendar Years: Microsoft released a fix for the Stock Count Calendar window but it only covers GP2016 and GP2018. Our Tweak addresses the same issue for GP2013 and up. This release addresses another script on that window that has a hard-coded date that we did not address in the first release of this Tweak on 5-JAN-2021.

MOGenerator 2021-01-29

Release Date: 29-JAN-2021
GP Versions: 12/14/16/18
MOGenerator Build: 3.98
* NEW – MOGenV2 – A new comprehensive MO integration utility that provides the ability to Create new MOs, Rebuild Picklists, Reschedule MOs, add MOP-SOP Links, as well as to update/change most of the fields on the MO and run the Rebuild the Picklist/Reschedule the MO routines to account for the changes. The utility can use either an Excel spreadsheet for input, or a SQL staging table. This new utility is covered under the Core Utilities License.
* FULL INSTALL REQUIRED

GP PowerPack 2021-01-15

Release Date: 14-JAN-2021
GP Versions: 12/14/16/18
GP PowerPack Build: 5.150
* Cash Receipt Report: (1) Created alternate versions of the reports that are formatted for emailing from the GP Print window. (2) Added support for printing the Cash Receipt report for posted receipts from the Cash Receipt Inquiry window. (3) This release uses new reports. If you were using modified versions of the previous release reports you will need to re-apply those changes using the new reports.
* FULL INSTALL REQUIRED: the new reports require updates to the GPPP Security Role and Task settings.

Learn more about the Cash Receipt Report.

MFG Import Release 2021-01-08

Release Date: 8-JAN-2021
GP Versions: 12/14/16/18
MFG Import Build: 2.48
* Routing Import: (1) fixed issue in Routing Header creation that could result in more than one routing being marked as Primary, (2) Added validation check and error reporting if import file has multiple routings marked Primary for the same item, (3) Added option to pad Routing Sequence to 2 characters, (4) Window now remembers the last used Routing Sequence Pad setting.

Extended Pricing SQL Locking

6-JAN-2021

A client site that uses our MO Receipt Integration (MORI) module recently reported a frequent occurrence of SQL deadlocking from a stored procedure called sopExtPricingPriceBookSetup.  Microsoft identified MORI as the source of the problem, however MORI does not use that stored procedure or have any interaction with Extended Pricing.

We found the source of the problem in the Dynamics GP Inventory module.  When ANY change is saved to an Item when Extended Pricing is enabled, the sopExtPricingPriceBookSetup stored procedure is called.  Posting an MO Receipt (with or without MORI) adds inventory to the system, which results in an update to the item’s Current Cost.  Saving that change to the Item Master causes the stored procedure to run…twice.

Viewing an item in Item Maintenance and clicking save (without making any changes) runs the stored procedure…twice.  Posting an Inventory Transaction or a PO Receipt also cause the stored procedure to run twice.  Any process in GP that makes a change to the Item Master will trigger the stored procedure to run, so it is running very frequently in any business that is inventory oriented.

The stored procedure appears to have been designed with the assumption that it would run only when creating a new item or making changes to an item’s UofM Schedule.  It deletes all information from IV00107 (Item Price List Options) and IV00108 (Item Price List) for an item where the Price Level ID is “EXTPRCLVL”, then repopulates the table.

For the SQL minded folks: in addition to locking the tables while it needlessly deletes and repopulates them, it uses two global (rather than locally scoped) SQL cursors, which means it will block itself if two calls are made to the stored procedure at nearly the same time.  On the other hand, since the stored procedure begins by deleting from IV00107 and IV00108 you would not want two calls to sopExtPricingPriceBookSetup to both have the ability to repopulate the tables simultaneously.

The issue was particularly noticeable with MORI because the module creates a large number of MO Receipts at a rate not possible if users were manually entering and posting transactions.  A site with a large number of users, or other automated integrations that touch inventory, could also be impacted by this Extended Pricing issue.

Fixing this is tricky.  The heart of the issue is in the GP source code in a “form” called IV_Item (specifically Commit() of form IV_Item).  It should not call sopExtPricingPriceBookSetup for ANY change to the Item Master.  It should only execute for changes to the UofM Schedule and a few other fields used by the stored procedure.  A second option that is less of a “fix” and more like a patch, would be to modify the stored procedure so it checks if repopulating IV00107 andIV00108 is necessary before it deletes everything.  This would technically resolve the issue but would also place an unnecessary load on the system.  Think about it this way–the stored procedure only needs to run when the UofM Schedule changes, which virtually never happens, yet it is running twice for every MO Receipt, Inventory Adjustment and PO Receipt.

There is a third option that was available to MORI.  Since MORI runs by itself on a dedicated GP client, our “fix” for this (which we released in a build yesterday) was to add switch on the MO Generator window to “Disable Extended Pricing”.  MORI now has a way to turn off Extended Pricing only on the GP client running MORI without affecting the rest of the system.

If you are using MORI and Extended Pricing, please download the latest build from www.willoware.com/downloads.

 

 

 

 

MOGenerator Release 2021-01-05

Release Date: 5-JAN-2021
GP Versions: 12/14/16/18
MOGenerator Build: 2.97
* Create MOs: added a new MOGen option called “Use OQM”. Order Quantity Modifiers. When this option is marked, MOs will be created using the OQM logic applied by MRP (i.e. an MO cannot exceed a certain quantity, so multiple smaller MOs will be created).
* Setup: added a new setup option to control whether the MO Gen Status window opens during the Create Child MOs process. The setup option defaults to true so that current behavior does not change (the window always opens). Unmark the option to suppress the window.
* MO Receipt Integration (MORI): a client site reported locking due to a stored procedure called sopExtPricingPriceBookSetup. If Extended Pricing is enabled, each MO Receipt makes updates to the Item Maintenance record (i.e. current cost), and each time a change is saved to the Item Maintenance record the Extended Price stored procedure is called. That stored procedure locks tables in the database which blocks other processes (such as other MORI instances, and other processes using Extended Pricing). This release includes a new option on the MOGen window (Disable Extended Pricing) that will temporarily disable Extended Pricing only on the GP client running MORI. Given that the stored procedure appears to be intended to run when creating a new item and/or changing the UofM Schedule, bypassing it only on the MORI processor should not have any effects on Extended Pricing. You may have observed this issue in a SQL Profiler trace as a large amount of activity on the SQL tables IV00107 and IV00108.  Disabling Extended Pricing affects ONLY the GP client running MORI, and it will be re-enabled automatically when the MOGen window is closed.  While Extended Pricing is disabled by MOGen, do not do anything else in the GP client (i.e. create a Sales Transaction).

GP PowerPack 2021-01-05

Release Date: 5-JAN-2021
GP Versions: 12/14/16/18
GP PowerPack Build: 4.148
* NEW TWEAK-Stock Calendar Years: The Stock Calendar Maintenance window “years” dropdown stops at 2020. This tweak adds years through 2094.

GP PowerPack 2020-12-23

Release Date: 23-DEC-2020
GP Versions: 12/14/16/18
GP PowerPack Build: 4.147
* Shortage Inquiry: addressed issue that caused a SQL error when processing shortages for transactions (like an Inventory Adjustment) with hundreds of lines on the transaction. The change will also improve speed when processing very large transactions.

MOGenerator Release 2020-12-15

Release Date: 15-DEC-2020
GP Versions: 12/14/16/18
MOGenerator Build: 2.96

  • MO Create: Create MO: Added error report when CreateMO is provided with MOP-SOP Link information but the SOP Line does not have a QTY Backordered (or QTY To Backorder).
  • NEW: MO Receipt Integration (MORI): Added Excel import option. MO Receipts can now be created from an excel spreadsheet.
  • MO Receipt Integration (MORI): Fixed issue that affected partial receipts, and processing records that had one or more of a five specific validation errors. In these cases the processor would not automatically move to the next receipt, but rather abort the current process and wait for the timer to restart the MORI processor at the top of the next minute. MORI now immediately moves to the next record and continues processing. If you periodically experience situations where the processor is waiting even though there are pending receipts, this update will eliminate that wait time.

GP Stock Count Ends in 2020

17-NOV-2020 / Updated 5-JAN-2021

The Dynamics GP Stock Calendar Maintenance window has a “year” dropdown list that contains years only up to 2020. If you are using the Dynamics GP cycling counting functionality you will not be able to extend your Stock Count Calendar beyond the end of 2020, which means you will not be able to schedule a count that takes into consideration company down days or perform cycle count assignment.

 

The most recent releases of CompleteCount and GP PowerPack contain a fix for this issue that will extend the Calendar to 2094.

 

Download the update for CompleteCount and GP PowerPack from www.willoware.com/downloads

 

Engineer to Order Release 2020-11-04

Release Date: 4-NOV-2020
GP Versions: 12/14/16/18
ETO Build: 2.37

  • Updates for GP18.3 compatibility
  • ME Copy: (1) fixed issue that caused “This is not a made Item” warning when the ME is linked to a SOP Line and the Quoted Item Number already exists in GP so it does not have a Source Item Number. (2) added check that the ME does not already have Components and/or a Routing. Having either will now prevent using Copy.
  • ME Accept: If the ME is linked to a SOP Line, the Accept process will automatically create an MO for the Item and link it to the SOP Line.
  • Sales Link: When an ME is created from Sales Transaction Entry, the Sales Line Quantity will automatically be added to the Estimation Quantities and marked as Accepted.

SpellCheck Release 2020-10-30

Release Date: 30-OCT-2020
GP Versions: 12/14/16/18
SpellCheck Build: 1.27

  • This release uses a new Microsoft Cognitive Services Spell Check API that replaces the previous Bing Spell Check API. Microsoft will discontinue the Bing API on October 30, 2023. If you are using the GP Web Client with our SpellCheck, or use the web-based spell checking with the desktop GP client, you must update WilloWare SpellCheck prior to October 30, 2023.
  • Updates for GP18.3 release

MFG PowerPack Release 2020-10-21

Release Date: 21-OCT-2020
GP Versions: 12/14/16/18
MFG PowerPack Build: 4.164

  • Capable To Promise (CTP): Added options to control whether Unmet Demand is subtracted from the Available Inventory calculation, and whether On Order is added to it. Both options affect both the calculations in the Finished Goods window, as well as the Components window and the Max Build calculation. The new checkboxes are saved per User ID so that when the window is opened again they are still marked/unmarked.