Dynamics Community Forum Thread Details

AL extension: Update a record and display the change

Hello,

I am currently making an extension to an extension. The original extension grabs a subset of all items and creates a new table with extra information calculated from sales, purchases and production.

My extension takes this table and adds a few columns. Originally, I just displayed the calculated values in extra fields, but we need the new fields to be filterable and sortable.

The new version adds an action that takes the same functions that worked before for calculating the values, but stores the values in the new table. Out of three fields, two display the updated values, while one stubbornly refuses to show anything other than "0". I checked and got Copilot to confirm that all of my fields point to the table and table is what I update.

I have the relevant code in attachment. Notice that in my page's action, I call three functions.

CriticalUpdate.CalculateQtyRequiredThisMonth(WorksheetLine); // Works
CriticalUpdate.FetchSafetyStockRequirement(WorksheetLine); // Fails
CriticalUpdate.FetchSafetyStockCriticalDate(WorksheetLine); // Works