Released on = May 17, 2007, 4:40 pm

Press Release Author = Alba Spectrum Group

Industry = Computers

Press Release Summary = Microsoft Great Plains is currently available on Microsoft
SQL Server database platform only, this makes SQL scripting to be simple enough and
feasible to practice, when integrating, reporting or doing data fixing for Microsoft
Great Plains. We already covered topics on Dexterity, eConnect, GP SDK Visual
Studio.net programming in earlier articles. In this small article we would like to
concentrate on SQL scripting

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

Microsoft Great Plains is currently available on Microsoft SQL Server database
platform only, this makes SQL scripting to be simple enough and feasible to
practice, when integrating, reporting or doing data fixing for Microsoft Great
Plains. We already covered topics on Dexterity, eConnect, GP SDK Visual Studio.net
programming in earlier articles. In this small article we would like to concentrate
on SQL scripting

Item Allocation example. For the reason of simplicity let's assume that the only
allocated quantity you have in Sales Order Processing orders and invoices and
disregard Inventory adjustments, transfers and other modules work transactions, then
the following script will give you discrepancy in allocation for the item master
record and the summary from Sales Order Processing work transactions lines:

select
a.ATYALLOC, b.ATYALLOC, a.ITEMNMBR
from IV00102 a
join
(
select ITEMNMBR as ITEMNMBR, sum (ATYALLOC) as ATYALLOC from
(
select
ITEMNMBR as ITEMNMBR, sum(ATYALLOC) as ATYALLOC
from SOP10200 group by ITEMNMBR
) bb group by ITEMNMBR
) b on a.ITEMNMBR

Web Site = http://www.albaspectrum.com

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