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