Hi,
I have a NL function that reports a Business Central table containing archive PO's...
=NL("Table","Purchase Header Archive")
I want to filter this data so that it only shows the latest archive version i.e...
If "Version No." = "No. of Archived Versions" then I want this data to be shown in the report
If "Version No." <> "No. of Archived Versions" then I don’t want this data to be shown in the report
Any help you can give is greatly appreciated
Thanks
Mike
Does the result need to use NL(Table)? Can it use NL(Rows) with NF() instead?
Additionally, how many different documents (not versions but documents) do you expect to be in your Purchase Header Archive? Are there any other filters or just all from that table?
Does the result need to use NL(Table)? Can it use NL(Rows) with NF() instead?
Hi CascadiaDataworks,
Thanks for your reply... sorry for my late reply.
Yes I could use NL(Rows) but I am not sure how to apply a filter that would be a different version No for each of the documents? i.e. PO 000001 needs filtering to version 2 and PO 000002 needs filtering to version 5 etc etc. (as these versions are the latest version of each of the documents)
The other filters are...
"DataSource" = "xxx"
"Company" = "yyy"
"Document Type" = "Order"
"No." = "PO011735.."
Currently there are 17,181 documents in the table excluding the above filters
(We have been using Business Central since 2020)
If I apply the "Document Type" and "No." filter then there are 5,447 documents
I don't have any data in my archive table so I can't verify the syntax, but it would probably look something like this:
=NL("Rows","Purchase Header Archive",,"Version No.",NF(,"No. of Archived Versions"),"Document Type","Order","No.","###"....)
Hi Mike, my reply got flagged for pending approval (which will never happen, this board isn't monitored) because it had code it in. Hit me up at my username at gmail for the answer.
Hi CascadiaDataworks,
I think the pending approval might be a new feature. my posts above had the same "pending approval". As this might be useful to others too please could you take a screenshot of your code and post that? I don't want to user gmail etc as I have had issues with scammers in the past.
Thanks for your help
Feel free to find my youtube channel, all my posts are getting flagged.