D365 D365 Custom JSON Web Service with Pagination I got a request for a RESTful API with Pagination; here is my proof of concept: There are a few keys to this: * A queryRun object must be used (vs SELECT statement) in
D365 Copy Write D365 Document Management Handling File to wherever via Logic Apps Because why not? Problem: How do I get this lost raccoon from a D365 attachment to another part of the cloud? Spoiler: You're going to DB partnerFirst, we need to create
D365 Reading Parsing Text Files From Document Management (fka Document Handling) When I started my career, I was blown away by how it seemed the world ran on text files. Today, even after years of cloud transformation, the world still seems to run on
sql Reverse Record Unique Set Lookup Attribute Match Is there a word or term for this? The other day someone asked me for help on a problem, "I've got an integration where I receive somewhere between 0 -
DynamicsCon March 2021 Companion - Logic Apps & D365 If you saw my DynamicsCon March 2021 session about D365 integrations using Logic Apps, thank you! If you didn't, you can see it below on YouTube. If you didn't
D365 ... does not implement the delegate 'convertPurchTableFieldToVendInvoiceDelegate' This is a fun surprise that can take a bit of digging. When adding fields to the PurchTable table's HeaderToLineUpdate field group, this error can pop up if they aren'
Logic Apps GET and POST Stuff via Logic Apps Sometimes you need to get stuff in and out of D365; Logic Apps help with this a lot. Here are some simple examples of GETs and POSTs that call D365 exposed web services,
Tips Tricks Run Multiple Instances of Teams I never thought I'd get this (in their words) "hack" from a supply chain consultant, but apparently anything is possible in 2020. Here is a great way to run
sql D365 Enum Values SQL With every AX release it seems the way enumeration values are stored and referenced changes. Thanks to my good friend Muhammad [https://twitter.com/afzaal_qau], we now have a great SQL query
DOM Intro to DOM rules There's a new sheriff in town making all sorts of rules around order fulfillment, and it goes by the name DOM [Distributed Order Management] [https://docs.microsoft.com/en-us/dynamics365/retail/
Bugs Order lines cannot be deleted while dependent Stores ... exist This is a frustrating bug that can happen in between DOM runs. The reason is there is a [bad] join between the SalesLine and DOMSalesLineToProcess tables, based solely on DlvMode. Until resolved, the
D365 Trace Batch Jobs and more via CMD Logman Tracing and debugging interactive user sessions is one thing, but how do you trace a batch job in a tier two SAT environment? Here's a high level how: 1. If the
x++ System.DateTime There are enough x++ date and time functions to do just about anything, but sometimes they can make simple tasks fussy, and lack precision. I was investigating how to bring in [at least]
x++ Call Center Payments Part 2 - Credit Cards Part 1 was a simple example of how to add a cash payment to a call center order. Here, we'll explore how to add a credit card payment to the order.
x++ Call Center Payments Part 1 - Cash Creating call center payments via x++ is a challenging and increasingly common task that every architect needs to know. It's a reasonable client request to integrate or create payments, and it&
Integrations Call x++ web service with web browser snippet There are a lot of ways to call D365 web services – Postman, Fiddler, Logic Apps – but they're all a bit fussy. Getting authentication right the first time can be stressful, and
Tips Tricks The sales order cannot be deleted because related not posted transactions exist Breaking up with sales orders can be hard to do. You try your best to make invoicing work, but eventually you cut your losses and to part ways. Or at least try to.
Tips Tricks JSON ODATA for people that miss AIF One of the seemingly scariest changes moving to D365 a few years ago [when it was still AX7] was the loss of the constant in our lives that was AIF. AIF was the
x++ Send NonInteractive E-mail x++ D365 There are a lot of posts out there about how to send e-mails in Dynamics. It's something we've all been doing for years, but a lot of us could
Tips Tricks Entity cannot be deleted while dependent Entities for a processing group exist. Delete dependent Entities for a processing group and try again. Entity cannot be deleted while dependent Entities for a processing group exist. Delete dependent Entities for a processing group and try again.
Retail Import Export Migrate Retail Receipt Formats How to migrate D365 Retail Receipts from one environment to another