Best Of
Re: Bulk Email Batch Size and Interval sugestions
- Start with batches of 50–100 customers
- Office 365 typically allows 30 messages per minute (per user)
- Use a delay of 60–120 seconds between batches
Re: Adding new field to Base App Drop down field group view
Dropdown fields in the base app can be a headache if you’re not careful with field groups and views. I ran into something similar while customizing a CRM for tracking user activity on pin up casino. The trick was making sure the new field didn’t disrupt the default sorting or filtering behavior. Always double-check where the table extensions are referenced. It can save hours later down the line.
Connecting Copilot to Microsoft Dynamics 365 Business Central On-premise
Hello,
I am looking for a solution to integrate Microsoft Copilot with Microsoft Dynamics 365 Business Central On-premise. I would appreciate your guidance on the specific steps required to establish this connection.
Your expertise and detailed insights on this integration would be greatly appreciated. Thank you in advance for your support!
Best regards,
I am looking for a solution to integrate Microsoft Copilot with Microsoft Dynamics 365 Business Central On-premise. I would appreciate your guidance on the specific steps required to establish this connection.
Your expertise and detailed insights on this integration would be greatly appreciated. Thank you in advance for your support!
Best regards,
kiabb
1
Lookup - Best Way and The Difference
I tried to created 4 methods to lookup table by using C/AL in the Control. All are have the same result (lookup the table, get the value, and put it to field or variable). What is the best way? are they any difference among this 4 methods?
"Test Lookup" is new field in Customer table.
In the form, pull "Test Lookup" and overwrite standard lookup :
"Test Lookup" - Onlookup (VAR Text : Text[1024];) : Boolean
//Method 1
CLEAR(CustForm);
CustTable.SETRANGE("No.",'10000','50000');
CustForm.SETTABLEVIEW(CustTable);
CustForm.SETRECORD(CustTable);
CustForm.LOOKUPMODE(TRUE);
IF CustForm.RUNMODAL = ACTION::LookupOK THEN BEGIN
CustForm.GETRECORD(CustTable);
"Test Lookup" := CustTable."No.";
END;
//Method 2
CLEAR(CustForm);
CustTable.SETRANGE("No.",'10000','50000');
CustForm.SETTABLEVIEW(CustTable);
//CustForm.SETRECORD(CustTable); //REMOVE SETRECORD
CustForm.LOOKUPMODE(TRUE);
IF CustForm.RUNMODAL = ACTION::LookupOK THEN BEGIN
CustForm.GETRECORD(CustTable);
"Test Lookup" := CustTable."No.";
END;
//Method 3
CustTable.SETRANGE("No.",'10000','50000');
IF FORM.RUNMODAL(0,CustTable) = ACTION::LookupOK THEN
"Test Lookup" := CustTable."No.";
//Method 4
CustTable.SETRANGE("No.",'10000','50000');
IF FORM.RUNMODAL(0,CustTable) = ACTION::LookupOK THEN BEGIN
Text := CustTable."No.";
EXIT(TRUE);
END;
"Test Lookup" is new field in Customer table.
In the form, pull "Test Lookup" and overwrite standard lookup :
"Test Lookup" - Onlookup (VAR Text : Text[1024];) : Boolean
//Method 1
CLEAR(CustForm);
CustTable.SETRANGE("No.",'10000','50000');
CustForm.SETTABLEVIEW(CustTable);
CustForm.SETRECORD(CustTable);
CustForm.LOOKUPMODE(TRUE);
IF CustForm.RUNMODAL = ACTION::LookupOK THEN BEGIN
CustForm.GETRECORD(CustTable);
"Test Lookup" := CustTable."No.";
END;
//Method 2
CLEAR(CustForm);
CustTable.SETRANGE("No.",'10000','50000');
CustForm.SETTABLEVIEW(CustTable);
//CustForm.SETRECORD(CustTable); //REMOVE SETRECORD
CustForm.LOOKUPMODE(TRUE);
IF CustForm.RUNMODAL = ACTION::LookupOK THEN BEGIN
CustForm.GETRECORD(CustTable);
"Test Lookup" := CustTable."No.";
END;
//Method 3
CustTable.SETRANGE("No.",'10000','50000');
IF FORM.RUNMODAL(0,CustTable) = ACTION::LookupOK THEN
"Test Lookup" := CustTable."No.";
//Method 4
CustTable.SETRANGE("No.",'10000','50000');
IF FORM.RUNMODAL(0,CustTable) = ACTION::LookupOK THEN BEGIN
Text := CustTable."No.";
EXIT(TRUE);
END;
Angelo
1
Navison in real estate/land development
Hello
I am looking for information about implementing Navison in real estate/ land development companies.
Does anyone know where I could find info about such projects/developments/add-ons etc?
Thank you
I am looking for information about implementing Navison in real estate/ land development companies.
Does anyone know where I could find info about such projects/developments/add-ons etc?
Thank you
Razzai
1
Re: Navison in real estate/land development
Please find the addon in Microsoft Appsource:
https://appsource.microsoft.com/en-us/product/dynamics-365-for-operations/dynamic-netsoft.ed43ab95-b434-487c-a4be-223b08c22c1e?tab=Overview
https://appsource.microsoft.com/en-us/product/dynamics-365-for-operations/dynamic-netsoft.ed43ab95-b434-487c-a4be-223b08c22c1e?tab=Overview
Re: Find the specific "Sales Price" the used to validate "Unit Price" on Sales Order Lines
this should be your correct event:
[EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnUpdateUnitPriceByFieldOnAfterFindPrice', '', false, false)]
[EventSubscriber(ObjectType::Table, Database::"Sales Line", 'OnUpdateUnitPriceByFieldOnAfterFindPrice', '', false, false)]
Reporting/tracking data Storage Capacity Usage
Hello,
I have had a few Business Central clients report that they have checked their data Storage Capacity Usage in their admin center and discover that they are over capacity, which they had not anticipated.
There are data retention tools and procedures, which we have helped these clients with, but as far as I am aware, there is currently there is no automated notification of either growth or of exceeding capacity in BC or the admin center, nor any tools or reports to provide growth pace and trends, which they may extrapolate from. These would be very useful as they would allow customers to make better decisions regarding data retention policies for data they can remove as redundant and manage their license budget to buy more capacity for data they must retain.
I wanted to see if some did know of such tools or reporting.
I have searched the forum for previous posts on this but have not found anything. Apologies in advance if I have missed anything in my search.
Thank you
I have had a few Business Central clients report that they have checked their data Storage Capacity Usage in their admin center and discover that they are over capacity, which they had not anticipated.
There are data retention tools and procedures, which we have helped these clients with, but as far as I am aware, there is currently there is no automated notification of either growth or of exceeding capacity in BC or the admin center, nor any tools or reports to provide growth pace and trends, which they may extrapolate from. These would be very useful as they would allow customers to make better decisions regarding data retention policies for data they can remove as redundant and manage their license budget to buy more capacity for data they must retain.
I wanted to see if some did know of such tools or reporting.
I have searched the forum for previous posts on this but have not found anything. Apologies in advance if I have missed anything in my search.
Thank you
Re: Reporting/tracking data Storage Capacity Usage
RecRef.Open(8700);
RecRef.SetLoadFields(2, 8);
RecRef.field(2).SetFilter('<>%1&<>%2&<>%3', 2000000184, 2000000183, 2000000185);
RecRef.field(8).SetFilter('>=%1', 240);
FldRef := RecRef.field(8);
if FldRef.CalcSum() then
VariantValue := Round(FldRef.Value(), 0.01, '>') / 1000;
RecRef.Close();
Table Information is protected, so you need to use RecRef.
That calculates the used storage in megabytes.