Customer dimension on Creation

(1) Share

Report

Posted on by Maro9595

105

Dear all,

How can I ensure that while user is creating a new customer he should fill default dimension? I tried to write a few lines of code in customer table extension and call it on customer card page Onpageclose trigger but it is not meeting the requirement.

procedure CheckDim()

var

vDims: Record /Default Dimension/;

begin

vDims.SetRange(/Table ID/, Database::Customer);

vDims.SetRange(/No./, rec./No./);

vDims.SetRange(/Dimension Code/, '');

if vDims.FindSet() then begin

if vDims./Dimension Code/ = '' then

Error('Customer Dimension is required');

// begin

// if vDims./Dimension Value Code/ = '' then

// Error('Customer Dimension is required');

// end;

end;

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (2)

Suggested answer

Saurav.Dhyani 14,414 User Group Leader on at

Like (1)

Report
Copy link

Link copied!
Hi,

You are approaching it incorrectly.

Here is how I would suggest approaching this -

1. When a new customer created, using oninsert subscriber make Blocked as All.

2. When user tries to Blocked as " ", then check Default Dimension.

3. If you only want to do it during first time (creation), then add a Boolean "Dimension Checked".

4. If you do 3, then after Blocked is set to " ", set that Boolean true and Do 2 only if Dimension Checked = false.

Here is code that you should be using -

Procedure CheckDefaultDimension(var Customer: Record Customer) var DefaultDimension: Record "Default Dimension"; begin DefaultDimension.SetRange("Table ID", Database::Customer); DefaultDimension.SetRange("No.", Customer."No."); If DefaultDimension.IsEmpty() then Error('Default Dimension is not set for this customer. Please set the default dimension for this customer.'); end;

Hope it helps.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Was this reply helpful? Yes No
Maro9595 105 on at

Like (1)

Report
Copy link

Link copied!

Thank you for your valuable replay Saurav,

but when I select OK the page close and customer is still created

Was this reply helpful? Yes No
Verified answer

Mustafa Omerbegović 1,477 Moderator on at

Like (3)

Report
Copy link

Link copied!

Hello,
I believe that Saurav.Dhyani gave you the correct answer, but I do not know why you do not use Customer Template for this purpose.

Why write code when you can use native functionality that will work well?

Customer Templates -> Dimensions -> Define default dimensions for customer template

Afer you create new customer with that template you will have defined dimension on customer card.

Templates gives you the opportunity to define another customer data which will automatically applied to new customer cards.

Greeting

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 97,471 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi, I would like to mention that the standard environment can do it, but it will be checked at post time, not at creation time.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Saurav.Dhyani 14,414 User Group Leader on at

Like (2)

Report
Copy link

Link copied!

Hi @Maro9595,

It will be created but you will not be able to unblock it.

Until its unblocked you will not be able to do any transaction for that customer.

Additionally, as @Mustafa Omerbegović suggested, if that is something you can do. It's a great suggestion.

Regards,

Saurav Dhyani

https://bit.ly/SubscribeSauravYouTube

Was this reply helpful? Yes No