Open Access to QB Vendor and QB Item - D-Tools Forum

**Kevin Mikelonis** · 06-02-2008, 08:26 PM

Since duplicating existing items 'like' in a database is a very consistent and efficient way to add new items to expand a database, many users take advantage of this functionality.

An unwanted result that occurs in this action is duplication of the QB item number if it has been sent over to QB via QL.

An 'edit' unlock as is found in Setup would be a good way to protect the QB item number from inadvertant changes to the field, but give users access to clear this field.

Having the item number automatically clear when copying an item would also be useful.

Thanks Loads!

Jack Frost · 07-20-2008, 07:22 PM

Hey Kevin,

I've just started making some changes in my DB and have started trying to use QL and QB. I have been copying QL'd products in SI5, which sounds like what you're describing, but I'm not sure I understand the problem and if I'm affected. How does it manifest itself in QB? What am I looking for?

Thanks.

**Kevin Mikelonis** · 07-20-2008, 07:56 PM

Once you send a product from a D-Tools project to QB via QL, the Accounting Item Number field will be populated for the product and cannot be changed without exporting the item to CSV, changing the item number there and re-importing.

So when copying an item in your D-Tools database to add a new iten, the Accounting Item Number will be copied, so you end up with two different products in your D-Tools database with identical Accounting Item Numbers.

I think the best solution would be to have D-Tools automatically clear the Accounting Item Number whenever an item is copied.