Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence

[JamesTAust]

Good morning all 🙂

• I am using the - Fin & Ops Apps (Dynamics 365) - CREATE A RECORD item
• Trying to create a Vendor record in D365FO
• I have setup D365FO to have an AUTOMATIC vendor number
• I have tried leaving the VENDOR NUMBER field blank, but keep getting error about missing number
• Does anyone know if it is possible to have automatic vendor number in D365FO and still use PowerAutomate to create?

Regards

[abm]

Hi @JamesTAust 

Is this field mandatory?

[abm]

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

[JamesTAust]

Good morning abm 🙂

Thank you for responding

• Yes the field is mandatory in D365FO
• Yes the field is mandatory in the Flow item I am selecting
• There are two ways to setup the Vendor Number in D365FO
  • Manual entry
  • Automatic
• I am guessing that Powerautomate cannot handle the Automatic Vendor number
  • I cannot query D365FO to get the next number, this won't work sadly.

Regards

[abm]

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

[JamesTAust]

Reading the last record won't help for the following reason:

• If the Vendor number is setup to be automatic, a user cannot manually enter a number when creating a new vendor.
• While I might be able to get the last number and increment by 1 and put into the flow, D365FO will reject it as it is setup to be automatic allocation (not manual number allocation)

I hope that makes sense?

[abm]

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

[Koen5]

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?

[AaronChen]

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.