This Error will appear when I add a new customer or make packing receipt at purchase order
-
[Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named '##ax_tmp_a.w20_131_4780' in the database.
SELECT T1.ACCOUNTNUM AS f1,MIN(T2.RECID) AS f2,N'a.w' AS DATAAREAID,1 AS RECVERSION,IDENTITY(bigint,1,1) AS RECID INTO [##ax_tmp_a.w20_131_4780] FROM CUSTTABLE T1 CROSS JOIN DIRPARTYLOCATIONROLE T2 WHERE ((T1.DATAAREAID=?) AND (T1.RECID=?)) AND EXISTS (SELECT 'x' FROM DIRPARTYLOCATION T3 WHERE ((T3.PARTY=T1.PARTY) AND (T2.PARTYLOCATION=T3.RECID))) GROUP BY T1.ACCOUNTNUM,T2.LOCATIONROLE ORDER BY T1.ACCOUNTNUM,T2.LOCATIONROLE
[Microsoft][SQL Server Native Client 10.0][SQL Server]There is already an object named '##ax_tmp_a.w20_131_4780' in the database.
SELECT T1.ACCOUNTNUM AS f1,MIN(T2.RECID) AS f2,N'a.w' AS DATAAREAID,1 AS RECVERSION,IDENTITY(bigint,1,1) AS RECID INTO [##ax_tmp_a.w20_131_4780] FROM CUSTTABLE T1 CROSS JOIN DIRPARTYLOCATIONROLE T2 WHERE ((T1.DATAAREAID=?) AND (T1.RECID=?)) AND EXISTS (SELECT 'x' FROM DIRPARTYLOCATION T3 WHERE ((T3.PARTY=T1.PARTY) AND (T2.PARTYLOCATION=T3.RECID))) GROUP BY T1.ACCOUNTNUM,T2.LOCATIONROLE ORDER BY T1.ACCOUNTNUM,T2.LOCATIONROLE
*This post is locked for comments
I have the same question (0)

Report
All responses (
Answers (