How to get Contact Person of Vendor & Customer

How to get Contact Person of Vendor & Customer 

Via below code you can retrieve the contact person list of vendor or customer

class SLD_DemoInstance

{

   

    public static void main(Args _args)

    {

        ContactPerson            contactPerson;

        DirPartyTable       dirPartyTable;

   

        RecId _refRecId= VendTable::find("S00038").Party;

        while select contactPerson

        where contactPerson.ContactForParty==_refRecId

        {

       

            info(strFmt("%1, %2",contactPerson.ContactPersonId,contactPerson.personName()));

        }

    }

}

How to get Vendors or Customer Primary Contact Information

How to get Vendors or Customer Primary Contact Information

Via below code you can get the Vendor/Customer complete contact information.

Important 
In AX 2012 PrimaryContactLinkedIn & PrimaryContactFacebook fields are not available.

class SLD_DemoInstance

{

   

    public static void main(Args _args)

    {

        LogisticsElectronicAddress logisticsElectronicAddress;

        DirPartyTable dirPartyTable=DirPartyTable::findRec(VendTable::find("K-DR-000001").Party);

     

        while select  logisticsElectronicAddress where (logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactEmail ||

            logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactPhone || logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactFacebook ||

            logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactFax || logisticsElectronicAddress.RecId == dirPartyTable.PrimaryContactLinkedIn)

        {

            info(strFmt("%1",logisticsElectronicAddress.Description));

        }

    }

}

VSTS Add External User

How to Invite External user on your VSTS

One of my colleague was want to add external user in VSTS. but while he is trying to add external user and typing user name then only organization users are appearing in the drop down.

Resolution

Login to Azure Active Portal with admin right or contact you AD administrator

Go to Azure Active Directory 

Select Users Menu

Now click on New Guest User and save it.

Now login again to your VSTS and try to add users

Item Attribute

Item Attribute
Query relation to getting Item attributes.

InventTable                                             objinventTable;
EcoResProduct                                        objecoResProduct;
EcoResValue                                           objecoResValue;
EcoResAttributeValue                             objecoResAttributeValue;
EcoResAttribute                                      objecoResAttribute;
EcoResInstanceValue                              objecoResInstanceValue;
EcoResAttributeType                              objecoResAttributeType;
EcoResProductInstanceValue                 objecoResProductInstanceValue;
int i = 0;
;
while select objecoResAttributeValue
join objecoResAttribute
where objecoResAttributeValue.Attribute == objecoResAttribute.RecId
join objecoResAttributeType
where objecoResAttribute.AttributeType == objecoResAttributeType.RecId
join objecoResInstanceValue
where objecoResAttributeValue.InstanceValue == objecoResInstanceValue.RecId
join objecoResValue
where ecoResAttributevalue.Value == objecoResValue.RecId
join objecoResProductInstanceValue
where objecoResInstanceValue.RecId == objecoResProductInstanceValue.RecId
join objecoResProduct
where objecoResProduct.RecId == objecoResProductInstanceValue.Product
join objinventTable
where objinventTable.Product == objecoResProduct.RecId
&& objinventTable.itemid='D0001'
{
     info(strFmt("%1 %2",objecoResProduct.DisplayProductNumber,objecoResAttribute.Name));
}

Product Receipt validation in Extension using COC D365FO

Product Receipt validation in Extension using COC D365FO

Using following code you can perform custom validation on product receipt using COC

[ExtensionOf(classstr(PurchPackingSlipJournalCreate))]

final class SLD_PurchPackingSlipJournalCreate_Extension

{

    protected boolean check()

    {

      

        PurchParameters     purchParam=PurchParameters::find();

        boolean flag=    next check();

            flag= flag && this.validatePackingSlip(flag);

      

        return flag;

    }

    public boolean validatePackingSlip(boolean flag)

    {

        if(flag && this.purchParmUpdate.DocumentStatus==DocumentStatus::PackingSlip)

        {

        

 

        }

        return flag;

    }

}

List of Tables X++ D365FO, AX7 and AX2012

List of Tables X++ D365FO, AX7 and AX2012

       public void run()

    {

        Dictionary dict = new Dictionary();

        DictTable dictTable;

        SysDictTable sysDictTable;

        for (int i=1; i<=dict.tableCnt(); i++)

        {

            sysDictTable=new SysDictTable(dict.tableCnt2Id(i));

        }

    }

Number Sequence D365FO

Number Sequence D365FO 

Number sequences are used to generate readable, unique identifiers for master data records and transaction records that require identifiers.

In this demo, I am going to create a new number sequence for customer group form.

Create a new class with name NumberSeqModuleCustomer_CustGroup that extends the NumberSeqModuleCustomer class and then create the method loadNumberSequence.

Reference Screenshot:

Now create extension class of CustParameters_Extension and add your custom method to find number sequence..

Reference Screenshot:

Now create Run able class to initialize the  number sequence...


Reference Screenshot:

Perform build & Sync and load the number sequence. In my demo i have place Action menu item of executable class on following navigation.


Reference Screenshot:

Now Navigate to organization administration > Number sequence and generate number sequence.

 Reference Screenshot:

Next Step to Navigate to Account receivable parameter setup to veriy our newly create number sequence loaded successfully or not...  You have to verify on your desire number sequence module.

Next step to override CustGroup form data source Initial value event.


 Reference Screenshot:

Perform build & Sync and verify on your cust group.. for me its working fine please have look on below screenshot.

Please feel free to contact me if you are facing any issue during implementation of above blog.