Why are Receipt Notes not available on the PO Receipts data view?


Management has considered the addition of Receipt Notes into the PO Receipts data view but has opted against it due to some concerns.  


First, the PO Receipts data view presents detail-level data whereas the Receipt Notes are header-level.  This means that a large PO Receipt for 100 items would show the Receipt Notes (which could also be very large) 100 times in the view, once for each line item.  This can become quite a lot of data.


Also, the Receipt Notes data itself can be incredibly large because it uses a "blob" field with essentially unlimited input.  So, even for a PO Receipt of just a few items, if the Receipt Notes is extremely large then it would slow down the reporting in that data view.