Pages

Banner 468 x 60px

 

Thursday, February 21, 2019

Get Workflow Information AX using SQL

0 comments
Hai guys, I want to share how get Workflow Information AX using SQL USE AXReports SELECT  A.SALESID,                            A.CUSTACCOUNT,                            (SELECT TOP 1 NAME FROM AXABU.DBO.DIRPARTYTABLE AS R WITH (NOLOCK)                                    WHERE R.RECID = (SELECT PARTY FROM AXABU.DBO.CUSTTABLE AS X WITH (NOLOCK) ...
Read more...

A financial dimension value is based on the record and has been used on a transaction. You cannot delete the record

  SOLUTION delete in table DimensionAttributeLevelValue base on Bank Account  :  and Delete the Bank Account FINISH