Re: [Openledger-developer] Discussion - SL - IC.pm

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

On Mon, 2005-04-25 at 17:03, Ang Tun Chek wrote:
> To All,
> i have been studying the IC.pm on SL 2.4.11 and i have some questions here
> 
> 1) what is partscustomer and partsvendor in the database?

I haven't looked at this feature much but I would say they're for the
price matrix feature. If your new to the 2.4 version have a look in
"Goods & Services->(Add|Edit) Part" you'll see that you can assign a
price, etc... per customer or a partnumber, cost, etc... per vendor.

> 2) how warehousing works in SL? what inventory table do?

The inventory table keeps track of individual shipping and receiving
reports. When you go to the "Shipping->(Ship|Receive)" screens when you
click "Done" SL inserts a row into inventory and updates
orderitems.serialnumber for each line that you receive or ship. Purchase
Orders have a positive inventory.qty and Sales Orders have a negative
inventory.qty

When you do a "Shipping->Transfer" 2 rows are inserted into inventory
for each part number you transfer one with the "from" warehouse_id and a
negative qty and one with the "to" warehouse_id and a positive qty. The
oe_id and orderitems_id columns seem to be left NULL for transfers.

> 3) SL comes with a "labor", do we really need it? or we can treat it as 
> another service? (i prefer to treat it as a service)

The idea of a "Labour" item is that it can be included onto an assembly
as a cost to assemble the the assembly or an overhead associated with
assembly like "Shop Supplies".

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