1 Topic by henryadam (edited by henryadam 11/20/2008 07:48:00 pm)

  • Registered: 11/20/2008
  • Posts: 3

Topic: Inventory Status

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

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

  • Registered: 11/20/2008
  • Posts: 3

Re: Inventory Status

joe,
wheres table for inventory adjustment,

thanks
henry

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

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

  • Registered: 11/20/2008
  • Posts: 3

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

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Inventory Status

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

/Joe