Wednesday, July 26, 2017

Dynamics GP - PO Receipt Posting hangs, freezes at 100%

Issue:
We were experiencing this problem with a specific number of items. Whenever a purchase receipt was posted for any one of these specific items, the posting would hang at 100%. Upon investigation, it looked as though all posting actually completed in the tables, but the original work document was failing to delete from the work tables.

No error message was being returned to screen

We enabled the DEXSQL Log, and saw this error coming up
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'MOP1041'.*/

Also, when we switched the posting to transaction level posting, and attempted to post, we got the error message
A Get Change operation failed on POP Line Hist

Solution:
Create the MOP1041 object

/****** Object:  Table [dbo].[MOP1041]    Script Date: 7/26/2017 2:25:58 PM ******/
SET ANSI_NULLS OFF
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING OFF
GO

CREATE TABLE [dbo].[MOP1041](
[MANUFACTUREORDER_I] [char](31) NOT NULL,
[MOPDOCNUM] [char](31) NOT NULL,
[CALLEDBY] [smallint] NOT NULL,
[TO_SITE_I] [char](11) NOT NULL,
[BIN] [char](15) NOT NULL,
[SEQNUMBR] [int] NOT NULL,
[ITEMNMBR] [char](31) NOT NULL,
[IVDOCNBR] [char](17) NOT NULL,
[QUANTITY] [numeric](19, 5) NOT NULL,
[DEX_ROW_ID] [int] IDENTITY(1,1) NOT NULL,
 CONSTRAINT [PKMOP1041] PRIMARY KEY CLUSTERED
(
[MANUFACTUREORDER_I] ASC,
[MOPDOCNUM] ASC,
[CALLEDBY] ASC,
[SEQNUMBR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


No comments:

Post a Comment