Topic Options
#39939 - 01/20/14 10:40 AM Unable to Delete Item from IC
BrusW Offline
Casual

Registered: 02/02/07
Posts: 13
Loc: Seattle, WA
Over the course of years, it turns out we've added some Items using cut and paste from Excel, which adds a hard return to the SKU. So it looks and displays like "123456" but it is really "123456
".

I cannot delete the entry from Item Maintenance. When I go to the item (which requires going to an adjacent one and using arrows to move up to it, find doesn't match) and click on Delete, I get the message "Can't delete item with quantities on hand, on purchase order, or on sales order." even though Item Inquiry > Quantities shows no quantities in any of those.

How can I remove this bugged item?

Top
#39944 - 01/20/14 11:54 AM Re: Unable to Delete Item from IC [Re: BrusW]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4413
Loc: Vancouver, BC
My guess is that the hard return now incorporated into your item number will prevent any solution that you could try from the data entry screen. You can't access the item by keying the item code as the hard return is causing Adagio to look at the next item number. To know for sure I would need to obtain a copy of your data.

This would leave a database repair as the only other option.

We would be happy to offer this service.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#40089 - 01/31/14 02:44 PM Re: Unable to Delete Item from IC [Re: Douglas Dickie]
BrusW Offline
Casual

Registered: 02/02/07
Posts: 13
Loc: Seattle, WA
Ah, so there is no way within the interface. Drat.

Thanks for the confirmation.

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 48 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14458 Topics
70633 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30