Best Of

They are linked by table 5054 "Contact Business Relation",
There is a standard nav report you can run, 5195 "Create Conts. from Customers"

Modifying a field in Rec during the OnDelete trigger will have no effect in SQL, since that change is never sent to the database server (that would require a MODIFY - don't do that from OnDelete of the same record).

It is not clear to me what you would like to accomplish here?

In BC 16 you do not have a ClientUserSettings file, it only exist on RTC client.
I would presume that you need to change the credentialtype of a webclient?
Then you need to go have a look at navsettings.json on the webserver

If you don't want to link them by CustomerNo which needs customising on Contact table, you can adopt the current linkage using Email or Mobile as these are also unique to each Customer.

Well, this is up to your Vendor Remittance report.
If you build a well done dataitem the only thing you have to do is pass with the SETTABLEVIEW a filtered Journal Line for what you want to print.
And in this case you don't have to loop anymore on GenJnlLine.

So, I don't remember if SETTABLEVIEW works with temporary records. If it does your code should be like this:

    TmpGenJnlLine.RESET;
    TmpGenJnlLine.SETRANGE("Account No.", TmpVendor."No.");

    PdfDocPath := 'Remittance for ' + TmpVendor.Name + '.pdf';
    Path := FileMgt.ServerTempFileName('.pdf');

    CLEAR(VendRemittance);
    VendRemittance.USEREQUESTPAGE(FALSE);
    // We just ask the report to print all the journal filtered for the current vendor
    // We don't need to loop anymore on TmpGenJnlLine
    VendRemittance.SETTABLEVIEW(TmpGenJnlLine); // <<<<<<
    VendRemittance.SAVEASPDF(Path);

    SMTPMail.AddAttachment(Path, PdfDocPath);

    TmpFileList.INIT;
    TmpFileList.ID := 1; // Just put one, is always a single record now
    TmpFileList.Name := Path;
    TmpFileList.INSERT;

    SMTPMail.AddAttachment(Path, PdfDocPath);

    SMTPMail.Send;

    IF TmpFileList.FINDSET THEN
      REPEAT
        FileMgt.DeleteServerFile(TmpFileList.Name);
      UNTIL TmpFileList.NEXT = 0;

If it doesn't work because the record is temporary we need to use marks for filter.
We have to loop, mark the records on a real variable and then print.
Example:

    TmpGenJnlLine.RESET;
    TmpGenJnlLine.SETRANGE("Account No.", TmpVendor."No.");

    // Reset marks on every vendor loop
    GenJnlLine.RESET;

    IF TmpGenJnlLine.FINDSET THEN
      REPEAT
        // Marks the records we want to print
        GenJnlLine.GET(TmpGenJnlLine."Journal Template Name", TmpGenJnlLine."Journal Batch Name", TmpGenJnlLine."Line No.");
        GenJnlLine.MARK(TRUE);
      UNTIL TmpGenJnlLine.NEXT = 0;

    PdfDocPath := 'Remittance for ' + TmpVendor.Name + '.pdf';
    Path := FileMgt.ServerTempFileName('.pdf');

    // Select all the marked records
    GenJnlLine.MARKEDONLY(TRUE);

    CLEAR(VendRemittance);
    VendRemittance.USEREQUESTPAGE(FALSE);
    // Print marked records
    VendRemittance.SETTABLEVIEW(GenJnlLine);
    VendRemittance.SAVEASPDF(Path);

    SMTPMail.AddAttachment(Path, PdfDocPath);

    TmpFileList.INIT;
    TmpFileList.ID := 1;
    TmpFileList.Name := Path;
    TmpFileList.INSERT;

    SMTPMail.Send;

    IF TmpFileList.FINDSET THEN
      REPEAT
        FileMgt.DeleteServerFile(TmpFileList.Name);
      UNTIL TmpFileList.NEXT = 0;

The pain is much lower than the cheek There's a PowerShell Cmdlet to remove the language. You export the objects, which includes the languages, and then you take the language out using the Cmdlet.

https://docs.microsoft.com/en-us/dynamics-nav/windows-powershell-cmdlets-for-microsoft-dynamics-nav

For OnPrem, the customer need to buy/pay for objects in 50000-99999 (Table extension and pag eextenson are free)

I am glad they are not letting you use SOAP hehe

So in NAV, ODATA and API are different endpoints.
See https://docs.microsoft.com/en-us/dynamics-nav/api-reference/v1.0/endpoints-apis-for-dynamics
API does not use the webservice table to be configured.

Batch requests are not supported afaik.

Hello @ImperatorMing,

Have you tried this commanda alone to see the users:

get-WmiObject -Class Win32_UserAccount

Because I think that you are missing the domain name in the filter for the Caption value.

$FullName = (get-WmiObject -Class Win32_UserAccount | Where-Object -FilterScript {$_.Caption -eq "Domain\User03"}).FullName

Or you can use the like comparation instead the equal one.

$FullName = (get-WmiObject -Class Win32_UserAccount | Where-Object -FilterScript {$_.Caption -like "User03"}).FullName

Regards.