Small and medium business | Business Central, N...

Create all customers as employes

(0) Share

Report

Posted on by P V Sarath

130

Hi All,

Can anyone explain me on this create all customers as employees can we do this in AL and is there any reference for how to create all customers as employess if anyone knows help me.

Thank you.

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Andy Sather on at

Like (0)

Report

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

I will open this up to the community in case they have something to add.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

There are plenty of ways to do this. Do you want it done as a batch job or should it happen every time you create a new customer?

And just out of curiosity, what is the business case behind this request? Employee is basically just a sub ledger in the same way as a customer is.

Was this reply helpful? Yes No
P V Sarath 130 on at

Like (0)

Report

Hi Bruvik,

Can you tell me the way how to do this I want to apply this through a report when I call the report It should create how many customers I had them to a employee, It is not for a business case just causually I am trying this.

Thanks & Regards.

P V Sarath.

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,037 on at

Like (0)

Report

hi,

Pls create one batch job taking Customer table as base dataitem and in that Dataitem write code for creating Employee Master.

Regards

Amit Sharma

www.erpconsultors.com

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,311 Super User 2025 Season 2 on at

Like (0)

Report

Hi, I personally recommend using Configuration Package, which does not require customization and only needs to collate the same data.

https://yzhums.com/4286/

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
P V Sarath 130 on at

Like (0)

Report

Hi All,

I have wrote the code in the report for creating all customers as employess but my code is not working can anyone will help me. I am attaching the code of look at it and guide me guys

trigger OnAfterGetRecord()

var

Customer: Record Customer;

Employee: Record Employee;

begin

IF Not Employee.GET(Customer."No.") THEN BEGIN

Employee.INIT();

Employee."No." := customer."No.";

Employee.INSERT();

END;

Employee."First Name" := Customer.Name;

Employee.Address := Customer.Address;

Employee."Address 2" := customer."Address 2";

Employee.City := customer.City;

Employee."E-Mail" := customer."E-Mail";

Employee.Modify();

end;

Thanks & Regards

P V Sarath.

Was this reply helpful? Yes No
P V Sarath 130 on at

Like (0)

Report

Hi All,

I have wrote the code in the report for creating all customers as employess but my code is not working can anyone will help me. I am attaching the code of look at it and guide me guys

trigger OnAfterGetRecord()

var

Customer: Record Customer;

Employee: Record Employee;

begin

IF Not Employee.GET(Customer."No.") THEN BEGIN

Employee.INIT();

Employee."No." := customer."No.";

Employee.INSERT();

END;

Employee."First Name" := Customer.Name;

Employee.Address := Customer.Address;

Employee."Address 2" := customer."Address 2";

Employee.City := customer.City;

Employee."E-Mail" := customer."E-Mail";

Employee.Modify();

end;

Thanks & Regards

P V Sarath.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Also show your report filters if any

Was this reply helpful? Yes No
P V Sarath 130 on at

Like (0)

Report

Hi Nitin

In the proccessinonly Report I am doing this.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Share complete report code

Was this reply helpful? Yes No