Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
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








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables