web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Database Error while Posting Purchase order or add new Customers

(0) ShareShare
ReportReport
Posted on by 450

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)
  • Syed Zeeshan Haider Jafry Profile Picture
    725 on at

    Try Synchronize DataDictionary, right click AOT>Data dictionary, and click Synchronize.

    Regards,

    Zeeshan

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Pratik Bhosle Profile Picture

Pratik Bhosle 2

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans