Hello everyone, The following link states that orders for books that have not been received is accessed by the aqorders for which datereceived is Null: Acquisition Reports - SQL Library <https://wiki.koha-community.org/wiki/SQL_Reports_Library#Acquisition_Reports> But this SQL query also makes use of the column biblio. Will record of an item exist in the biblio and biblioitems table before that item is received by the library? I understood that biblio and biblioitems are created after catalogging a book. Regards *Raghav Arora* Sophomore, M.Sc (Hons) Chemistry BE Electrical and Electronics Engineering Contact : (+91) 9897597761 Personal Email <raghavarora999@yahoo.in> | University Email <f20171016@pilani.bits-pilani.ac.in> LinkedIn <https://www.linkedin.com/in/raghav-arora-9820a648/> | GitHub <https://github.com/RAraghavarora/> ▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄ *Birla Institute of Technology and Science, Pilani* Pilani campus, Rajasthan-333031