<![CDATA[FrontAccounting forum — Inventory Status]]> 2009-03-02T11:31:35Z PunBB https://frontaccounting.com/punbb/viewtopic.php?id=403 <![CDATA[Re: Inventory Status]]> Hello,
This is the type relating to systypes. You can see the types in file /includes/types.inc

/Joe

]]> https://frontaccounting.com/punbb/profile.php?id=3 2009-03-02T11:31:35Z https://frontaccounting.com/punbb/viewtopic.php?pid=1923#p1923 <![CDATA[Re: Inventory Status]]> 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

]]> https://frontaccounting.com/punbb/profile.php?id=257 2009-03-02T03:42:53Z https://frontaccounting.com/punbb/viewtopic.php?pid=1922#p1922 <![CDATA[Re: Inventory Status]]> 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

]]> https://frontaccounting.com/punbb/profile.php?id=3 2009-02-25T10:08:35Z https://frontaccounting.com/punbb/viewtopic.php?pid=1910#p1910 <![CDATA[Re: Inventory Status]]> joe,
wheres table for inventory adjustment,

thanks
henry

]]> https://frontaccounting.com/punbb/profile.php?id=257 2009-02-25T08:34:56Z https://frontaccounting.com/punbb/viewtopic.php?pid=1909#p1909 <![CDATA[Re: Inventory Status]]> 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

]]> https://frontaccounting.com/punbb/profile.php?id=3 2008-11-20T23:02:56Z https://frontaccounting.com/punbb/viewtopic.php?pid=1442#p1442 <![CDATA[Inventory Status]]> what table in mysql to view invetory status ?
and where's function get_qoh_on_date ?
thanks

]]> https://frontaccounting.com/punbb/profile.php?id=257 2008-11-20T15:31:58Z https://frontaccounting.com/punbb/viewtopic.php?pid=1437#p1437