Customization CR1006
Parts List Utility
Description of Need:
ACME needs to report on components within a top-level item, in the manner shown below. Rather than an “Exploded BOM,” this is more of a “Parts List.”
ACME will need to run … more...
Category: Inventory
Customization DS1262: Discontinued Inventory
Customization DS1262
Discontinued Inventory
Problem Definition:
ACME uses Dynamics GP. When they discontinue an item, they need to ensure they sell the remaining inventory of the item before transitioning to its replacement, and they need to ensure the replacement item … more...
Customization CR1348: Kit Window Security
Customization CR1348
Kit Window Security
Description of Need:
ACME uses Inventory Kits. In addition to users who create/edit/maintain the Kit setup, there are other users who need to view the Kits. Since Dynamics GP does not have a Kit Inquiry … more...
Customization CR0971 Consignment Transfer
Customization CR0971
Consignment Transfer
Description of Need:
ACME sells/fulfills inventory out of Consignment Sites. When an Order is entered it allocates inventory in the primary site called ITASKA. When the order ships, they unallocate each line, transfer the inventory to … more...
Customization CR1196 – MFG Auto-allocation from Multiple Bins
Customization CR1196
MFG Auto-allocation from Multiple Bins
Description of Need:
When Manufacturing Allocates inventory it does so only from the Default Material Issue Bin set up on the Item-Site. If there is not enough inventory in that bin, the user … more...
Customization DS1115- WIP Cost Reversal
Customization DS1115
WIP Cost Reversal
Problem Definition:
ACME builds water dispensers. Some units contain high value assemblies which are treated as capital equipment, so the value is not in an inventory account. When these assemblies are used on a manufacturing … more...
Customization DS1452 Lot Adjustment
Customization DS1452
Lot Adjustment
Problem Definition:
ACME uses Dynamics GP lot tracking on their inventory items. Sometimes during stock counts they will find that a Lot Number is incorrect in GP for the physical inventory counted, so they need to … more...
Customization DS0835 Return Item Number Swap
Customization DS0835
Return Item Number Swap
Problem Definition:
ACME has a Salesforce.com integration into GP. When a piece of equipment is pulled from a customer‘s home and returned, it is currently coming back into the system as the same Item … more...
Customization DS1192 IV Adjustment Number in GL Header Reference
Customization DS1192
Inventory Adjustment Number in
GL Header Reference
Problem Definition:
When Dynamics GP posts an Inventory Transaction to the General Ledger, the GL Transaction Header “Reference” field contains “Transaction Entry”, as shown below:
ACME would like the Reference Field … more...
Customization CR1206- Lot Number Suffix by Receipt
Customization CR1206
Lot Number Suffix by Receipt
Description of Need:
ACME can receive multiple receipts of the same Lot Number over a period of time. They need to be able to select Lots for use in Manufacturing by the order … more...
Customization DS1068 Always Backorder
Customization DS1068
Always Backorder
Acme would like to be able to enter a Sales Order, and always have the quantity backordered, even if there is availability.
When they are ready to ship an order, they allocate the order … more...
PO Receipt User-Site Restriction
Customization DS1184
PO Receipt User-Site Restriction
Problem Definition
At any given time, Acme, Inc. will have a large number of open Purchase Orders and In-Transit Transfers for each of their multiple locations. The large volume of open transactions makes using … more...
Customization DS1261 Historical Stock Status with Lot Numbers
Customization DS1261
Historical Stock Status with Lot Numbers
Acme, Inc uses Microsoft Dynamics GP. Dynamics GP provides a Historical Stock Status Report by Item Number, but Acme needs Lot Number level detail.
A new Historical Stock … more...
Price List by Store
VT1257
ACME sells landscaping products, such as stones and pavers. They have numerous stores in their State. Due to the difference in the cost of transport to get materials from the manufacturer or quarry to the different stores, each store … more...
Consignment Inventory
DS1007
Consignment Inventory
Problem Definition
ACME Co makes generator powered lighting units used on construction sites. Each unit is lot numbered, and there is a quantity of 1 for each lot number (the lot numbers are effectively serial numbers). The … more...
Pro Forma Invoicing
Summary of Requirement
ACMECO makes innovative carrying solutions for the imaging world. These are specialized backpacks, shoulder bags, camera pouches, rolling cases, etc., designed specifically for the needs of photographers and videographers.
Their worldwide distributors place orders on Business Portal, … more...
Material Test Report
Summary of Requirement
ACMECO manufactures equipment for Oil and Gas drilling. The materials used (steel) in the manufacturing process have a large amount of testing data associated with each Lot Number that need to be tracked from purchasing through to … more...
Smart Bin Lookup
Summary of Requirement
ACMECO manufactures forged steel pressure flanges. The materials used include alloys, stainless, and carbon. The material in stock has a wide range of physical attributes, some of which are coded into the Item Number. To fulfill customer … more...
Tracking Eaches Selling Feet
Summary of Requirement
ACMECO sells drywall and other building materials. The products are purchased from vendors in many different units of measure, but are always treated as “eaches” by ACMECO.
For example, drywall is purchased per Thousand Board Feet, but … more...
Manufacturer Representative
Summary of Requirement
ACMECO sells direct (where they act as a distributor), and also as a representative of a manufacturer. In the rep sales, ACMECO receives a commission from the manufacturer for the sale, but manufacturing, order fulfillment and invoicing … more...
Granite and Marble Slabs
Summary of Requirement
ACMEco imports and sells granite slabs. Granite is shipped in a Bundle, which contains a number of Slabs granite where the total square footage contained in the Bundle is about 300 square feet. A Slab is approximately … more...
Internal Inventory Sales Transactions
Summary of Requirement
ACME Co. uses Sales Transactions to record internal transfers of material between facilities, however the process is highly manual and time consuming.
Their current process entails the following:
- A Sales Order is entered into the System.
- The
MFG and RMA Item Revision Levels
Summary of Requirement
ACME Co. plans to purchase two WilloWare products:
- Purchase Order Revision Levels
- Sales Order Revision Levels
In addition to the functionality that these two products provide, ACME requires additional features:
- ACME would like the current Item Revision
Current Costs By Site
DS0796
Item Current Cost by Site
Problem Definition
ACME Co utilizes Dynamics GP with a multi-Site environment. Dynamics GP stores each Item’s Current Cost at the Company level. ACME Co requires the ability to track an Item’s Current Cost by … more...
Lot Number Selection In Alternate U of M
Summary of Requirement
ACMECO uses lot numbered inventory in Dynamics GP. While the main transaction windows in GP can use any unit of measure from the Item’s Unit of Measure Schedule, the Lot Number selection windows are all in the … more...
Multi Bin & MO Receipts
Summary of Requirement
ACME Co. makes nutritional supplements and drinks. There are two areas of need.
Multi-Bin Enhancements
GP is being implemented with multi-bins where each bin represents a different physical location. Bins are being used in this manner so … more...
SOP Hold Removal Auto-Allocation
Summary of Requirement
ACME CO. uses a Sales Process Hold ID that prevents Fulfillment. This hold is used while final determination is made of the quantity the customer will order. The hold also prevents allocation.
When ACME removes the Hold, … more...
Automated Lot Transfer
Summary of Requirement
ACME Co. needs to prevent accidental transfer of inventory from a QA location into “released” inventory. The need the following:
- Users should have the ability to indicate the status of a Lot is “released”.
- Once a Lot
Long Serial Numbers
Summary of Requirement
ACME Co. has some items with Manufacturer’s Serial Numbers (or Lot Numbers) up to 40- characters in length. These Ser/Lot Numbers need to be printed in Sales Transaction Entry.
When the long Ser/Lot items are received in … more...
Assembly Serial Entry & Field Service Enhancements
Summary of Requirement
ACME Co. produces serial numbered units with several serial numbered subassemblies. Many of these items are from subcontractors and never go through ACME inventory.
GP Manufacturing is used to produce the complete unit, and many of the … more...
Inventory Transfer User-Site Security
Summary of Requirement
ACME Co. develops and manufactures molecular diagnostic tests.
When QA controlled material is received, it is put into a QA site in GP. Since there are no restrictions on which sites users have access to, and different … more...
Historical Inventory Valuation and Historical Lot Numbers Reports
Summary of Requirement
ACME Co.’s activities include fishing, trading, processing and marketing with offices and operations in strategic locations around the world. Their customer base includes famous brands, tuna processing plants and fishing companies.
They currently utilize Dynamics GP with … more...
Sync Item Resource Planning Replenishment Method to Item Engineering
Summary of Requirement
ACME has found that their Item Engineering Data and their Item Resource Planning records are not in sync. ACME would like the Item Engineering Data window “BOM Should Treat As Field” to be the master control for … more...
Automatic Backorder, Allocation and Fulfillment
Summary of Requirement
ACME Co. utilizes an EDI system to import the majority of their Sales Order Documents into Dynamics GP. Based on the rules of their EDI system, all Order ID’s have been set up to “Allocate by Line” … more...
Quick MO Automation
Summary of Requirement
ACME Co. currently utilizes Dynamics GP to manage and support Inventory Control. In conjunction with the Inventory Control module they also use Manufacturing. The manufacturing process handles make to stock counter tops (a.k.a. Granite Slabs) and sinks … more...
Item Stock Inquiry
Summary of Requirement
ACME Co. is a Contract Research Organization (CRO) who utilizes Dynamics GP as its ERP system. ACME’s Supply Chain group frequently utilizes the Item Stock Inquiry window. The Item Stock Inquiry window defaults the quantities displayed to … more...