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

Re: Can sales orders affect inventory?

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

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?


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
Ledger-smb-users mailing list