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) / Importing payment jour...
Microsoft Dynamics NAV (Archived)

Importing payment journal lines with Bal. Account Type of Bank Account

(0) ShareShare
ReportReport
Posted on by Lowprofiler 37

I'm using Config. Package Card to import payment journal lines in an Excel file, to table 81 - Gen. Journal Line. In the Bal. Account Type field we have Bank Account and in the Bal. Account No. field the bank account code. However, the Bal. Account No. field has table 15 G/L Account as its Relation Table, so I uncheck the Validate Field option otherwise the system is validating the bank account code against G/L Account number. The problem is that for some reason when the data are imported, the bank account code is not imported at all, i.e. Bal. Account No. field is all blank. Any advice why this is happening and any solution please? Thanks. 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Alex A Profile Picture
    Alex A 2,870 on at

    Hello,

    Double check the Filters and makes sure nothing is preventing the Bal Account Type field for type of Bank Account from coming in.

    You might try entering one row of correct data into the General Journal Line in NAV, a legitimate line, and then exporting that from the Configuration Package card to Excel to create an import template spreadsheet with one existing row of data that you know is good. Then test importing that back in and see if it works.


    If it does, then continue to test adding your own second line into the same excel spreadsheet and now importing both records in to see if it works. If that is good to go then you should be able to put all your data into the import template and go for it.

  • Verified answer
    RobertasR Profile Picture
    RobertasR 5,004 on at

    Hi,

    that is not strictly correct. The relation of Balancing Account No. filed depends on what is in the Balancing Account Type fields, for example, if 'Bal. Account Type' is 'Bank Account' then the 'Bal. Account No.' will validate with Bank accounts.

    However there is a small flaw in standard configuration packages. If you go to the list of fields in the package, you can see that 'Bal. Account Type' comes AFTER 'Bal. Account No.' as Processing Order. You need to Move Down the Bal. Account No. to be below Bal. Account Type and all will import correctly with validations.

    Hope that helps.

    Robertas

  • Lowprofiler Profile Picture
    Lowprofiler 37 on at

    Hi, Robertas,

    Thank you very much.

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