web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Table Import for Class...
Finance | Project Operations, Human Resources, ...
Suggested answer

Table Import for Class ID's

(0) ShareShare
ReportReport
Posted on by TCREGINA 15

Hi, I am working on a test company trying to import Class ID's and Account Groupings. I was successful in the Class ID's but not the Account Groupings. I deleted the Class ID import to start over by going to Utilities>FA>Clear Data. Now, I am unable to even do the Class ID import. I checked all my choices i.e. "Source File Format" = Tab. My Excel import file is set up the same, no headers and columns formatted by Index=number, Class ID and Class Description=General. The first issue popped up when the Data Map Table looked weird....instead of (see first example), pastedimage1658151951114v3.pngI had (see second examplepastedimage1658151553160v1.pngpastedimage1658151883171v2.png

If anyone could give me the benefit of your expertise, it would be very much appreciated. Thank you

Categories:
Microsoft Dynamics GP
I have the same question (0)
  • Suggested answer
    Cheryl Waswick Profile Picture
    Cheryl Waswick on at
    RE: Table Import for Class ID's

    I tested the FA Class ID with table import and it worked for me. 

    • on the left below, I put my data in a .CSV file (and viewed it with Notepad)

    • For the value in the first field, I used a value higher than the highest last used value in the FA CLass ID table (FA40201).  My table had used index values of 1-7, so I put '9' on my csv file.   (I see you have a value of '1', so be sure that has not already been used in the FA40201 class ID setup table.  Increment it to a value higher than has already been used.) 

    • Then I went to Tools | Integrate | Table import and just mapped the first 3 fields (Shown below in middle) and clicked on IMPORT and it worked.  I can now see this new class in the FA40201 table. 

    pastedimage1658176961089v1.png

    Usually when invalid values appear as you asked about on the right, it means it can't read something.  Like if you map it to a CSV file and save it, and then go back into the import and switch it to TXT file, then the values on the right would be invalid and not display correctly anymore.   So the invalid values are due to you changing something where it can't read it anymore. 

    I hope this works for you to get new CLASS ID's importing in again. 


    Cheryl 
    Microsoft Support - GP Apps team

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 783

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 715 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 519 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans