Inventory Control: Microsoft Great Plains Dynamics GP tables structure

Inventory Control: Microsoft Great Plains Dynamics GP tables structure – Alba Spectrum

Alba Spectrum Group, http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577

This article is not intended to be distributed in open press, we at Alba Spectrum have copyrights and do not allow anyone to republish it outside of www.albaspectrum.com

Microsoft Dynamics GP tables structure is pretty complex and you should seek professional GP technical consultant help if you can not figure out you technical questions within your company IT department. You should be aware that such tables as IV10200 play important role in the following SOP cost calculation process, even if you think this table is gone to history. The inventory control architecture dilemma:

IV tables have to help in Sale Order Processing (SOP tables, such as SOP30200 and SOP30300), Purchase Order Processing (POP tables, such as POP30300 and POP30310 plus POP30330 – lot number and POP30700 – landed cost tracking history table). This fact makes IV historical data conversion table too complex and probably not feasible outside of the realm of Microsoft Dynamics GP Integration manager
Inventory Master Tables: IV00101, IV00102. If you plan to analyze IV00102 inventory item QTY master table then please know the following trickL

Select * from IV00102 where LOCNCODE like ‘ %’ will give you the qty records, in all GP sites (where LOCNCODE is blank)

If you need SQL scripting where you import landed cost (good example would be integration with Microsoft RMS (Microsoft Retail Management System))

Alba Spectrum Group: http://www.albaspectrum.com help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Microsoft Dynamics GP Great Plains customers in USA/Canada nationwide. Local service is available in Dallas and Houston, TX: Richmond, Sugar Land, Katy, Rosenberg, Missouri City, Pearland, Friendswood, Meadows, Mission Bend, Jersey Village; Chicago, IL: Naperville, Aurora, Bolingbrook, Romeoville, Joliet, Wheaton, Lisle, Downers Grove, Schaumburg, Elk Grove, Lombard, Woodridge, Darien, Westmont, Batavia, St. Charles, Elgin, Crystal Lake.

International: Brazil-English Brasil-Portuguese

We serve large scale Microsoft Dynamics GP Great Plains Customization, Data Conversion/Massage/Migration, version upgrade, custom software development and integration to GP, heterogeneous reporting for GP: SQL Server Reporting Services, Crystal Reports; Visual Studio.Net programming for GP, including eConnect, ADO to GP database; complex GP data repair (when somebody damaged GP data via inaccurate UPDATE SQL statement)