Method Community

Hi!  Hoping someone can help me here.

I've written a code to calculate when Qty x rate doesn't get to a minimum amount, that Method should put the minimum in the Amount field.  I have this set to work when there is a text change on the Item field in the Invoice Line Item (I have already entered the quantity).  It works fine until I click the "Update" button, at which time my calculation is overwritten by what is hard coded in the Update coding (it is overwriting with Qty x rate), which is a non editable field.  Anyone have a suggestion where I can get around this issue?

Thanks!

Karen Dellaripa

Hi Karen,

kdellaripa:

Anyone have a suggestion where I can get around this issue?

There's no getting around this - we mimic exactly what happens in QuickBooks after sync so we can't allow overwrites with RateXQty.  What you could do is overwrite the rate with desired Amount/Qty.  

If the minimum amount is $10 and:
Qty: 2
Rate: 4
Amount: 8

Then the rate should be adjusted to 5 to meet the minimum.  It would be best to do this on the grid after the update actions rather than on text change.

~C