Based on the information provided, it sounds like the INReceiptStatus table is the most appropriate table to use to track the receipt number of an item that was selected for a sale. This table contains receipt number and receipt date information for every inventory receipt/return.

If you need to track the connection between a purchase and a sale, you may consider using the POOrder and SOOrder tables. The POOrder table contains information about purchase orders, and the SOOrder table contains information about sales orders. You can use the ReceiptNbr field from the INReceiptStatus table to link an inventory receipt to a purchase order in the POOrder table, and then use the OrderNbr field from the POOrder table to link the purchase order to a sales order in the SOOrder table.

It is important to note that this is just one approach, and you may need to make modifications to suit your specific use case.

Thank you Yuri, 

Im going to look into it. Just fyi...Im not trying to obtain the ReceiptNbr in a Sales to Purchase case, i want to obtain it when FIFO or serial issues method are performed.

Ill update this case after testing.