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 GP (Archived) / how can I combine acco...
Microsoft Dynamics GP (Archived)

how can I combine account numbers

(0) ShareShare
ReportReport
Posted on by PaulaCam1 1,005

I am using the professional Sevice tools to Change/combine Account numbers.

I have an excel file with the old and new account numbers.  The validation process works fine.  When I click the button to combine account numbers I receive the message:\

You can not have the same Account Number in the From and To

you must choose a new Account Number of=r Skip this

Change/Combine

 

I have verified the excel file and there are not account numbers in the From Field that is also in the Two field.  I have also manually setup a spreadsheet with 6 numbers to combine, saved to a txt file and tried to combine those.  I receive the same message.  If I Combine one account at a time the process runs with no errors.

Can someone guide me as to what I might be missing here?

 

Thanks

*This post is locked for comments

I have the same question (0)
  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Paula,

    I faced same problem and I documented in my blog here is link : sandipdjadhav.blogspot.com/.../professional-services-tools-import.html

    Let me know it work for you or not.

    Thanks

    Sandip

  • PaulaCam1 Profile Picture
    PaulaCam1 1,005 on at

    Thanks for the suggestion Sandip, but the file is a txt file with no header information.  I have combined account numbers in the past and they succeeded using the same type spreadsheet I am using currently.  I just can't get beyond the error

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Paula,

    Is it Tab Delimited or CSV file? You need Tab Delimited file.

    THanks

    Sandip

  • PaulaCam1 Profile Picture
    PaulaCam1 1,005 on at

    It is tab delimited

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    You mentioned that when you run them individually they run fine. Are you sure you have no From/To columns mixed? For example:

    1000 goes to 1010

    2000 goes to 2010

    3000 goes to 3010

    4000 goes to 4010

    5000 goes to 5010

    1010 goes to 6010 - This one would cause a problem because you have 1000 going to 1010 while at the same time you are trying to change 1010 to 6010.

  • PaulaCam1 Profile Picture
    PaulaCam1 1,005 on at

    positive, Ihad someone else look as well.  I even took two acounts and enter them onto a new import and tried to import just the 2 accounts and got the same error message

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    I would now suspect you have bad data in the PSTL for this funciton. I would delete whatever you have imported and start all over. Can someone chime in with the proper table names?

  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi,

    I don't know how long the list is, but what did you use to verify? You can open the file in Excel, then use Rmove Duplicates in the Data Tab of Excel. It will let you know if there are any duplicates. Watch out for Excel, it has a bad habit of stripping leading zeros.

    If you make your first colume all strings, you won't have that problem.

    Kind regards,

    Leslie

  • PaulaCam1 Profile Picture
    PaulaCam1 1,005 on at

    Thanks for the suggestion Leslie.  I used the data tab in excel to search and remove duplicaates.  The file is about 460 rows.  There were no duplicates.  

    I am going to run a dex log to see if that shows me anything unusual.

  • L Vail Profile Picture
    L Vail 65,271 on at

    Paula,

    I accidently sent this reply as an email message instead of a post

    If you do not see in the log, I would try doing half of the file, for instance to see if you can drill down on your problem child. Also, make sure you do not have any extra rows at the bottom of your import file.

    Kind regards,

    Leslie

    Sent from my iPhone

    On Sep 11, 2012, at 3:15 PM, Microsoft Dynamics GP Forum <dlcommed@microsoft.com> wrote:

    Re: how can I combine account numbers

    Replied to by PaulaCam1

    Thanks for the suggestion Leslie.  I used the data tab in excel to search and remove duplicaates.  The file is about 460 rows.  There were no duplicates.  

    I am going to run a dex log to see if that shows me anything unusual.

    You can view this thread online.

    To unsubscribe from only this thread, disable email notifications online .

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 GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans