Alfasith AX

The purpose of this blog is for knowledge sharing and connect the relevant audience who are all into Microsoft Dynamics world.

▼
Thursday, January 23, 2025

Get a table ID in SQL - D365

›
Hi select ID from SysTableIdView where  SysTableIdView .Name = 'CustTable' Regards,

Get enum value of a Enum in SQL- D365

›
 Hi, SELECT et.Name AS enumIdName, ev.EnumValue AS enumValue, ev.Name AS enumValueName FROM EnumIdTable et INNER JOIN En...
Friday, October 18, 2024

SQL code to upate one Legal entity banner to all the legal entity in D365

›
 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...

SQL _ Update statement using selection of same table or different table

›
 Hi, update TableA set TableA.Image  = TableB.Image from ( select Image from TableA where dataAreaid = 'USMF' and imagetype = 1) as...

X++ code to submit the pending vendor invoices

›
 Hi, VendInvoiceHeaderWorkflow::submitToWorkflow(VendInvoiceInfoTable::find(541879755462212), "Submitted by Integration"); Regards...
›
Home
View web version

About Me

  • Mohamed Alfasith Ismail
  • Mohamed Alfasith Ismail
  • Mohamed Alfasith
  • Unknown
Powered by Blogger.