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

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?





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


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