Announcements
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
Hi,
Yes, you can link.
Take Transfer Header dataitem and then Link Transfer Receipt Header with field Transfer Header --> No. field and Transfer Receipt Header "Transfer Order No." field.
Regards
Amit Sharma
https://linkedin.com/in/amit-sharma-94542440
Press Yes If info is useful.
André Arnaud de Cal...
294,125
Super User 2025 Season 1
Martin Dráb
232,871
Most Valuable Professional
nmaenpaa
101,158
Moderator