web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Import PO invoice via excel

(0) ShareShare
ReportReport
Posted on by 30

Hi all, 

I'm processing to import PO invoice into Pending vendor invoice screen. I find out, it could use 03 entity to import PO invoice:

+Vendor invoice header

+Vendor invoice line

+Vendor invoice subline

I added these entity in a single import project and set "HEADERREFERENCE" field is auto generate. However, when I'm process to import, it happen error for Vendor invoice line as:

"Number sequence is not set
Issue exists in auto generation of number sequence
Issue exist in generate staging data
'2' 'Vendor invoice line' record(s) inserted in staging"

2437.pastedimage1575451770284v1.png

Anyone can show me how can I import vendor invoice header and line in a same project. 

Thanks in advance

Chloe

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    301,037 Super User 2025 Season 2 on at

    Hi Chloe,

    I have moved your question to the Dynamics 365 Finance forum. Your error is on the line entity.

    You can't setup an auto numbering on the line level as it should get the reference from the created header. Have you tried to use the composite entity 'Vendor invoice'?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Chloe,

    The screenprint refers to D365FO. Please don't use the AX2012 tag.

    Moved this thread to the D365Finance forum.

    About your issue:

    Please ensure that all number sequences are setup.

    To get this quickly done, you can make use of the number sequence wizard that is available in the number sequence form in the Org Admin module.

    Once they are setup, try to import again.

    Best regards,

    Ludwig

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans