Skip to content
Microsoft Dynamics 365 Blog


Sales order refunds for credit card payments 

  Processing refunds can be a very simple and easy task, a customer returns an item that they do not want and you refund the money they paid for it right? Unfortunately, it’s not quite that simple as you also need to take into consideration partial returns, taxes, discounts, freight, and restocking fees? There are...Read more

Unable to insert data into the Channel database – String or Binary data would be truncated 

Dynamics AX2012 R2/R3 Retail   Description:   While inserting a Distribution package job like 1010 into the Channel database following message appears and the operation stops.   Full error message: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.ProcessSourceRequestHeaderException:ProcessTargetRequestHeader failed due to an InvalidOperationException. connectionString:Data Source=743R1;Initial Catalog=POSDB;Integrated Security=True;MultipleActiveResultSets=True;ConnectTimeout=60;Encrypt=True;TrustServerCertificate=True;ApplicationName=”Commerce Data Exchange Async Client” —>System.InvalidOperationException: The given value of type String from the data source...Read more

AXRETAIL: How to control the Action flow 

Applies to AX 2012 R2  Description: The purpose of this article is to provide an example, how to control the data flow concerning (preaction/action). Retailers might have to add new catalogs, Changing prices and barcodes during opening hours. If the number of changes are huge, the processing time increases and the locking behaviour on the store...Read more

AX Content: Management Packs for AX 2012 R3! 

The Management Packs have arrived! We now have System Center Operations Manager management packs for both core Microsoft Dynamics AX 2012 and the AX 2012 R3 Retail functionality. The Retail management pack has been tested for side-by-side compatibility with the core management pack. Core Management Pack   The management pack for Microsoft Dynamics AX 2012...Read more

AX for Retail 2012 R2: Run-down on Log Files 

Logging and tracing has changed quite a bit between AX for Retail 2009 and 2012 R2 so an updated version of my AX for Retail: Run-down on Log Files article is somewhat overdue.  Hopefully this will be a quick reference guide that you can use for all Retail components. Retail POS This is the component...Read more

AX for Retail 2012 R2: Commerce Data Exchange implementation guide white paper published! 

One of our most common requests for documentation is an end-to-end implementation guide for Commerce Data Exchange: Synch Service (previously “Retail Store Connect”) and Commerce Data Exchange:  Real-time Service (previously “Retail Transaction Service”).  We are excited to announce that a white paper has just been published that will address this need.  As you can see...Read more

Dynamics AX 2012 for Retail: Items not showing in POS 

I recently came across a case where items were no longer showing up at the POS terminals.  Running A-1040 and N-1040 jobs processed successfully with no errors, but items still wouldn’t show up in POS.  Looking at the tables in the POS database, we could see that data was coming across until we saw that the RetailInventTable...Read more

AX2012 Retail error 32769 in Store connect while running P-job 

Version: AX 2012 FPK   Symptom:  When running the P job following error messageappears in the event log or in the Retail store connect databaseoutgoingmessages table.   Error 32769 2012.6.7 13:21:45:114 (4684) [1]CCommMgr::HandleException: Target request handler failed to process targetrequest header: Microsoft.Dynamics.Retail.StoreConnect.Request.SQLHandler.SCSqlRequestHandlerException:SQL target request handler failed to process request: SQL operation failure.—> System.Data.SqlClient.SqlException: Invalid column...Read more

AX for Retail 2012: Store Connect missing mfc100u.dll error 

All components of AX for Retail 2012 now get installed via the unified AX installer.  One of the nice things about this installer is the built-in Prerequisites Validation checker that it has. However, there is one missing prerequisite for the Store Connect installer;  you may get the following error when you launch the setup utility:...Read more

AX for Retail: Run-down on Log Files 

Because of the modular aspect of AX for Retail, it can sometimes be a bit daunting to try and track down the log files when troubleshooting.  Here is a recap of where to go looking. Retail POS Log messages for Retail POS are stored in the POSISLOG table in the POS database.  The logging level...Read more