18 August, 2010

Reconciling SOP Batches in Dynamics GP

Yesterday I posted a SQL proc that would reconcile SOP Batches and delete any that were empty.  I realized that was somewhat incomplete after learning about a problem another client was having with missing batch headers.  That also is not for everyone since there was not an option to NOT delete empty batches.

To that end, I have posted a new SQL proc that will reconcile SOP Batch Totals, optionally delete any empty batches, and add any missing batch headers.  If this sounds like something that would be useful to you, feel free to download the proc here, load it on your GP company database, and then simply run the following to execute it:

EXEC [dbo].[SACi_sp_GP_SOP_Batch_Reconcile] 'Sales Entry', 1

The second parameter will drive whether or not empty batches are deleted.  Pass a 1 to delete empty batches and a 0 to not delete empty batches.

This blog is provided "AS IS" with no warranties, and confers no rights.

3 comments:

Javier S. said...

Very nice my friend, just what i was looking for.
Once more, thanks, ^^

smitha said...

really amazing blog and I was thankful to you for sharing such a useful information.
- Microsoft Dynamics CRM

Unknown said...

Yo modificaria esta linea:


SELECT @BCHTOTAL = SUM(CASE SOPTYPE WHEN 4 THEN s.DOCAMNT*-1 ELSE s.DOCAMNT END)

Saludos
DIEGO MALTANERI