Re: [Openledger-developer] Questions

[Tony F. <to...@sy...>]

On Wed, 2005-07-27 at 10:05, Ang Tun CHek wrote:
> To All
> i have few question about sql-ledger
> 
> 1) what is the purpose of status table

Don't know off hand.

> 2) what is the price break in customer price matrix

pricebreak is for quantity pricing. If the customer orders pricebreak or
more of the part the sellprice will be the one used:
 e.g.
parts_id  customer_id  pricebreak sellprice
1003      1001                  0     10.00
1003      1001                 10      9.50

If customer 1001 orders 9 of part 1003 the price is $10.00 each. If he
orders 10 (or more) the price is $9.50.

 
> 3) what does function  do in IS.pm -> price_matrix

IS->price_matrix() is where all the SQL and stuff for the partscustomer
and partsvendor tables are. It summarizes the info into
$form->{"pricematrix_$x"}. Say using the partscustomer data above an
invoice is created for customer 1001 and part 1003 is added to line 3.
IS->price_matrix() would create a $form->{"pricematrix_3"} that contains
the string "0:10.00 10:9.50".

-- 
Tony Fraser
to...@sy...
Sybaspace Internet Solutions                        System Administrator
phone: (250) 246-5368                                fax: (250) 246-5398