what is the FMP calculation order?
The values i'm storing are out of step with calculation field whose value i want to store.
What is FMP calculation order? Is a Record Commit script step done before a calculation field sum is executed?
i have a calculated field, sale::outstanding, that subtracts a sum of values in two portals and dispalys it:
sale::outstanding= Sum(sale items::amount)-Sum(transaction::amount)
the displayed value is always what i expect as i test it.
i have a script trigger On Record Commit that takes this value and stores it in a field:
Set Field [sale transaction:amount;sale::outstanding]
the stored value rarely matches what is displayed, it's value is one step behind what is displayed. it's out of sync.
any ideas as to why this is?
how do i force a sync?
Try forcing both the portals to redraw. You can often do that by a script step that resets one of the relationship fields to itself. Then pick up the value.