You’re offline. This is a read only version of the page.
3,225
I need to know if this is possible. We have GP 2010.
Can you change a kit to just an item number under your normal sales inventory?
For example we had a kit "SRMIXA2" We no longer want to use a kit but we do still need that item number.
I can not delete it because we need to keep the history, but I can not change the item type from kit to sales inventory.
Any other way to do this?
Thank you,
*This post is locked for comments
I do believe you are an accountant Ms. Katie, just guessing :)
You will absolutely do great with SQL,
Always welcome :)
Dont worry. I will not be doing any SQL :) (even though it does sound interesting to learn) I have sent this thread to our partner to see if she can assist in this. I appreciate all the feedback.
I would never suggest SQL update statement for an end user with no knowledge with SQL management studio, it would end up with a misery if they missed the where statement, table name or any other parameters. No matter how simple the update/delete statement could be, manipulating db records is not a recommendation.
In this essence, Microsoft has released automated solutions (.msi) for very simple issues such as the commonly known batch status issue in order to save the end user undesirable touch with the GP database.
Please never hesitate to share any further inquiries,
Soma,
FYI, I intentionally omit SQL code this easy. If the user cannot write it, they need to take the issue to a partner to avoid damaging their database. Yes, the line is so easy for those of us that know how but to someone that has no SQL background, they should not be plugging in the code.
They could have also opened IV00101 in MS SQL Studio for the part number and manually changed the value.
Thank you for your help. I am not able to do SQL so I will send this on to our partner.
Katie
As was mentioned above, history will stay with the SRMIXA2_old item.
If you are comfortable with SQL...
1. Create a test company using the data from your live company
2. In the test company, change the Item Type from 3 to 1 for the item.
3. Check out everything. can you still enter orders? can you now enter PO's? Is history as you expect it?
I have had success with this method but suggest extreme caution.
Note that I did not include SQL statements. If you don't know them, get your partner to assist.
If you use the PSTL Item Number Modifier, you could change the original SRMIXA2 to a different name (maybe SRMIXA2_old or something?), then create new item called SRMIXA2. Historical data will be tied to the _old item, and you can create a new item.
Disclaimer - I did test this, but it was in Fabrikam, Inc.; this may work differently in your environment. Make sure you take a backup beforehand if you try this.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (