I am doing a BAQ report for Inventory Usage as the coded one in Vantage only shows STK-MTL transactions and we would also like to sum ADJ-QTY transactions.
I have the following BAQ:
for each PartTran where ( PartTran.TranType = 'STK-MTL' OR PartTran.TranType = 'ADJ-QTY') no-lock , each UD01 where (PartTran.Company = UD01.Company and PartTran.TranDate = UD01.Date01) no-lock .
And in the Report Designer I filter on the Part Tran date (From / To). My problem is the report only seems to count the date for the ADJ-QTY transactions and includes all other transactions for the other transaction type. Am I missing something obvious, or is there a better way to do this report? Thanks.
I have the following BAQ:
for each PartTran where ( PartTran.TranType = 'STK-MTL' OR PartTran.TranType = 'ADJ-QTY') no-lock , each UD01 where (PartTran.Company = UD01.Company and PartTran.TranDate = UD01.Date01) no-lock .
And in the Report Designer I filter on the Part Tran date (From / To). My problem is the report only seems to count the date for the ADJ-QTY transactions and includes all other transactions for the other transaction type. Am I missing something obvious, or is there a better way to do this report? Thanks.