Re: Invoice calculations

Anonymous — Tue, 16 Oct 2012 14:30:25 GMT

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.

Invoice calculations

kdellaripa — Tue, 16 Oct 2012 13:20:38 GMT

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

Method:Classic General Q&A

Re: Invoice calculations

Invoice calculations