Re: Math with sequences and single values
- Posted by ChrisB (moderator) Mar 14, 2011
- 2507 views
Hi
Coming in late, but I agree - Vinoba's making his requirements far more complicated than they need to be.
IMHO, each item should be a Record in a Table with each property a Field (price, tax/VAT, discount, etc), then the pricing of each item should act on the items Fields. Ie using a database.
Secondly, and forgive me if I'm wrong, but if each priced up item has a variable number of sequences for the final 'invoice' calculation, then that's going to lead to a lot of nightmares anyway. Again IMHO, each 'invoiced up' item should have a fixed number of items within the sequence, and it's often best to assign a constant to each sequence number, eg
constant PRICE = 1, TAX = 2, DISCOUNT = 3 (etc)
item[PRICE] = 20
item[TAX] = item[PRICE] * current_tax
etc
just my 2p worth
Chris
