We wanted to use the IC 6.1B's User defined cost 2 field to divide the Qty in hand
in QR 6.5. During the the formula in QR it says that User defined Cost2 field
should be a numeric (number required here) But on screen it is marked with 2 decimals.
Pls help.

The error message appears in the formula because Quik Reports sees a dollar field that has formatting for 2 decimal places and it knows that the results of the formula may be not be 2 decimal places.

To work around this, you need to enter a formula to convert the dollar field to text and then back to a number so that you can multiply. For example:

Most recent cost * ToNumber (ToText (Standard cost, 2))

Thanks for your hint. It worked. Now I am facing another problem. When we list the pending PO and their qty's in line with each item 2 records per item gets printed. It looked to me as if Receipt info (which is on the same data file) also gets printed. How could we restrict the report to have only one line per Item and say if many P/Orders are pending then to print many lines per Item. Any hints would be much appreciated..

Hello Devon,

To determine which transactions are Receipt transactions and which are PO transactions, you should add enough fields to a sample report so that you can differentiate between the two document types.

Some programs have a document type field. In others, certain fields are only updated for a specific document type.

For IC, you may be able to restrict the records by selecting records where the Receipt number is equal to " ".