how to deploy from sandbox to d365bc cloud ?

(0) Share

Report

Posted on by SABIH

339

Dears

How to deploy from sandbox to d365bc cloud ? Please see below screen shot file i want to deploy this page(cutback setup) to production if anybody know please help me

Categories:

Purchasing

Other

Documentation

Geographies and Localization

Opportunity Management

Data Migrations

Inventory and warehouse management

Web and mobile experience

Reports and Business Intelligence

All responses (9)

Answers (0)

SABIH 339 on at

Like (0)

Report

RE: how to deploy from sandbox to d365bc cloud ?

Hello Stefano Demiliani ,

Finally i can deployed to cloud thank you so much stefano

below permission code has been successfully deployed to cloud

<PermissionSets>

<PermissionSet RoleID="CutBackTable" RoleName="Cut Back List">

<Permission>

<ObjectType>TableData</ObjectType>

<ObjectID>50105</ObjectID>

<ReadPermission>Yes</ReadPermission>

<InsertPermission>Yes</InsertPermission>

<ModifyPermission>Yes</ModifyPermission>

<DeletePermission>Yes</DeletePermission>

<ExecutePermission>0</ExecutePermission>

<SecurityFilter />

</Permission>

</PermissionSet>

</PermissionSets>
SABIH 339 on at

Like (0)

Report

RE: how to deploy from sandbox to d365bc cloud ?

Dear Stefano Demiliani ,

still i cant rectify this ,please find below screenshot

my permsiion code
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

RE: how to deploy from sandbox to d365bc cloud ?

Your permission set must be:

<PermissionSet RoleID="CutBackTable" RoleName="Cut Back List">

<Permission>

<ObjectType>TableData</ObjectType>

<ObjectID>50105</ObjectID>

<ReadPermission>Yes</ReadPermission>

<InsertPermission>Yes</InsertPermission>

<ModifyPermission>Yes</ModifyPermission>

<DeletePermission>Yes</DeletePermission>

<ExecutePermission>0</ExecutePermission>

<SecurityFilter />

</Permission>

</PermissionSet>

My suggestion: generate automatically the permission sets you need by going to VS Code Command Palette and run AL:Generate permission set
SABIH 339 on at

Like (0)

Report

RE: how to deploy from sandbox to d365bc cloud ?

Hello Stefano Demiliani,

Still i am getting extension status is failed please see below screenshot ,how can i rectify this ...Please advise me or please help me in permission set following my screenshots .actually am using in trial d365 bc cloud not with license

my permission code is below

<PermissionSet RoleID="CutBackTable" RoleName="Cut Back List">

<Permission>

<ObjectType>CutBackTable</ObjectType>

<ObjectID>50105</ObjectID>

<ReadPermission>Yes</ReadPermission>

<InsertPermission>Yes</InsertPermission>

<ModifyPermission>Yes</ModifyPermission>

<DeletePermission>Yes</DeletePermission>

<ExecutePermission>0</ExecutePermission>

<SecurityFilter />

</Permission>

</PermissionSet>

my page is below

page 50105 "Cut Back List"

{

PageType = List;

ApplicationArea = All;

UsageCategory = Lists;

SourceTable = CutBackTable;

Caption = 'Cutback Setup';

layout

{

area(Content)

{

repeater(Cutback)

{

field("Account Category Code"; "Account Category Code")

{

ApplicationArea = All;

}

field("Bill code"; "Bill code")

{

ApplicationArea = All;

}

field("Control Account"; "Control Account")

{

ApplicationArea = All;

}

field("Percentage"; "Percentage")

{

Description = 'd';

ApplicationArea = All;

}

}

}

}

}

my table is below

table 50105 CutBackTable

{

DataClassification = ToBeClassified;

fields

{

field(1; "Account Category Code"; Code[20])

{

DataClassification = CustomerContent;

TableRelation = "G/L Account Category"."Entry No.";

//TableRelation = "G/L Account Category".Description;

}

field(2; "Bill code"; Code[20])

{

DataClassification = CustomerContent;

//TableRelation = "Dimension Value".Code where ("Dimension Code" = field ("Bill code"));

TableRelation = "Dimension Value".Code;

//where ("Dimension Code" = field ("Bill code"), Code = field ("Control Account"));

}

field(3; "Control Account"; Code[20])

{

DataClassification = CustomerContent;

TableRelation = "G/L Account";

}

//field(4; "Percentage"; Decimal)

//{

//DecimalPlaces = 2 : 2;

//DataClassification = CustomerContent;

//OptionMembers =default;

// MinValue = 0;

//MaxValue = 100;

//}

field(4; "Percentage"; Option)

{

//DataClassification = ToBeClassified;

Caption = 'Percentage';

OptionMembers = " ","Working Interest","Paying Interest","Revenue – Cost Oil","Revenue – Profit Oil";

}

//field(id; MyField; Option)

//{

// DataClassification = ToBeClassified;

// OptionMembers =

//}

}

keys

{

key(PK; "Account Category Code", "Bill code")

{

//Clustered = true;

}

}

}
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

RE: how to deploy from sandbox to d365bc cloud ?

In your permission set file, ObjectType value is wrong. It must be TableData. Check Roberto’s link for more informations.
SABIH 339 on at

Like (0)

Report

RE: how to deploy from sandbox to d365bc cloud ?

hello Roberto Stefanetti

i will keep you update
Suggested answer

Roberto Stefanetti 12,998 on at

Like (1)

Report

RE: how to deploy from sandbox to d365bc cloud ?

hi,

you need to define a permission set for table used in Al project

also you can create a new ROLEID.

example for table 50105

<PermissionSets>

<PermissionSet RoleID="SomeRoleId" RoleName="Some Role Name"> example EXT EXT (extensions roles)

<Permission>

<ObjectType>TableData</ObjectType>

<ObjectID>50105</ObjectID>

<ReadPermission>Yes</ReadPermission>

<InsertPermission>Yes</InsertPermission>

<ModifyPermission>Yes</ModifyPermission>

<DeletePermission>Yes</DeletePermission>

<ExecutePermission>No</ExecutePermission>

<SecurityFilter />

</Permission>

</PermissionSet>

</PermissionSets>

take a look here

github.com/.../1880
SABIH 339 on at

Like (0)

Report

RE: how to deploy from sandbox to d365bc cloud ?

Hello Stefano Demiliani ,

I am trying to upload using extension management after uploading when i seeing in deployment status showing as error "Package validation failed due to the following error(s): (1,13): error PTE0004: Table '50105' is missing a matching permission set. - Job Id : d6a34372-8d45-40d6-b55e-0b7464988398" is there any solution ?please help me or advise me
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

RE: how to deploy from sandbox to d365bc cloud ?

You need to take your .app file and manually deploy it to production from Extension Management page.

Only manual deployment is supported in a production environment.