Create All employees as vendors

balusubbu · November 16, 2012, 4:46am

create all employees as vendors,

Can any one help me please

amol_salvi · November 16, 2012, 7:03am

Are you expecting code for the creating all employee as Vendors ???

balusubbu · November 16, 2012, 7:35am

i want to convert all employees into vendors in c/al code format

can you please help me

mohana_cse06 · November 16, 2012, 7:37am

You can check how contacts are created as vendors and customers as reference…

amol_salvi · November 16, 2012, 7:40am

I have written it somewhere as follows let check whether it is useful for you or not

Create function in Employee Table

IF NOT Vendor.GET(“No.”) THEN BEGIN

Vendor.INIT;

Vendor.“No.” := “No.”;

Vendor.INSERT;

END;

Vendor.Name := COPYSTR(“First Name” + ’ ’ + “Middle Name” + ’ ’ + “Last Name”,1,50);

Vendor.Address := Address;

Vendor.“Address 2” :=“Address 2”;

Vendor.City := City;

Vendor.“Post Code” := “Post Code”;

Vendor.“Vendor Posting Group” := “Emp Posting Group”;

Vendor.“P.A.N. No.” := “PAN No”;

Vendor.“Global Dimension 1 Code” := “Global Dimension 1 Code”;

Vendor.“Gen. Bus. Posting Group” := ‘DOMESTIC’;

Vendor.“VAT Bus. Posting Group” := ‘NOVAT’;

Vendor.MODIFY;

Modify the code according to your requirement …