Author: admin

Complete Count Release 2018-09-27

V12.0.34 / 14.0.24 / 16.0.17 / 18.0.7
* Mass Add/Update: changed how the Set/Update Count Date utility works. It now has options to choose “work days”, and it will allocate groups of items to be counted on each work day within the Count Interval. For example, if 100 items need to be counted every 10 days, the utility will assign 10 items to be counted each day (assuming those are all “work days”) (#20185182).

GP PowerPack Release 2018-09-19

V12.0.125 / 14.0.68 /16.0.36 / 18.0.8
* TWK-SOP: Auto-Open Customer Detail: addressed issue that caused Customer Detail Entry information to not save if the user used the mouse to click into the Customer Number field on the Sales Transaction Entry window, rather than tabbing into it (#20185112)

MFG PowerPack Release 2018-09-19

V12.0.138 / 14.0.85 / 16.0.51 / 18.0.12
* Sales Forecast Integration: re-enabled ability to import a negative forecast so that Appending can be used to perform net change adjustments.
* Item Copy: added a change to the Item Master using dexterity (all of the copying is done via SQL) so it causes any 3rd Party Item Master triggers to fire.
* Quick Disassembly: window now remembers settings on a per-user basis so that each time the window opens the previously used options are selected automatically.

Consulting Toolkit Release 2018-09-18

V12.0.23 / 14.0.17 / 16.0.13 / 18.0.5
* Virtual Triggers: (1) Rewrote VT trigger registration routine to make it more efficient with a large number of triggers, (2) Changed method of choosing databases so they can be marked (checkboxes) rather than manually entering database IDs. The databases window also now has Mark All/Unmark All buttons.

Complete Count Release 2018-08-29

V12.0.33 / 14.0.23 / 16.0.16 / 18.0.6
* Mass Add/Update: addressed issue that caused duplicate key error when adding items to a Stock Count with multi-bins when there were items with multiple quantity types (i.e. In Use/In Service) in the same bin (#20185059)
* XLLink: added options to export Quantity Available and Quantity On Hand

LeanMFG Release 2018-09-13

V12.0.34 / 14.0.23 / 16.0.13 / 18.0.5
* MO Entry: (1) Addressed issue that caused error “Cannot insert value NULL into column TRXQTYTL” after clicking the Build Picklist button when using a Multi-product BOM that has no input or output items. (2) Added handling for MO with only Labor input with/without cost (i.e. $0 inputs). (3) Added handling for zero cost input Inventory items. (4) Post button now enables on a Manual MO after Inputs & Outputs have been entered. (5) Addressed issue that allowed bypassing Add New Item check on the Inputs tab.

Complete Count Release 2018-08-29

V12.0.32 / 14.0.22 / 16.0.15 / 18.0.5
* Stock Tag Submission: addressed issue that could cause a duplicate key error when moving Complete Count records to history tables. When this happens, the GP Stock Count updates correctly but the Stock Tag Printing information does not get moved to history (#20184931).

MFG PowerPack Release 2018-08-27

V12.0.137 / 14.0.84 / 16.0.50 / 18.0.11
* Serial/Lot Mass Generate: (1) Addressed issue that caused Global lot/serial mask to revert to the item’s mask when generating multiple lots. (2) Addressed issue that caused the Quantity per Lot Number to revert to the Lot Quantity instead of using the Lot Split Quantity. (3) Lot Split Quantity was incorrectly reverting the the Lot Quantity. (4) Lot Split Quantity from the Global Lot Mask is now applied to all Lots. (5) The quantity of Lot Numbers, and Quantity per Lot, now correctly handles the remaining quantity when the Lot Split Quantity does not divide evenly into the Lot Quantity.

Cash Payables Transaction Thru AP Account

DS0684

Cash Payables Transaction Thru AP Account

Problem Definition

ACME Co is a focused network of community and social websites that include G*****.com, T*****.com, A*****.com, and L*****.com. They use Dynamics GP as their ERP system.

To support a reporting requirement of their Auditor, ACME Co needs to create Payables Transactions with the following distributions when the transaction is entered with either a cash or check payment:

1.       Cash Account (standard GP)

2.       Purchases Account (standard GP)

3.       Debit AP account

4.       Credit AP account

The entries in #3 and #4 in the list above are not standard GP functionality. ACME Co would like to automatically add these accounts to the Payables Transaction Distributions.

Design Features

Payables Transaction Entry

There is no user interface for this enhancement.

When a Payables Transaction is entered through the Payables Transaction Entry window and the following criteria is met:

  1. Payment Type equals Invoice, Finance Charge or Misc Charge AND
  2. An Amount is entered in the Cash and/or Check fields

The enhancement will add the following two entries to the Distribution Accounts during posting of the Payables Transaction. Posting is supported through the Payables Transaction Entry window and the Payables Batch Entry window only.

  • Debit to the Accounts Payable Account set in the Posting Accounts Setup Window for the amount(s) entered in the Cash and Check fields combined. The Account Type will be set to PAY.
  • Credit to the Accounts Payable Account set in the Posting Accounts Setup Window for the amount(s) entered in the Cash and Check fields combined. The Account Type will be set to PAY.

In the example below, an AP Invoice has been entered for $1,000.00 with a corresponding $1,000.00 Cash Payment entered at the same time:

The enhancement will add a credit and debit entry to the default Accounts Payable account (Account Type = PAY) for the amount entered in the Cash and/or Check field on the Payables Transaction Entry window during the posting process:

Payables Distribution Zoom

The debit and credit to the Accounts Payables Account will be visible in the Payables Distribution Zoom window for posted Payables Transaction Documents which have been updated by the enhancement.

Pricing & Downloads

We are excited to announce a couple of small changes to our website that we hope will improve you life!  Well…that might be overstating things a bit, but we hope the changes will help you do your job more efficiently, or make a product decision just a little bit more quickly.

First, our Price List is now available on our website.  Just click the PRICING button (or at the top of the webpage, click MORE >> Pricing).

Second, the Downloads page no longer requires a password.  Just click the DOWNLOADS button (or MORE >> Downloads), select the GP Version, and download the software you need.

 

GPPowerPack Release 2018-08-02

V12.0.124 / 14.0.67 /16.0.35 / 18.0.7
* TWK-SOP: Use Item’s Default Site: modified behavior so it sets the Site ID before leaving the Item Number field. Since SOP defaults the site on a new line to the Site ID from the previous line, this change prevents getting prompted to add an Item-Site combination based on the previous lines Site ID. It will now also revert to the Default Site ID on the SOP Header if the Item being entered does not have a Default Site assigned.
* TWK-POP: Duplicate Items Warning: NEW. Warns user if the same Item Number is entered more than once on a Purchase Order.

MOGenerator Release 2018-08-02

V12.0.84 / 14.0.59 / 16.0.37 / 18.0.4
* MORI: (1) MO Query-addressed issue that could cause the query to not save, (2) Override IV Doc Number with MO#-this new user preference setting on the MOGen window causes MORI to override manufacturing when it creates Inventory Adjustments. Instead of using the default Next IV Adjustment Number, the adjustment will be created using the MO# plus a suffix for each subsequent Adjustment (such as MO00123*1, MO00123*2, MO00123*3 and so on). This option was added to address a condition reported in very high volume environments with multiple MORI processors where the normal GP logic that generates the Next IV Document Number allows two nearly simultaneous processes to receive the same Document Number.

GPPowerPack Release 2018-07-24

V12.0.123 / 14.0.66 /16.0.34 / 18.0.6
* TWK-SOP: Auto-Open Customer Detail: addressed issue that caused Customer Detail Entry to pop behind SOP Entry if user clicked on Customer Detail Entry with the mouse rather than using the keyboard (#20184512)
* TWK-SOP: Display Ship Weight in Title Bar: added a setup option to control whether shipping weight for kits comes from the Kit Item or the Components.

MOGenerator Release 2018-07-16

V12.0.83 / 14.0.58 / 16.0.36 / 18.0.3
* MORI: (1) Error Log- added button to “hide” errors. This changes records errors to a new status code so they are no longer displayed in the error log window. (2) Changed how conversion to Base UofM is handled in the MOPick table to account for a UofM Schedule that has circular conversions. (3) Changed timing of when a “split” MO is created during a partial receipt so that all errors checks must pass before the split MO is created. (4) Added Edit MORI Data window (accessible from Error Log window GoTo button) to facilitate manually changing data in the MORI tables from inside GP.

Trying Our Software

In additional to being fully functional in Fabrikam, all of our software is also fully functional, without registration keys, in <TEST> companies.  There are two benefits from this:

First, you can download and test our software using your live data without needing a temporary, time-limited key.

Second, if you already have our software but are not registered for all of its features, you can test ALL functionality in the <TEST> company without changing your registration key.

In short, all functionality of all of our modules is always available in a <TEST> company.

In case you are not familiar with a <TEST> company, here’s a quick overview.

Dynamics GP has a little feature that is not well documented, which provides support for Test and Historical company databases.  To enable this feature, put <TEST> or <HISTORICAL> at the end of the Company Name, as shown below:

<TEST> must be placed at the end of the Company Name (i.e. “WilloWare Inc. <TEST>”).

The primary effect of this is that it Zeros the Employee Count so the Employees in a TEST or HISTORICAL Company do not affect payroll.

It also causes a warning to pop-up during login to help alert users that they are not in the live company:

And, it will also cause WilloWare software to enable full functionality.

NOTE: During log-in you will receive a warning that the software is not registered.

MFG PowerPack Release 2018-07-09

V12.0.134 / 14.0.81 / 16.0.47 / 18.0.8
* Item Copy: addressed issue that prevented the Excel Import utility from creating new Items when the spreadsheet did not contain additional columns (E and beyond).
* Quick Disassembly: addressed issue that caused “Illegal address for field ‘Reason Code'” when user closed window while it was processing the disassembly (#20182763).
* Service Equipment Suite: added check that SVC Setup has been completed before enabling SVC Equipment Suite.

Grant SQL All Objects

It is commonly thought that the grant.sql script (found in the GP Folder\SQL\Utils\) takes care of security at the SQL Server level by granting access to DYNGRP to all of the SQL objects used by Dynamics GP.

It doesn’t!

We recently had a support case where the user was getting the following error:

The EXECUTE permission was denied on the object ‘MFG_FUNC_Component_BOM_Type’

The function is part of the Manufacturing Module, but our Export Indented BOM feature in MFG PowerPack uses the function.

We asked the client to run grant.sql to fix the issue.  The user still had the error.

At that point we knew there were only two options: (1) the User ID wasn’t assigned to DYNGRP, or (2) there was something wrong with grant.sql.

A quick look at grant.sql and the problem was obvious–it grants security on Tables, Views and Stored Procedures.  It does not grant security to Scalar Functions or Table Valued Functions.

An updated GRANT.SQL script is below.  It covers all of the SQL objects listed above.

Download GrantAll.zip (it contains a text file): GrantALL 

 

 

MFG Data Archive Release 2018-06-20

V12.0.24 / 14.0.15 / 16.0.10 / 18.0.1
* First GP2018 Release
* Added new tables to the archive. If an MO has already been archived using a prior build, the archive routine will “catch up” on the new tables the next time the archive utility runs. The new tables are:
MOP1003 – MOP_MOVar_HIST
MOP1004 – MOP_MO_Variance_Material_Hist
MOP1006 – MOP_Item_MSTR_Qty_Var
MOP1009 – MOP_WIPCostChanges
MOP1012 – MOP_MO_Variance_Material_Hist_STD
MOP1015 – MOP_WIPOverrideHist
MOP3000 – MOP_Variances
* New Archive Processor window: a new bulk copy archive routine achieves a significant decrease in the time required to archive MOs.
* New locally installed PDF documentation, and context sensitive CHM help

LeanMFG Release 2018-06-13

V12.0.32 / 14.0.21 / 16.0.11 / 18.0.3
* Install/Upgrade: added checks for temp tables remaining from a prior upgrade to prevent an attempt to re-upgrade the tables (#20183874)
* MO Entry: addressed Illegal address for field ‘BuildPicklist’ in script ‘AbortForShortages’ error caused by closing window while picklist is being built (#20183844)

GP PowerPack Release 2018-05-29

V12.0.121 / 14.0.64 /16.0.32 / 18.0.4
* SOP Doc Print Options Defaults: addressed issue that caused field not found error is user quickly closed the Sales Print Options after it opened (#20181312)
* Extended Lot Attributes: (1) Addressed issued that cause ELA to not save the core GP attributes on an MO Receipt, (2) Connected ELA to Manufacturing PowerPack’s Serial/Lot Mass Generate Utility. ELA will now open for each Lot created by SLMG.

MFG PowerPack Release 2018-05-29

V12.0.133 / 14.0.80 / 16.0.46 / 18.0.7
* Serial/Lot Mass Generate: integrated into GP PowerPack’s Extended Lot Attributes. If ELA is registered and enabled, the ELA Attribute Entry window will pop-open for each Lot Numbered generated.
* Quick Disassembly: changed routine that retrieved average cost for the actual cost raw materials to use a weighted average, and also take into account reverse issues.

LeanMFG Release 2018-04-09

V12.0.30 / 14.0.19 / 16.0.9 / 18.0.1
* First GP2018 Release
* Item Engineering: (1) creating Item Engineering records is now REQUIRED. Missing Item Engineering records will generate a warning to that effect if they are used in MO Entry.
* MO Entry: (1) Addressed issue in posting that left empty batch records in Batch Header/SY00500 (#20180802). (2) Added routine during installation that checks for empty LeanMFG batches and removes them. (3) Addressed issue that caused “selected record has been deleted by another user” error after clicking the Build Picklist button. (4) Added posting indicator that appears on the window while the posting process is running. (5) New posting routine prints Transaction Posting Journals rather than Inquiry Journals.
* Vendor Approval: NEW- Vendor Approval functionality. Enabling Vendor Approval will require that a Vendor is approved for purchase of an item before the item will be allowed on a PO.
* Added additional controls to keep LeanMFG transactions from being viewed in IV Transaction Entry.
* Doc Type Details: (1) Changed labels on Journal Printing options, (2) New Option: Show Unit Cost Warning–if enabled, shows a warning message if posting Output(s) would create split cost layers because the input costs do not divide evenly into the Output unit cost.
* New locally installed PDF documentation, and context sensitive CHM help

MFG PowerPack Release 2018-03-26

V12.0.131 / 14.0.78 / 16.0.44 / 18.0.5
* Quick Disassembly: (1) Added support for disassembly using a Manufacturing Order as the source, (2) Added support for Inventory Reason Codes on the Quick Disassembly window.
* PowerATP: (1) Added logic to handle an Intersite Transfer created by an RTV where the Return Item is different than the Out Item (#20180797). (2) Added exclusion for SOP Voids so the ATP query does not catch them while they are being moved to history (#20180081)
* Serial Mass Entry: (1) Addressed issue in Item Transaction Entry that caused the Total Serials Selected to display the Quantity Required
* Indented BOM Report: (1) Added more columns, (2) Added new BOM Export Query window from MFGPP Setup to allow editing the query so that columns can be added/remove/renamed or additional tables joined to the query.

MFG PowerPack Release 2018-03-26

V12.0.130 / 14.0.77 / 16.0.43 / 18.0.4
* Serial/Lot Mass Generate: (1) Addressed issue that caused Next Lot Number to not increment correctly if a Global Lot Number was not being used. (2) Added warning if Global Serial/Lot Number functionality is enabled and Item Class Serial/Lot Numbering setup exists (the features should not be used at the same time)
* Item Class Serial Numbering: (1) renamed to Item Class Serial/Lot Numbering and extended its functionality to Lot Numbers. (2) Added warning if Global Serial/Lot Number functionality is enabled and Item Class Serial/Lot Numbering setup exists (the features should not be used at the same time)
* Updated WW Internal Resources

LabelLink Release 2018-03-21

V12.0.36 / 14.0.19 / 16.0.8 / 18.0.1
* First GP2018 release
* Addressed issue that could cause no labels to print from Sales when the SOP Header contains a bad SOPTYPE
* Item-Label Setup: added new functionality to allow associating a label with one or more Item Numbers. When that label is selected in the LabelLink window it automatically restricts the view to show only items covered by the selected label.
* Updated WW Internal Resources

MOGenerator Release 2018-03-14

V12.0.81 / 14.0.56 / 16.0.34 / 18.0.1

*First GP2018 Release

* MORI: (1) Added new receipt posting process tracking to ensure MO Receipts are posted one at a time, and that posting has time to finish before the next MO Receipt is started. Removed the “in batches of” setting as MORI will now run continuously untill all pending receipts have been processed before it enters its timer-mode to wait for more records. (2) The Date column in MO Hdr is now being used (previously it was not used) with the new MO Query functionality. (3) Cancel button now terminates all processing immediately after the current MO finishes. (4) By Products are now supported for non-serial/lot tracked components. (5) Added new Setting “Delete MORI Record After Import”. When marked, if an MO Receipt processes OK it will be cleared from the MORI tables.

* MOGen:(1) CreateMOs & MOP-SOP Link: when importing from Excel, SOP Number and Line can now be provided to have the utility create a MOP-SOP Link. There is also a new SQL table for importing MOP-SOP links. (2) Added new Setting “Delete File After Import”. When enabled, MOGen will delete the excel file after importing the contents. (3) MO Description, BOM Type, and Schedule Method have been added to User Settings (they are remembered across sessions). (4) Create Child MOs: addressed an issue that caused the utility to run when the Create Child MOs box was not marked on MOGen, but the Setup option to Create Child MOs from SOP was marked.

* MO Query: New MO Query window has selection options to control which MO Receipts are processed. The MOHdr Date column can be used to only bring in MOs on or before the GP User Date. The window can also build complex, multi-parameter queries to restrict which records are pulled-in by the processor. The MO query can be used when running multiple MORI processors to ensure each one only handles certain types of records.

* MO Gen Error Log: added go-to button to access Picklist Shortages Inquiry, and MO Activity Inquiry.

* Documentation: complete rewrite, and deployment of local CHM help, PDF help, and webhelp.

MFG Import Release 2018-03-12

V12.0.39 / 14.0.22 / 16.0.10 / 18.0.3
* BOM Import Map: (1) Added radio buttons to change map view to BOM Header fields or BOM Line fields
* BOM Import: (1) Added check for multiple Rev Levels of same BOM in same file, (2) Added check for PPN having itself as a CPN, (3) Added check for first row missing Parent Item, (4) Added imported line count on window
* Updated WW Internal Resources