Hi,
I'm using Baan Iv c4 , I wanted to find a missing receipt no from table
tdpur045. having field tdpur045.reno. If receipt numbers are in sequence 1,2,4,5,7,11,12.. want to find missing one i.e. 3,6,8,9,10,.... Reteriving records with input field as receipt no (tdpur045.reno) it self in rang.
if anybody could help me out
Thanks and reagards
akash

I am not sure I understand - are you searching just based off receipt number or are you talking about for a given PO? For a given PO I would not expect receipt numbers to be sequential. And searching thru the table looking for receipt numbers out of sequence would a difficult task - and that is assuming receipt number is not part of the first free numbers - which I think it is and we did not have to reset it or something.

I checked the order quantity and backorder quantity to find a relation between the receipts within one purchase order line.

Some users booked zero receipts, the number was not always in sequential order.

Kozure

not sure if you can do this in your database:

select *
from ttdpur045150
where t_reno >= 'start reno'
and t_reno <= 'end reno'

not sure if you can do this in your database:

select *
from ttdpur045150
where t_reno >= 'start reno'
and t_reno <= 'end reno'

Hi
benito..
Thanks for the reply.