Forum Discussion

Grandinfo's avatar
Grandinfo
3 years ago

MYOB V19 - Stock items that are not inventoried

Hi community,   Is there a way to count inventory on items that are not initially inventoried?   It seems our company had set over 900 items that don't appear in the count inventory tab. I canno...
  • gavin12345's avatar
    gavin12345
    3 years ago

    Hi Grandinfo 

     

    You cannot change the existing Items. You need to create new ones. This is the 'work around', say you have an item called 100B and you have existing transactions using this Item.

     

    • Create a new Item Test000 and set up this Item the way you want your Items to end up (I Buy, I Sell, I Inventory etc and set accounts for each)
    • Export all of your Items
    • Open 100B and on the profile tab change the Item Number to zz-100B (or similar) and make the Item Inactive
    • Repeat for all other Items
    • Edit the exported file and modify the existing items using Test000 as a guide
    • Save as tab delimited and import

    You will now have 900 Items with the correct Item Number and settings, as well as 900 Inactive original Items

     

    If you don't fancy manually changing 900 Items, there is a MYOB specialist who can do all this for you in bulk. Send me a private message if you want contact details.

     

    Regards

    Gavin

gavin12345's avatar
gavin12345
Ultimate User
3 years ago

Hi Grandinfo 

 

You cannot change the existing Items. You need to create new ones. This is the 'work around', say you have an item called 100B and you have existing transactions using this Item.

 

  • Create a new Item Test000 and set up this Item the way you want your Items to end up (I Buy, I Sell, I Inventory etc and set accounts for each)
  • Export all of your Items
  • Open 100B and on the profile tab change the Item Number to zz-100B (or similar) and make the Item Inactive
  • Repeat for all other Items
  • Edit the exported file and modify the existing items using Test000 as a guide
  • Save as tab delimited and import

You will now have 900 Items with the correct Item Number and settings, as well as 900 Inactive original Items

 

If you don't fancy manually changing 900 Items, there is a MYOB specialist who can do all this for you in bulk. Send me a private message if you want contact details.

 

Regards

Gavin

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.