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

This question is answered

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

Verified Answer
  • 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.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

All Replies
  • 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.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

  • Hi Andre,

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

    Regards,

    Anu

  • 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,

  • 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,

  • 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.

    kind regards,

    André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

    This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

  • Thanks Andre.

    Now got your point. Thanks for the possible solution.

    Regards

    Neha

  • Hi Anuradha ,

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