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

Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Sales order invoice po...
Supply chain | Supply Chain Management, Commerce
Unanswered

Sales order invoice posting error.

(0) ShareShare
ReportReport
Posted on by VRD

Hi,

I have a custom batch job  which runs every hour and does the job of invoicing sales orders.  Below is the error log. Please have a look at Red marked lines. I believe issue lies there.

It says something related to cql (SQL). I believe it could be because of temporary DB connection issue.

When this happened, batch job did not invoice around 30% to 40%  orders it was supposed invoiced. When it run again, it picked up these uninvoiced orders and successfully invoiced them without any issue.

This shows that there was no data related issue. It was something related to infrastructure. But i want to check with the experts here on their opinion.

Also, We will touch base with MS Support on this error.


" at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.Interop.GetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* )
at [aoskernel.dll]Microsoft.Dynamics.Ax.Services.AOSAppDomainHelper.callGetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* )
at callGetManagedCallStack(basic_string<wchar_t\,std::char_traits<wchar_t>\,std::allocator<wchar_t> >* )
at cqlClass.callEx(cqlClass* , Char* , interpret* )
at cqlClass.callEx(cqlClass* , Char* , interpret* )
at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes)
at [Microsoft.Dynamics.AX.Server.Core.dll]Microsoft.Dynamics.Ax.Xpp.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs)
at [Microsoft.Dynamics.Ax.Xpp.Support.dll]Dynamics.AX.Application.xInfo.add(Exception exception1, String text1, String text2)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.`add(Exception _exception, String _txt, String _helpUrl, XppObjectBase _sysInfoAction, Boolean buildprefix, String _label, Boolean @_helpUrl_IsDefaultSet, Boolean @_sysInfoAction_IsDefaultSet, Boolean @buildprefix_IsDefaultSet, Boolean @_label_IsDefaultSet)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.add(Exception _exception, String _txt, String _helpUrl, XppObjectBase _sysInfoAction, Boolean buildprefix, String _label, Boolean @_helpUrl_IsDefaultSet, Boolean @_sysInfoAction_IsDefaultSet, Boolean @buildprefix_IsDefaultSet, Boolean @_label_IsDefaultSet)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.add(Exception _exception, String _txt, String _helpUrl, XppObjectBase _sysInfoAction, Boolean buildprefix, String _label)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.`kernelAdd(Exception _exception, String _txt, String label)
at [Dynamics.AX.ApplicationPlatform.dll]Dynamics.AX.Application.Info.kernelAdd(Exception _exception, String _txt, String label)
at Info::kernelAdd(Object , Object[] , Boolean& )
at [Microsoft.Dynamics.Ax.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)
at callILClassMethod(interpret* ip, Char* method, UInt32 chdl, cqlClass* c)
at cqlCursorIL_Native.EndFind(cqlCursor* )
at cqlCursorIL_Native.EndFind(cqlCursor* )
at [aoskernel.dll]Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.EndFind(IntPtr table)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesLine.`findRecId(Int64 _recId, Boolean _update, Boolean @_update_IsDefaultSet)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesLine.findRecId(Int64 _recId, Boolean _update, Boolean @_update_IsDefaultSet)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesLine.findRecId(Int64 _recId)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.RetailTransactionServiceFulfillment.`updateFulfillmentStatus(Int64 salesLineRecId)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.RetailTransactionServiceFulfillment.updateFulfillmentStatus(Int64 salesLineRecId)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.`updateInventory(InventMovement _inventMovement)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.updateInventory(InventMovement _inventMovement)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.`postInventory()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.postInventory()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.`postSingleLine(Boolean _countryRegion_RU, Boolean _hasQualityOrder, Boolean _isExciseEnableIN, Boolean _isVATEnableIN, Boolean _isCustomsEnableIN, Boolean _isConfigurationkeyRetailEnabled)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.postSingleLine(Boolean _countryRegion_RU, Boolean _hasQualityOrder, Boolean _isExciseEnableIN, Boolean _isVATEnableIN, Boolean _isCustomsEnableIN, Boolean _isConfigurationkeyRetailEnabled)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.`postSingleLine(Boolean _countryRegion_RU, Boolean _hasQualityOrder, Boolean _isExciseEnableIN, Boolean _isVATEnableIN, Boolean _isCustomsEnableIN, Boolean _isConfigurationkeyRetailEnabled)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.postSingleLine(Boolean _countryRegion_RU, Boolean _hasQualityOrder, Boolean _isExciseEnableIN, Boolean _isVATEnableIN, Boolean _isCustomsEnableIN, Boolean _isConfigurationkeyRetailEnabled)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.`postLines()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.FormletterJournalPostCoCHelper.`postLines(FormletterJournalPost instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.ProjFormLetterJournalPost_Extension.postLines(FormletterJournalPost this)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.FormletterJournalPostCoCHelper.`postLines(FormletterJournalPost instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.postLines()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.`post()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.post()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterJournalPost.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.SalesInvoiceJournalPostBaseCoCHelper.`run(SalesInvoiceJournalPostBase instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase_ApplicationSuite_Extension.run(SalesInvoiceJournalPostBase this)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.SalesInvoiceJournalPostBaseCoCHelper.`run(SalesInvoiceJournalPostBase instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPostBase.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.SalesInvoiceJournalPostCoCHelper.`run(SalesInvoiceJournalPost instance)
at [Dynamics.AX.RevenueRecognition.dll]Dynamics.AX.Application.RevRecSalesInvoiceJournalPost_Extension.run(SalesInvoiceJournalPost this)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.SalesInvoiceJournalPostCoCHelper.`run(SalesInvoiceJournalPost instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesInvoiceJournalPost.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`postJournal(Common _parmTable)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.postJournal(Common _parmTable)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`createAndPostJournal()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.createAndPostJournal()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`processJournal(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.FormletterServiceCoCHelper.`processJournal(FormletterService instance, Printout arg0)
at [Dynamics.AX.RevenueRecognition.dll]Dynamics.AX.Application.RevRecFormLetterService_Extension.processJournal(FormletterService this, Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.FormletterServiceCoCHelper.`processJournal(FormletterService instance, Printout arg0)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.processJournal(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`processFormLetterParmTable(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.processFormLetterParmTable(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`runSingleThread(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.runSingleThread(Printout _printout)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.`postSalesOrderInvoice(SalesFormLetterInvoiceContract _contract)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormletterService.postSalesOrderInvoice(SalesFormLetterInvoiceContract _contract)
at FormletterService::postSalesOrderInvoice(Object , Object[] , Boolean& )
at [Microsoft.Dynamics.Ax.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeInstanceCall(Object instance, String MethodName, Object[] parameters)
at [Microsoft.Dynamics.Ax.Xpp.Support.dll]Microsoft.Dynamics.Ax.Xpp.DictClass.Callobject(String _methodName, XppObjectBase _Called, Object[] varArgs)
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.`runOperationInstance(SysOperationServiceController controller)
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.runOperationInstance(SysOperationServiceController controller)
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.`runOperationSynchronously()
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.runOperationSynchronously()
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.`run()
at [Dynamics.AX.ApplicationFoundation.dll]Dynamics.AX.Application.SysOperationServiceController.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormLetterServiceController.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.FormLetterServiceController.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter.run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_Invoice.`run()
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_Invoice.SalesFormLetter_InvoiceCoCHelper.`run(SalesFormLetter_Invoice instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_InvoiceAppSuite_Extension.run(SalesFormLetter_Invoice this)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_Invoice.SalesFormLetter_InvoiceCoCHelper.`run(SalesFormLetter_Invoice instance)
at [Dynamics.AX.ApplicationSuite.dll]Dynamics.AX.Application.SalesFormLetter_Invoice.run()

I have the same question (0)
  • VRD Profile Picture
    VRD on at

    Admins - Can we please move this question to D365FO forum?

  • ToddB Profile Picture
    ToddB Microsoft Employee on at

    Hi LamVikky,

    This has been moved to the Commerce forum.

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

News and Announcements

The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Laurens vd Tang Profile Picture

Laurens vd Tang 88 Super User 2026 Season 1

#2
Sagar Suman Profile Picture

Sagar Suman 72 Super User 2026 Season 1

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 54 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans