Negative calculation

[ianmuir]

Hi, my database produces an invoice at the end of a job.

Sometimes I have to raise a credit note against the invoice. How can I make a copy of the invoice with negative numbers which cancels out the invoice?

Any Ideas?

Thanks

[comment]

How about something like:

Duplicate Record

Set Field [ Invoices::Amount ; -Invoices::Amount ]

Commit Records []

[ianmuir]

Hi, Thanks! This makes the amount zero. What I need is if the amount is 100 I need the script to make it -100

[comment]

This makes the amount zero.

No, it doesn't. Make sure you enter only this part:

-Invoices::Amount

into the Calculated result formula box. The first part specifies the target field.

[ianmuir]

Hi I did this. if the sum is 100 and you -100 it leaves zero.

I need it to show -100

Thanks

[ianmuir]

Hi, if the sum was 100 and I could take away 200 it would leave the total as -100 which is what i want.

[comment]

You don't take anything away - you simply set the field to a new value, which happens to be minus the old one:

Invert.zip

[ianmuir]

Hi, here is script step after duplicate record.

Set Field [ jobs::unit_price ; - jobs::unit_price ]

When run it clears the data from unit price and leaves it blank!

any ideas?

[ianmuir]

Hi, got it working now. Many Thanks!