Skip to main content

Posts

Showing posts from March, 2016

Value in Table column getting blank during Excel import by code in Axapta

If you have written code to import data in Ax Table using Excel template and getting value blank in any column which is string type but value is mentioned in Excel column. After checking that column value getting that number entered in string field and import code not able to pick number in string field  to handle that situation you need to write below code for particular field . switch(Cells.Item(Rownum, 11).value().variantType()) { case COMVariantType::VT_BSTR: accNo = strFmt("%1", Cells.Item(Rownum, 11).value().bStr()); break; case COMVariantType::VT_DECIMAL, COMVariantType::VT_R4, COMVariantType::VT_R8: accNo = strFmt("%1", any2int(Cells.Item(Rownum, 11).value().double())); break; case COMVariantType::VT_I1, COMVariantType::VT_I2, COMVariantType::VT_I4: accNo = strFmt("%1", Cells.Item(Rownum, 11).value().int()); break; case COMVariantType::VT_UI1, COMVariantType::VT_UI2, COMVariantT

Workflow user and SQL Error in Ax 2012

Error description: Stopped workflow suddenly and throwing below error Cannot select a record in Work items (WorkflowWorkItemTable). User: abc, Check and Approve Purchase Order. The SQL database has issued an error. Solution: Give Full CIL then error not resolved.  We check batch job and showing there  batch job for workflow work item and due date getting stopped with error shown above. I changed the status of job to waiting.System Administrator->inquiries->Batch Jobs After that workflow error resolved.