Power ATP

HelpID: 497022013, 497022007

Power ATP adds numerous enhancements beyond what is available in the standard Inventory Available to Promise window, such as:

• Can include MRP Planned Manufacturing Orders and Purchase Orders in the ATP calculation
• Can include Field Service inventory requirements from Service Calls and Work Orders
• Can include In Transit Transfer
• Can include Manufacturing Sales Forecasts
• Color coded ATP to makes it very easy to spot shortages
• Allows changing dates to see impact of moving an MO or PO
• Allows changing quantities to see impact of bumping up or down an MO or PO
• Can include multiple sites at one time in the ATP calculation
• Can create MOs and POs directly from the ATP window
• Includes Lot Numbers by expiration date in the ATP calculation

PowerATP includes the following transactions in the ATP calculation:

• Sales Transactions
• Purchase Orders
• Inventory Transactions
• Inventory Transfers
• Manufacturing Orders
• Manufacturing Picklists
• Manufacturing Sales Forecasts
• Service Calls
• Service Depot Work Orders
• Service In Transit Transfers
• MRP Suggested Manufacturing Orders
• MRP Suggested Purchase Orders
• MRP Suggested Cancellations, Move Ins and Move Outs
• Other sources of demand or supply (see Adding Custom Sources)

Setup

Navigation: Tools >> Setup >> Manufacturing >> MFG PowerPack Setup

Mark the box next to “Power ATP”. Restart Dynamics GP.

At least one Option Set must be created. The first time you open PowerATP, it will prompt you to create an Option Set if one does not exist.

The Option Set defines, among other settings, which sites to include in the ATP calculation.

Click the OPTIONS button to open ATP Setup to create a new Option Set.

At least one Option Set must be created for PowerATP to function.

User Default: an Option Set can be set as the Default Option Set for a User. The other Option Sets will still be available, but the window will open with the Default selected. Click the User Default button to open the User Default window.

Enter users for whom the selected Option Set should be the default.

Zoom Settings: ZOOM settings control how the ATP window will open source documents—either Inquiry windows or Transaction Entry/Maintenance windows.

Subtract Safety Stock: if marked, an extra “demand” line will be added as the top row of the ATP display to remove the Safety Stock Quantity (Safety Stock is subtracted from available inventory on date 0/0/0000, so that all future ATP calculations start from a lower starting inventory quantity). If all sites are included, Safety Stock will come from the Item Resource Planning Initial Values. If one or more sites are included, Safety Stock will be the sum of the Safety Stock values on Item Resource Planning for each of the included sites.

Subtract Order Point Quantity: if marked, an extra “demand” line will be added as the top row of the ATP display to remove the Order Point Quantity (OPQ is subtracted from available inventory on date 0/0/0000, so that all future ATP calculations start from a lower starting inventory quantity). If all sites are included, OPQ will come from the Item Resource Planning Initial Values. If one or more sites are included, OPQ will be the sum of the OPQ values on Item Resource Planning for each of the included sites.

Use Order Up To Level: Order Up To Level is considered the maximum desired stock quantity. When inventory is above this level the ATP quantity will be highlighted with a Yellow bar.

Open From SOP: if marked, and the Option Set is the User Default for a user, when the Quantity Expansion button (blue arrow) is clicked in Sales Transaction Entry it will open PowerATP instead of the GP ATP window.

Sales Demand: select which date to use for displaying (subtracting) demand from Sales Transactions. The options are: In House Due Date or Requested Ship Date.

Restrictions

• Item Number: if enabled, the scrolling buttons on the PowerATP window will scroll through just the specified item numbers. This is useful if a Planner works with only a small sub-set of items. Items can be added on at a time to the Item List, or via one of the mass-add options.

To mass-add items, click the “+” button.

The Add Items window integrates with SmartList. It will pull in all of the Items from a displayed SmartList Favorite. The only requirement is that the first column of the Favorite is “Item Number”.

Click Open SmartList. When SmartList is opened from the Add Items window, an Additional Menu item will be added to the SmartList window, such as “Add Items to DEFAULT”.

In SmartList, select the Favorite and make any necessary restrictions with the Search criteria. Then run the integration by selecting Additional >> Add Items to DEFAULT (it will display the name of the current Option Set).

After importing the list of items, SmartList will close automatically.

The “-“ (minus) button provides an option to Delete All Items from the list.

• INV Site: only include On Hand Inventory, Safety Stock, Order Up To Level, and Inventory Transactions from a list of sites. If sites are specified, all inventory values that come from Item Resource Planning will be the sum of the selected sites. For example, if Order Up To Level is used, the ATP will be flagged as exceeding Order Up To Level when the ATP quantity exceeds the sum of Order Up To Level from all selected sites in total. If no sites are specified the system will use the “Initial Values” settings. Click the Expansion button to open the Sales Sites Restrictions window. Enter the site/sites to include.

• MFG Site: mark to only include MOs and Picklists for specified sites. MOs will be selected when the “Post To” site on MO Entry in in the MFG Sites list. Picklist items will be included when the Draw From site is listed in the MFG Sites list.
• MFG Status: mark to only include MOs that have a specified status. Click the expansion button to open the MO Status Restrictions window (below). Mark which Status(es) should be included.

If Restrict By MFG Status is NOT marked, Manufacturing Orders and Picklists will be included when the MO Status is Open, Released or Partially Received.

If you want to include other statuses, or not include one of the default statuses, you must mark Restrict By MFG Status and select the statuses you want included.

• POP Site: mark to only include PO Lines for specified sites, otherwise all PO Lines are included regardless of Site.
• SOP Site: Include only sales orders from specific sites. Click the Expansion button to open the Sales Sites Restrictions window. Enter the site/sites to include.
• FCST Site: Include only Sales Forecasts for specific Sites. Click the Expansion button to open the FCST Sites Restrictions window. Enter the site/sites to include.
• Include Supply Sources: Mark which sources of Supply you want to include in the ATP calculation. “Supply” is a transaction which adds inventory. If Manufacturing MRP is set up to calculate Cancellations, Move-Ins or Move-Outs, those can be included.
• Include Demand Sources: Mark which sources of Demand you want to include in the ATP calculation. “Demand” is a transaction which removes inventory.

The Manufacturing and Service related options will only be available if those modules are installed.

Sales Forecasts are only included if Manufacturing’s Material Requirements Planning is being used, and has a current MRP Run that includes one or more selected forecasts. To make a forecast visible to MRP it must be added to Forecasting Selections.

Lookup the Forecast in the Sales Forecasting window. It must be assigned a Site ID. Click the GoTo Button and select Forecasting Selections.

Click the INSERT button to add the forecast to MRP Forecasting Selections.

Adding Custom Sources

Custom sources of inventory supply and demand can be added into PowerATP. For example, perhaps you have 3^rd Party Project Software or Manufacturing software. The inventory supply or demand from these sources can be included in PowerATP.

The installation process for MFG PowerPack creates two SQL stored procedures in the company database:

• wspATPSupply
• wspATPDemand

Each has two input parameters: Item Number, Plan ID (“Option Set”).

The output must be a results set with four columns:

• Date (i.e. Required Date/ Due Date)
• Document Number
• Quantity (in Base Unit of Measure)
• Date Label (i.e. ‘Required’ or ‘Due’)—this is custom label that will appear in PowerATP describing the type of date.

For example:

SELECT ReqShipDate, SOPNUMBE, (QUANTITY * QTYBSUOM), ‘Required’

from SOP10200 where ITEMNMBR = @ItemNum

This query would add “demand” from Sales Lines.

Modify the stored procedures to return data from your custom inventory supply or demand source.

Important Tables

ATP Sites (W4970713)

• Plan ID
• GPSource
  • 1 = INV Sites
  • 2 = MFG Sites
  • 3 = POP Sites
  • 4 = SOP Sites
• Location Code

ATP MO Status (W4970711)

• PlanID
• MOStatus

Setup Detail (W4970901) stores Checkboxes & Dropdown lists

• ProdID = 4970
• NodeID: Retreived from W4970900 where ProdID = 4970 and NodeLabel = PlanID
• ChildID:
  • 1 – Subtract Safety Stock
  • 2 – Use Order Up To Level
  • 3 – Restrict by Item Number
  • 4 – Restrict by Inventory Site
  • 5 – Restrict by MFG Site
  • 6 – Restrict by MFG Status
  • 7 – Restrict by POP Site
  • 8 – Restrict by SOP Site
  • 9 – Include Inventory Supply
  • 10 – Include In-Transit Transfer IN
  • 11 – Include MO Supply
  • 12 – Include MRP MO Supply
  • 13 – Include MRP PO
  • 14 – Include PO Supply
  • 15 – Include Inventory Demand
  • 16 – Include In-Transit Transfer OUT
  • 17 – Include MO Picklist Demand
  • 18 – Include MRP MO Picklist Demand
  • 19 – Include Field Service Demand
  • 20 – Include SOP Demand
  • 21 – Include Unmet Sales Forecast Demand
  • 22- Restrict by Forecast Site
  • 101 – INV Zoom Setting
  • 102 – MFG Zoom Setting
  • 103 – POP Zoom Setting
  • 104 – SOP Zoom Setting

Using Power ATP

Navigation: Inquiry >> Manufacturing >> Power ATP

Field	Information
Deplete by Lot Expiration Date	Enabled for Lot Numbered Items. Adds demand rows into the display for inventory loss on the lot expiration date.
Include MRP checkboxes	These are set by default from the Option Set but can be toggled on/off. To see the impact of Cancels or Move Ins, mark/unmark the checkbox and click the REDISPLAY button. An icon will display in the Document Number field to highlight Cancels, Move Ins and Move Outs.
On Hand	The starting On Hand inventory. Allocations have not been removed from this number.
Allocated	Quantity Allocated
Available	On Hand – Allocated
Open POs	Total quantity on POs
Unfulfilled Sales	Total quantity on unfulfilled sales lines
Released MOs	Total quantity on released MOs
Unfulfilled Picklists	Total quantity remaining on picklists
Free Forward	ATP quantity on the last calculation date
Free Forward Date	The first date after which there are no inventory shortages. The Date will be zero if there are no shortages at any point, and it will also be zero if there is only shortage. The Free Forward Quantity and the Free Forward Date combined tell you the earliest date and quantity you could provide a customer if no changes are made to existing orders.
Purchasing Lead Time	If the INV Sites restriction is not used, the item’s Default Site is used (from Item Quantities Maintenance) if present, if not the All Sites record is used. If the INV Sites restriction is used and there is one site, that site is used. If there are multiple sites specified it will use the Item’s Default Site if one exists, or the first site alphanumerically from the INV Sites window. This applies to MFG Lead Time, Buyer ID and Planner ID below.
Mfg Lead Time
Buyer ID
Planner ID
Scrolling Window Fields	Information
Date	Either the Date Required (i.e. Sales Requested Ship Date, or Start Date for Picklist), or the Date Due (i.e. MO Due Date), or PO Current Promise Date.
Type	INV OH = Inventory On Hand INV SS = Safety Stock IV Trx = Inventory Transaction or Transfer Mfg MO = Manufacturing Order Mfg PL = Manufacturing Picklist MRP Cancel = MRP Suggested Cancel MRP Move In = MRP Suggested Move In MRP Move Out = MRP Suggested Move Out MRP MO = MRP suggested MO MRP PL = MRP MO Picklist MRP PO = MRP suggested PO POP = Purchase Order SOP = Sales Transaction SVC = Service Call or Work Order parts requirement SVC Trf = Intransit Transfer Unmet Fcst = Manufacturing Unmet Sales Forecast As shown below, the MRP lines will have a Black Dot to highlight that they are from MRP and represent Planned supply or demand vs. actual.
Document Number	The source document number = MRP Suggested Cancellation. The QTY will be set to ZERO to show the effect of cancelling the document. = MRP Suggested Move In. The document will be shown on the new date suggested by MRP. = MRP Suggested Move Out. The document will be shown on the new date suggested by MRP.
Quantity Out	Demand quantity (i.e. sales, picklists, service calls, etc).
Quantity In	Supply quantity (i.e. MOs, purchase orders).
ATP	Available To Promise. A running total of expected Available Inventory on that date.
Hold	Red Dot appears if the transaction in On Hold. Holds are shown for Sales Transactions, Purchase Orders, and Manufacturing Orders.
Date Type	A brief explanation of the date (i.e. Required Date, or Due Date).
Transaction Information	Displays additional information from the document: In-Transit Transfer: IO Site and Customer Name MO: MO Description POP: Vendor ID and Vendor Name SOP: Customer ID and Customer Name
Unit Price	From Sales Transactions
Yellow Box ATP	Indicates the ATP is above the Order Up To Level.
Red Box ATP	Indicates the ATP is below zero.

The Quantity In and Quantity Out can be changed, and the window recalculated with the new values. You might do this to see the effect of changing a PO, or MO. Change the quantity to the desired value, then click the CALC button. Changing a value here does not change the actual document, it only changes it on the window.

REDISPLAY refreshes the window using unchanged data.

MRP lines (MRP MO and MRP PO) can be opened in the MRP-Planned Orders window. Select an MRP line then click the Document Number zoom. If you change the Quantity In first, the new quantity will appear on the MRP-Planned Orders window. This provides the ability to override an MRP suggestion and either increase or decrease it as needed.

MRP Information

MRP suggestions (Manufacturing Orders and Purchase Orders) are highlighted with a black dot.

MRP suggested Cancels, Move-Ins and Move-Outs can also be included.

PowerATP will show Cancels for the displayed item (such as BA100G) and also if the item is required by a Picklist for an MO that has an MRP suggested Cancel. This is shown above with MO0082 (100XLG). The quantity on Cancel lines will be set to zero to show the impact of cancelling the document.

Create MO

The first step to creating an MO from PowerATP is to add a Planning Line to the display.

Click the Add Planning Line Button, shown above.

If the selected item has a Manufacturing BOM, the Doc. Type will default to MANUFACTURING. Enter a Date and Quantity. The PowerATP functions in the Item’s Base Unit of Measure. NOTE: if the cursor is in an existing line in the ATP window, the New Document Entry window will pull in the Date and Quantity from that line as default values. Click SAVE to add the Planning Line.

Locate the Planning Line and confirm it has the desired effect on ATP for that date. Select the line, then click Create >> Create Manufacturing Order.

An MO will be created for the selected Item and Quantity, and will open automatically in the MO Entry window.

Create PO

The first step to creating a PO from PowerATP is to add a Planning Line to the display.

Click the Add Planning Line Button, shown above.

If the Item has a Manufacturing BOM, the Doc. Type will default to “Manufacturing” , otherwise it will default to “Purchasing”. You can change the Doc. Type as needed.

Enter a Date and Quantity. PowerATP functions in the Item’s Base Unit of Measure. NOTE: if the cursor is in an existing line in the ATP window, the New Document Entry window will pull in the Date and Quantity from that line as default values.

Click SAVE to add the Planning Line.

Locate the Planning Line and confirm it has the desired effect on ATP for that date. Select the line, then click Create >> Create Purchase Order.

The Create PO window will open. Review the information to be used to create the PO, or make changes as needed.

Unit of Measure: It will look for a default Purchasing Unit of Measure. If none is found, it will use the Base Unit of Measure. If the Purchasing U of M is not the Base U of M, the Quantity will be rounded up, if necessary, to the next whole unit of the Purchasing U of M.

If the Item allows quantity decimal places, but the Purchasing Options required WHOLE units, the quantity will be rounded up to the nearest whole unit.

Site ID:

• If no Inventory Sites are specified on the Option Set, it will look for a Default Site on the Item Quantity Maintenance window. If there is not a Default Site, the Location Code field will be blank and must be entered manually.
• If one site is specified in the Option Set’s Inventory Sites, that site will be used for the PO.
• If multiple sites are specified in the Options Set’s Inventory Sites, if the list of Sites includes the Item’s Default Site, the Default Site will be used. Otherwise the Location Code will be blank and must be entered manually.

Vendor ID:

• If a Site was found, an attempt is made to find the Primary Vendor assigned to that Item-Site.
• If no Primary Vendor is assigned to the Item-Site, an attempt is made to use the Last Purchase Vendor for that Item-Site.
• If no Last Purchase Vendor exists, the FIRST Vendor is retrieved from the Item-Vendors table.
• If no Vendor is located the Vendor ID field will be blank.

Buyer ID: if a Buyer ID is defined on Item Resource Planning for the selected site, it will default to that value.

PO Number: if there are open POs for the selected Vendor, this field will be enabled. If there are no open POs, the field and lookup will be locked, and a NEW PO will be created. If there are open POs, leave the PO Number blank if you want to create a new PO.

Open PO for Review: when marked, the PO will open in PO Entry after it is created. When un-marked, the PO will be created in the background and the create PO window will close when it is finished.

When ready, click the CREATE PO button. You will be asked to confirm you are ready.

NOTE: GP Manufacturing must be installed to use the Create PO functionality.

Accessing from other windows

• MRP Quantities Query: click on a row in the scrolling window then Additional >> PowerATP
• Pegging Inquiry: Additional >> PowerATP
• MRP Workbench: Additional >> PowerATP
• MRP Projected Available Balance Inquiry: Additional >> PowerATP
• Purchase Request Resolutions: click on a row in the scrolling window then Additional >> PowerATP