Re: Adjust inventory counts

The best way to adjust inventory is to issue a vendor invoice to purchase (at a 100% discount) to purchase where onhand is more than expected, and issue a sales invoice to sell shrinkage and loss when items are found missing. There is a framework to do this automatically in 1.4 but it is still being tested.

If you want to do this programmatically you can query and insert purchase orders and sales orders which can be reviewed and turned into inventory.

The Inventory Entity customer and vendor can be used to issue these invoices.

Best Wishes,

Chris Travers

On Thu, Oct 24, 2013 at 6:32 AM, Brian Wolf <..hidden..> wrote:

This may seem like a basic question, but.....

As part of conducting quarterly physical inventory, actual onhand counts do not match entries in LedgerSMB.
What is the best way to adjust inventory?
If adjustments are performed programmatically (as opposed to manually), what stored procedure(s) should be executed?

Thanks.
Brian

Brian Wolf

Phone: 410.367.2958

Email: ..hidden..

Integrated Payment Solutions

------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Best Wishes,

Chris Travers

Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.

http://www.efficito.com/learn_more.shtml