Best Of

Re: Using an IF statement inside the sourcexpr of a textbox on a Form

IF is a statement. In an expression you can use

immediate values
functions
operators

Some languages provide a conditional operator. C/AL does not.

So, you're out of luck and need to ask your NAV partner to do it for you.

vaprog

Re: when i am opening client application automatically closing and in the event viewer showing error o

I suggest you to remove the application completely and reinstall.

Developer101

Re: Install Business Central Wave 2 : Error message in Web browser

Sources like something went wrong during installation since you do have have the $ndo$srvproperty table on your Master database.
Try Creating the table:

USE [master]
GO

CREATE TABLE [dbo].[$ndo$srvproperty](
	[license] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

SanderDk

Re: Upgrading Business Central Spring 2019 On premise to CU4

It sound like you are missing symbol on your C/Side objects.
Try adding generatesymbolreference=1 to your finSQL.Exe and compiling your object again.
Or use PowerShell "Compile-NAVApplicationObject -GenerateSymbolReference xxxxxx"

This will create symbol for your objects, then your should be able to publish the new versions

SanderDk

Re: How to publish customisation via Extensions?

What do you see when you click the 'Manage' option (which you highlighted)

foo_bar

Re: C/AL code for specific user

I do this for the customer table:

CheckCustPermission(UserName : Code[50])
WITH UserSetup DO BEGIN
SETRANGE("User ID",UserName);
IF (NOT FINDFIRST) OR (NOT "Allow Modifying Customer") THEN ERROR(NoPerm);
END;

It is NAV2017 so it is called from an event subscriber codeunit, but in an older version you would have to call it from the table triggers.

Miklos_Hollender

Re: How to modify reports in D365BC using VS Code

HI jordi79
You cannot (yet) change a report, you do need to create you own report.
A way of doing that is to copy a standard report and do you modification.
If your report have a report selection, you can change the report there, if not then you need to do a bit of coding and hook into the Report Management Codeunit.

You can get the standard report in a couple of different ways, person I like do this in a container with the script from Freddy:
https://freddysblog.com/2019/07/31/preview-of-dynamics-365-business-central-2019-release-wave-2/

a different way is like waldo descrip here:
http://www.waldo.be/2019/03/01/business-central-as-an-app-getting-to-the-al-source-code/

SanderDk