sql-ledger-users

Inventory not incrementing

[<br...@th...>]

Hi,

I'm using SQL-Ledger 1.8.2, and have a problem with inventory.

When I add a Vendor invoice containing received goods, quantity is not
incremented appropriately in inventory.

When I invoice the customer for a given part, quantity IS decremented
appropriately.

As a result, I now have a number of parts in inventory with a negative
value. Would this likely be something *I've* overlooked, or is it a
known problem?

Further, exactly how much a bad thing(tm) would it be for me to manually
adjust the quantity in the tables directly (if I've created the correct
invoices)?

I'm using the following:

	SQL-Ledger 1.8.2
	Apache 1.3.23
	Postgres 7.2

Thanks,

Brad.
 

Re: Inventory not incrementing

[Dieter S. <dsi...@sq...>]

Did you use the same part on the customer and vendor invoice or perhaps
do you have two of what seems to be the same item in inventory?

Run an inventory report for the item and check "bought" and "sold". It
will tell you how many items where bought and sold.


Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
DWS Systems Inc.     Accounting Software       Fax: 478-5281
=========== On a clear disk you can seek forever ===========

On 20 Mar 2002 br...@th... wrote:

> 
> Hi,
> 
> I'm using SQL-Ledger 1.8.2, and have a problem with inventory.
> 
> When I add a Vendor invoice containing received goods, quantity is not
> incremented appropriately in inventory.
> 
> When I invoice the customer for a given part, quantity IS decremented
> appropriately.
> 
> As a result, I now have a number of parts in inventory with a negative
> value. Would this likely be something *I've* overlooked, or is it a
> known problem?
> 
> Further, exactly how much a bad thing(tm) would it be for me to manually
> adjust the quantity in the tables directly (if I've created the correct
> invoices)?
> 
> I'm using the following:
> 
> 	SQL-Ledger 1.8.2
> 	Apache 1.3.23
> 	Postgres 7.2
> 
> Thanks,
> 
> Brad.
>  
> 
> 
> 
> 
> 

RE: Inventory not incrementing

[Sergio M. <ma...@ds...>]

Does SQL-Ledger offer the functionality to capture inventory going out.  For
example, the system will actually decrease the inventory when invoice is
posted.  Since items are still in inventory warehouse, there is a pick
process, then there is a control quality process.  Do you guys have
suggestions on controling Inventory going out of warehouse?


Thanks...
Sergio