Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

PO Generator Error

(0) ShareShare
ReportReport
Posted on by

When trying to generate PO's from Purchase Request Resolution window I'm getting the following error:

Unhandled Script Exception

Object has no reference

EXCEPTION_CLASS_SCRIPT_BAD_PARM

The client is using manufacturing and MRP.

How do I correct this error?

Thank you,

Scott W

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: PO Generator Error

    Stefanie,

    I do not remember, but if it does come back to me I will post the steps.

    Scott

  • StefanieC Profile Picture
    434 on at
    RE: PO Generator Error

    Scott,

    Do you remember what your solution was for this issue?

    Thank you,

    Stefanie

  • Community Member Profile Picture
    on at
    RE: PO Generator Error

    Following is the DEXSQL.log from selecting the Create button and then the OK button.  Any assistance would be appriecated.

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151754864):*/

    { CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030F_3('sa',1,'','sa',1,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030F_3('sa',1,'','sa',1,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:04*/

    BEGIN TRANSACTION if exists (select 1 from tempdb.dbo.DEX_LOCK where row_id = ? and table_path_name = 'ZTEST.dbo.MRP1030') begin commit transaction raiserror ('DEXSHR',15,2) end else begin BEGIN UPDATE ZTEST.dbo.MRP1030 SET CB_I = ?, ACTIONTAKEN_I = ? WHERE CB_I = ? AND ACTIONTAKEN_I = ? AND USERID = ? AND VENDORID = ? SELECT @@rowcount END  commit transaction end

    /*  Date: 11/19/2015  Time: 8:52:04*/

    Prepared stmt(151747472):

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030N_3(25,'sa',0,'16350','sa',1,'','sa',1,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:04*/

    Prepared stmt(151747472):

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030N_3(25,'sa',0,'17100','sa',1,'','sa',1,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151748376):*/

    SELECT COUNT(USERID) FROM ZTEST.dbo.MRP1030 WHERE USERID = 'sa' AND CB_I = 1

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030F_1(NULL,NULL,NULL,NULL)}

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151766616):*/

    SELECT TOP 25 USERID,ITEMNMBR,LOCNCODE,MRPISSUEDATE_I,SHORTAMOUNT_I_1,SHORTAMOUNT_I_2,VENDORID,ORD,DECPLQTY,STR30,Buy_Total,UOFM,RELEASEDATE_I,RNNMBR,ITEMDESC,DEX_ROW_ID FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK, READUNCOMMITTED) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa')) ORDER BY USERID ASC ,RELEASEDATE_I ASC ,ITEMNMBR ASC ,LOCNCODE ASC ,DEX_ROW_ID ASC

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151748376):*/

    SELECT COUNT(USERID) FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa'))

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151766616):*/

    SELECT TOP 25 USERID,ITEMNMBR,LOCNCODE,MRPISSUEDATE_I,SHORTAMOUNT_I_1,SHORTAMOUNT_I_2,VENDORID,ORD,DECPLQTY,STR30,Buy_Total,UOFM,RELEASEDATE_I,RNNMBR,ITEMDESC,DEX_ROW_ID FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK, READUNCOMMITTED) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa')) AND USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR = '005 80/20' AND LOCNCODE = 'PACK' ORDER BY USERID ASC ,RELEASEDATE_I ASC ,ITEMNMBR ASC ,LOCNCODE ASC ,DEX_ROW_ID ASC

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151748376):*/

    SELECT COUNT(USERID) FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa'))

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151748376):*/

    SELECT COUNT(USERID) FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR = '005 80/20' AND LOCNCODE >= 'PACK') OR (USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR > '005 80/20') OR (USERID = 'sa' AND RELEASEDATE_I > '2015.11.05') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa'))

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151766616):*/

    SELECT TOP 25 USERID,ITEMNMBR,LOCNCODE,MRPISSUEDATE_I,SHORTAMOUNT_I_1,SHORTAMOUNT_I_2,VENDORID,ORD,DECPLQTY,STR30,Buy_Total,UOFM,RELEASEDATE_I,RNNMBR,ITEMDESC,DEX_ROW_ID FROM ZTEST.dbo.MRP1010 WITH ( NOLOCK, READUNCOMMITTED) WHERE ((USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR = '' AND LOCNCODE >= '') OR (USERID = 'sa' AND RELEASEDATE_I = '1900.01.01' AND ITEMNMBR > '') OR (USERID = 'sa' AND RELEASEDATE_I > '1900.01.01') OR (USERID > 'sa')) AND ((USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR = 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ' AND LOCNCODE <= 'ÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I = '9999.12.31' AND ITEMNMBR < 'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ') OR (USERID = 'sa' AND RELEASEDATE_I < '9999.12.31') OR (USERID < 'sa')) AND (USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR = '005 80/20' AND LOCNCODE = 'PACK' AND DEX_ROW_ID > 1969 OR USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR = '005 80/20' AND LOCNCODE > 'PACK' OR USERID = 'sa' AND RELEASEDATE_I = '2015.11.05' AND ITEMNMBR > '005 80/20' OR USERID = 'sa' AND RELEASEDATE_I > '2015.11.05' OR USERID > 'sa') ORDER BY USERID ASC ,RELEASEDATE_I ASC ,ITEMNMBR ASC ,LOCNCODE ASC ,DEX_ROW_ID ASC

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}

    /*  Date: 11/19/2015  Time: 8:52:04

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151742952):*/

    { CALL DYNAMICS.dbo.zDP_SY02100SS_1 ( 2, 346, 10, 0 ) }

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151748376):*/

    {CALL ZTEST.dbo.zDP_PRL10030L_1('sa',-99999999999999.99999,'sa',99999999999999.99999)}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151737528):*/

    { CALL DYNAMICS.dbo.zDP_SY10550SS_1 ( 'sa', 2 ) }

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151724760):*/

    { CALL DYNAMICS.dbo.zDP_SY10800SS_1 ( 'DEFAULTUSER', 0, 85, 2 ) }

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030N_1(25,'sa','17100',NULL,NULL,NULL,NULL)}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151762096):*/

    {CALL ZTEST.dbo.zDP_MRP1030F_5('sa','sa')}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151766616):*/

    {CALL ZTEST.dbo.zDP_MRP1010F_2('sa','17100','','sa','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151750184):*/

    { CALL ZTEST.dbo.zDP_IVR10015SS_1 ( '005 80/20' ) }

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151754864):*/

    { CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151750184):*/

    { CALL ZTEST.dbo.zDP_IVR10015SS_1 ( '005 80/20' ) }

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151740240):*/

    { CALL ZTEST.dbo.zDP_IV00102SS_2 ( 'WIREROOM', '005 80/20' ) }

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151731992):*/

    {CALL DYNAMICS.dbo.zDP_SY00800L_1('sa','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY',-32768,'sa','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY',32767)}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151726568):*/

    BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_SY00800SI 100, 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 0, '', @num OUT SELECT @num END

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151731992):*/

    {CALL DYNAMICS.dbo.zDP_SY00800F_2('Utility','','','Utility','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151731992):*/

    {CALL DYNAMICS.dbo.zDP_SY00800F_2('PM RECONCILE','PM RECONCILE','zTest <TEST>','PM RECONCILE','PM RECONCILE','zTest <TEST>')}

    /*  Date: 11/19/2015  Time: 8:52:06

    stmt(151731992):*/

    {CALL DYNAMICS.dbo.zDP_SY00800F_2('TRX ACTIVITY','TRX ACTIVITY','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY','zTest <TEST>')}

    /*  Date: 11/19/2015  Time: 8:52:06*/

    BEGIN TRANSACTION if exists (select 1 from tempdb.dbo.DEX_LOCK where row_id = ? and table_path_name = 'DYNAMICS.dbo.SY00800') begin commit transaction raiserror ('DEXSHR',15,2) end else begin BEGIN UPDATE DYNAMICS.dbo.SY00800 SET TRXSOURC = ? WHERE TRXSOURC = ? AND WINTYPE = ? AND USERID = ? AND CMPNYNAM = ? AND BCHSOURC = ? AND BACHNUMB = ? SELECT @@rowcount END  commit transaction end

    /*  Date: 11/19/2015  Time: 8:52:06*/

    Prepared stmt(151722048):

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151754864):*/

    { CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151754864):*/

    { CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }

    /*  Date: 11/19/2015  Time: 8:52:07*/

    BEGIN UPDATE ZTEST.dbo.POP40100 SET PONUMBER = ?, MODIFDT = ? WHERE PONUMBER = ? AND MODIFDT = ? AND INDEX1 = ? SELECT @@rowcount END

    /*  Date: 11/19/2015  Time: 8:52:07*/

    Prepared stmt(151724760):

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151754864):*/

    { CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151729280):*/

    BEGIN DECLARE @num int EXEC ZTEST.dbo.zDP_POP10100SI 'PO000112', 0, 0, 0, '', '', '1900.01.01', '1900.01.01', '1900.01.01', '1900.01.01', '1900.01.01', '1900.01.01', '1900.01.01', '', '', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', '', 0.00000, '', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0.00000, 0, 0.00000, '1900.01.01', '1900.01.01', 0, '', 0, '1900.01.01', '1900.01.01', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', 0.00000, '', 0, '', '', 0.0000000, '1900.01.01', '00:00:00', 0, 0.0000000, 0, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, '', 0.00000, 0.00000, 0, '1900.01.01', '', '1900.01.01', '', 0, 0, 0, 0, 0, 0x00000000, 0, '', 0, 0, 0, 0, 0, '', '', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0, 0.00000, 0.00000, '', '1900.01.01', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0.00000, 0, 0, 0, 0, 0, 0.00000, 0.00000, @num OUT SELECT @num END

    /*

    /*  Date: 11/19/2015  Time: 8:52:07

    SQLSTATE:(01000) Native Err:(5701) stmt(0):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed database context to 'master'.*/

    /*

    /*  Date: 11/19/2015  Time: 8:52:07

    SQLSTATE:(01000) Native Err:(5703) stmt(0):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language setting to us_english.*/

    /*

    /*  Date: 11/19/2015  Time: 8:52:07

    SQLSTATE:(00000) Native Err:(5703) stmt(0):*/

    */

    /*

    /*  Date: 11/19/2015  Time: 8:52:07

    SQLSTATE:(00000) Native Err:(5703) status(0):*/

    SWSTATUS DUMP*/

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151727472):*/

    BEGIN  SET DATEFORMAT ymd

    SET NOCOUNT ON

    SET CURSOR_CLOSE_ON_COMMIT OFF

    SET ANSI_NULLS ON

    SET ANSI_WARNINGS OFF

    SET ANSI_NULL_DFLT_ON ON

    SET ANSI_PADDING ON

    SET NUMERIC_ROUNDABORT OFF

    END

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151726568):*/

    insert into tempdb.dbo.DEX_LOCK values (90,347,'ZTEST.dbo.POP10100')

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151726568):*/

    { CALL ZTEST.dbo.zDP_POP30100SS_1 ( 'PO000112' ) }

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151727472):*/

    {CALL ZTEST.dbo.zDP_POP10500F_2('PO000112',-2147483648,-32768,-32768,'',-2147483648,'PO000112',2147483647,32767,32767,'ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ',2147483647)}

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151711144):*/

    BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_SY00801SI 1001, 'PO000112', '', 2, 'sa', 1102, '', 0, @num OUT SELECT @num END

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151711144):*/

    insert into tempdb.dbo.DEX_LOCK values (90,3871061,'DYNAMICS.dbo.SY00801')

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151729280):*/

    {CALL DYNAMICS.dbo.zDP_SY00801F_1(1001,2,'PO000112','','',1001,2,'PO000112','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:07*/

    BEGIN UPDATE DYNAMICS.dbo.SY00801 SET USECT = ? WHERE RULEID = ? AND RSRCID = ? AND RSRCSBID = ? AND CMPANYID = ? AND USERID = ? SELECT @@rowcount END

    /*  Date: 11/19/2015  Time: 8:52:07*/

    Prepared stmt(151712048):

    /*  Date: 11/19/2015  Time: 8:52:07*/

    Prepared stmt(151713856):

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151754864):*/

    { CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151711144):*/

    { CALL DYNAMICS.dbo.zDP_SY01500SS_1 ( 2 ) }

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151711144):*/

    { CALL DYNAMICS.dbo.zDP_SY01500SS_1 ( 2 ) }

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151716568):*/

    { CALL ZTEST.dbo.zDP_WF100002SS_3 ( 1, 'Purchase Order Approval' ) }

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151714760):*/

    BEGIN DECLARE @stored_proc_name char(31) DECLARE @retstat int DECLARE @param3 numeric(19,5) DECLARE @param4 int set nocount on SELECT @stored_proc_name = 'DYNAMICS.dbo.smGetNextNoteIndex' EXEC @retstat = @stored_proc_name 2, 90, @param3 OUT, @param4 OUT SELECT @retstat, @param3, @param4 set nocount on END

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151713856):*/

    BEGIN DECLARE @stored_proc_name char(31) DECLARE @retstat int DECLARE @param3 numeric(19,5) DECLARE @param4 int set nocount on SELECT @stored_proc_name = 'DYNAMICS.dbo.smGetNextNoteIndex' EXEC @retstat = @stored_proc_name 2, 90, @param3 OUT, @param4 OUT SELECT @retstat, @param3, @param4 set nocount on END

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151741144):*/

    { CALL ZTEST.dbo.zDP_PM00200SS_1 ( '17100' ) }

    /*  Date: 11/19/2015  Time: 8:52:07

    stmt(151741144):*/

    { CALL ZTEST.dbo.zDP_PM00200SS_1 ( '17100' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151713856):*/

    { CALL ZTEST.dbo.zDP_PM00300SS_1 ( '17100', 'MAIN' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151714760):*/

    { CALL ZTEST.dbo.zDP_SY03300SS_1 ( '2% 15/NET 30 DAYS' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151717472):*/

    {CALL ZTEST.dbo.zDP_CO40100F_1(NULL,NULL)}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151737528):*/

    { CALL DYNAMICS.dbo.zDP_MC40200SS_1 ( 'Z-US$' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151777816):*/

    { CALL DYNAMICS.dbo.zDP_MC60100SS_1 ( 2, 'Z-US$' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151748376):*/

    {CALL ZTEST.dbo.zDP_PRL10030L_1('sa',-99999999999999.99999,'sa',99999999999999.99999)}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151748376):*/

    SELECT TOP 25 USERID,LNSEQNBR,STRNG132,DEX_ROW_ID FROM ZTEST.dbo.PRL10030 WHERE USERID = 'sa' AND USERID = 'sa' AND LNSEQNBR = 1.00000 ORDER BY USERID ASC ,LNSEQNBR ASC

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151778720):*/

    BEGIN DECLARE @num int EXEC ZTEST.dbo.zDP_PRL10030SI 'sa', 1.00000, 'The currency ID couldn''t be used. Be sure that the currency ID is set up correctly in the Currency Setup window, Multicurrency Access', @num OUT SELECT @num END

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151716568):*/

    { CALL ZTEST.dbo.zDP_WF100002SS_3 ( 1, 'Purchase Order Approval' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151781432):*/

    { CALL ZTEST.dbo.zDP_SY03900SS_1 ( 237.00000 ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151787760):*/

    { CALL ZTEST.dbo.zDP_POP10150SS_1 ( 'PO000112' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151785952):*/

    {CALL ZTEST.dbo.zDP_CO00102F_1('0\PM\Purchase Order\','','0\PM\Purchase Order\','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151754864):*/

    { CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151754864):*/

    { CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }

    /*  Date: 11/19/2015  Time: 8:52:08*/

    BEGIN UPDATE ZTEST.dbo.POP40100 SET PONUMBER = ? WHERE PONUMBER = ? AND INDEX1 = ? SELECT @@rowcount END

    /*  Date: 11/19/2015  Time: 8:52:08*/

    Prepared stmt(151786856):

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151754864):*/

    { CALL ZTEST.dbo.zDP_POP40100SS_1 ( 1 ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151778720):*/

    BEGIN DELETE FROM ZTEST.dbo.POP10100 WHERE PONUMBER = 'PO000112' SELECT @@rowcount END

    /*  Date: 11/19/2015  Time: 8:52:08*/

    Prepared stmt(151775104):

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151729280):*/

    { CALL DYNAMICS.dbo.zDP_SY00801SS_1 ( 1001, 2, 'PO000112', '', 'sa' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151778720):*/

    insert into tempdb.dbo.DEX_LOCK values (90,3871061,'DYNAMICS.dbo.SY00801')

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151772392):*/

    BEGIN DELETE FROM DYNAMICS.dbo.SY00801 WHERE RULEID = 1001 AND RSRCID = 'PO000112' AND RSRCSBID = '' AND CMPANYID = 2 AND USERID = 'sa' SELECT @@rowcount END

    /*  Date: 11/19/2015  Time: 8:52:08*/

    Prepared stmt(151776912):

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151731992):*/

    { CALL DYNAMICS.dbo.zDP_SY00800SS_1 ( 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 100 ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776912):*/

    BEGIN DELETE FROM DYNAMICS.dbo.SY00800 WHERE WINTYPE = 100 AND USERID = 'sa' AND CMPNYNAM = 'zTest <TEST>' AND BCHSOURC = 'TRX ACTIVITY' AND BACHNUMB = 'TRX ACTIVITY'  and (not exists (select 1 from tempdb.dbo.DEX_LOCK where row_id = 2423084 and table_path_name = 'DYNAMICS.dbo.SY00800')) SELECT @@rowcount END

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151766616):*/

    {CALL ZTEST.dbo.zDP_MRP1010F_2('','17100','','','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151766616):*/

    {CALL ZTEST.dbo.zDP_MRP1010UN_2(1,'','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','','17100','','','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776912):*/

    CREATE TABLE ##0080852 (ORDERNUMBER char(31) NOT NULL, ITEMNMBR char(31) NOT NULL, LOCNCODE char(11) NOT NULL, DUEDATE datetime NOT NULL CHECK (DATEPART(hour,DUEDATE) = 0 and DATEPART(minute,DUEDATE) = 0 and DATEPART(second,DUEDATE) = 0 and DATEPART(millisecond,DUEDATE) = 0), QUANTITY numeric(19,5) NOT NULL, MANUFACTUREORDER_I char(31) NOT NULL, ORD int NOT NULL, DEX_ROW_ID int identity NOT NULL)

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776912):*/

    ALTER TABLE ##0080852 ADD CONSTRAINT PK##0080852 PRIMARY KEY CLUSTERED (ORDERNUMBER)

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776912):*/

    CREATE PROC ##zDP_0080852S_1 (@ORDERNUMBER char(31)) AS /* 12.00.0311.000 */ set nocount on SELECT TOP 1  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER ORDER BY ORDERNUMBER ASC set nocount off

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776912):*/

    CREATE PROC ##zDP_0080852F_1 (@ORDERNUMBER_RS char(31), @ORDERNUMBER_RE char(31)) AS /* 12.00.0311.000 */ set nocount on IF @ORDERNUMBER_RS IS NULL BEGIN SELECT TOP 25  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 ORDER BY ORDERNUMBER ASC END ELSE IF @ORDERNUMBER_RS = @ORDERNUMBER_RE BEGIN SELECT TOP 25  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER_RS ORDER BY ORDERNUMBER ASC END ELSE BEGIN SELECT TOP 25  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER BETWEEN @ORDERNUMBER_RS AND @ORDERNUMBER_RE ORDER BY ORDERNUMBER ASC END set nocount off

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776912):*/

    CREATE PROC ##zDP_0080852L_1 (@ORDERNUMBER_RS char(31), @ORDERNUMBER_RE char(31)) AS /* 12.00.0311.000 */ set nocount on IF @ORDERNUMBER_RS IS NULL BEGIN SELECT TOP 25  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 ORDER BY ORDERNUMBER DESC END ELSE IF @ORDERNUMBER_RS = @ORDERNUMBER_RE BEGIN SELECT TOP 25  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER_RS ORDER BY ORDERNUMBER DESC END ELSE BEGIN SELECT TOP 25  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER BETWEEN @ORDERNUMBER_RS AND @ORDERNUMBER_RE ORDER BY ORDERNUMBER DESC END set nocount off

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776912):*/

    CREATE PROC ##zDP_0080852N_1 (@BS int, @ORDERNUMBER char(31), @ORDERNUMBER_RS char(31), @ORDERNUMBER_RE char(31)) AS /* 12.00.0311.000 */ set nocount on IF @ORDERNUMBER_RS IS NULL BEGIN SELECT TOP 25  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ( ORDERNUMBER > @ORDERNUMBER ) ORDER BY ORDERNUMBER ASC END ELSE IF @ORDERNUMBER_RS = @ORDERNUMBER_RE BEGIN SELECT TOP 25  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER_RS AND ( ORDERNUMBER > @ORDERNUMBER ) ORDER BY ORDERNUMBER ASC END ELSE BEGIN SELECT TOP 25  ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD, DEX_ROW_ID FROM .##0080852 WHERE ORDERNUMBER BETWEEN @ORDERNUMBER_RS AND @ORDERNUMBER_RE AND ( ORDERNUMBER > @ORDERNUMBER ) ORDER BY ORDERNUMBER ASC END set nocount off

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776912):*/

    CREATE PROC ##zDP_0080852SI (@ORDERNUMBER char(31), @ITEMNMBR char(31), @LOCNCODE char(11), @DUEDATE datetime, @QUANTITY numeric(19,5), @MANUFACTUREORDER_I char(31), @ORD int, @DEX_ROW_ID int OUT) AS /* 12.00.0311.000 */ set nocount on BEGIN INSERT INTO .##0080852 (ORDERNUMBER, ITEMNMBR, LOCNCODE, DUEDATE, QUANTITY, MANUFACTUREORDER_I, ORD) VALUES ( @ORDERNUMBER, @ITEMNMBR, @LOCNCODE, @DUEDATE, @QUANTITY, @MANUFACTUREORDER_I, @ORD) SELECT @DEX_ROW_ID = @@IDENTITY END set nocount off

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776912):*/

    CREATE PROC ##zDP_0080852SD (@ORDERNUMBER char(31), @RowsAffected int OUT, @RID int = 0, @TN char(99) = 'TN') AS /* 12.00.0311.000 */ set nocount on BEGIN IF @RID > 0 DELETE FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER AND ( NOT EXISTS ( SELECT 1 FROM tempdb.dbo.DEX_LOCK WHERE row_id = @RID AND table_path_name = @TN ) ) ELSE DELETE FROM .##0080852 WHERE ORDERNUMBER = @ORDERNUMBER SELECT @RowsAffected = @@rowcount END set nocount off

    /*

    /*  Date: 11/19/2015  Time: 8:52:08

    SQLSTATE:(S0022) Native Err:(207) stmt(151772392):*/

    [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'desSPRkmhBBCreh'.*/

    /*

    /*  Date: 11/19/2015  Time: 8:52:08

    SQLSTATE:(00000) Native Err:(207) stmt(151772392):*/

    */

    /*

    /*  Date: 11/19/2015  Time: 8:52:08

    SQLSTATE:(00000) Native Err:(207) status(41):*/

    SWSTATUS DUMP*/

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151766616):*/

    {CALL ZTEST.dbo.zDP_MRP1010F_3('sa','17100','','','1900.01.01','sa','17100','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞ','9999.12.31')}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151750184):*/

    { CALL ZTEST.dbo.zDP_IVR10015SS_1 ( '005 80/20' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151749280):*/

    { CALL ZTEST.dbo.zDP_IV00103SS_3 ( '005 80/20', '17100' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151742048):*/

    { CALL ZTEST.dbo.zDP_IV00101SS_1 ( '005 80/20' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151749280):*/

    { CALL ZTEST.dbo.zDP_IV00103SS_2 ( '17100', '005 80/20' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151762096):*/

    { CALL ZTEST.dbo.zDP_MRP1030SS_1 ( 'sa', '17100' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151731992):*/

    { CALL DYNAMICS.dbo.zDP_SY00800SS_1 ( 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 0 ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151776008):*/

    {CALL ZTEST.dbo.zDP_POP10110F_1('PO000112',-2147483648,-32768,'PO000112',2147483647,32767)}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151731992):*/

    {CALL DYNAMICS.dbo.zDP_SY00800L_1('sa','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY',-32768,'sa','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY',32767)}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151778720):*/

    BEGIN DECLARE @num int EXEC DYNAMICS.dbo.zDP_SY00800SI 100, 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 0, '', @num OUT SELECT @num END

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151731992):*/

    {CALL DYNAMICS.dbo.zDP_SY00800F_2('Utility','','','Utility','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ','ÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞÞ')}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151731992):*/

    {CALL DYNAMICS.dbo.zDP_SY00800F_2('PM RECONCILE','PM RECONCILE','zTest <TEST>','PM RECONCILE','PM RECONCILE','zTest <TEST>')}

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151731992):*/

    {CALL DYNAMICS.dbo.zDP_SY00800F_2('TRX ACTIVITY','TRX ACTIVITY','zTest <TEST>','TRX ACTIVITY','TRX ACTIVITY','zTest <TEST>')}

    /*  Date: 11/19/2015  Time: 8:52:08*/

    Prepared stmt(151722048):

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151719336):*/

    { CALL ZTEST.dbo.zDP_POP10100SS_1 ( 'PO000112' ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151731992):*/

    { CALL DYNAMICS.dbo.zDP_SY00800SS_1 ( 'sa', 'zTest <TEST>', 'TRX ACTIVITY', 'TRX ACTIVITY', 100 ) }

    /*  Date: 11/19/2015  Time: 8:52:08

    stmt(151784144):*/

    BEGIN DELETE FROM DYNAMICS.dbo.SY00800 WHERE WINTYPE = 100 AND USERID = 'sa' AND CMPNYNAM = 'zTest <TEST>' AND BCHSOURC = 'TRX ACTIVITY' AND BACHNUMB = 'TRX ACTIVITY'  and (not exists (select 1 from tempdb.dbo.DEX_LOCK where row_id = 2423085 and table_path_name = 'DYNAMICS.dbo.SY00800')) SELECT @@rowcount END

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans