Dynamically Update Sum of Real Value Field as Navigating Through Lines in Grid in AX 2012 R3

(1) Share

Report

Posted on by Fawad Ahmad

 Public realI have a method to calculate the total consumption cost based on a production ID:
 getTotalConsumptionCost(ProdId _prodId)
{
    ProdJournalBOM prodJournlBOM;
    real totalCost = 0;


    select sum(ConsCost) from prodJournlBOM
           where prodJournlBOM.ProdId == _prodId;

    totalCost = prodJournlBOM.ConsCost;

    return totalCost;
} 


Where should I place the logic to calculate and update line-level data based on header information in AX 2012 R3?Should this logic be placed in the header table or the lines table? 
I want to ensure that the calculated value is accurate and up-to-date for each line.

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 307,719 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Can you tell on what form you need the calculation and what exact tables are used as data source? What do you mean by the last two words "each line"? What lines are you referring to?
Fawad Ahmad 61 on at

Like (0)

Report
Copy link

Link copied!
Sorry for the late reply. Regarding the Production Order Cost Analysis customization:

I have the following setup:

ProdTable in the header.

ProdJournalBOM in the line.

I wrote a method in ProdJournalBOM, but the data in the field is inconsistent, whereas the calculations in the header table (ProdTable) are working correctly. How can I ensure that the line-level data accurately reflects the header information? Where should the logic to calculate and update line-level data based on header information be placed in AX 2012 R3?
Martin Dráb 241,360 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

The logic in your method has a single parameter: prod ID. Putting it at the line level makes no sense, because all lines with the same prod ID will have the same value, because they'll call the same logic with the same parameter. If you want different values for different lines with the same prod ID, it's not just about the code placement. You need to add the missing logic.

If you need more help, you'll need to give us more information about your goal. We see code you have at the moment, but we don't know what code you meant to write.