Best Of

Re: Error in BC cloud migration when defining SQL database connection

What is the Source - GP, BC Prem?

RockWithNAV

1

How to Choose the Right Microsoft Dynamics 365 Partner in Canada?

Hey everyone,
Our company is planning to implement Microsoft Dynamics 365 (primarily for Sales and Customer Service) in the coming months. We’re based in Canada and want to work with a reliable, experienced Dynamics 365 partner who understands both local compliance needs and global scalability.

I’ve done some research, but the choices are overwhelming — there are so many gold and silver Microsoft partners out there, and it’s hard to tell who’s the right fit for our business size (SME) and industry . Can anyone recommend what key factors I should consider when selecting a Dynamics 365 partner in Canada?

Also, if you’ve worked with a Canadian partner you’d highly recommend, I’d appreciate the referral! Thanks in advance for your advice and experiences!

digitalb2bmarketing

1

What are the emerging trends in field service technology?

What are the emerging trends in field service technology, and how can Dynamics 365 Field Service adapt to stay ahead? How do you see advancements in AI, IoT, 5G, or automation shaping the future of field service? Are there any features or capabilities you’d like to see added to Dynamics 365 Field Service in future updates?

digitalb2bmarketing

1

Re: Appending to the end of a file - BC v14, C/AL

You cannot do this with C/AL streams, as there is no way to position them. Since you have a file (not a Blob) you can use FILE:

// upload your existing file to the server and get that file's full filename
OutputFile.WRITEMODE := TRUE;
OutputFile.TEXTMODE := TRUE;
OutputFile.OPEN(TempFileName, TEXTENCODING::MSDos);
OutputFile.SEEK(OutputFile.LEN);
OutputFile.WRITE(FileString);
OutputFile.CLOSE;
// download the file again

I don't know if you could use .NET streams. Check out codeunits 3034 DotNet_Stream, and 3025 DotNet_StreamWriter.

vaprog

1

Re: Control addin event arguments

dreez wrote: »

Hey,

Thanks, for the insight. I didn't understood the syntax at first since it's my first time using JS.

I did this and it worked.

'<div id=buttonPreview>' +
        '<button onclick="previewDocumentFunction(' + '\'' + Docid + '\'' + ')">Preview</button>' +
        '</div>'

Thank you for your time. Have a great week

josalm

1

Re: PDF file size when saveas via Job Queue results in 100mb file

Notes to take into attention:
1. How many records Vendor Ledger entry comes from parent code. VendorPaymentReceipt report processes all incoming records to one PDF.
2. In all cases clear variables, especially streams.

lubost

1

Re: Identify which field has been modify in table

there are 2 ways : you can check Currfieldno, this has the number of the field the USER changed. it is NOT filled when changing something via code. teh other way is comparing every field in Rec with the same in xRec in the OnModify trigger

MBerger

1

Re: Generate QR Code for a report

A QR code can contain a max of 3KB of data. However that requires a really high res QR.

You can easy save a PDF to blob storage with public access using not easily discoverable paths like:

https://<GUID1>.blob.core.windows.net/<GUID2>/<GUID3>/<GUID4>.pdf

GUID1: Storage Account
GUID2: Storage Container
GUID3: Customer- / Vendor System Id
GUID4: Document System Id

And create a QR to that URL.

Duikmeester

1

Re: How to make a field mandatory...newbie question

What about the following method:
On Table Level:

- use "not blank"-property for the mandatory field - add following code

OnInsert()
TESTFIELD(Mandatoryfield);

On Form level:

- Work with "Delayed insert"

Waldo

1

Re: How to make a field mandatory...newbie question

I don't understand, there is a very simple way to do this. Granted, Navision is by no means a sophisticated development environment like Visual Studio, but it gets the job done in no time.

Set your form's DelayedInsert property to YES, like was suggested. Then put the validation code in your table, not the form, that way the form won't close if there is an ERROR. In both the OnInsert trigger and the OnModify trigger, you do the TESTFIELD, like suggested. You will not be able to insert or modify the record without having a value in your field, and all the other values will be preserved. I use it all the time.

HTH

DenSter

1