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…

Stumbled across this little gem of an article when trouble-shooting my inventory costs.…

We have received a number of recent queries about the difference between Inventory Assembly Bill of Materials, Manufacturing Bill of Materials, and Kits.

From the simplest to the most complex, Kits:

Kits are transparent in inventory. Only the component quantities exist in inventory; the kit is assembled at the moment of sale, i.e., when the invoice is posted. Kit components can be swapped in and out.

The system will automatically open the Sales Quantity Shortage Options form if any component is not in…

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…

Adjust Costs.

It looks like a simple enough tool and it does exactly what you tell it to do. However, read on, what it does may not be exactly what you want it to do. Here's what it does. Say you have a purchase receipt that went through the system at $1465. Several of the items were sold but now the inventory is obsolete and the powers that be task you to write it off. They still want the items in inventory in case they can sell…

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…

Hello,
Like to share a very nice article from Microsoft which help to udnerstand how the Inventory Costing does in Dynamics GP 9.0 and 10.0 and how we can determine the Inventory Costing .

E…

During a normal implementation, customers using the Inventory module are faced with testing numerous transaction scenarious prior to going live with their Dynamics GP system. However, the conversion to the live company requires transfering the Inventory Master tables, including the Item Quantity Master (IV00102) table. This table hosts the Quantity On Hand and Quantity Available fields per site which can already be affected by the transactions previously tested.

In order to reset the values in these fields without any SQL…

Historical Inventory Trial Balance Report

Microsoft Dynamics GP recently came out with a new feature that would provide GP users that are utilizing the Inventory Module the ability to create a Historical Inventory Trial Balance report. It goes without saying that any company maintaining an inventory has had reconciliation issues between the valuation in the Inventory Module and the General Ledger control account or accounts. The HITB features will allow the following:

• The Historical Inventory Trial Balance report enables users to tie the Inventory Sub-ledger to…

View below list the inventory items that have not sold between two dates:

SELECT IV00101.* FROM …

In MS Dynamics GP, items can have several units of measure and any of these units can be…