Dynamics Community Forum Thread Details

Adding New lines in a GrideView in enterprise Portal in AX 2012

To resolve the issue where clicking “New” in the Corporate KPIs grid in Enterprise Portal (EP) in Microsoft Dynamics AX 2012 does not add a new line, follow this solution checklist. This is a common problem when either the AX metadata, AOT setup, or SharePoint EP configurations are incomplete or not correctly wired.

✅ Solution: Enabling Line Addition in EP GridView (AX 2012)

🔧 Step 1: Confirm Grid Configuration in AOT

Open AOT in AX.
Go to your Web Module → Web → Web Pages → locate the EP page you're working with.
Find the GridView control under the relevant Web Form.
Ensure:
- The AllowAdd property = Yes
- The AllowEdit property = Yes
- The DataSource is bound to a DataSet properly.

🔧 Step 2: Check the DataSet

Go to AOT > Data Sets.
Open the DataSet used in this EP page.
Verify:
- The data method for insertion (create or initValue) is implemented and exposed.
- The DataSet’s AllowCreate and AllowEdit = Yes
- The related table in the dataset allows inserts (check table properties).

🔧 Step 3: Implement the Create Method if Missing

If the "New" button does not trigger anything, you might need to handle the creation of a new record manually.

In the Web Form code-behind (.cs file in EP project if customized), implement the Create button handler:

csharp

protected void NewButton_Click(object sender, EventArgs e)

    CorporateKpiDataSource.Create();

Ensure your CorporateKpiDataSource is linked to the correct AX DataSet.

🔧 Step 4: Rebuild and Deploy EP

If you made any changes to AOT or Visual Studio EP project:

Deploy the Web project via:
- Right-click EP Web project → Deploy
Restart IIS (iisreset).
Clear browser cache and test again.

✅ Step 5: Security/Permissions

Confirm that the user has insert permissions on the table behind the Corporate KPI entity.
Use AX Security Keys and Privileges to ensure access.

🧪 Step 6: Test in AX Client (not EP)

To isolate if it’s a data issue:

Go to the corresponding form in AX rich client.
Try to add a new KPI line manually.
If it fails here too, it’s a data or table-level restriction.

Optional: Enable Logging

Enable EP tracing in web.config for SharePoint to catch errors not shown in UI.

🧠 Summary

Step	Area	Action
1	GridView Control	Set `AllowAdd` and `AllowEdit` = Yes
2	DataSet	Check `AllowCreate`, `create` method
3	EP Button Code (Optional)	Handle `Create()` manually
4	Deployment	Rebuild EP project and deploy
5	Permissions	Ensure insert rights on table
6	AX Client	Test manually via AX form