DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
AbrahamA 8/10/2011 7:39:58 AM

SQL Scripts for Dynamics GP

Scripts designed to run against Dynamics GP

Copy setup information from an existing company to a new one

Company/System

FP_SY00500_UPD - Retotals the SY00500 batch table

GL

GL Trial Balance Summary

PM

taGetPMNextPaymentNumber- Gets the next available PM Payment Number

RM

AR Historical Aging - Loop through the open receivables only

AR Historical Aging - This report is a modification of the Dynamics script, it fills the Aging Buckets

RM00103_SEL

FP_RMGetNextDocNumber

taGetPaymentNumber - Gets the next RM document number

FP_RMCashReceipt_INS - Inserts an RM Cash Receipt

SOP

FP_SOP10102_UPD - Delete and recreate the distributions on an order

FP_SOPGetNextDocNumber/sopGetIDNumber - Gets the next SOP document number

FP_SOPPayment_INS - Insert a SOP payment

sopGetIDNumber - Gets the next SOP document number

Move a SOP transaction from open to history

Posting Sequences - documents the order that tables are Updated/Inserted on a Dynamics GP Post action

usp_SOPTotal - retotals a SOP document

usp_SOPTotalTaxes - retotals the taxes for a SOP document

TAX

Get one or all Tax Schedules

 

Version: Unknown or N/A
Section: SQL Scripts
This thread has been marked as 'Closed' and archived