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 -
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,
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/
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
x++ LedgerDimensionFacade is the new DimensionDefaultingService This is more of a reminder for me than you that the DimensionDefaultingService class doesn't exist in D365. The DimensionDefaultingService was a short-lived class; brought into existence for only one version
x++ x++ Add custom DMF entity to form; Open in Excel Use x++ form extension to add custom DMF data entity to a form's Open in Excel menu.
x++ DMFUtil DMFDownloadDataPackage Stuff The DMFUtil class is a great code collection to be aware of in case you ever find yourself trying to kick off DMF import/exports via x++, or are just curious about how