Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Removing quantity from...
Microsoft Dynamics GP (Archived)

Removing quantity from a misc type part number

(0) ShareShare
ReportReport
Posted on by MBender 270

I have a part number that was set up many years ago and was set up as item type misc charges.  It has a quantity assigned to it.  I would like to remove the quantity because we no longer use this part.  It will not let me do an inventory adjustment it gives an error saying:

 

"Kit, service, miscellaneous and flat fee items may not be adjusted"

 

I also tried to remove it by sales transaction but it just marked an item as sold but didn't remove any quantity.  Please let me know if there is a way to fix this.  The only option i can think of at this time is go into the iv00101 table and change the part type to something other then misc.

 

Any advise would be good, thank you.

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Removing quantity from a misc type part number

    You are quite welcome. Please verify the answer if you are happy with the results.

    Thank you,

    Leslie

  • MBender Profile Picture
    MBender 270 on at
    Re: Removing quantity from a misc type part number

    awesome thanks

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: Removing quantity from a misc type part number

    Michael,

    Edit the Item Master (IV00101) and change the field ITEMTYPE to 2.

  • MBender Profile Picture
    MBender 270 on at
    Re: Removing quantity from a misc type part number

    Thanks Leslie,

    I did what you suggested and removed it from qty from the IV00102, we don't use multi-bin.  I remove the quantity from BGNGQTY and QTYONHND.  How do I discontinue a part number?

    I appreciate your help.

    thanks

    Michael

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Removing quantity from a misc type part number

    MBender,

    Misc charges cannot have quantities. Someone must of set this up as a Sales Inventory item and then went behind the scenes to change it to a Misc part. You could just go in and edit the Item Quantities Master (IV00102) and get rid of any 'quantities' assigned to the item number. If you are using multi-bin, you might also need to check for bin quantities.

    If you want to remove this part number from your item master, you'll need to change it to a Sales Inventory item, make sure item quantities is zero, discontinue it, and then delete discontinued items during inventory year end close.

    In order to delete it the "right" way, you would have to remove any transaction history that used this item.

    You can't discontinue anything that isn't a Sales Inventory item, so often we change the item type just so we can mark it discontinued.

    It's not ideal, but it works.

    Kind regards,

    Leslie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans