Microsoft Dynamics GP (Archived)

Adding an additional address ID in RM00102

(0) Share

Report

Posted on by Syrus

4,156

Hello Everyone Merry XMass

Just a quick question. The SOP table RM00102 is setup to have multple addresses with multple address IDs.

Is there any possibility to globaly update all the customers, by adding one more address ID in addition to the exisiting IDs by using SQL?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Adding an additional address ID in RM00102

How many inserts are we talking about here?

You can always write a SQL script to insert them or if you own Integration Manager you could do it that way. Just populate a spreadsheet or a text file and set up the integration.

There is no functionality directly inside GP to do a mass insert of customer address ID's

Was this reply helpful? Yes No
Syrus 4,156 on at

Like (0)

Report

Re: Adding an additional address ID in RM00102

about 7,000

Thanks for your quick reply

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

Re: Adding an additional address ID in RM00102

Is there anyway you can use a source file and use the data to help build script to insert these addresses in the RM00102?

If you can get the raw data into SQL you would need to add the customer ID and the new address ID you want to use to each record. You could then build a script and use the output of that script to actually do the insertion.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: Adding an additional address ID in RM00102

Hi,

You could of course use a script, all you are doing is adding records to a tsble. But...you are writing directly to the tables...and not in the process obeying the underlying GP business logic / additions to related tables etc. Instead of writing a script, you could use the table impor facility in GP.

But best to use Integration Manager or eConnect to get the data in.

Ian.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Re: Adding an additional address ID in RM00102

Ah yes, table import is so overlooked these days!

Just to clarify, the table import utility is a direct write to the tables, none of the GP business logic is evaluated with Table Import utilitiy. You don't need any SQL skills to use it. Just put your data in a tab or comma delimited text file and slam it into the tables.

Additionally, you can do inserts only with table import, it does not do updates. Since all you want to do is inserts, you should be good to go.

It is lightening fast!

Kind regards,

Leslie

Was this reply helpful? Yes No
Syrus 4,156 on at

Like (0)

Report

Re: Adding an additional address ID in RM00102

Thanks everyone, I will certainly all the options to see what best fits

Was this reply helpful? Yes No