Sales Price calculated in queries to be transferred to Sales Invoice table

[Perfac]

No KD2017. With humble respect, in my threads I described it comprehensively. It updates the unit price when fields quantity, and Inventory Item(SubLdgAcc) is edited, after opening any invoice. After the idea I mentioned last, it works perfect now. No changes of unit price. Thank you very much. I think Microsoft must employ me and Ruben, what do you think Ajax?

[kd2017]

Another idea that crossed my mind in the last minute. The Max expression can establish the latest invoice number, then the calculations on the fields "UnitPrice" should not happen if the invoice number is smaller than the current invoice. Or am I nuts? If ever a previous invoice is opened, even the second to last one, it will not recalculate the unit price, that will work.

This proposed strategy might cause conflict with this requirement

I like if an error was made yesterday on an invoice, to edit the invoice and fix it.

No KD2017. With humble respect, in my threads I described it comprehensively.

I wish you the best of luck.

[CJ_London]

hmmmm. think you need to ask Microsoft!