I have been asked to produce a report of Transfer Orders and Posted Transfer Receipts, to show -
i) Orders which still have items to be received
ii) Orders which have been partially received and have some outstanding items
and iii) Orders which have been fully received
Since SQL Unions are not allowed in Business Central, I wondered if there was another way to combine the data from the orders and receipts.
Thanks for any help in advance

Report
All responses (
Answers (