How I can find Product Receipt Number from Posted Invoice Journal for Item Non Stock / Procurement Category.
I know we can find Product Receipt from Lot Transaction but it just for item stock, now I want for my item non stock because I want to show the User if He/She wrong match product receipt.
Hi @edwind90
For non-stock items, check VendInvoiceTrans.PurchReceiptId first, that’s your direct link to the receipt number.
If it’s empty (common for non-stock), join VendInvoiceTrans → PurchTable → PurchRcpnHeader via PurchaseOrderNumber. Non-stock items often skip formal receipts, so this indirect path is usually needed.
Add a computed field in your form using this logic to show users the receipt instantly and flag mismatches.
Hit a wall on the table joins, let me know.