Home » TIPS AND TRICKS BY MODULES » Inventory
Top Websites
- Mark Polino's DynamicAccounting.net
Over 5100 resources listed. - Dynamics GP Help
Over 1700 resources listed. - Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
Over 900 resources listed. - Mariano Gomez at The Dynamics GP Blogster
Over 700 resources listed. - Microsoft Dynamics Partner Community Blog
Over 700 resources listed. - Mohammad Daoud's Dynamics GP Blog
Over 500 resources listed. - Vaidy Mohan at Dynamics GP - Learn & Discuss
Over 400 resources listed. - Inside Microsoft Dynamics GP Official Blog
Over 400 resources listed. - Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
Over 300 resources listed. - eOne Business Solutions Blog
Over 300 resources listed. - Frank Hamelly at GP2theMax
Over 300 resources listed. - About Dynamics, Development and Life
Over 300 resources listed. - Dynamics CPM
Over 200 resources listed. - Rose Business Solutions Blog New
Over 200 resources listed. - Janakiram M.P. at DynamicsBlogger
Over 100 resources listed. - Victoria Yudin's Dynamics GP Website
Over 100 resources listed.Victoria Yudin - VS Tools Forum
Over 100 resources listed.Your Resource for Visual Studio Tools for Dynamics GP - Inside Microsoft Dynamics GP Official Blog
Over 100 resources listed. - Leslie Vail at Dynamics Confessor Blogspot
Over 100 resources listed. - BKD Dynamics GP Insights Blog
Over 100 resources listed. - US Dynamics GP Field Team Blog
Over 100 resources listed. - Catherine Eibner MBS Developer Evangelist
Over 100 resources listed. - Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
Over 100 resources listed. - Dynamics Small Business
Over 100 resources listed. - Belinda, The GP CSI
Over 100 resources listed.
Useful Dynamics GP Links
Search all GP Blogs, Groups and Forums New!
GPWindow is Everything Dynamics GP. Try the Custom GP Search engine which searches high quality GP Blogs, and the Microsoft Dynamics GP Community Forums.
Parent Category: Inventory
Links Sort by: Hits | References | Alphabetical
gptip42day - Inventory Site Segment
http://gp2themax.blogspot.com/2009/11/gptip42day-inventory-site-segment.html
If you stock inventory in mutiple warehouses (Sites) and want to utilize Site-specific inventory accounts, GP provides a way to automatically code inventory transactions to the proper accounts based on the Site ID where the transaction occurs. Here's how it works. Go
Cards>Inventory>Site
* click iamge to enlarge
When you define a Site, you can enter an account segment for the Site. This allows the Site’s account…
Posted by
Week 3: Did you know? Series of the Week
http://blogs.msdn.com/gp/archive/2009/06/27/week-3-did-you-know-series-of-the-week.aspx
Weekly, the Dynamics GP team will be posting a ‘Did you know?’ series. We’ll give tips, tricks, and general comments around features and functions that already exist in Microsoft Dynamics GP. This week we will focus on the HITB.
Our challenge to you is…how much do you really know about Dynamics GP?
The Historical Inventory Trial Balance (HITB) report shows your inventory value as of a specific date or date range and the value of the…
Posted by
To Check or Not to Check: Understanding Landed Cost's Invoice Match and Revalue Inventory Options in Microsoft Dynamics GP
http://dynamicsgpblogster.blogspot.com/2008/07/to-check-or-not-to-check-understanding.html
Dynamics GP presents two selection options in the Landed Cost Maintenance screen: Invoice Match and Revalue Inventory. These two options have profound accounting effects in how inventory and purchases are tracked in GP. The following is provided as is and was posted by Marge Swanson, Senior Software Development Engineer at Microsoft in response to a user's question on the Dynamics GP community board, but I felt it was important to rescue as it contains valuable information not found in the manuals or elsewhere:
You should determine whether or not to mark the Invoice Match checkbox based on how you want your distributions to be tracked for the Landed Cost. If you do not mark Invoice Match, the distributions will be reversed from the accrued purchases account used on the Shipment – which defaults from the Landed Cost card. If you mark Invoice Match, the distributions will be…
You should determine whether or not to mark the Invoice Match checkbox based on how you want your distributions to be tracked for the Landed Cost. If you do not mark Invoice Match, the distributions will be reversed from the accrued purchases account used on the Shipment – which defaults from the Landed Cost card. If you mark Invoice Match, the distributions will be…
Posted by
Tips on Discontinued Items
http://mohdaoud.blogspot.com/2010/03/tips-on-discontinued-items.html
When you need to inactivate one of your inventory items, your only available option is to change the item type to discontinued, in Item Maintenance:
Logically, discontinued items that has quantity on hand must give users the…
Posted by
List of inventory items that have not sold between two dates
http://mohdaoud.blogspot.com/2008/11/list-of-inventory-items-that-have-not.html
View below list the inventory items that have not sold between two dates:
SELECT IV00101.* FROM …
SELECT IV00101.* FROM …
Posted by
gptip42day - Applying Labor to an Inventory BOM Item
As you may know, the Inventory BOM is a great little tool for accumulating assembly costs for simple, single-level manufactured items. However, the IV BOM does have its limitations. It's generally useful for capturing only the material component of assembly costs. But, all is not lost. If you want to incorporate labor costs into your IV BOM Assemblies (and/or overhead costs, for that matter), here's a way to do it.
http://gp2themax.blogspot.com/2009/11/gptip42day-applying-labor-to-inventory.html
As you may know, the Inventory BOM is a great little tool for accumulating assembly costs for simple, single-level manufactured items. However, the IV BOM does have its limitations. It's generally useful for capturing only the material component of assembly costs. But, all is not lost. If you want to incorporate labor costs into your IV BOM Assemblies (and/or overhead costs, for that matter), here's a way to do it.
Simply setup an item and call it 'LABOR' or some other descriptive item number. Set the item as a 'Services' Type so you don't have to worry about inventory shortages, as quantities are not tracked for Service items.
Cards>Inventory>Item
*click image to enlarge
Set your other required fields as desired and set a Current Cost per unit of Labor. You can also set a Standard Cost to use as a comparative value as…
Posted by
gptip42day - Understanding Inventory Unit of Measure
Let's make this really simple. Say your company buys and sells automotive shock absorbers. You stock them as 'EACH', buy them by the 'DOZEN', and sell them in 'PAIRs'.
http://gp2themax.blogspot.com/2009/10/gptip42day-understanding-inventory-unit.html
Let's make this really simple. Say your company buys and sells automotive shock absorbers. You stock them as 'EACH', buy them by the 'DOZEN', and sell them in 'PAIRs'.
Stocking UOM = EACH
Purchasing UOM = DOZEN
Selling UOM = PAIRs
Here are the UOM Schedules for shock absorbers -
EACH
* click image to enlarge
DOZEN
* click image to enlarge
PAIR
*…
Posted by
gptip42day - Non-Inventory Sales Item Distribution Error
Okay, I'm sneaking this one in just under the wire today but here it is.
http://gp2themax.blogspot.com/2009/09/gptip42day-non-inventory-sales-item.html
Okay, I'm sneaking this one in just under the wire today but here it is.
A client ran into a posting issue today on an SOP Invoice. This issue seems common to users who only occasionally process non-inventory sales invoices. Although everything on the invoice appeared to be correct, she kept getting a missing distribution account error on the posting journal and couldn't recall how to resolve it. Here's the key -
When entering a non-inventory…
Posted by
gptip42day - Inventory 'Change Valuation'
http://gp2themax.blogspot.com/2009/09/gptip42day-inventory-change-valuation.html
Sometimes it is necessary to change the valuation method on one, many, or all of your inventory items. This can be due to an item having been setup incorrectly or perhaps a management decision to change the inventory valuation method from say, Average Perpetual to FIFO Perpetual.
GP provides a means to accomplish this -
Tools>Utilities>Inventory>Change Valuation
* click image to enlarge
1. Select a new Valuation…
Posted by
FIFO/LIFO Perpetual Stock Status Report
http://gp2themax.blogspot.com/2009/07/fifo-stock-status-report.html
Using FIFO or LIFO Perpetual to value your inventory? Want a Stock Status report that ties back to your GL balance?
Modify the Purchase Receipts report to sum the quantity fields in the…
Modify the Purchase Receipts report to sum the quantity fields in the…
Posted by
Feature of the Day: Inventory Auto Lot Numbers
http://blogs.msdn.com/gp/archive/2010/02/15/feature-of-the-day-inventory-auto-lot-numbers.aspx
Inventory Auto Lot Numbers
Module: Inventory
Why this feature is cool!
· Allows users to setup a pre-defined lot mask for designated items
· Provides the ability to…
Posted by
Kits and BOMs and Components, Oh My!
http://dynamicsgpland.blogspot.com/2009/07/kits-and-boms-and-components-oh-my.html
Posted by
From The Community #6 – Non Inventory Items and GL
http://rldu.wordpress.com/2010/05/21/from-the-community-6-non-inventory-items-and-gl/
A question in the Dynamics GP forums was posted on the following issue: “Hi, Would like to know how to…
Posted by
Weekly Dynamic: Prevent the Sale of Discontinued Items
http://msdynamicsgp.blogspot.com/2009/08/weekly-dynamic-prevent-sale-of.html
In Dynamics GP users can discontinue items in Inventory. Discontinued items can still be sold but not bought. This gives companies the options to work through obsolete inventory. But sometimes companies don't want to be able to sell discontinued items. There could be safety issues…
Weekly Dynamic: Copy an Inventory Item
http://msdynamicsgp.blogspot.com/2008/11/weekly-dynamic-copy-inventory-item.html
Let's say that your company has just added an inventory item that is very similar to an item already in stock. Do you really have to go through the full inventory setup? I know, Item Classes help a lot but it's Friday afternoon, can't inventory setup be even…
Posted by
Dual Personality: Inventory Transfer Entry
http://dynamicsgpland.blogspot.com/2010/05/dual-personality-inventory-transfer.html
What do you think of when I say "Inventory Transfer Entry"? If you are like most folks, you think of the window that allows you to transfer an item from site to site. But, actually, that window is Item Transfer Entry (TransactionsInventory). Inventory Transfer Entry is actually a project accounting window (TransactionsProject) with a variety of uses.
If you use Project Accounting with Inventory, you are most likely familiar with this window as the next step after receiving an item associated with a project. The purchasing and inventory process for project accounting looks something like this:
- Record purchase order for inventory item and associate it with a project and cost category, which increases the committed cost on the project budget.
- Receive the purchase order, which decreases committed cost.…
Posted by
Weekly Dynamic: Specific Item Costing
http://msdynamicsgp.blogspot.com/2010/08/weekly-dynamic-specific-item-costing.html
I ran into a situation recently where a client needed specific item costing for each product that they sell. This is most common for serialized items where there is a single item number but specific costs need to be applied for each serialized…
New Items or Site added to Inventory 
Don’t worry, I’m not suggesting you do it one item at…
http://belindaallen.blogspot.com/2010/08/new-items-or-site-added-to-inventory.html
If you are in a situation where you’ve added a lot of inventory items, you can save yourself or invoice entry people a lot of time by assigning them to a site right away.
Don’t worry, I’m not suggesting you do it one item at…
Posted by
In Defense of Classes (Inventory)
http://dynamicsgpland.blogspot.com/2010/08/in-defense-of-classes-inventory.html
So, last week I was on phone support (which sometimes happens when the stars align and our regular support folks actually want to take the vacation they have earned), I had a case come through that was a great reminder of the benefits of classes in Dynamics GP.
Of course, there are the generally accepted benefits:
Of course, there are the generally accepted benefits:
- Provide defaults for new records
- Roll down changes to records
- Group records for reporting and other processes
In all modules except Fixed Assets, classes are completely optional. However, there are some very practical reasons to use classes which I was reminded of this past week. First, let's talk inventory. When you set up an item from scratch, using CardsInventoryItem, the maintain history checkboxes are not…
Posted by
How to determine, maintain, and report accurate costing in Inventory in Microsoft Dynamics GP 9.0 and 10.0
http://greatplainsguy.blogspot.com/2009/07/how-to-determine-maintain-and-report.html
Latest links
- Website is down...but not for long!
- “Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013” is almost here
- Doug Pitcher’s OFFICIAL 100 most famous, awesome and totally influential Dynamics people for 2013
- Rob Collie’s Open Letter to My Friends at Microsoft: The Power of Excel’s Internal Network Effect « PowerPivotPro
- Using Maps to Visualize Data in SQL Server Reporting Services Reports | Dynamics GP Insights
- Dynamics GP Land: Dynamics GP 2013 appears to still have bug in Payables EFT CTX File Format
- Dynamics GP 2013 FAQ: How to Run File Maintenance. – Etelligent Solutions
- Error message -Could not find a part of the path when publishing Excel Report Builder report in GP
- Warning “Sales Order Processing and Invoicing are both installed” in Microsoft Dynamics GP
- SOP Quote Warning -Line item quantities are not fully distributed. Do you want to continue ?
GPWindow.com
Developed and presented by
Smith & Allen Consulting, Inc.,
GP specialists since 1991.