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