Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

GL Interface Tables

Posted on by Microsoft Employee

 Currently we have to switch to each one to upload excel General Ledger entries using D1 Free Excel Paste.  This is very time consuming since we have around 20 companies and have to switch to each one and do the upload.  Can some provide any guidance with potential using an interface table or another integration tool.  We strictly need this for the General Ledger

Categories:
  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 10,996 User Group Leader on at
    RE: GL Interface Tables

    Your screen shot is not very clear, all I can see that you are showing some options in Additional Menu.Are you using some custom code? 

  • 26P2ER Profile Picture
    26P2ER 1,773 on at
    RE: GL Interface Tables

    Hey Nikolaos T:

    As Richard pointed out, eOne solutions offer a nice suite of tools starting with Smartconnect. You setup what are called Maps in there and can probably add post map tasks to run the remaining 19 imports. Plus all this can be done by just clicking a button in Smartconnect, no GP sessions is required.

    Plus the entire execution can be scheduled if needed.

    Good luck.

    Best Wishes

    Ven

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: GL Interface Tables

    I would look into SmartConnect from eOneSolutions.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,570 Super User 2024 Season 2 on at
    RE: GL Interface Tables

    Moved to the Dynamics GP forum.

  • vinitgoyal2005 Profile Picture
    vinitgoyal2005 6,330 on at
    RE: GL Interface Tables

    Nikolas,

    This forum is for Dynamics 365 Finance and Operations.  You need to ask the question to correct forum. here is the link community.dynamics.com/gp

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL Interface Tables

    This is the ERP application

    5861.pastedimage1596744580557v1.png

  • nmaenpaa Profile Picture
    nmaenpaa 101,148 on at
    RE: GL Interface Tables

    Could you be more specific? Is it Dynamics CRM 2016?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL Interface Tables

    Microsoft Dynamics 2016 is the version we are using.

  • Sukrut Parab Profile Picture
    Sukrut Parab 71,645 Moderator on at
    RE: GL Interface Tables

    Can you share more info about your requirement ? Also information about your version , from where data is coming for these entries etc.. without knowing anything its difficult to provide suggestions. Looks like you are using AX 2012 , this forum is for D365.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: GL Interface Tables

    Thank you for responding

    It the feature in the Journal entry.  I would rather have all of these entries automate via and interface or some process.  Any help will be much appreciated

    0042.pastedimage1596742111730v2.png

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans