[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Can sales orders affect inventory?

I am glad we have a solution you can live with for the moment.  As we
get into invoices, inventory control, etc, your customer's experience
will be quite helpful in making sure we get it right. :-)

On 11/11/06, Charley Tiggs <..hidden..> wrote:

Thanks for your response.  I figured that there hadn't yet been any
discussion on inventory handling but I had hoped that there might be a
way for me to still accomplish what I need to do.  Since I know it
doesn't exist natively, I've been trying to think of other ways to get
the information I need to accomplish what I want and you've given me a
ray of hope in using a view.  So, I have a couple of questions:

1) In LSMB, under what circumstances is the inventory table used?  I've
been playing with entering product and I've only gotten the software to
use the inventory table once and I couldn't reproduce the situation that
led to that happening.

I have to double check, but I think it handles shipping, receiving and
transfers between warehouses.

Orderitems is the other table you want to take a look at.

2) I think that the parts.onhand column in the parts table indicates the
received inventory.  I'm thinking that I could create a view around the
parts.onhand column, the orderitems.qty column and whether or not the
oe.closed column is true to come up with a different way to view
available inventory from the retail side.  Basically, sum all of the of
quantities of a particular part in the orderitems table and compare that
to parts.onhand column to get the true available quantity according to
the client's rules.  Anything else I should be looking for or include in
that view?

I think inventory, but I will have to double check.

3) To check whether an entry into the oe table is a purchase order or a
sales order, I'd need to check whether the vendor_id or the customer_id
fields is populated, correct?  Or is there a simpler or more preferred
way to do this?

Yes, and you have to check for ordnumber.  If ordnumber is null and
quonumber is set, then it is a quotation and not an order.

(Yes, we are aware that this makes it hard, and we will be fixing this
when we get to it).

Best Wishes,
Chris Travers