Author: admin

GPPowerPack 2025-10-28

Release Date: 28-OCT-2025
GP Versions: 12/14/16/18
GP PowerPack Build: 10.196
* UM Schedule Change: in build 8.176 (May 2024) we added a data integrity check on IV30300. There are cases where transactions can be added to this table and the UofM is later removed from the item’s UofM Schedule. This make converting the UofM on that item impossible. However, the check added in 8.176 was checking for ANY invalid data, which turned out to be too restrictive. The utility now only checks the specific item you are trying to change. If a problem exists it will be reported on the error log and the UM change will not be executed for the item.

GPPowerPack 2025-10-27

Release Date: 27-OCT-2025
GP Versions: 12/14/16/18
GP PowerPack Build: 10.195
* Auto-Select Lots: fixed issue that affected the IV Transaction and IV Transfer windows when multi-bins is disabled where it the Auto-Select Lots utility was not populating the QTY Selected field resulting in message from GP “The number of selected lots must be greater than zero.” (#202501226)

LeanMFG 2025-10-27

Release Date: 27-OCT-2025
GP Versions: 12/14/16/18
LeanMFG Build: 6.76
* NEW: Output Item Cost Variance Check. A new Numeric Option has been added to the Sytem and MO Doc Type Setups called “Allowable Output Cost Variance”. This is a percentage of an item’s Current Cost, and applies only to Actual Cost items. The MO must have only one Output Item Number. If Allowable Output Cost Variance is 8% and the total of Input Costs when applied to the Output is more/less than 8% of the item’s Current Cost it will prevent posting and add an error to the Error Log. This check can then be overriden using a new checkbox in the Production Information tab called “Override Output Cost Error”.
* NOTE: if you have modified the MO Entry window, export those modifications before installing the new build. You will need to re-do your modifications on the new version of the MO Entry window.

 

 

 

Customization DS1560- External Component Selection App

Customization DS1560

External Component Selection App

Problem Definition:

ACME needs a simple barcoded component picking solution that is outside of GP. The picking of the components does not need to update the MO in GP. Rather, it should save the data to a SQL table so that a user in GP can use that information to issue the MO.

The component being picked needs to pass the following verification:

  1. The component must be an item number on the picklist.
  2. If the component is a nutrient broth, the item number must exactly match the generic description of the parent.

Solution Overview:

The proposed solution will be delivered as an external application that can be added to the desktop of the warehouse workstations. This application will require the workstation to have an ODBC connection setup so it can make a connection to the SQL Database. A SQL User ID will need to be created to be used by this application to connect.

The type of barcode scanner this application is designed for is a keyboard wedge style.

Design Features:

Ingredient Scanner

The person doing the picking will have paperwork that includes barcodes for the MO Number and Components to pick. When picking an MO, the user will use the ingredient Scanner window.

A screenshot of a computer screen Description automatically generated

Field Function
MO Number The focus will default to the MO Number field. If the MO Number field is populated and a new MO needs to be scanned, click the CLEAR button to reset the window. Scan an MO Number Barcode on the paperwork. If the MO cannot be found in GP, or does not have a picklist, the field will flash red and user will not be able to continue to scan. If the MO is valid, the field will be populated and the focus will move to the ingredient field.
Ingredient Scan the Ingredient (item number) from the paperwork. The enhancement will perform the following validations:

  1. Verify the item is on the picklist for the selected MO.
  2. If the component is marked as nutrient broth, the item number must match the Generic Description of the parent item on the MO.

If either of these validations fail, the Scan Status field will turn red and the message will read “Invalid Item.” The focus will return to the Ingredient field to scan again. If the validation passes, the Scan Status field will turn green and the message will read “Item Added.” The focus will return to the Ingredient field to scan again.

In both cases, the last scanned ingredient for the displayed MO in this session will be displayed. If a successful scan needs to be backed out for some reason, the user can click the UNDO button. This will remove the scan from the system.

Recording Scans in GP

After an item is successfully scanned, the data will be pushed to a SQL table within the company database. The table will include two columns- MO Number and Item Number.

ACME will use this information when issuing material to the MO. There is no GP interface in this estimate to view the contents of the table, but the table will be available for ACME to create a Smartlist or use any other reporting products that can pull from SQL tables.

Assumptions/Requirements:

  1. The Warehouse workstation must have an ODBC connection to the SQL Server setup.
  2. Only one GP Company is being accessed from this application.

NOTE: This design can be reimagined with various table columns.

For information on this design, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/

 

CompleteCount 2025-10-24

Release Date: 24-OCT-2025
GP Versions: 12/14/16/18
CompleteCount Build: 5.66
* Tag Submission Wizard: fixed issue in Tag Submission process that caused the process to fail updating the variance quantity. The issue was introduced in build 5.64.  The entire tag process runs correctly, during the tag submission process the stock count lines ‘counted quantity’ is updated but the variance quantity is not calculated.  The variance quantity on the stock count lines and serial/lot table can be updated via SQL if needed.  Please contact us for update scripts if you are unable to install this update before performing your next count.
* Post Stock Count: added check on Post button to look for lines with missing GL accounts. If any exist the user will be warned and the window will display only lines with Missing GL Accounts.

MFGPowerPack 2025-10-16

Release Date: 16-OCT-2025
GP Versions: 12/14/16/18
MFG PowerPack Build: 20.268
* Updates for GP18.8. The updates are backwards compatible to all versions of GP from 2013 up.
* Scrap Entry: (1) The New SR Num button now asks if you want to create a new SR before it generates the next number. (2) If an SR Num is manually entered and it does not exist the user will be asked if they want to create a new SR. (3) If Post To GL and/or Create Journal Entry are marked in Setup AND the MO Status is CLOSED, the user will receive a warning: “This MO is CLOSED. You can create a Scrap Record but it will not adjust costs.”. (4) When posting and the MO is closed it will not attempt to create a journal entry. This fixes a situation where it was creating $0 journal entries.

 

Customization DS0901- Pick Ticket Resorting

Customization DS0901

Pick Ticket Resorting

Problem Definition:

ACME has multi-bins enabled in GP, but finished good inventory is all in one bin. To make it more efficient to pick inventory during order fulfillment, ACME would like to arrange the lines on the Pick Ticket by:

  1. Item User Defined Field #1, then
  2. Item Number

By default, GP normally prints a Picking Ticket in same order in which the lines are entered on the Sales Transaction.

Design Features:

Pick Ticket Sorting

There is no user interface for this enhancement.

ACME will need to use the SOP Blank Picking Ticket Bin Sequenced report. This version of the Pick Ticket uses a different set of field to sort the report, which will allow the enhancement to force the desired sort order.

A screenshot of a computer AI-generated content may be incorrect.

SOP Blank Picking Ticket Bin Sequence is printed by marking the Bin Sequenced box, shown above.

When a Pick Ticket is printed, GP adds lines to a temporary table used by the report. The enhancement will determine the correct/desired order of the lines and reorganize this table prior to printing. The lines will be ordered on the report by:

  1. Item User Defined Field #1 (Sorted alphanumerically, with blank/empty UDF #1 sorted at the bottom.)
  2. Item Number

The Item UDF#1 values will NOT be displayed on the report. It will simply sort those values, and then by Item Number within each Item UDF #1 grouping. There will not be a break between Item UDF#1 groupings.

Assumptions/Requirements

  • ACME must use the SOP Blank Picking Ticket Bin Sequenced report

For information on this design, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/

 

CompleteCount 2025-10-14

Release Date: 14-OCT-2025
GP Versions: 12/14/16/18
CompleteCount Build: 5.65
* Updates for GP18.8. The updates are backwards compatible to all versions of GP from 2013 up.
* Updated Excel Export and Import to use OpenXML. This is expected to yield a 4x improvement in export/import time.

Dynamics GP Support 2025

Date: 14-OCT-2025

Last year around this time I provided some numbers on the version of Dynamics GP used by our customers.  Since Summit is just around the corner and support is likely to be a hot topic, I wanted to revisit this topic.

Here is last year’s post: Dynamics GP Support

Last year I left off the decimal places, so the numbers look a bit different this time around, but it is the same overall distribution:

  • 82.63% – GP18.x (any GP18 version)
  • 7.08% – GP2016
  • 5.19% – GP2015
  • 2.08% – GP2013
  • 1.23% – GP2010
  • 1.70% – GP10

Last year about 23% were on a version below 18, this year it is 17%.  GP2010 and GP10 haven’t changed, and we’ve seen some movement from 2013 and 2015 to 18.7.

The main take away is that there are a significant number of Dynamics GP customers happily running their businesses on some version of GP below 18.  The software continues to work just fine, and we continue to support them.

Summit may create excited blog posts and emails mentioning these topics:

  • GP Lifecycle
  • Dynamics GP Roadmap
  • Microsoft Support
  • Timelines
  • Or even the scary and completely wrong “end of life”.

As you can see from our numbers, those posts and emails are just noise that is not backed up by real world usage.

-Brenner

MFGPowerPack 2025-10-08

Release Date: 8-OCT-2025
GP Versions: 12/14/16/18
MFG PowerPack Build: 20.267
* NEW Module – BOM BINS: Adds the ability to specify a Material Issue Bin at the BOM-Component level. When present this bin will be used rather than the Item-Site Material Issue Bin. This gives you the ability to specify a Material Issue Bin for a Component that is different depending which finished good is consuming it. This module also adds “MO Bins”, which adds the ability to specify a Material Issue Bin and Receipt Bin per Manufacturing Order. Additionally, the logic for performing the bin selection is contained in a SQL function which can be edited to provide your own custom bin selection logic.


* NEW TWK- Suppress Mfg Sales Item Detail When Not Short. Normally the window always opens for every line if the item’s fulfillment method is Make To Order – Manual, which can be confusing when it opens on a sales line an there is not a shortage. Enabling this Tweak will suppress the window if there isn’t a shortage.
* NEW TWK- Revaluation Detail: the Journal Entry created by a Standard Cost Revaluation does not provide a reference to the Item Number related to each distribution. This tweak tracks the Item Number, Location Code and Quantity On Hand associated with each distribution, and changes the Distribution Reference to contain the Item Number.


* Actual Cost Rollup: (1) fixed Pending Amount/Percent radio buttons (2) fixed table creation process that was missing some fields resulting in errors
* FULL PROCESS INSTALLATION REQUIRED: The updates are backwards compatible to all versions of GP from 2013 up.

 

Virtual Trigger VT1478- MFG Fulfillment Enhancements

Virtual Trigger VT1478

MFG Fulfillment Enhancements Scriptlet

Description of Need:

ACME uses the Sales Fulfillment History functionality provided by the Manufacturing module. ACME would like to improve efficiency by addressing the following needs:

#1 Item Maintenance – Fulfillment Detail: Although there is an Item Class setting, it does not automatically get applied to new items. (it can be rolled down from the Item Class which will update all items in the Class.) This can result in the Maintain Shipping History setting being missed for new items which then results in delays in fulfillment because the Fulfillment History Entry does not open. ACME would like to ensure that the Maintain Shipping History box is always marked.

A screenshot of a computer Description automatically generated with medium confidence

#2 Fulfillment History Entry: ACME often has 15-20 lines or more on a Sales Transaction and the Fulfillment History Entry window opens once for each line. Since everything being fulfilled is on one shipment, all of the information is repeated on each line. This requires a lot of user time. ACME would like to enter information into he Fulfillment History Entry window once, then for each subsequent line fulfilled, have the information already entered be used to automatically create a Fulfillment History record AND keep the window from opening.

A screenshot of a computer Description automatically generated with medium confidence

ACME scans/enters the Tracking Number into the Ship BOL field. They also re-enter this same information into the Sales User Defined Tracking Numbers window. ACME would like to have the Tracking Numbers that are entered into the Ship BOL field automatically copied to the Sales User Defined Tracking Numbers window.

A screenshot of a computer Description automatically generated

Description of Solution:

WilloWare will create Scriptlets for use in the Virtual Triggers module of Consulting Toolkit:

Consulting ToolKit

The Scriptlets will provide the functionality described above.

This solution requires the purchase of WilloWare’s Consulting Toolkit Virtual Triggers module.

For information about this solution, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/

 

Customization DS1469: Purchasing Account Allocation

Customization DS1469

Purchasing Account Allocation

Problem Definition:

ACME needs the ability to split a purchase order expense among several accounts. Currently, GP only allows the selection of one purchasing account per PO line item. All PO line items are non-inventory items and ACME always creates a Shipment/Invoice.

The allocations to other purchasing accounts are based on a percentage of the PO amount. This amount will be determined at the time of PO Entry. The first two segments of the account number will be the same, and only the third segment needs to be selected. The user needs to be able to select the third segment and percentage.

ACME may partially receive a PO item, and the allocation percentages are to be calculated for each receipt. For example:

PO Cost $100

Account Split required:

Acct #1 = 60%

Account #2 = 40%

Receipt #1 $20

Account Split posted:

Acct #1 = 20 * (60/100) = $12

Acct #2 = 20 * (40/60) = $8

Receipt #2

Account Split posted:

Acct #1 = 80 * (60/100) = $48

Acct #2 = 80 * (40/100) = $32

Solution Overview:

A solution will be developed that will track the purchasing account allocations during PO entry and then apply those to the POP Invoice at the time of posting.

Design Features:

Purchase Account Allocation

The user will enter a purchase order for a non-inventoried item as usual. When a line is selected, the user will navigate to Additional >> Account Allocation

Graphical user interface, application Description automatically generated

From the PO Item Detail Entry window, the user can also access the window from the Additional menu.

Graphical user interface Description automatically generated

Field Function
Item Number Displays the Item Number from PO Entry.
Purchases Account Displays the Purchases Account that is assigned to the Item Number.
Allocation Displays the current allocation to the default Purchases Account. As allocations are added to the scrolling window, the amount will decrease. The sum of all allocations will always add up to 100%.
Segment ID Enter or select from the lookup at Segment ID. The Segment ID selected here will replace the third segment of the default Purchases Account. If the new account number created by swapping out the segments does not exist, the user will be warned and will not be able to continue.
Description Displays the Account Segment Description.
Allocation Enter the allocation percentage for the additional segments. The sum of the values in the scrolling window can not exceed 100%. If an entry in the window causes the total to be over 100%, the user will be warned and unable to continue.

Receivings Transaction Entry:

When the user adds a PO Line item to a Shipment/Invoice, the enhancement will recalculate the PURCH distributions and split it using the Allocations from the PO. If the line is only partially invoiced, the proportional allocation percentage will be maintained.

If no allocations were set up on the Purchase Order, then only the default account will be used.

Graphical user interface, application, table Description automatically generated

After the document is posted, these are the distributions that will appear in the GL.

IMPORTANT NOTES:

  1. There are no controls to prevent the user from changing the PO Purchasing Account in PO Entry AFTER allocation percentages have been set. Doing so may make the swapped account number invalid. If the Receiving Process encounters an invalid account number, it will ignore that portion of the allocation and keep the amount in the default account.
  2. The Allocation percentage can be changed on the PO line after a portion of the quantity has been received. If allocations are changed, all future receipts for the PO line will use the new allocation percentages.

Assumptions/Requirements:

  1. ACME is only receiving Non-Inventoried items.
  2. ACME is only entering Shipment/Invoices.
  3. The functionality described above will not work with eConnect, any software that uses eConnect, or any software that directly writes to, updates, or deletes from SQL tables.
  4. The functionality described above is intended for the GP Desktop client.
  5. National Accounts functionality is NOT used.
  6. Advanced Distribution functionality is NOT used.
  7. Unless otherwise noted in this document, reporting is not included in this estimate.
  8. Unless otherwise noted in this document, Word Template functionality is not addressed.
  9. Unless otherwise noted in this document, the enhancement will not integrate with 3rd party products. Some examples of 3rd party products would be:
  • An ISV plug-in product, including WilloWare products
  • A dexterity customization designed by another developer
  • Dynamic GP Modules including, but not limited to:
  • Project Accounting
  • MDA
  • Analytical Accounting
  • Copy functionality found in SOP, POP, and Inventory
  • Field Service
  • Extended Pricing
  • Manufacturing

For information on this design, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/

 

Customization DS1557- Extended Pricing Price Update Utility

Customization DS1557

Extended Pricing Price Update Utility

Problem Definition:

ACME uses Extended Pricing with GP. They have both universal pricelists for items as well as customer specific pricelists. ACME often makes price increases or decreases for specific customers. These price changes can be either for all items in the price sheet, or specific items.

The items on the price sheet have the following characteristics:

  1. Only one unit of measure per item.
  2. There is usually more than one price break.

The source of the item list used by the price update utility can come from both an external source, (Salesforce), or from users within GP.

Design Features:

Staging Table

The enhancement will create a staging table in the company database. This table will be used by both the Salesforce process and the UI mass update window in the next section. ACME will be responsible for populating the table from Salesforce.

The table name and final field names will be provided after project approval.

Field Function
Customer Number Required for Import. The customer must exist in GP. It is a key field of the table.
Price Sheet ID When records are added to the staging table, this field can be blank. If it is populated, the PS must be both in GP and assigned to the customer. The PS will be filled in from the GP. (See next section)
Item Number Required for Import. The customer must exist in GP, and belong to the Price Sheet ID.
Quantity From If price breaks exist, enter the starting quantity of the price break. If only one price break exists, this should be set to 1 by default
Consolidate Price Breaks True or False. Set this to True (1) if the utility should remove all extra price breaks (if they exist) and set the item to use only one price break.
Update Method 1 = Fixed Price

2 = Percent Change
Price Value If the Update Method is 1 (Fixed Price), the value entered here will be the NEW PRICE of the item on the price list.

If the Update Method is 2 (Percent Change), the value entered here will be the percentage increase or decrease of the CURRENT PRICE.

Example 1:

Current Price = $100

Update Method = 2

Price Value = (10)

This is read by the enhancement as a 10% decrease in price. Therefore, the new price is 100 – (100 x 0.10) = $90
Status This field will display the current status of the line. It will get updated by the enhancement. Lines imported from Salesforce should be imported with a value of 0. The possible values are:

  • 0 – New Line. This line has been added to the staging table but not verified and/or ready to be pushed into the Extended Pricing Tables.
  • 1 – Ready to Process. This line has had its Price Sheet added and is ready to be added to the Extended Pricing Table.
  • 2 – This line has been successfully processed and Extended Pricing module has been updated to reflect the change.
  • 3 – This line did not pass all of the validations required to update the Extended Pricing module. Error may include:
  • Customer Number does not exist in GP
  • Price Sheet is not assigned to the Customer
  • Item Number is not assigned to the Price Sheet ID
  • Price Break does not exist
Error Displays the error message if the Status = 3

Price Change Utility

Navigation: Tools >> Utilities >> Inventory >> Price Change Utility

A screenshot of a computer screen Description automatically generated

Field Function
Update Prices Runs the update utility. All lines that pass the error checking will have their prices updated based on the logic selected for the line. If the line was marked to consolidate breaks, then all price breaks greater than the marked line will be deleted from the price sheet.

The enhancement will back up all data prior to making table changes, so if the outcome needs to be reversed, the data will be available. This estimate does not include any functionality to perform the restore if required.

After processing, the Status flag for the line in the table will be set = 2. After processing, lines will not be removed from the table. ACME will need to manually remove the lines.

Since the key on the table is Customer Number – Item Number – Qty To, future price changes for this combination WILL override older updates.

The Update Process will be written as a SQL stored procedure so that if ACME wants to automate the process in the future using a SQL job, it will be available.
VALIDATE Validates the lines. This is for the lines that may have been imported from Salesforce as the UI will validate on the fly. Any lines that do not pass the validation will be marked with a warning symbol and will not be processed.

Errors may include:

  • Customer Number does not exist in GP
  • Price Sheet is not assigned to the customer
  • Item Number is not assigned to the Price Sheet ID
  • Price Break does not exist

The Validation Process will be written as a SQL stored procedure so that if ACME wants to automate the process in the future using a SQL job, it will be available.
REDISPLAY Fetches new lines from the staging table if lines were added while the window was open.
X This field is not editable. It is only a visual indicator to indicate which line is currently selected.
Customer ID Enter or select from the lookup the Customer ID to update. If there are records already in the staging table, this field will be populated with that value. If a non-customer specific price sheet is being updated, leave this field blank.

After the customer is selected, the enhancement will attempt to locate the customer specific price sheet. The customer specific price sheet uses the logic described in the setup window. If one is found, it will automatically be populated.
Price Sheet ID Enter or select from the lookup the Price Sheet ID to update. If the Customer ID is blank, the lookup will display ALL Price Sheets, otherwise it will only display Price Sheets that are assigned to the Customer.

This field is required in order to use the Export, Import, and Find Items buttons.
EXPORT TO EXCEL Sends the contents of the scrolling window to Excel so that the Value can be updated.
IMPORT FROM EXCEL Imports lines from an Excel spreadsheet. Any lines that already exist in the scrolling window will be overridden with the import. The import file must be formatted with data beginning on Row 2 and columns as follows:

  1. A = Customer Number
  2. B = Price Sheet ID
  3. C = Item Number
  4. D = Qty To
  5. E = Update Method – 1 = Fixed Amount, 2 = Percent Change
  6. F = Value of the change
FIND ITEMS Opens the Find Items window. This is used to add items to the scrolling window. See Below.
Item Number Displays the Item Number that will be updated for the selected Price Sheet.
Qty From Displays the Qty From Price Break.
Qty To Displays the Qty To Price Break
Update Method Displays the method that will be used to calculate the new price. This will either be Fixed Amount or Percent Change. The Update Method is set when:

  1. The item is added to the staging table from Salesforce
  2. The item is selected using the Add Items window

The scrolling window could be a mix of Fixed Amount AND Percent Change update methods for a given Price Sheet.
Amount This field displays the amount of the change. It is displayed as a unitless value, however, depending on the Update Method:

  1. Fixed Amount – Value is expressed in dollars. This will be the NEW price of the item.
  2. Percent Changed – Value is expressed in percent. A value of 10 will cause a 10% increase in price. A value of – 10 will cause a 10% decrease in price.
Consolidation Breaks This checkbox is marked if all price breaks AFTER the currently marked break should be deleted from the price list. For example, if ABC-001 has 3 breaks:

1-10 = $10

11-50 = $8

51-99999 = $6

If the Break for 1-10 is added to the window with this check box marked with a $2 increase, the new Price Sheet will be:

1-99999 = $12

If the Break for 11-50 is added to the window with this checkbox marked with a $2 increase, the new Price Sheet will be:

1-10 = $10

11-99999 = $10

Find Items

A screenshot of a computer screen Description automatically generated

Field Function
DONE Closes the window and returns the Price Change Utility with the selected items loaded.
Customer ID Displays the Customer ID from the PS Utility window.
Pricesheet ID Displays the Pricesheet ID from the PS Utility window.
Find Items Where Field Dropdown options:

  • Item Number
  • Item Class

Conditions Dropdown Options:

  • Is equal to
  • Is not equal to
  • Is greater than
  • Is less than
  • Is greater than or equal to
  • Is less than or equal to
  • Contains
  • Does not contain
  • Begins with

Use the filters to build a selection set of items to add.
Display Choose to filter the added items to all items, only those active on the price sheet, or only inactive items.
ADD Adds the filter set chosen from above to the text field below the buttons.
REMOVE Removes a filter set from the text field below the buttons.
RUN QUERY Uses the filters to build a SQL query that will select items from the pricesheet ID to add to the PS Utility window.

Assumptions/Requirements

  1. The functionality described above will not work with eConnect, any software that uses eConnect, or any software that directly writes to, updates, or deletes from SQL tables.
  2. The functionality described above is intended for the GP Desktop client.
  3. National Accounts functionality is NOT used.
  4. Advanced Distribution functionality is NOT used.
  5. Unless otherwise noted in this document, reporting is not included in this estimate.
  6. Unless otherwise noted in this document, Word Template functionality is not addressed.
  7. Unless otherwise noted in this document, the enhancement will not integrate with 3rd party products. Some examples of 3rd party products would be:
  • An ISV plug-in product including WilloWare products
  • A dexterity customization designed by another developer
  • Dynamics GP Modules including, but not limited to:
  • Project Accounting
  • MDA
  • Analytical Accounting
  • Copy functionality found in SOP, POP and Inventory
  • Field Service
  • Manufacturing

For information on this design, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/

 

Tariff 2025-09-09

Release Date: 9-SEP-2025
GP Versions: 16/18
Tariff Build: 7.23
* Fixed issue with tariff calculation when using a fixed amount per item where it was not correctly multiplying the per item calculation by the sales line quantity.

Customization DS1552- Mass Import AP Apply Records

Customization DS1552

Mass Import AP Apply Records

Problem Definition:

ACME issues pre-payments in GP to Vendors. After the payables invoices are posted in GP, users need to apply them to the pre-payment. The list of invoices are in an Excel file and ACME would like a way to quickly import the Apply information into GP to make the Apply process more efficient.

Design Features:

Auto-Apply from Excel

Navigation: Apply Payables Documents >> Additional >> Auto-Apply from Excel

A screenshot of a computer Description automatically generated

This window can only be accessed if there is a Vendor and Document Number displayed in the Apply Payables Documents window with an Unapplied Amount greater than $0.

Field Function
File Enter or browse from the button the Excel file to import
Auto-Apply Processes the Excel file. The file will open and GP will read the lines from top to bottom, using the logic on the next page to do the Apply. After the routine runs, the Apply Payables Documents window will refresh and all of the lines that could be applied will be marked, and the Apply Amount will be updated.
Cancel Closes the window without processing the file

Excel File Read/Write

The Exel file ACME will use for this process is displayed below:

A screenshot of a computer Description automatically generated

The import enhancement will use columns B, E, and I for the import.

B = Vendor ID

E = Invoice Number

I = Payment Number

The enhancement will begin reading lines on Row 2.

The import routine will perform the following validation during processing. If a line does not pass the validation, and thus cannot be applied, the error “Could Not Apply” will be written back to the Excel file in Column J. The validations considered in the utility will be:

  1. The invoice is posted
  2. The document type is Invoice
  3. The invoice is not on hold
  4. Both documents are in the same currency
  5. Apply amount will be greater than $0

If a line passes the validation, it will be applied. Lines will be applied until the Unapplied Amount on the payment is $0.

Assumptions/Requirements

  1. The functionality described above will not work with eConnect, any software that uses eConnect, or any software that directly writes to, updates, or deletes from SQL tables.
  2. The functionality described above is intended for the GP Desktop client.
  3. National Accounts functionality is NOT used.
  4. Advanced Distribution functionality is NOT used.
  5. Unless otherwise noted in this document, reporting is not included in this estimate.
  6. Unless otherwise noted in this document, Word Template functionality is not addressed.
  7. Unless otherwise noted in this document, the enhancement will not integrate with 3rd party products. Some examples of 3rd party products would be:
  • An ISV plug-in product including WilloWare products
  • A dexterity customization designed by another developer
  • Dynamics GP Modules including, but not limited to:
  • Project Accounting
  • MDA
  • Analytical Accounting
  • Copy functionality found in SOP, POP and Inventory
  • Field Service
  • Extended Pricing
  • Manufacturing

For information on this design, or any other WilloWare customization or product, please contact us at:

www.willoware.com/contact-me/

 

MFGPowerPack 2025-09-08

Release Date: 8-SEP-2025
GP Versions: 12/14/16/18
MFG PowerPack Build: 18.265
* Scrap Reporting: (1) Posting Scrap now adds records to the MO Activity window. It will create a record for posting the Scrap Transaction, and if it is set up to create Journal Entries, it will also add a “Financial Activity” record. The Expansion Button (blue arrow) will open the Scrap Transaction in Scrap Inquiry. (2) Fixed an issue with the MO Scrap Inquiry window that caused an error when filling the display.
* MRP Exclusion Utility: (1) Further testing with MRP found that there are multiple places where it adds records to the MRP Exclusions table, so attempting to change/add/remove records from the table is pointless because MRP will repopulate it. Accordingly the MRP Exclusion setting is no longer editable in our MRP Exclusion Utility window. Additionally, the MFG MRP Exclusions window can add bogus records (i.e. invalid item-site combinations) which then cause MRP to create new item-site records in IV00102 (Item Qtys Master). Due to this we advise not use the MFG MRP Exclusions window–only use WilloWare’s MRP Exclusion Utility. (2) Opening the MFG MRP Exclusions window now automatically open MRP Exclusion Utility and closes MFG MRP Exclusions.

LeanMFG 2025-09-02

Release Date: 2-SEP-2025
GP Versions: 12/14/16/18
LeanMFG Build: 6.74
* This release includes several important changes that prevent users from doing things that can lead to three related Check Links errors (“Transaction quantity total was adjusted for document…”, “Batch Number has been added”, and “The batch total was adjusted for batch LEANMFG”). (1) It was possible to select the LEANMFG holding batch for posting in IV Series Post and Master Posting, (2) Deleting an MO did not update the Batch Total, (3) Scrolling through documents in the MO Entry window could caused the Batch Total to update incorrectly, (4) If you made a change to Inputs or Outputs and then clicked the Clear button and said NO to saving changes the Document Totals would not update, (5) If you closed MO Entry without saving changed the Document Totals would not update.
* Select Lot Number (Lot Entry) window: now has an option to sort Available Lot Numbers by Expiration Date.

GPPowerPack 2025-08-26

Release Date: 26-AUG-2025
GP Versions: 12/14/16/18
GP PowerPack Build: 10.193
* PO Doc IDs: when PO Doc IDs are required the PO Entry window will remember the last used Doc ID and not prompt again unless the last used was the default GP PO Number.
* SOP Rules: if one or more SOP Rules have been added but the “SOP Rules” has not been enabled in the main Setup window there will now be a warning when the SOP Rules window closes and the main Setup window will scroll to the “SOP Rules” checkbox.

MFGPowerPack 2025-08-21

Release Date: 21-AUG-2025
GP Versions: 12/14/16/18
MFG PowerPack Build: 18.264
* Vendor Pricing: fixed error (“Illegal address for field rgView in script Display . Script terminated”) caused by the following scenario: If the SO-PO Preview window is closed quickly after it opens, Vendor Pricing forces the Vendor Pricing Inquiry window to close before it has finished displaying the pricing information.
* PowerATP: Free Forward- modified the logic of the Free Forward Quantity (FFQ) and Date, also added a color indicator dot (red/green) to highlight inventory conditions. (1) Green & 0/0/0000: ATP is always positive. FFQ shows the lowest ATP in the calculation period. (2) Red & 12/31/9999: ATP ends negative. FFQ shows the lowest ATP in the calculation period. (3) Red & Specific Date: ATP is negative at some point but ends positive, FFQ shows the lowest positive ATP after the shortage and the date it occurs.

 

Free ForwardATP always positive:

ATP ends negative:

ATP goes negative but stays positive.  After the shortage this is the date of the lowest positive ATP quantity:

 The Free Forward Quantity (FFQ) and the Free Forward Date combine tell you the earliest date and quantity you could provide a customer if no changes are made to existing orders.

Green & 0/0/0000: ATP is always positive, FFQ shows the lowest ATP in the calculation period

Red & 12/31/9999: ATP ends negative, FFQ shows the lowest ATP in the calculation period

Red & Specific Date: ATP is negative at some point but turns positive and stays positive. FFQ shows the lowest positive ATP and date it occurs.

Tariff 2025-08-20

Release Date: 20-AUG-2025
GP Versions: 16/18
Tariff Build: 7.22
* Fixed issue with installation routine that resulted in a sql function (wfnGetItemHTSCodes) not being created. When running the Tariff BOM Report this would result in an error: Cannot find either column “dbo” or the user-defined function or aggregate “dbo.wfnGetItemHTSCodes”. The sql function is used only by the Tariff BOM Report and does not impact other parts of the software.
* FULL INSTALLATION ROUTINE REQUIRED

GPPowerPack 2025-08-18

Release Date: 18-AUG-2025
GP Versions: 12/14/16/18
GP PowerPack Build: 10.192
* PO Doc IDs: fixed issue where it prompted to select a PO Doc ID when PO Print Options opened, or the Actions button was used to select an option that opened another window.

GPPowerPack 2025-08-13

Release Date: 13-AUG-2025
GP Versions: 12/14/16/18
GP PowerPack Build: 10.191
* PO Doc IDs: (1) it now always prompts for new PO Doc ID selection in PO Entry when sites are assigned, (2) MRP uses the same window to release suggested MOs and POs and PO Doc IDs was active in both cases. It is now only active for suggested POs (MPO).
* Sales Pro: (1) It now auto-closes when saving/changing SOP Docs, (2) The SalesPro window has a new display only field, Sales Line Site, in addition to the editable Lookup Site. The Lookup Site changes which site the SalesPro window is using. This was done to highlight for users that changing the Lookup Site does not change it on the sales line. (3) if user changes the Lookup Site and it doesn’t match the Line Site when they select an item, they will be reminded that this will not change the Sales Line Site and asked if they want to continue.

Tariff 2025-08-13

Release Date: 13-AUG-2025
GP Versions: 16/18
Tariff Build: 6.21
* Fixed issue in MFG BOM tariff calculation that caused it to not display all of the tariff codes on the Sales Line w/Detail even though the total amount of tariff calculated was correct.

MFGImport 2025-07-24

Release Date: 24-JUL-2025
GP Versions: 12/14/16/18
MFG Import Build: 6.80
* BOM Import/Routing Import: Fixed an issue in the Errors window display caused by certain errors not having a row number to refer to because the error pertains to multiple rows, such as duplicate BOM Name or duplicate Routine Name. When opening the window the following error would occur: Error converting data type varchar to numeric.

Tariff 2025-07-23

Release Date: 23-JUL-2025
GP Versions: 16/18
Tariff Build: 6.19
* NEW Sales Tariff Inquiry: Available from the Additional Manu on Sales Transaction Entry, this window shows the Tariff Code details and amounts associated with the tariff calculation for each sales line.
* NEW Item Maintenance Additional Menu item to access Item Tariff Code Maintenance
* Tariff Code Maintenance: (1) fixed issue where the window would not retrieve any HTS information when the HTS code had only three segments, (2) fixed issue where it would not parse both a rate and dollar amount if the General Rate contained both (for example $1.05/hr + 2.3%).
* Item Tariff Code Maintenance: the scrolling window now shows the detail of the Tariff Code linked to the item.
* Custom Sales Line Tariff Description: (1) fixed issue where the returned value was not being used, (2) added missing section to the documentation.
* FULL INSTALLATION REQUIRED!

LeanMFG 2025-07-21

Release Date: 21-JUL-2025
GP Versions: 12/14/16/18
LeanMFG Build: 6.73
* Builds new table used for LeanMFG integration error reporting (WMFG7000)
* FULL PROCESS INSTALLATION REQUIRED: The updates are backwards compatible to all versions of GP from 2013 up.

LeanMFG 2025-07-17

Release Date: 17-JUL-2025
GP Versions: 12/14/16/18
LeanMFG Build: 5.72
* MO Entry: The change in build 70 to default the Cost Allocation method was causing the window to always use Manual. Cost Allocation now gets set to Manual only if it is not set on the BOM.

MFGPowerPack 2025-07-15

Release Date: 15-JUL-2025
GP Versions: 12/14/16/18
MFG PowerPack Build: 18.263
* Serial Number Mass Entry: fixed an issue where it incorrectly required a bin when (1) receiving a drop-ship PO, (2) marking the Serial/Lot box on the receipt, and (3) multi-bins is enabled.

MFGPowerPack 2025-07-07

Release Date: 7-JUL-2025
GP Versions: 12/14/16/18
MFG PowerPack Build: 18.262
* Actual Cost Rollup: (1) (a)optimization of all SQL used in the rollup process to significantly improve speed, (b) fixed an issue in the rollup routine that prevented to pending cost from rolling into the current cost on Item Cost Maintenance. (2) (a)Rollup Inquiry-substantial redesign of this window so it now can show only changed items or all items, (b) filters on window to quickly find items, (c) Snapshots–capture snapshots of rollups so you can switch between them to compare different scenarios. (3) Item Cost Maintenance now only allows setting costs on buy items.
* FULL PROCESS INSTALLATION REQUIRED: The updates are backwards compatible to all versions of GP from 2013 up.

GPPowerPack 2025-07-01

Release Date: 1-JUL-2025
GP Versions: 12/14/16/18
GP PowerPack Build: 10.190
* New TWEAK: SO-PO Return To Sales Entry- from the Purchase Orders Preview window easily return to the Sales Entry window with the sales transaction displayed.
* U of M Schedule Change: NEW Paste functionality! Mass update a large number of items from a spreadsheet. Copy Item Number and New UM Schedule from a spreadsheet and paste into the UM Schedule Change window.
* PO Doc ID: (1) NEW PO Doc ID – Site Assignment. This optional new feature adds the ability to assign one or more sites to a PO Doc ID which then controls which site(s) can be used in all of the windows supported by PO Document Types (i.e. PO Entry, Purchase Request Resolution, PO Generator, etc). (2) Added support for Purchase Request Resolution

Why Doesn’t This Item Appear In MRP?

DATE: 26-JUN-2025

Why doesn’t this item appear in MRP? Who hasn’t asked this question?  Why is this other stuff showing up in MRP when I don’t think it should?  Another great question!

Scroll down for a cool new tool for managing MRP, but first the background.

A client contacted us to help investigate why they had a huge number of Item-Site records in IV00102 that they swear nobody created.  The problem records were all Work Centers where they wouldn’t normally store inventory so they wouldn’t assign items to those sites (as you know, Manufacturing requires that Work Centers also be Sites).

The first thought was somebody mass assigned a Site to Items.  We deleted over 20,000 “bad” Item-Site records from the table, but a short time later they had several thousand of the bad records again.  It was apparent that something was automatically creating them, and the only thing that seemed a possible culprit was MRP.

We repeated the “bad” record deletion in a test company and ran MRP and watched it adding records to IV00102.  At this point we noticed that all of the bad records were in the MRP Exclusion List as “Inactive”.

The MRP Exclusion List “Type” options are confusing.  Here is what each option actually does:

  • VIEW ONLY: The Item is included in MRP Calculations but does not show in the MRP windows
  • VIEW AND CALCULATE: This one corresponds to NOT marking the Calculate MRP checkbox, in other words the Item is excluded entirely from MRP (it is not calculated and it does not show in the MRP windows)
  • INACTIVE: It sounds like the Item/Site/Item-Site would be ‘inactive’ for MRP but what it does is include the item in MRP calculations and only show it if there is activity

The root of the Item-Sites problem is that you can add Item-Site pairs to the exclusion list as INACTIVE where the Item-Site assignment does not exist.  When MRP runs it creates records for those items in IV00102.  In addition, you see all sorts of results in MRP for these items that appear to be excluded because they are INACTIVE.

There’s more…

The Exclusion List window is not just “exclusions”.  As described above the Type field also results in different things happening when an item is INCLUDED in the calculations.  As you can see in the screen shot above, the Exclusions List allows TRIPLICATE records.  This happens because the key on the MRP Exclusions table (MP030000) is Item, Site, Exclusion Type.  This creates a situation where different parts of MRP will handle the Item differently depending on what it is looking up in the Exclusions Table.

We created a better way to manage MRP Exclusions.

The new MRP Exclusion Utility in MFG PowerPack gives you one place to manage all the settings that affect whether or not an Item is included in MRP.  From this window you can change the Calc MRP flag and/or change the MRP Exclusion setting.

Given the issues described above with the Exclusion List “Type” options we strongly encourage you to only use Calc MRP checkbox because this will enforce the Exclusion List table containing ONLY items/sites/item-sites that are EXCLUDED.

MRP Exclusion Utility breaks out Work Centers separately from regular Sites.  Usually, inventory is not stored in Work Centers, so this view provides an easy way to mass update all Work Center-Sites to “unmark” the Calc MRP checkbox.  Note the small downward arrow above the CALC MRP column header–this will rolldown the adjacent checkbox to all displayed records.

MRP Exclusion Utility flags errors–records where the Calc MRP flag is not compatible with the MRP Exclusion setting.

The Rebuild Exclusions button clears the MRP Exclusion table and repopulates it based on Calc MRP settings in:

  • Site Resource Planning
  • Item Engineering
  • Item Resource Planning

Note: Rebuild Exclusions leverages an existing Manufacturing utility under Tools >> Utilities >> Manufacturing >> MRP Exclusion Build.  Unfortunately, the MFG utility does not clear the table first, so if there are any ‘bad’ records in there such as the triplicates described above, it will not clear them.  Our MRP Exclusion Utility clears the table first so you are starting with clean data.

MRP Exclusion Utility is available now if you have the Suite License.  Just download an install the latest build.

PowerATP User Fields

25-JUN-2025

We have an interesting addition to PowerATP this week!  It addresses a frequent user request that, until now, we have not had a good answer for.  The user interface for PowerATP is already rather full, so finding space to display more information has been a challenge, and it seems that everybody would like something else on the window–standard cost, actual cost, item class, user defined #3, you name it.  You now have the ability to add an unlimited number of additional fields from any source.

The PowerATP window has a new “pop-out” extra fields scrolling window!

The pop-out uses a stored procedure (wspPowerATPFields) to populate a temp table which fills the scrolling window.  You can edit the stored procedure to add as much additional information as needed.  As you can see above, the stored procedure already has a couple of fields in it to give you some examples to work from when adding your own fields.