Tim Keating
Senior Member
  

DBA CLASSIC WIN 2000 C/S
Posts: 298
|
For this report I would link the Inventory Transaction File, INVTXN, to the Inventory Master File, BKICMSTR. Using the BKIC_PROD_CODE Field, you have the potential to list all entered parts on the report, regardless of whether they have activity or not. Simple report line: BKIC_PROD_CODE MTIT_DATE MTIT_TYPE MTIT_QTY Sort, filter, group, subtotal and you're there.
|