Serial number inquiry

[Former Member]

I am looking for the quickest way to view the transaction history of a specific serial number. For example I want to see the PO no., Rcpt no., Invoice no., etc...

The serials number management report basically provides the data I want, but in the Selections Criteria window Numberings tab the serial number from/to doesn't have a lookup function. Is this window my only or best option?

[Former Member · Accepted solution]

Hi Robert ,

What is your purpose of tracing all transaction? Do your need to know who has particular serial number ?

B1 has so far only serial number report and I don't think you have any other report regarding Serial number.

May be you have to build up customised query to fulfll

your needs in this case .

Thank you

Bishal

[former_member204969]

You can set one or more FS to the Serial Number Transaction Report - Selection Criteria window and select from the list provided by the FS. E.g. to the Serial Number From and To field you can connect this FS:

SELECT IntrSerial From OSRI Where ItemCode=$[OSRI.ItemCode]