DynDeveloper.com

DynDeveloper.com

Sign Up Now!Log In
sg360 11/14/2014 6:03:03 PM

Batch Posting Date via scribe

Hi Guys

I'm posting a PM batch to GP2010 via scribe insight. I create the PM distributions then AP then transaction header then batch header, In the step where I create the batch header, I set the posting date, but I never get that date in the purchasing batch. On a previous integration I used an SP to set the posting date, etc. (see end).

The problem with doing this is that I lose the transaction options to commit repeating rows together. No Problems, I thought, I'll just update the SY00500 table directly from Scribe, but when I try to add an update step, I get a message saying it's not updateable. Does anyone have any suggestions for how I can keep the repeating row transactions AND get the correct posting date?

 Thanks

Mark

 

 

<br>
ALTER PROCEDURE [dbo].[SetBatchPostingDate]
    
    @BatchNo AS VARCHAR(15)
   ,@Series AS TINYINT 
   ,@PostingDate AS DATE
AS
    BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
        SET NOCOUNT ON;
        DECLARE @CheckBookID AS VARCHAR(15)
        SET @CheckBookID = (
                            SELECT
                                CASE WHEN LEFT([BSSI_Facility_ID],1) = 1 THEN 'BA REGULAR     '
                                     ELSE 'COLE TAYLOR OP '
                                END
                            FROM
                                [SGGRP].[dbo].[B3900900]
                            WHERE
                                RTRIM([BACHNUMB]) = @BatchNo
                                 
                           )
    -- Insert statements for procedure here
        UPDATE
            [SGGRP].[dbo].[SY00500]
        SET
            [GLPOSTDT] = @PostingDate
           ,[CHEKBKID] = @CheckBookID
        WHERE
            RTRIM([BACHNUMB]) = @BatchNo
            AND [SERIES] = @Series
 
        IF @@ROWCOUNT = 0
            OR @@ERROR != 0
            RETURN 1
        ELSE
            RETURN 0
    END

 

Version: GP 2010
Section: Dexterity, Dynamics GP, eConnect, Integration Manager, SQL Scripts, Visual Studio Tools for Dynamics GP