Re: Fixing incorrect inventory

[..hidden..]

Start a new book is a good idea too...this is the worst part of the
softwares. If you only have a few inventories that are off you should look
into the AR and AP to see how it happened and try correcting it.

Remember, when you create an invoice from sales order and if that invoice
is only a partial shipment of the sales order the moment you click on
create invoice the inventory item would be deducted from the inventory. A
bad feature if you or your employee had forgotten to post that invoice
then you would have less on hand and no invoice (hence no COGS).

We use SL and that's the down side that we have to put an extra effort to
keep our book tight. We try having issues like this resolved on a weekly
bases and, if not, by month end.

Tim

> On 9/9/07, Robert Fraser <..hidden..> wrote:
>>
>> Hi
>>
>> I need to tidy up a SQL Ledger 1.1.12 instance where we are about to
>> start
>> using the inventory properly.  Over the years - SQL ledger then
>> LedgerSMB -
>> they didn't use the inventory and it is a bit of a mess (lots of
>> negative
>> inventory on various parts).
>>
>> What is the best way of getting everything back to zero?
>
>
>
> The invoices are important for things like COGS calculation.  If these are
> negative, COGS is likely off as well.
>
> Is it the "opposite" of adding initial inventory, ie make an AP invoice
> with
>> zero prices for the affected parts, and cancel out the quantities?
>
>
>
> If you do this, adjust your  inventory and COGS accounts as well.
> Otherwise
> do an AP invoice at the cost of each item.
>
> Best Wishes,
> Chris Travers
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/_______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>