Hello all, I need to get a report of all quotes raised even those converted to a sales order. I'd imagine that this requires a union Join to the sales quote archive table but I just cannot work out how to link it in jet. Thanks.
Date
Votes
2 comments
-
CascadiaDataworks While you could attempt to use an NP(Union), you are better off creating replicator for each table and just putting them on subsequent rows. If you try to union, and you need anything other than generating record keys and using only NF functions, you will end up with having to use crazy logic to try and figure out which table to pull NL values from.
On top of that, if you union all record keys from multiple tables together, you end up with a list from Table A, then a list from Table B, and so forth, which is the same as just using stacking Rows on subsequent rows in Excel.
If you would like to discuss more, feel free to reach out to me at my username at gmail.
-
Sam G Thanks for your answer - much appreciated.
Please sign in to leave a comment.