Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
Physical inventory by inventory dimensssion report crashing on a report class insert_recordset command. I checked the AX4 sp2 to that class and the report, there are no differences in the code.
Error Message (13:07:39) Cannot insert multiple records in On-hand inventory periodic transactions (InventSumDateTrans). Parameter ID: , .The SQL database has issued an error.Info Message (13:07:39) SQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'F1'.Info Message (13:07:39) SQL statement: INSERT INTO INVENTSUMDATETRANS (POSTEDQTY,RECEIVEDQTY,DEDUCTEDQTY,PICKEDQTY,REGISTEREDQTY,POSTEDVALUE,ITEMID,INVENTLOCATIONID,INVENTBATCHID,INVENTSERIALID,CONFIGID,INVENTSIZEID,INVENTCOLORID,WMSLOCATIONID,WMSPALLETID,PARMID,TRANSTYPE,DATAAREAID,RECVERSION,RECID)SELECT F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13,F14,F15,F16,F17,DATAAREAID,RECVERSION,RECID+5642486298 FROM #axapta_tmp_lu184
What can I do?
The same report works as a test datatabase.
I suspect there might be some corruption in your SQLDICTIONARY records between the two environments.
Inspect both the test and production databases and compare the records for both. You can do a
SELECT * FROM SQLDICTIONARY WHERE TABLEID = %1
Where %1 is the table number of that table in the AOT.
There are no differences between prod and test. Only in REGID.
Business Applications communities