I am trying to generate a report from QR based on Movement Reporter (peresoft) with the columns as Item, Location, Transaction type, reference and Quantity and the total line to have the physical qty at a location based on IC.
Q1. I get 3 records repeated after each line of detail. Any hints on how to avoid this.
Q2. When the selection is made thru MR location field how can one link the IC location file to retrieve qty in hand by a similar location (say location number =1)

Thanks in advance

Hi Devon,

I'm not familiar with the Movement Reporter program, so I don't know how the data is structured. Typically, if you are printing a report in Quik Reports and it appears that records are being duplicated, usually they are different records, but the field(s) that are different haven't been placed into the report. For example, Order Entry transactions can have a 'Document Type' of order, invoice, or credit note, and if this field is not used in a report, an order/invoice can look like duplicate records. What you'll have to do is look for some other fields in this table, such as transaction type, and when you find a difference, create a selection formula to choose the records you want.

The issue could also be related to linking, if you have more than one file on the report (ie item master and transaction file). For this type of report, you want to 'drive' fronm the transaction file. From Edit Links, choose driver, and if you are given the option of choosing from 2 or more files, pick the transaction file. Also edit the link field to what's appropriate (probably item number) and set the link mode to 'one-to-one'.

As for your second question, if this issue is how to link two files, this should be done through the table; it cannot be edited by a user. Whatever pre-determined settings have been written into the table, you can choose from those options in Edit Links. That would mean that in Edit links, when a link is created from Files between the MR file and IC Locations, a link field of Location Code should automatically be an option for you to select.

Hope this helps out,
Softrak Support