Re: Can sales orders affect inventory?

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

Hi Charley,

I acouple things to note.  We haven't even gotten to addressing what
needs to change with regard to order and inventory handling yet.  I
suspect that when we do, we will have some sort of handling for parts
on order (what that will look like, I don't know yet).

Right now, things are not handled in a very granular way.  LedgerSMB
can't do what you need it to out of the box.  However, you could
relatively easily put together a view and a report.  You could even
add triggers to fail posting an order when the available parts get too
low.

I guess the question is how much time, expense, and programming effort
it is worth to you an your customer.  If you want to do the
programming yourself, I am more than happy to provide high-level
technical guidance.  It would certainly help define usage requirements
as we get further into re-engineering the software.

Best Wishes,
Chris Travers

On 11/11/06, Charley Tiggs <..hidden..> wrote:
> Which is the challenge.  Consider the following scenario:
>
> Client has retail customers that call in orders or place orders via
> their website.  They also have customers that are dealers who resell
> their products who place orders ahead of time, which the client call
> "wholesale" orders.  Sometimes, those wholesale orders are place several
> months in advance but client is instructed to ship these orders at a
> certain time.  The kicker is that some product can only be ordered one
> time (due to the process and materials involved in creating the
> product).  So, needless to say, a best guess forecast is made and the
> item is ordered in sufficient quantities to cover the forecast of those
> wholesale AND retail orders.
>
> So, a wholesale customer places a their order in June and requests that
> it ships to them in April of the following year.  Client orders
> inventory in August.  The product is received in January.  Retail
> customers can begin placing orders for the arrived product so there's a
> need to retain the requested amount for the wholesale customer until the
> requested ship date in April.  Is there no way to do this without
> creating an invoice and prematurely marking it as shipped?  After all,
> doing that in January means that the invoice will show as being in
> arrears when the product hasn't yet left the warehouse.
>
> Given the above, how can I protect the inventory already committed to
> the wholesale customers, particularly on product that, once it is gone,
> quantity can't be renewed?
>
> Charley
>
> Chris Travers wrote:
>
> > Items are deducted from the inventory when shipped.
> >
> > On 11/11/06, Charley Tiggs <..hidden..> wrote:
> >> Howdy gents!
> >>
> >> The client I'm working with has a model where sale orders are placed but
> >> payment is not necessarily verified at the time that the sale takes
> >> place.  It could be as many as three days before payment is verified.
> >> Once payment is verified, an invoice is created.
> >>
> >> For the client, this means that inventory needs to be committed at the
> >> time the sales order is created instead of waiting for the sales invoice
> >> to affect inventory.  Is this possible?
> >>
> >> Charley
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users