Dear Ganesh,
You have to use the table inventdim which carries the warehouse details. The
related field
in both the table is inventdimid.
Regards
Rekha
On 11/27/07, Ganesh kumar A. [EMAIL PROTECTED] wrote:
HI Friends,
my name is ashok (Ax4.0 Technical Consultant) i want Raw
material Stock Statement report. iam using invent Table as datasource
and in fetch method iam using invent trans table and depending on the
Status issue and Status receipt,inventTransType(purchase,sold etc) and
date status(using dialog method) iam fetching the transactions i.e,
(OPENING , RECEIPT ,ISSUES , CLOSING )
closing stock will be calculated using the formula
(opening stock + receipts - issues = closing stock)
but now i want same report using the warehous (i.e,inventLocationid)
in inventTrans table iam having inventdimid may be iam using wrong
datasource.
please tell me for warehouse which datasource i have to use and query
relations.
waiting friends for ur output..
mail id : [EMAIL PROTECTED] ashok.koduri.kumar%40gmail.com
[Non-text portions of this message have been removed]