Dynamics GP

January 2007 - Posts

• POP Transaction Flow Primer for 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 Posted Jan 11 2007, 08:19 PM by Steve Gray with no comments

• Migrate Inventory Data in Dynamics GP 9

  Here is a script that migrates most of the tables that are needed for setup of the inventory module in Dynamics GP. I created only the tables that I needed for this installation, it is not exhaustive. But it is a good starting point. www.4penny.net/SQL_Scripts/migrate_iv_data_for_dynamics_gp_9.txt Posted Jan 11 2007, 08:18 PM by Steve Gray with no comments