×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Replacement Item Numbers

Replacement Item Numbers

Replacement Item Numbers

(OP)
This is a connected issue with my previous thread for using Code 39 font in Report Writer. I was successful in creating a calculated field, thanks to David Mizzou. Unfortunately, another problem was discovered when we tested a variety of item numbers on the report. Although most items print and scan just fine, items with spaces, the # (pound) sign, and the & (ampersand) sign do not scan. These characters, along with a few others do not work with the Code 39 font.

The solution is to create new item numbers as replacement for the problem items (there are about 150 in total), and doing this is not a big issue. The big issue is we lose all historical and transaction data with the new item. Other inventory systems I used in a previo0us life always allowed an easy transfer of such historical data from the old item to new; unfortunately, Dynamics GP does not! It is another important feature they just plain forgot or do not care about!

There is a product called Changer designed to do this. Has anyone here had any experience with this add on product with GP 10?

RE: Replacement Item Numbers

The Professional Services Tools Library (PSTL) from Microsoft has a tool called Item Modifier that will let you change the name of an item while preserving all the history. Microsoft has now made this tool free, you can get it through your GP Partner.

Victoria Yudin
Dynamics GP MVP 2005 - 2012
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

RE: Replacement Item Numbers

(OP)
"The Professional Services Tools Library (PSTL) from Microsoft has a tool called Item Modifier that will let you change the name of an item while preserving all the history."

Victoria:

By "name", I assume you mean item number? There is also a Dynamics GP add-on called modifier that will do the same thing, although it also allows you to change vendor ID, Customer ID, etc. It, however, not free! Free is good. I will check this out.

Thanks

RE: Replacement Item Numbers

Sorry, yes, I meant Item Number. The tools for changing Vendor IDs, Customer IDs, GL Account Numbers, etc. are all part of the PSTL, which is now free for GP 10.0 and 2010 (announced in March by Microsoft). Free IS good. smile

Victoria Yudin
Dynamics GP MVP 2005 - 2012
Use Crystal Reports and SSRS with GP:
http://www.GPReportsViewer.com/gpreports.html
blog: http://victoriayudin.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close