Currently we have Item Descriptions on the I/C Item and on the Item Pricelist which drives the descriptions etc when you put an item on an order in O/E etc. So the information is more or less duplicated.
When you creating new item it's not an issue as your firstly create your item, (logically put a item description on it), then goto to Item Pricing (or a stepped through here with the item wizard) and this copies the description that you have already entered and you are away, the same description in two places.
Clients invariably tidy up their Item Description sooner or later and apply the changes. It does not occur to them that you also have to go to Item Pricing and change the description there, as that is the one that really matters and appears on the invoice.
I know that the existing logic allows you to have a different item description on the item card, to a description that appears in the item pricing which appears on sales documentation. This is pretty cool and nice an flexible.
However in my 10 years experience installing Accpac I have never know any clients to want any thing different and we invariably get support calls for clients complaining that they have updated their item descriptions but it's not appearing on the invoice. We then invariably talk them through the process of updating the item pricing descriptions and we are away again, sometimes we need to export the I/C Item table and the I/C Item Pricing table, do a vlookup replace the descriptions on the Item Pricing table and we are back in sync again.
Can we not have a setup option in I/C where it will maintain consistency between the I/C Items and I/C Item Pricing Descriptions. If it's turned on when you update an item price if they are any Item Pricing records it will go and update the descriptions on those as well. if it's turned off the system would behave as it currently does.
by: Kerry J. | over a year ago | Operations Management
Comments
You can easily write a macro to update item descriptions on the price lists.
Here is an SQL trigger that we use to get around this. Hopefully it's helpful.
CREATE TRIGGER EnablingUpdatePriceListDescriptions
ON ICITEM
AFTER UPDATE
AS
IF UPDATE([DESC])
BEGIN
DECLARE @ITEMNO AS varchar(100)
DECLARE @DESCR AS varchar(100)
SELECT @ITEMNO = ITEMNO, @DESCR = [DESC] FROM INSERTED
UPDATE ICPRIC SET [DESC] = @DESCR WHERE ITEMNO = @ITEMNO
END
It would be a nice feature to have the choice, by price list - a little check box let's say, to keep item description the same as IC or to overwrite it. All items in the price list would default to the same as the price list default, but would be changeable as necessary.
Would automatically update when IC description is updated.