Tag: F&O

Enable Gmail accounts to access Dynamics 365 SCM Vendor Collaboration Portal

D365 SCM’ Vendor Collaboration portal enables external vendors to access related purchase orders, invoices, consignment inventory, and requests for quotation information.

If you are new to Vendor Collaboration portal, I advise you to start here. This topic discusses how to enable Gmail accounts to access Vendor Collaboration Portal.

Set up and maintain vendor collaboration.

Not all vendors use Microsoft 365 accounts and therefore use their personal email accounts to sign up for and access Vendor Collaboration portal. As you might know this is not supported officially. If you followed steps listed here using Gmail accounts, you will receive this error.

You are not authorized to login with your current credentials

To enable Gmail (or other non-Microsoft accounts) accounts to access Vendor Collaboration portal, you need to sign up to create Microsoft account for these personal accounts. Below I will show you how can achieve that in simple steps:

For Gmail accounts you DO NOT need to invite them to Azure Portal as guest accounts when you create Microsoft account for them.

Skip adding Gmail accounts to Azure Portal

First, in your browser navigate to: https://accounts.microsoft.com

Click on Create account > button.

Signup for Microsoft account

Enter your personal accounts, then click Next button.

Signup for Microsoft accounts

Create password that you can use to access your Microsoft account later (this is different that your personal account password), then click Next button.

Signup for Microsoft account

After this point Microsoft account service should send you verification email including security code you will need to use to verify your personal account.

Verification email

use security code to continue signup process. Click Next button.

Verify email

You will be asked to resolve a puzzle to ensure you are not a robot. Complete it then click Next button.

Enter your Birth date and country, then click Next button.

Enter Birthdate and Country

Verify your birthdate, then click Next button.

Confirm age

you are all set!

Vendor Collaboration portal

How to read text file in Dynamics 365 F&O

Using System.IO.Stream library you can read text files. here is a runnable class to load the file using FileUploadBuild control, then read its content:

class AZTxtFileRead
{
/// /// Runs the class with the specified arguments. ///
/// The specified arguments.
public static void main(Args _args)
{
#File;
    
    System.IO.Stream            stream;
    FileUploadBuild             fileUpload;
    DialogGroup                 dlgUploadGroup;
    FileUploadBuild             fileUploadBuild;
    FormBuildControl            formBuildControl;
    Dialog                      dialog = new Dialog("Import the data from File");

    dlgUploadGroup          = dialog.addGroup("@SYS54759");
    formBuildControl        = dialog.formBuildDesign().control(dlgUploadGroup.name());
    fileUploadBuild         = formBuildControl.addControlEx(classstr(FileUpload), 'Upload');
    fileUploadBuild.style(FileUploadStyle::MinimalWithFilename);
    fileUploadBuild.fileTypesAccepted('.txt');

    if (dialog.run() && dialog.closedOk())
    {
        FileUpload fileUploadControl     = dialog.formRun().control(dialog.formRun().controlId('Upload'));
        FileUploadTemporaryStorageResult fileUploadResult = fileUploadControl.getFileUploadResult();

        if (fileUploadResult && fileUploadResult.getUploadStatus())
        {
            CommaTextStreamIo textStream = CommaTextStreamIo::constructForRead(File::UseFileFromURL(fileUploadResult.getDownloadUrl()));

            textStream.inFieldDelimiter(',');
            textStream.inRecordDelimiter(#delimiterCRLF);

            // First line might have header information
            container currentLine = textStream.read(); 

            while(currentLine)
            {

                info(strFmt("%1, %2, %3", 
                    conPeek(currentLine, 1),
                    conPeek(currentLine, 2),
                    conPeek(currentLine, 3)));

                currentLine = textStream.read();

            }
        }

    }
}
}