Issue with negative price totals in 1 .5
Message from matt@cavh.com.au matt@cavh.com.au
In previous versions we have run price reduction promotions for products (for example $5 off a product) by adding a new product which has a fixed price of -$5. Then when we charge for the product we also charge the extra product which is -$5 and the total invoice price would be $5 off.
I like doing it this way as I can then run a report to list the sales of the discount to claim rebates back.
In 1.5 this doesn't seem to be working. When the item is charged the fixed price is charged as $0. When I just tried I was able to change the fixed price to -$5 but during the last week when it has happened we haven't been able to get it changed to a negative value. I'm not sure what it is that we had done differently.
Is there any reason that the behaviour has changed?
Related to this issue, I now have an account that has had a counter sale done (selling the actual product) and then 2 subsequent counter sales. The second counter sale has a $5 discount on the ‘$5 off product’ so it has a total invoice price of -$5. Then there is a third counter sale which has a unit price on the '$5 off product' of -$5 and a total invoice price of -$5. The account should be in credit for $10 but is showing a 0 balance.
If I check the account I get this message:
Mismatch in Customer Account Balance. Expected an Account Balance of ($10.00), but current Account Balance is $0.00. Regenerate balance? If I then press OK to regenerate the balance it is still $0.
I'm not sure what's going on here or how to correct it. In the end we need to end up with account balance of $5 credit because the client didn't receive her $5 off ie. she paid full price.
Hope that all makes sense,
Matt Y
If you'd like to unsubscribe and stop receiving these emails click here.
Re: Issue with negative price totals in 1 .5
I can create products with negative fixed prices and add them to invoices OK. So long as the resulting invoice total is >= 0, it should work.
Previously counter sales were allowed to have negative totals, but this was an oversight. It will now display an error: Failed to validate Amount of Counter Sale: Value must be >= 0.0
Your balance is incorrect because you have 2 debit acts (the counter sales) with negative values which shouldn't be there. They need to have positive values in order for balances to be summed correctly.
-Tim
Re: Issue with negative price totals in 1.5
Thanks Tim,
I just checked my pricing on the discount products and there was an end date on the fixed price which had passed. That was why the pricing wasn't working.
With regard to the 2 debit acts if I just reverse them will the account then sum correctly? Or will they have to be removed some other way? And a final question; if the counter sale value must be >=0 how did these 2 counter sales manage to get finalised? Do I need to check my counter sale archetype?
Matt.
Re: Issue with negative price totals in 1.5
The restriction that counter sales have totals >= 0 appeared in 1.5 beta-2 I believe. You probably entered them before the Counter Sale archetype prevented it.
As their amounts are negative, they won't impact the customer balance, but performing an account check will always yield a "Mismatch in Customer Account Balance" error.
You won't be able to reverse them as the reversal won't be valid (it too will have a negative amount which is disallowed by the Credit archetype).
To correct this, I think you need to change their status to "IN_PROGRESS" and then delete them via the app. Unfortunately the only way to do this is via SQL. I strongly suggest backing up your database first.
-Tim