Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Unable to Import the Data
Small and medium business | Business Central, N...
Suggested answer

Unable to Import the Data

(2) ShareShare
ReportReport
Posted on by AH-17011133-0 7
I want to load 'Account Payables' module in a excel sheet to Microsoft Dynamics 365 Business Central. The closest tables to 'Account Payables' in Business Central are 'Vendor Ledger Entry' (Table ID - 25) and 'Detailed Vendor Ledg. Entry (Table ID - 380). Unfortunately, I don't have the permissions to import data to either of these 2 tables.

I notice the following error is preventing me to import the data. I did a brief research on the internet and I haven't found a concrete solution to this solution. Can anyone please guide me to proceed further?


Categories:
Dynamics 365 Business Central
Vendor Ledger Ent...
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 6,173 Moderator on at
    Unable to Import the Data
  • Suggested answer
    Mustafa Omerbegović Profile Picture
    Mustafa Omerbegović 1,090 on at
    Unable to Import the Data
    Hello,
     
    you cannot enter data into ledger entry tables like that. That are tables that will populate when you post some documents within BC. 
    If you want to post your starting balance, then you will need to use general journal and populate journal with Account type Vendor. After you post something to the vendor, then you will get vendor ledger entry for that postings.
     
    Greetings
  • Suggested answer
    Inkey Solutions Profile Picture
    Inkey Solutions 1,825 on at
    Unable to Import the Data
    Hello,

    Configuration packages cannot be used to insert or update data in any ledger entry tables. However, the general journal line can be used to load initial accounting balances and open ledger entries for customers/vendors.

    Check out this link: A Strategy for Opening Balances in Business Central - Dynamics 365 Business Central

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans