Order Points

(0) Share

Report

Posted on by LarryL-KC

220

Does anyone know how to import Order Point Qty & Order Up To Level numbers into GP2013? Can't find anything in Integration Manager. I have tried Table import (Errors out - looking for currency it appears, that doesn't make sense). Import thru SQL server (although I don't know if I was doing that correctly) nothing changed. Any help would be greatly appreciated.

*This post is locked for comments

All responses (3)

Answers (0)

Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: Order Points

Sorry about that Larry, I failed to test the link prior to posting it. Try this one - blogs.msdn.com/.../how-to-use-word-mail-merge-and-macros-to-import-data.aspx. It works.

What SQL tool are you using to import the values back in?
LarryL-KC 220 on at

Like (0)

Report

RE: Order Points

Frank, I tried the link but it said "The Resource Could Not Be Found".

I haven't worked with SQL server very much, I did an export of the records and then changed the values and then did an Import back to the same place. It did not give an error nor did it change anything. This is on a test database.

Thanks

Larry
Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at

Like (0)

Report

RE: Order Points

Larry, do you have any other integration tools (eConnect, SmartConnect, Scribe) at your disposal? Table Import won't work because you can't use it for updates to existing records. Integration Manager won't work because it doesn't have the necessary source adapter. You could also use a macro to do the update. See this article on how to use a Mail Merge macro to update GP records - http://blogs.msdn.com/b/developingfordynamicsgp/archive/2008/10/30/how-to-use-word-mail-merge-and-macros-to-import-data.aspx.

When you say 'import thru SQL server', what do you mean? You did a record insert? A DTS job?