Skip to Content
Author's profile photo Jeroen Waart

Find the first delivery of an order

A customer wanted a delivery analysis, which meant for them: what’s the delivery % on the first delivery created for an order. In other words how complete is the first delivery for an order. This gave me a challenge, because I can easily find out if an orderline is delivered or not, but it was not that easy finding out if it was delivered with the first delivery.

For this I created a join where I searched for all DLN1 lines per order (no matter if it was the first or second one). To be able to do this I created a join between docentry of the order and base entry for the DLN1. I didn’t join the baseline as you would normally do.


I created an aggregate on the docentry of the DLN1, where I wanted the minumum number of the docentry (which is always the first delivery, as the docentry is an internal numbering). After this, the result was I had the order and the First delivery of that order. Later on I could join this delivery in combination with the linenumber of the order, in order to find out if the line of the order was delivered in the first delivery.

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.