FrontAccounting forum — Inventory Status

Re: Inventory Status

null@example.com (joe) — Mon, 02 Mar 2009 11:31:35 +0000

Hello,
This is the type relating to systypes. You can see the types in file /includes/types.inc

/Joe

Re: Inventory Status

null@example.com (henryadam) — Mon, 02 Mar 2009 03:42:53 +0000

thanks joe,
now i'm create custom report for frontaccounting.
on x_stock_moves, what mean of 'type' field,
ex:
25 for : GRN
11 : adjustmen

CMIIW

Henry

Re: Inventory Status

null@example.com (joe) — Wed, 25 Feb 2009 10:08:35 +0000

Sorry henry,
Wrong name for the table. It should be X_stock_moves, where X_ is the table prefix. If this is your only company, then it could be 0_stock_moves.

/Joe

Re: Inventory Status

null@example.com (henryadam) — Wed, 25 Feb 2009 08:34:56 +0000

joe,
wheres table for inventory adjustment,

thanks
henry

Re: Inventory Status

null@example.com (joe) — Thu, 20 Nov 2008 23:02:56 +0000

Hello,

function get_qoh_on_date is in the file /includes/db/inventory_db.inc and the table for doing the inventory is X_stock_movements which you will se in the function.

/Joe

Inventory Status

null@example.com (henryadam) — Thu, 20 Nov 2008 15:31:58 +0000

what table in mysql to view invetory status ?
and where's function get_qoh_on_date ?
thanks