Using multiple bins in Microsoft Dynamics GP Inventory Control (With Video)

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.

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!

Author: Belinda Allen

Belinda Allen (Microsoft MVP) is both a Microsoft Certified Professional for Dynamics GP (MCP) and a Microsoft Certified Trainer (MCT). She is also the co-founder of Smith & Allen Consulting, Inc. (www.saci.com), a business management software consulting firm for over 24 years. Belinda began implementing ERP systems so long ago that Windows was not an operating system, but an application. Larger businesses used old Main Frames with monitors that were Green and Black and smaller business did accounting by hand. Having seen the evolution that has taken place over the years from pieces of paper to analytics, Belinda still gets excited every time she helps a business improve. Belinda is also well known for her Blog www.BelindaTheGPcsi.com. Her blog is about sharing really useful information about the product quickly and succinctly. She has earned the nickname GP CSI because she excels at reviewing GP problems and figuring what went wrong and why. With followers all over the Globe she is able to share knowledge and achieve her mission: “To Improve the Lives and Business Success of my Followers.” In her time off, Belinda enjoys sailing, woodturning, crochet/knitting, sewing/quilting, reading and playing the ukulele (Belinda often participates in Ukulele Jams in NYC.) View all posts by Belinda Allen