Good morning all π
Regards
There is a Odata table SequenceV2Tables which stores the all the number sequence for the different entities that using auto number.
System will generate a Vendor number for the next vendor you will create. You can find you your next Vendor number in this table and apply to your Power Apps /Power Automate.
I am having a similar problem in creating a record in D365FO with PowerAutomate.
I am trying to create a new Arrival Journal in 'ItemArrivalJournalHeadersV2'.
'Journal' is a mandatory field which cannot be left blank.
You have to put in the 'next/new' journal number, this cannot be lower or higher than what D365 expects.
However, the next journal number is not simply the last journal +1. The number may be 20 or a 100 numbers higher.
So I am in a bit of a jam. I MUST put in the number, the number MUST be correct, but I have no way of finding the right number and looping through until I get it right is just too big of a range.
Anyone any ideas?
Hi @JamesTAust
Thanks for your reply. I did tried in D365 CE and it did worked for me by setting the manual value. Did you tried and getting any error?
Thanks
Reading the last record won't help for the following reason:
I hope that makes sense?
Hi @JamesTAust
I don't have D365FO to test this. Yes if its mandatory without mapping flow won't be able to save it. What I am confused is if flow is creating the record why can't you read the latest record? Could you please explain?
Thanks
Good morning abm π
Thank you for responding
Regards
Hi @JamesTAust
You could get the latest record autoid value by querying the list row createdon field as desc and set the row count to 1.
Once you had the value increment by 1 and set the value under the create record.
What I am not sure is if its non mandatory why its complaining about it?
Thanks
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional