QueryBuildRange qbr;
---To set the value we usually follow as below mentioned code
qbr.value(“Our Value”);
qbr.value(queryValue(“Our Value”));
--We can set the value using SysQuery methods like mentioned below

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

COC FORM BUTTON IN D365 CHAIN OF COMMAND

CHAIN OF COMMAND ON A FORM BUTTON

Yes with the new version it is possible to have a COC on a form BUTTON IN D365 .
It has the similar syntax as we use to follow as shown below.
[ExtensionOf(formControlStr(FormToExtend, Button1))]

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

class CustomizedLookup extends RunBase
{
DialogField fieldAccount;
CustAccount custAccount;
DialogField dialogField , dialogText1, dialogText2, dialogText3 , dialogText4;

lionlionchopper 發表在 痞客邦 留言(0) 人氣()

image

加入developer VB Code

Developer Tab
  • Right click anywhere on the ribbon, and then click Customize the Ribbon.

  • Under Customize the Ribbon, on the right side of the dialog box, select Maintabs(if necessary).

  • Check theDevelopercheck box.
  • lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    Below are the sample queries to get the vendors and customers addresses and contact details. Change the code according to your requirement.
    All Vendors
    SELECT * FROM VENDTABLE WHERE VENDTABLE.DATAAREAID='CEU'
    All Addresses - Vendor 
    SELECT * FROM  DirPartyPostalAddressView  JOIN VENDTABLE ON  DirPartyPostalAddressView.PARTY =VENDTABLE.PARTY

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    image

    1. 找尋workspace, server 的資料:

    C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE>TF.exe workspaces /owner:* /computer:*

    也可以:

    tf workspaces /owner:* /computer:COMPUTERNAME /collection:http://TFSSERVER:8080/tfs/COLLECTIONNAME

    2. Delete workspace from server:

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    image

    目的: 加financial dimension 入去excel template

    1. 第一, 要先將自家的financial dimension 加入ODATA (之前有篇教學)

    Visual Studio → Dynamics365 → Addins → Add financial dimensions to Odata option to seperate the financial dimensions to Odata option to seperate the financial dimensions into different columns

    2. 在standard Excel Template 下做更新:

    The standard Excel templates can be accessed from Organization Administration → Setup → Office → Integration → Document Templates.

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    ❤

    Table name from table id

    以下語句返回數據庫中 table id 9669的名稱,如上所述,我們正在尋找field id 為0的行。

    /* GET table name for table id */
    SELECT NAME
    FROM SQLDICTIONARY

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    image
    1. Openlcs.dynamics.comin your web browser.

    2. Log in with your credentials.

    3. Select theLCS projectyou want to add a Azure subscription to from the list.

    4. Click theHamburgermenu button.

    5. SelectCloud-hosted environmentsfrom the list.

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    public class InventSum_View extends common
    {
    private static str prepareInventPhyStr(str key)
    {
    #define.ViewName(InventSum_View)

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    [DataEventHandler(tableStr(CustTable), DataEventType::Inserting)]
    public static void CustTable_onInserting(Common sender, DataEventArgs e)
    {
    CustTable custTable = sender as CustTable;
    custTable.inventSiteId = InventParameters::find().DGS_MainInventSiteId;

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    image

    1.網站 -- >  http://formatmysourcecode.blogspot.tw/

    2.將所需要的程式碼填入其中

    3.點擊「Form Text」

    4.將產生出的碼複製

    5.產生如此效果

    lionlionchopper 發表在 痞客邦 留言(0) 人氣()

    Blog Stats
    ⚠️

    成人內容提醒

    本部落格內容僅限年滿十八歲者瀏覽。
    若您未滿十八歲,請立即離開。

    已滿十八歲者,亦請勿將內容提供給未成年人士。