Virtual Trigger VT1151 Assembly Transaction- Change Assemble Quantity

Virtual Trigger VT1151

Assembly Transaction- Change Assemble Quantity

Note: Virtual Triggers is a module from the WilloWare product Consulting Toolkit.

Virtual Triggers provides the ability to quickly enhance GP functionality with small bits of dexterity code.

Description of Need:

ACME uses the Dynamics GP Inventory Assembly transaction in food production. Due to the nature of working with food, there is variability in the quantity of the finished good regardless of the quantity of raw materials consumed. For example, given a certain amount of raw materials, the finished good output could be the desired quantity (i.e. 50 cases), or it could be slightly less or slightly more (49 or 51 cases).

ACME adjusts the Assembly Quantity to reflect the actual quantity produced.

However, when they do this, GP recalculates the raw material quantities and deletes any Lot Numbers selected for the raw materials, which means the user has to then re-select all of the raw material lots.

ACME would like a way to change the Assemble Quantity without losing raw material lot numbers.

Description of Solution:

The solution proposed is based on using WilloWare’s Virtual Triggers module in the Consulting Toolkit Suite. The cost of that module ($1000 + $180/yr Annual Enhancement) is NOT included in this estimate.

See more about Virtual Triggers here: //willoware.com/products/consulting-toolkit/#vt

WilloWare will create a Scriptlet, (a small bit of dexterity code,) which is imported into the Virtual Triggers module. The Scriptlet will add an Additional Menu option to the Assemble Entry window called “Change Assemble Quantity”. Selecting that menu option will:

  • Check that the Assembly Transaction is assigned to a Batch ID
  • Open a dialog window and ask the user to enter the new quantity. They can cancel at this point and not make any changes.
  • If a Quantity is provided, the Assembly Transaction will be saved.
  • It will make adjustments necessary on the Assembly Transaction to change the Assemble Quantity.
  • It will redisplay the document.

After changing the quantity, the user can make adjustments to the finished good Lot Numbers, or Lot Quantity. NOTE: Assembly Entry will not allow the transaction to post if the finished good Lot Quantity does not match the Assemble Quantity.

Assumptions/Requirements:

  • Requires the separate purchase of WilloWare’s Consulting Toolkit Virtual Triggers module.

For information on this Scriptlet, or any other Willoware customization or product, please contact us:

www.willoware.com/contact-me/