Import/Export Items List, short description.

(0) Share

Report

Posted on by Community Member

Hi, we are trying to figure out if it is possible to export, then edit, then import our Items list (inventory). Management is hoping to change the "short description" on all items to be a category header to make it easier to break down when creating reports.

In short, they want to have items listed as "valves & fittings" "Spill containment" just as examples

We can go in and change each item one by one, but we were hoping for a solution that would allow us to change all of this info externally, and bring it back into great plains.

Thank you in advance.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

Hello Mark,

Yes it is possible. Use SmartList to Export all Inventory in Excel-->Update require field and import it back using Integration Manager. There are several product available to do import in Dynamics GP.

Thanks much

Sandip

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Looking in Great Plains, the option for Integration Manager is "gray" and we are unable to click on it. Is this something that will need to be purchased later ? Is it also User Friendly ? As in, we would not corrupt or do anything to our database other than changing that specific field in all records ?

Was this reply helpful? Yes No
Tami Farrelly 5,080 on at

Like (0)

Report

are there existing values in the short description??

you could use an update script in SQL

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, I believe that would be beyond my capabilities.

Was this reply helpful? Yes No
Tami Farrelly 5,080 on at

Like (1)

Report

cheaper and easier than integration manager

Was this reply helpful? Yes No
Suggested answer

sandipdjadhav 18,306 on at

Like (0)

Report

Hello Mark,

Check Dynamics GP Macro with mail-merge option. You don't need to buy Integration Manger if it is one time cost.

blogs.msdn.microsoft.com/.../how-to-use-word-mail-merge-and-macros-to-import-data

Thanks much

Sandip

Was this reply helpful? Yes No
mm123 2,535 on at

Like (0)

Report

Mark, Recently we developed a solution for our customer to export Price list & items list to excel , then make changes, import back to GP automatically. I am sure this solution will address your needs, If you are interested to learn please drop an email.

samr(at)expsoltech(dot)com

Was this reply helpful? Yes No