Author Topic: Changing category of an existing item  (Read 1201 times)

johnlewisdesign

  • Member
  • *
  • Posts: 81
Changing category of an existing item
« on: September 24, 2013, 06:47:47 AM »
Hi guys I need to recognise a change in category for existing inventory items but I don't see the logical place to do this skimming the OSR. What is the usual way of approaching a category modification? Does it need to be separate from ItemInventoryMod?

TIA,

John

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Changing category of an existing item
« Reply #1 on: September 24, 2013, 07:14:20 AM »
Not sure what you're asking--there is no QB-native Category field for any Item type. Is Category a custom field in your QB Company file? (A custom field in QB is a DataExtDef record, its value is a DataExt record that links to a parent record.)

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852

johnlewisdesign

  • Member
  • *
  • Posts: 81
Re: Changing category of an existing item
« Reply #2 on: September 24, 2013, 07:41:46 AM »
Sorry Geoffrey I've not looked for a bit! I usually have a mad purge towards month end with people requesting new features but I picked this up off somebody else so am learning on my feet.

By category I mean I have categories in my system such as Misc with a product SKU1234 inside it

In QuickBooks it is hierarchical such as

Misc
   SKU1234

(the product is a child of Misc.)

However if I change in my system to Category Other it still shows as Misc:SKU1234 in QuickBooks.

To add, I use

PCQB_RqNew( "ItemInventoryAdd";"" )
PCQB_RqAddFieldWithValue( "Name" ;Stock::Category )

How would I query then change this value of Name if different? Something like:

PCQB_RqNew( "ItemInventoryMod";"" )
PCQB_????( "Name" ;Stock::Category )

?

Sorry if this is vague. Johns world, lol. Thanks.

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Changing category of an existing item
« Reply #3 on: September 24, 2013, 07:59:40 AM »
I'm still trying to understand what a Category is in QB. It sounds like you have an Item in QB with a Name value of Misc, and its purpose is to categorize all its Subitems. Is that close?

If so, it's the ParentRef::ListID or ParentRef::FullName that needs a new value in the ItemInventoryMod Request. That will make the ItemInventory record a Subitem of the designated parent record.

HTH!

Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852