Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 1RLMvKoCzj7/5ujni9U6B4
Power Automate - Building Flows
Unanswered

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

Like (1) ShareShare
ReportReport
Posted on 6 Feb 2022 04:37:14 by 14

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

  • CU31070740-0 Profile Picture
    on 31 Jul 2024 at 08:10:43
    Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence
    Is Fin & Ops (Dynamics 365) app released for Android OS?
  • AaronChen Profile Picture
    on 19 Jul 2022 at 04:38:38
    Re: Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence

    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. 

  • Unknown geen idee Profile Picture
    1,755 on 25 Mar 2022 at 15:44:56
    Re: Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence

    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?

     

  • abm abm Profile Picture
    32,464 Most Valuable Professional on 06 Feb 2022 at 23:39:08
    Re: Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence

    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

     

     

  • JamesTerrington Profile Picture
    14 on 06 Feb 2022 at 23:25:29
    Re: Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence

    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 abm Profile Picture
    32,464 Most Valuable Professional on 06 Feb 2022 at 23:14:55
    Re: Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence

    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

  • JamesTerrington Profile Picture
    14 on 06 Feb 2022 at 23:11:52
    Re: Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence

    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 abm Profile Picture
    32,464 Most Valuable Professional on 06 Feb 2022 at 23:01:12
    Re: Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence

    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.

     

    image.png

     

    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

     

     

  • abm abm Profile Picture
    32,464 Most Valuable Professional on 06 Feb 2022 at 12:59:30
    Re: Fin & Ops Apps (Dynamics 365) CREATE A RECORD - Create Vendor with Automatic number sequence

    Hi @JamesTAust 

     

    Is this field mandatory?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started