Re: Can sales orders affect inventory?

["Chris Travers" <..hidden..>]

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:
> Chris,
>
> 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