Printing of Inventory Count in SAP Business One

Dear SAP Experts,

Good morning!

We are using SAP Business One and we will be using the Inventory Count and need to print from the said Module. We have found out that the Standard Print Out Report/Form Lay-out does not contain Batch Number (We managed our items by batch number). I need to create a crystal lay-out report from here just to have a print out copy of the inventory count with batch number for the basis of the counting purposes. With your expertise skills, may I request your assistance the linkage between OINC or INC1 to the batch number management.

Here is the Script started:

SELECT

a.DocNum,

CONVERT(DATE, a.countdate) 'Count Date',

CONVERT(DATE, a.createdate) 'Create Date',

b.LineNum,

b.ItemCode,

b.ItemDesc,

b.WhsCode, b

.InWhsQty,

b.Counted,

b.CountQty,

b.CountDiff,

a.Time,

a.Taker1Id,

a.CountType

FROM OINC A

LEFT JOIN INC1 B on a.DocEntry = b.DocEntry

Your immediate response is highly appreciated.

Thank you.

Best Regards,

Stephen P. Soriano