Inventory Management in Microsoft Dynamics GP

Give your business a competitive edge. By gaining accurate visibility and effective control over inventory and setting prices on a customer-by-customer basis, you can reduce operating costs and achieve the fast, efficient fulfillment that keeps customers coming back.

Inventory Management in Microsoft Dynamics GP delivers easy-to-use stock analysis tools and flexible reporting capabilities, enabling rich access to detailed, consolidated inventory and ordering information. Advanced search capabilities provide quick, easy access to business-critical data. Onetime stock and pricing entry provides accurate and timely information throughout the system. All help maximize operational efficiency and give your people the information they need to make informed decisions fast.

Benefits

  • Keep customers coming back. Offer better service and improve customer satisfaction with accurate inventory control and customer-specific pricing and promotions.
  • Streamline processes. Gain tight control over processes using a cradleto-grave view of serial and lot numbers to quickly trace where and when the item appears in bills of materials, customer orders, or other transactions.
  • Track items across multiple locations. Improve picking efficiency with multi-bin tracking for primary and secondary stocking locations.
  • Negotiate with strength. Secure customer contracts with personalized pricing to meet customer demands and beat the competition, while maintaining the ability to change prices as needed.
  • Integrate smoothly. Inventory Management integrates with other Microsoft Dynamics GP modules— including Sales Order Processing, Purchase Order Processing, Invoicing, and General Ledger—to streamline mission-critical inventory and sales processes.

Features

  • Extended Pricing. Equip your sales team to improve customer satisfaction and beat the competition by creating flexible pricing options and rules for each customer. With extended pricing you can:
    • Create standard price schemes such as percentage-off, value-off, and net pricing, along with personalized pricing options.
    • Implement powerful date-sensitive functionality for sales and promotions.
    • Navigate the system using drill-down, zoom, and special menu capabilities that offer a fast learning curve and easy visibility into your pricing index.
  • Bill of Materials. Increase productivity by providing a superior solution for tracking the components and subassemblies used in light manufacturing and similar production and assembly operations. With bill of materials you can:
    • Define the exact order of your assembly process, up to 10 levels deep.
    • Attach electronic notes to bills to detail exact component use at every assembly level.
    • Track the actual cost for assembled items, plan for future changes, and manage current and past items.
    • Schedule transactions into the future without reserving stock.
  • Cradle-to-Grave Serial/Lot Tracking. Transform time-consuming searches into quick, efficient processes by identifying all instances of an item with a single trace. With cradleto-grave serial/lot tracking you can:
    • Increase visibility into serial/lot number lifecycles.
    • Conduct powerful searches using an item’s serial or lot number.
    • Complete widespread searches across all transactions, including bills of materials and customer orders.
    • Consolidate like lot numbers in all lot number entry windows to gain an accurate view of inventory for a given lot number—including manufactured date and expiration date—without juggling multiple records.
  • Shelf Life in View Use Shelf Life controls and automated alerts to ensure that expired lots are not selected for distribution.
  • Serial/Lot Number Tracking Initiate traces using an item’s serial or lot number and view where and when the number occurred in bills of materials, customer orders, or any other transaction.
  • Item Classing. Create and track the item information that’s most important to you with the ability to choose default entries for classes of items, such as color, style, and manufacturer.
  • Inventory Ranking. Prioritize sales stock with options to rank your inventory items by usage value, actual or project usage quantity, on-hand inventory value, or unit cost.
  • Quality Controls. Maintain complete control over your inventory with quantity tracking at the bin level, cycle counting, stock count calendars, and inventory snapshots.
  • Bin Lookups. Quickly determine which bin to use based on bin priorities and maximum capacities. Accept or override system recommendations.
  • Multi-Bin Tracking. Track a single inventory item across multiple bins within the warehouse to optimize picking efficiency.
  • Real-Time Moving Average Cost. Calculate an item’s current (average) cost—as many times as the purchase receipt changes. Simultaneously generate General Ledger adjustments for inventory items that use the Average Perpetual valuation method.
  • Instant Access to Transaction Information. Get instant information on all transactions related to any item you define in the inquiry windows—including lot number, price levels, and item type—and drill down as needed. Query originating documents, and then drill down for details about Field Service, Project Accounting or Manufacturing documents.
  • Document Transfer. Easily transfer item information from existing documents to new documents, including price lists, currency assignments and list price, site assignments, vendor assignments, and kit components.
  • Comprehensive Reporting Tools. Analyze all facets of your inventory with comprehensive standard reports, including Item List, Price List, Stock Status (positive, zero, or negative), and Turnover—all integrated with the flexible reporting power of Microsoft Dynamics GP modules such as Microsoft SQL Server  Reporting Services, Report Writer, and Crystal Reports.
  • Stock Count and Discrepancy Alerts. Maintain an accurate stock count schedule and investigate stock discrepancies quickly with system alerts that notify you when inventory is due for counting or when differences occur between an item’s reported status and warehouse presence. Stock Card Inquiry View historical inventory movements in the Item Stock Card window.
  • In-Transit Inventory Transfers. 
    • Input a middle site into the transfer process to allow for Via tracking to prevent salespeople from selling material that isn’t currently in the destination warehouse.
    • Accurate inventory quantities at both the From site and To site allow more realistic promise dates and improve inventory management.
  • Increased Lot Flexibility.
    • Notify employees when a lot is close to its expiration date, so they can determine the best course of action.
    • Inventory Control preferences offer optional password protection, so your people can control the selection of expired lots.
  • Historical Stock Status Calculations. Maintain histories of cost changes, including Average Perpetual, Last InFirst Out (LIFO) Periodic, and First In-First Out (FIFO) Periodic values.
  • Multiple Manufacturer Item Numbers. Enter multiple manufacturers’ part numbers for a single inventory item to speed purchasing of items.
  • Bill of Materials. Maintain full control over the assembly process with complete bills of materials to accurately define, track, and analyze how your inventory is used as part of your assembly operations.
  • Historical Document Print. Accurately track sales and purchase order lifecycles with minimal effort, using Print Documents windows to generate document histories.
  • Simplified Year-End Inventory Closure. Control Sold receipts and Cost Change History records by entering the desired end date.
  • Detailed Insight into Inventory Usage. 
    • More effectively analyze sales, transfers, and materials used for manufacturing by drilling down to each transaction that reduces inventory, including those in debited and credited accounts.
    • Access supply and demand information using Allocated and On Order drill downs and view item allocations in existing orders quickly and easily.
    • Narrow search results by providing date ranges for item transaction inquiries
  • Extended Pricing
    • Personalize pricing by combining date ranges and quantity break options with special net, percentage-off, or value-off pricing for specific customers or groups of customers.
    • Use relational pricing to update customer price lists instantly and reflect fluctuations with your supplier when you change your base net prices.
    • Choose the pricing method that works best for each item, including pricing by currency amount, percent of list, percent markup based on current or standard cost, or percent margin based on current or standard cost.
    • Make individual or mass updates to your pricing lists with helpful wizards.
    • Easily set up and maintain price lists using unlimited combinations of units of measure, price levels, and currencies.