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 NAV (Archived) / pasting journal from e...
Microsoft Dynamics NAV (Archived)

pasting journal from excel - dimension values don't copy

(0) ShareShare
ReportReport
Posted on by Community Member

I have the following journal in excel which I want to paste into a NAV General Journal:

Everything pastes into the NAV journal except for the Job Code and the Department code.  Why does this happen?  I know that the fix for this is to move the Job Code and the Department code so that they are after the Bal.Gen Posting Type.  But I would still like to know why it doesn't work if the columns are as shown in the picture?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Maneesha Profile Picture
    Maneesha 5,891 on at

    hi SergeiJ ,

    yes you are correct you now the fixed actually right the reason is  Job Code and the Department code referring Bal.Gen Posting Type its allocating and capturing by inside

    so that Bal.Gen Posting Type should be in first whats going to posting (rg : Purchase /sales/settlement) according to that the dimension levels items / production are allocated

    its like priority ,

    when you paste actually its copied, its there but when Bal.Gen Posting Type applied its refresh the lines on dimensions that the issue

    you know the solution its the right , just follow that :)

  • Community Member Profile Picture
    Community Member on at

    I have another issue with pasting from excel - perhaps you can advise me on this as well.  When I paste a "Null" value into Gen Posting Type - NAV comes up with a validation error "Your entry of '' is not an acceptable value for 'Gen.Posting Type'.  However, when I click on the options for Gen Posting Type and select the blank, NAV then accepts the entry.  Is there any way around this? 

  • Maneesha Profile Picture
    Maneesha 5,891 on at

    if wanna send "Null" value

    mark you excel Gen Posting Type field as "0"

    dont use any other charters

  • Community Member Profile Picture
    Community Member on at

    Nope.  This did not work.

    However, I have solved my problem in pasting from excel - it took be almost all day yesterday in figuring it out.  But I also had to rewrite/amend a macro in excel that creates the journal.  This is the column layout that finally worked:

    Posting Date

    Document Type

    Document No.

    Applies-to Doc.No

    Account Type

    Account No.

    Description

    Amount

    Bal. Account Type

    Bal. Account No.

    Gen.Posting Type

    Job Code

    Department Code

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    For anyone else still struggling with this issue, I think I have discovered a solution.  NAV does not like pasting blank cells from Excel into Option fields which have a Blank option - Document Type, Gen. Posting Type etc.  If, however, you put a Space character into these fields on your Excel template, then this does not cause the error.  Problem solved!

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 NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans