Dynamics GP

This is a primer for the transaction flow in Microsoft Dynamics GP (formerly Great Plains).

POs are entered into POP10100 and POP10110

There are three types of receiving docs - Shipments, Shipment/Invoices, and Invoices. Shipments and Shipment invoices are entered directly into the POP10500 through the TRANSACTIONS > PURCHASING > RECEIVINGS TRANSACTION ENTRY form.

Invoices are entered through TRANSACTIONS > PURCHASING > ENTER/MATCH INVOICES. These lines also go into the POP10500 table, and links to the shipment are entered in the POP10600 table. So in this case there is a link from POP10500 (invoice) to POP10600 to POP10500 (shipment)


This query will show all items on order that have outstanding quantities:
select pol.qtyorder- pol.qtycance- shipments.qtyshppd as qtyOnOrder, pol.itemnmbr, pol.itemdesc, pol.uofm
from pop10100 po
join pop10110 pol on pol.ponumber = po.ponumber
--get the total amount already received
left join (select ponumber, polnenum, sum(qtyshppd) as qtyshppd
from pop10500
group by ponumber, polnenum)
shipments on shipments.ponumber = pol.ponumber and shipments.polnenum = pol.ord
where pol.qtyorder - pol.qtycance - shipments.qtyshppd > 0