Hi all,
I am trying to return certain fields on all sales orders and posted sales invoices raised today, in DESCENDING time order.
I am using NL Rows, NP Union(NL Filter on "Sales Header", NL Filter on "Sales Invoice Header") (with relevant filters) returning the Document No. and that works, but I have two issues:
1. The Document No. for orders and posted invoices may be similar, even though the No. Series are different for each, (no opportunity for change).
2. NP Union sorts in ascending order.
I can run two NLs, one under the other, but I am unsure how to sort by 'Created Time' between the two tables on the one worksheet. Data only related to a single day - TODAY().
Just wondering if anyone has done something to handle anything similar to this?
Regards,
The Datalore ;)
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
I have the same question. I want to do an union between Sales header and Sales header Archive, and I want to sort the result by Customer No.
I can perform the union: C4 =np("union";NL("filter";"Sales Header";"No.");NL("filter";"Sales Header Archive";"No."))
And I can retreive informations from this union: D4 =if(NL("First";"Sales Header";;"No.";B4)<>"";NL("First";"Sales Header";;"No.";B4);NL("First";"Sales Header Archive";;"No.";B4))
But I don't know how to sort the result by Customer No. :?:
best regards
Please sign in to leave a comment.