Sometimes batch totals are incorrect and batch headers can go missing. This script will create a stored procedure (Prospr_Reconcile_SOP_Batches) that will reconcile all batch totals, optionally delete any empty batches, and add any missing batch headers.
Benefits of using SQL Scripts
Dynamics GP is a great system full of lots of features, but every now and then we need to turn to SQL to help us. So we have gathered some of the most useful SQL scripts from our partners, and the GP community, for your use.
Supported Systems | |
ERP Software | Microsoft Dynamics GP |
This is a great SmartList because it does something that can't be done in GP. It shows what check paid a Purchase Order. Again this can be really handy for general enquiries.Benefits of Using SmartLis...
Free
Free
With this SmartList you can see all of the account numbers assigned to each asset. Saving you a monotonous scroll through the asset windows.Benefits of Using SmartList For Dynamics GPSmartList is one ...
Free
Free
Electronic Funds Transfer (EFT) is becoming a more common payment method in our everyday personal banking. Remember the last time you transferred money to your friend? Was it done in a swipe throug...
$80.00
$80.00
This SmartList shows your current inventory quantities on hand, along with their costs. Great for general enquiries and also other company specific calculations.Benefits of Using SmartList For Dy...
Free
Free