This is all about how I use GP, based on what I learned in my investigations with clients...

Using multiple bins in Microsoft Dynamics GP Inventory Control

Posted by Belinda Allen on Feb 5, 2016 2:44:59 PM

Ever have a hard time trying to find a specific inventory item in your warehouse? If you said yes, you should be using the multiple bins feature in Microsoft Dynamics GP.

 InvetoryBottles.jpg

Think of bins as a shelf or an aisle, so with the combination of Site ID and bins you can walk right to your items. Default bins can be assigned to sites for transactions such as Purchase Receipts, Purchase Returns, Sales Order Fulfillment, Sales Returns, Assembly Receipts, Material Issues, Manufacturing Receipts and Repair Issues.

 

Let’s say you receive an item (from a PO) to your WAREHOUSE site. By default it is placed in a bin called “Receivings”. When your warehouse person moves the item to its proper place in the warehouse, a bin transfer is recorded in GP.   Yes, it is an extra step, but how big is your inventory site? How important is it to know exactly where that item is located? How much is your inventory worth?

 

If you choose to use multiple bins in GP, a bin must be specified for each and every transaction. The default site can be used or you can manually edit the bin in the transaction.

 

If you already use GP and want to start using bins there are a couple of very important steps that must occur:

  1. Perform a backup of your database.
  2. All Sales Order Processing transactions must be posted, deleted or voided.
  3. Perform a backup of your database.
  4. Check the Enable Multiple Bins in the Inventory Setup window.
  5. Perform a backup of your database.
  6. Run Check Links for all Inventory tables.
  7. Perform a backup of your database.
  8. Run Reconcile for Inventory Items
  9. Perform a backup of your database.
  10. Verify there is a Next Document Number in the Inventory Setup window.
  11. Enter bins for your sites.
  12. Specify default bins for your sites.
  13. Oh, and Perform a backup of your database.

 

Watch the video below for multiple bins in action!

Tags: GP, Inventory

Using a separate Fulfillment Process in Microsoft Dynamics GP

Posted by Belinda Allen on Jan 29, 2016 4:20:42 PM

In this Video I will show the various methods of fulfilling an Invoice in Microsoft Dynamics GP Sales Order processing.

Inventory.jpg

Tags: GP, Inventory, Sales Order Processing

Microsoft Dynamics GP – Inventory Item Reorder Dashboard (with video)

Posted by Belinda Allen on Nov 25, 2013 10:00:00 AM

This is part 4 of a 7 part series of Microsoft Dynamics GP Dashboards for Distribution presentation I did at the GPUG Summit in Tampa, November 2013.

 

In this video, I build an Excel Refreshable Report that shows when I need to reorder Inventory Items based on Item Quantities Maintenance and the Item Resource Planning Maintenance (Order-Up-To Level) in Microsoft Dynamics GP.  

 Belinda Allen of Smith & Allen Consulting, Inc. in New York, NY speaks at the Microsoft Dynamics GP User Group (GPUG) Summit in Tampa, FL 2013.

Dashboard for Distribution Series:

Part 1:  Microsoft Dynamics GP - Excel AR Trial Balance

http://saci.com/blogs/belinda-the-gp-csi/bid/154096/Microsoft-Dynamics-GP-Excel-AR-Trial-Balance-with-video

Part 2:  Microsoft Dynamics GP - Excel AR Trial Balance with SQL 

http://saci.com/blogs/belinda-the-gp-csi/bid/154097/Microsoft-Dynamics-GP-Excel-AR-Trial-Balance-with-SQL-with-video

Part 3:  Microsoft Dynamics GP - Excel Power Pivot SOP Dashboard

http://saci.com/blogs/belinda-the-gp-csi/bid/154098/Microsoft-Dynamics-GP-Excel-Power-Pivot-SOP-Dashboard-with-video

Tags: Inventory, Excel

Overview of Landed Costs in Microsoft Dynamics GP (with video)

Posted by Belinda Allen on Oct 17, 2013 10:30:00 AM

This video gives an overview of Microsoft Dynamics GP Landed Costs and their setup.  This includes both the Inventory Control and Purchase Order Processing modules.

This video gives an overview of Microsoft Dynamics GP Landed Costs and their setup.  Video by Belinda from Smith & Allen Consulting, Inc.

Tags: Purchase Order Processing, Inventory

Transfer Inventory to Fixed Assets in Microsoft Dynamics GP

Posted by Belinda Allen on Aug 7, 2013 10:05:00 AM

A Microsoft GP User sent me an email asking about how they can consume inventory items for use and how they can transfer inventory items to Fixed Assets.  For the second part, I found a fabulous blog posting from my friend and fellow Microsoft MVP, Mariano Gomez (the link is below).

This video is simply putting Mariano’s blog posting into action.  Thanks Mariano for this great answer to Jeanne’s question.

Mariano Gomez and Belinda Allen attending a Microsoft Dynamics GP technical conference.

See Mariano's Post here!

http://dynamicsgpblogster.blogspot.com/2010/03/moving-items-out-of-inventory-and-into.html

Tags: Purchase Order Processing, Inventory, Fixed Assets Management

In Use/Service/Return? Microsoft Dynamics GP Inventory (with video)

Posted by Belinda Allen on Aug 2, 2013 10:15:00 AM

If you have ever returned an item in Sales Order Processing in Microsoft Dynamics GP you know you asked to identify the status of the items returned. 

The options are:

  • On Hand
  • Returned
  • In Use
  • In Service
  • Damaged

 

How do these affect Inventory and when should you use each?  Watch this video and find out!

Belinda, from Smith & Allen Consulting, Inc. (SACI) in New York City, shows returns in Microsoft Dynamics GP.

Also note that in Microsoft Dynamics GP 2013, the Field Service Series gives you these same options in Returns Management.

Tags: Inventory, Sales Order Processing, Field Service

Bill of Materials Introduction - Microsoft Dynamics GP (with video)

Posted by Belinda Allen on Jul 30, 2013 2:18:00 PM

Here I’ll provide a brief demonstration on the functionality of the Bill of Materials module in Microsoft Dynamics GP Inventory Control. 

This video is in response to a comment I received on my blog posting about using Kits in Sales Order Processing.

Using Kits in SOP

With Bill of Materials you can use serial numbers on the items you create and you can stock them in Inventory.

Belinda gives a brief introduction to Microsoft Dynamics GP Bill of Materials.  Belinda is from Smith & Allen Consulting, Inc. (SACI) in New York, NY.

Tags: Inventory, Bill of Materials

Selling Kits in Microsoft Dynamics GP (with video)

Posted by Belinda Allen on May 16, 2013 10:20:00 AM

What is a Kit?  (THIS IS DIRECT FROM GP HELP)

An item type assigned to items that consist of other component items that are assembled at the time of sale. The kit is a single item with an item number; it consists of one or more component items in your inventory. Component items can be services, sales inventory, discontinued, miscellaneous charge, and flat fee items.

Kit items consist of other component items. Quantities on hand won’t be tracked for items you designate as kits. However, current costs are associated with these items, and the quantity sold will be tracked when the items are assembled at the time of sale. When you post a transaction that contains a kit item, amounts will be posted to the Sales account specified for the kit item and the Inventory account and Cost of Goods Sold account for each of the component items in each kit.

Even if you select Kit as the item type for a class of items, you can sell components as separate items if you want to.

So what does this mean to you?

I always use the example of buying a Big Mac at McDonald’s.   You buy a Big Mac and that is what you see on your receipt, 1 Big Mac.  McDonald’s does not keep Big Mac’s in inventory.  They do keep in inventory:

  • 2 All Beef Patties
  • Special Sauce
  • Lettuce
  • Cheese
  • Pickles
  • Onions
  • Sesame Seed Bun.

So when you buy a Big Mac, you are reducing their inventory for all of the above.  If you do not want Cheese on your Big Mac, your receipt will say “Big Mac w/no Cheese.”  Then you are reducing the following from inventory:

  • 2 All Beef Patties
  • Special Sauce
  • Lettuce
  • Pickles
  • Onions
  • Sesame Seed Bun.

This is a great way to offer promotions by combining items.  A good example of this is McDonald’s Happy Meals.  It consist of:

  • Hamburger
  • Small fries
  • Small Coke
  • Toy.

McDonalds can then capture how many burgers they sold (with and without the Happy Meal,) and independently track how many Happy Meals they sold.

 Belinda compares a Microsoft Dynamics GP Kit to a McDonald’s Big Mac.

I do not know what McDonald’s uses for an Accounting/ERP system, but if you use Sales order Processing, I’m sure you can think of a lot of opportunities by using Kits.  They are easy to setup and easy to use!

 

 

Tags: Inventory, Sales Order Processing

Use Microsoft Dynamics GP Inventory Returns Part 2(video)

Posted by Belinda Allen on Jan 15, 2013 9:30:00 AM

If you use Microsoft Dynamics GP Inventory Control, you may need to occasionally return some of these items to the Vendor (or Supplier) you purchased them from.  The Purchase Order Processing module can handle this for you using the Returns Transaction Entry window.  The return window will return any item entered as returned through Sales Order Processing (SOP) or any item entered in Inventory from Inventory Transactions.

Microsoft Dynamics GP Inventory Return from Customer to Vendor from Belinda, the GP csi.com

Type:

  • Inventory: This type allows you to reduce your Inventory quantities and inventory value.
  • Inventory w/Credit: This type allows you to reduce your Inventory quantities and inventory value AND issue and post a return in payables to reduce the amount you owe your vendor.  If you choose this option, you will still need to manually apply the return to the appropriate invoice using Apply Payables Document.

Check Boxes:

  • Replace Returned Goods: Checking this box indicates that you expect to receive replacements for the goods you are returning.  A PO will be created.
  • Invoice Expected for Returned Goods: If you choose the type “Inventory w/Credit” this option will be checked and dimmed out so you can change the field.

Use Microsoft Dynamics GP Inventory Returns Part 1 will follow and will cover the return types: Return and Return w/Credit.

Tags: Purchase Order Processing, Inventory, Sales Order Processing

Use Microsoft Dynamics GP Inventory Returns Part 1 (video)

Posted by Belinda Allen on Jan 14, 2013 9:30:00 AM

If you use Microsoft Dynamics GP Purchase Order Processing (POP) to receive Inventory Items, you may need to occasionally return some of these items to the Vendor (or Supplier) you purchased them from.  The Purchase Order Processing module can handle this for you using the Returns Transaction Entry window.

Microsoft Dynamics GP Inventory Returns by Belinda, the GP CSI.

Type:

  • Return: This type allows you to reduce your Inventory quantities and inventory value.
  • Return w/Credit: This type allows you to reduce your Inventory quantities and inventory value AND issue and post a return in payables to reduce the amount you owe your vendor.  If you choose this option, you will still need to manually apply the return to the appropriate invoice using Apply Payables Document.

Check Boxes:

  • Replace Returned Goods: Checking this box indicates that you expect to receive replacements for the goods you are returning.  If the original Purchase Order has not been moved to history, the quantity you expect will be added to the PO.  If the PO has been moved to history, a new PO will be created.
  • Invoice Expected for Returned Goods: If your vendor will issue an invoice for the original amount, a credit memo and another invoice for the new amount (if you choose to replace the goods) then check this box.  If you choose the type “Return w/Credit” this option will be checked and dimmed out so you can change the field.

Use Microsoft Dynamics GP Inventory Returns Part 2 will follow and will cover the return types: Inventory and Inventory w/Credit.


Tags: Purchase Order Processing, Inventory, GP 2013