[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Can sales orders affect inventory?
- Subject: Re: Can sales orders affect inventory?
- From: Charley Tiggs <..hidden..>
- Date: Sat, 11 Nov 2006 17:39:45 -0600
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:
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?