Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Lowprofiler Profile Picture
    Lowprofiler 37 on at
    RE: Importing payment journal lines with Bal. Account Type of Bank Account

    Hi, Robertas,

    Thank you very much.

  • Verified answer
    RobertasR Profile Picture
    RobertasR 5,002 on at
    RE: Importing payment journal lines with Bal. Account Type of Bank Account

    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

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: Importing payment journal lines with Bal. Account Type of Bank Account

    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.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans