I am AX 3.0 SP5, using SQL Server 2005. I am trying to build a report that pulls the last route journal information that is not for a certain item number. We have built an item number that is used for a place holder value for our Production Edit report. Can anyone help me with coding the fetch method on the report to pull the last item produced on a work center?
I believe that SQL statement should look similar to: Select distinct(wrkctrid), prodid, transdate from dbo.prodjournalroute where max(transdate) and dbo.prodtable itemid != 3000-00-00 Though I cannot get this to work in SQL manager. Any guidance would be appreciated?