Build 1301 Calculation Error

GertV

In my object Invoices I defined the following rule:

IF Invoices IS NEW Then
Invoices.InvoiceNumber=SystemSettings.LastInvoiceNumber+1

When I create an invoice the new invoicenumber is one lower than the one in SystemSettings instead of one higher.

When I change the formula to
Invoices.InvoiceNumber=SystemSettings.LastInvoiceNumber-1
The result is opposite.
It seems + does a subtraction and - an addition.

A bug?

aware_support

Impossible. Aware IM would be un-usable if + was interpreted as minus. Check the value in the SystemSettings. It is probably negative.

GertV

You are right. I didn't see this because the value showed positive in AwareIM, but when I looked directly into the database the value was stored negative.

This was probably caused by a wrong format that I set for the Invoice Number. Problem is solved.

Thanks for pointing me in the right direction and my apologies for thinking this was a bug.