Fail to create new Item Arrival Journal in D365 F&O with Power automate due to number sequence

[Koen5]

Hello,

How can I figure out the next 'new' item arrival journal sequence number in D365 F&O?

D365 F&O only allows you to create a new item arrival journal in the "ItemArrivalJournalHeadersV2" entity if you define exactly the next sequential number. The problem is that the sequence does not seem to follow a +1 process. If the last journal is for example 5999, then the next journal number can be 6000, 6005 or 6012 ... I cannot get a grip on it.

I could write a 'Do until' loop to keep trying, but that seems sloppy, is there a better way?

Thank you in advance for your time/ideas.

Happy flowing,

Koen

[Heartholme]

@Koen5 

Posting it here as well, so it will be visible to other users in the future: 

I've ran into this exact issue as well, with both this journal and other journals. ItemArrivalJournals does not follow a +1 sequence like you say. This is because whenever you post Item Arrivals, through PO's etc, the record is posted as an item arrival journal, but don't show up in the "ItemArrivalJournalHeadersV2" entity. Since this entity is only showing journals specifically posted through Item Arrival. I initially did something like you, and iterated upwards from the last journal in ItemArrivalJournals, but ran into the same issues as you did, where you can end up being so far behind on the ItemArrivalJournalHeadersV2 seq. number. Since you almost never create Item arrivals manually through a journal. At least not compared to other item arrivals. 

So for a good solution to this, you have two options: 

1. Coordinate with a developer to make a custom entity, where you can create item arrival journal without including the item arrival journal number. 
2. Coordinate with a developer and have them setup an Azure function which writes to ItemArrivalJournals. Then you will be able to post HTTP request to the Azure function which is then posted to the system. For some reason, it's possible to post to this entity through Azure functions without needing the next Journal Batch Number in the sequence, but not from PowerAutomate. 

In my opinion this is something that should be possible with PowerAutomate, so I suggest that you post it to the PowerAutomate suggestion page. I'll do the same, and hopefully selecting the next number in the number sequence for all journals will be in a future release. 

Hopefully I were able to provide some clarity on the issue. 

Br

Joachim 

[Koen5]

Dear Joachim,

Thank you for your input. Knowing that you have experienced/tried the same at least makes me think that I am not a complete idiot in missing something obvious.

Including a developer at this stage is not open to me (resources are tight), thanks for the suggestion though.

Happy flowing,

Koen