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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Auto generation of Vou...
Microsoft Dynamics AX (Archived)

Auto generation of Voucher number in GL Opening balance in Data import export framework

(0) ShareShare
ReportReport
Posted on by Anuradha Pandrangi 260

Hi,

I am able to import GL opening balances successfully when I provide the voucher number in the file. But I want to use the number sequence for voucher number. So in the mapping, I made the voucher number as Auto. But I get error saying

 

Default scope cannot be implicitly determined by the number sequence framework for the given datatype. Please provide scope information explicitly. Issue exist in generate staging data '3' 'Opening balance' record(s) inserted in staging

Any help is much appreciated

Thanks,

Anu

*This post is locked for comments

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

    Hi Anu,

    The auto numbering works only for number sequences which are setup in the parameters as reference. The number sequence for voucher numbering (journal name setup)  is not supported from my experience.

    We solved the problem by using the 'Number allocation at posting' option which you can setup within the journal names. We provided a dummy voucher within the file (provide an unique number per voucher). When posting the journal, the voucher is taken from the number sequence.

  • Anuradha Pandrangi Profile Picture
    Anuradha Pandrangi 260 on at

    Hi Andre,

    Thank you, very much for the reply. This answered my question.

    Regards,

    Anu

  • Community Member Profile Picture
    Community Member on at

    Hi Andre,

    Thanks for the response on above Post.

    With reference to same Issue, I have one query.

    While creating Template for General Journal Opening Balance Import, shall we take JournalNum and Voucher as columns or Not? (In case if we want to use system number series).

    If i am removing the columns from Template and trying to generate the sourcefile mapping system is giving me error "Mandatory field voucher is not mapped"

    "Mandatory field JournalNum is not mapped"

    Please help me in creating the template file and importing the General Journal Opening using system generated number sequence.

    Thanks,

  • Neha Mishra Profile Picture
    Neha Mishra 10 on at

    Hi Anu,

    Please let me know, how to set Voucher Number as an Auto field.

    While creating Template for General Journal Opening Balance Import, shall we take JournalNum and Voucher as columns or Not? (In case if we want to use system number series).

    If I am removing the columns from Template and trying to generate the sourcefile mapping and validating system is giving me error "Mandatory field voucher is not mapped"

    "Mandatory field JournalNum is not mapped"

    Please help me in creating the template file and importing the General Journal Opening using system generated number sequence.

    Thanks,

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

    Hi Neha,

    As mentioned in my answer it is not possible to use the auto numbering for the vouchers. But there is a workaround given. If you enable autonumbering for the journal numbers, the result will be that every single line will have a new journal number. This is not desirable I guess. So you have to fill it manually.

  • Community Member Profile Picture
    Community Member on at

    Thanks Andre.

    Now got your point. Thanks for the possible solution.

    Regards

    Neha

  • axerp Profile Picture
    axerp 2,600 on at

    Hi Anuradha ,

    Could you able to import the GL opening balances with the financial dimensions also using DIEF ?

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans