Add sales order line to existing load through code X++

Selection of sales order lines

static void Job1(Args _args)
{
    WHSLoadPlanningWorkbenchServerForm loadPlanningWorkbenchServerForm = new WHSLoadPlanningWorkbenchServerForm();
    WHSInventTransSumDim whsInventTransSumDim;
    counter c = 0;
    WHSLoadTable whsLoadTable =
    whsLoadTable::find("USMF-000004");
    void addLine(InventTransId _inventTransId)
    {
        c++;

        select whsInventTransSumDim
        where whsInventTransSumDim.InventTransId == _inventTransId;

        loadPlanningWorkbenchServerForm.createTmpLoadLinesSalesLines(
            false,
            whsInventTransSumDim,
            c);
    }

    // Initialize parameter from Load
    loadPlanningWorkbenchServerForm.parmLoadPaysFreight(
            whsLoadTable.LoadPaysFreight);
    
    // Add lines using inventTransId
    addLine('012512');
    addLine('012513');

    // Add lines to load
    loadPlanningWorkbenchServerForm.addLoadLines(whsLoadTable);
}

 

All sales order lines of an sales order

static void Job1(Args _args)
{
    WHSLoadPlanningWorkbenchServerForm loadPlanningWorkbenchServerForm = new WHSLoadPlanningWorkbenchServerForm();  
    WHSInventTransSumDim whsInventTransSumDim;
    WHSLoadTable whsLoadTable = whsLoadTable::find("USMF-000004");
    InventTransId inventTransId = "012512";
    
    // Only one InventTransId must be selected,
    // loadPlanningWorkbenchServerForm processes all sales lines
    // with same Sales ID
    select whsInventTransSumDim
    where whsInventTransSumDim.InventTransId == inventTransId;     
 

    loadPlanningWorkbenchServerForm.createTmpLoadLinesSalesLines(
            true,
            whsInventTransSumDim,
            0);        
   
    // Add lines to load
    loadPlanningWorkbenchServerForm.addLoadLines(whsLoadTable);
}

Comments

Post a Comment

Popular posts from this blog

Azure BLOB storage with Dynamics 365 FnO X++

Image
Part-1: Azure BLOB storage with Dynamics 365 for operations 25 May 2020|Azure and Dynamics With the introduction of cloud based applications, Dynamics has opened doors for seamless integration with Azure services. This blog is created to portray one such example of how Azure capability can be utilized within Dynamics 365 for Operations. Lets consider a common scenario where Dynamics 365 for Operations needs exchange of files between different applications. This can be a file produced by your .Net application (or) it can be a file produced by you production system,etc,. In Dynamics AX 2012 this situation was handled by creating common folder and sharing in network path where different applications can place their files. Upon introduction of D365, local paths were not accessible by Dynamics production URL so we need to rely on common internet service for accessing the file. One of the convenient way to handle this situation is by using  Microsoft Azure BLOB storage  as the centra
Read more

Send Email from Ax / D365 FnO using X++

 static void SendEmail(Args _args) { SysEmailParameters parameters = SysEmailParameters::find(); SMTPRelayServerName relayServer; SMTPPortNumber portNumber; SMTPUserName userName; SMTPPassword password; Str1260 subject,body; InteropPermission interopPermission; SysMailer mailer; System.Exception e; ; if (parameters.SMTPRelayServerName) relayServer = parameters.SMTPRelayServerName; else relayServer = parameters.SMTPServerIPAddress; portNumber = parameters.SMTPPortNumber; userName = parameters.SMTPUserName; password = SysEmailParameters::password(); subject = "Subject line for the email"; body = "<B>Body of the email</B>"; CodeAccessPermission::revertAssert(); try { interopPermission = new InteropPermission(InteropKind::ComInterop); interopPermission.assert(); mailer = new SysMailer(); mailer.SMTPRelayServer(relayServer,portNumber,userName,password, parameters.NTLM); //instantiate email mailer.fromaddress("ax.notification@mycompany.com"); mailer.
Read more

Import Files from Blob storage using X++ - D365 FnO

 using Microsoft.WindowsAzure.Storage;  Using Microsoft.WindowsAzure.Storage.Blob;  class RunnableClassBlobStorageDownload  {      ///       /// Runs the class with the specified arguments.     ///       ///  The specified arguments.      public static void main(Args _args)      {          CloudBlobDirectory  cloudBlobDirectory;          CloudBlobClient  cloudBlobClient;          CloudBlobContainer  cloudBlobContainer;          CloudStorageAccount  cloudStorageAccount;          cloudStorageAccount  = CloudStorageAccount::Parse("Azure Blob Connection String");          cloudBlobClient = cloudStorageAccount.CreateCloudBlobClient();          cloudBlobContainer  = cloudBlobClient.GetContainerReference("files"); //           System.Collections.IEnumerable lstEnumarable =   cloudBlobContainer.ListBlobs(null, false, 0, null, null);          System.Collections.IEnumerator lstEnumarator = lstEnumarable.GetEnumerator();          List filenames = new List(Types::String);      
Read more