Revert invoice record update and have live related calculations
Hi, I have a problem thats seems like it would come up quite often, but I cant find any help.
I want the ability to update an invoice after its been created, so on an Invoice Update layout, I have a Cancel Update button and a Save Update button. The Save button justs commits the record and returns the user to the home layout. If the Cancel Update button is clicked, then I'd like it to revert the record and then return to the home layout.
I've seen the Web Portal trick on the layout to keep from committing the record until my script cancels or saves, but I also have a few calculations from the Invoice Table (totals, tax, etc) that I'd like to update while the user is entering data. So if the record doesn't commit then neither will the calculations.
So like I said, I'm sure that more advanced FM developers know how to accomplish this, and I'm hoping some can share some insight.