Product Groups Blank Title 121108

Yahoo Archive
1
Lauren,
Â
In the past, I have added a checkbox in Product Group Maintenance to make it active/inactive. Then using BPM, post processing directive of GetList/GetRows method delete the inactive ttProdGrup table. Then it will not be available for users to select from any form. Also you can add a BPM on Quote, Sales Order, AR Invoice and Job Entry to validate that users doesn't enter the inactive product groups.
Â
Regards,
Arul


________________________________
From: Calvin Dekker <calvind@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Saturday, 25 May 2013 7:34 AM
Subject: [Vantage] RE: Product Groups


Â

Lauren -

Building on Manasa's suggestion, if you prefix the items with a 'z' you could filter the items displayed in the combo box in a screen customization:
Dim dsTemp As DataSet
dsTemp = cb1.DataSource
dsTemp.Tables(0).Select(dsTemp.Tables(0).Columns(0).ColumnName & " NOT like 'z%'")
cb1.DataSource = dsTemp.Tables(0)

Hope this helps,
Calvin Dekker
[cid:mailto:image001.jpg%4001CE589B.54C0F4F0]<http://www.codabears.com/>
(630) 672-7688 x1484

*Solutions for Epicor users.

"No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."

From: mailto:vantage%40yahoogroups.com [mailto:mailto:vantage%40yahoogroups.com] On Behalf Of Hellings, Lauren
Sent: Friday, May 24, 2013 3:18 PM
To: mailto:vantage%40yahoogroups.com
Subject: [Vantage] Product Groups

We currently have 93 different product groups in our system and we are looking to consolidate down to a list of roughly 10 records. However, if the product group has been used in the past we are unable to delete these records from the master table which makes sense. Does anyone know of a way that I can eliminate the ones we no longer want from the drop down on the Sales Order Entry Line screen?

Thank you,

Lauren L. Hellings
Business Analyst
Direct: 281-207-4613
Cell: 832-472-1736
Fax: 281-207-0672
email: mailto:Lauren.Hellings%40c-p-i.com<mailto:Lauren.Hellings%40c-p-i.com><mailto:mailto:Lauren.Hellings%40c-p-i.com<mailto:Lauren.Hellings%40c-p-i.com>>
www.c-p-i.com<http://www.c-p-i.com/>

[cid:mailto:image001.jpg%4001CE5891.D62DEFC0<mailto:image001.jpg%4001CE5891.D62DEFC0>]

----------Legal Disclaimer----------

The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
2
We currently have 93 different product groups in our system and we are looking to consolidate down to a list of roughly 10 records. However, if the product group has been used in the past we are unable to delete these records from the master table which makes sense. Does anyone know of a way that I can eliminate the ones we no longer want from the drop down on the Sales Order Entry Line screen?

Thank you,

Lauren L. Hellings
Business Analyst
Direct: 281-207-4613
Cell: 832-472-1736
Fax: 281-207-0672
email: Lauren.Hellings@...<mailto:Lauren.Hellings@...>
www.c-p-i.com<http://www.c-p-i.com/>

[cid:image001.jpg@01CE5891.D62DEFC0]



----------Legal Disclaimer----------

The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.



[Non-text portions of this message have been removed]
3
It's been a while, but if you cannot inactivate what we did was put a "zDO NOT USE..." in the description field, this should put it at the bottom of your list and it should tell people not to use it!!!

Manasa











From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hellings, Lauren
Sent: Friday, May 24, 2013 3:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Product Groups



We currently have 93 different product groups in our system and we are looking to consolidate down to a list of roughly 10 records. However, if the product group has been used in the past we are unable to delete these records from the master table which makes sense. Does anyone know of a way that I can eliminate the ones we no longer want from the drop down on the Sales Order Entry Line screen?

Thank you,

Lauren L. Hellings
Business Analyst
Direct: 281-207-4613
Cell: 832-472-1736
Fax: 281-207-0672
email: Lauren.Hellings@...<mailto:Lauren.Hellings%40c-p-i.com><mailto:Lauren.Hellings@...<mailto:Lauren.Hellings%40c-p-i.com>>
www.c-p-i.com<http://www.c-p-i.com/>

[cid:image001.jpg@01CE5891.D62DEFC0<mailto:image001.jpg%4001CE5891.D62DEFC0>]

----------Legal Disclaimer----------

The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
4
Lauren -

Building on Manasa's suggestion, if you prefix the items with a 'z' you could filter the items displayed in the combo box in a screen customization:
Dim dsTemp As DataSet
dsTemp = cb1.DataSource
dsTemp.Tables(0).Select(dsTemp.Tables(0).Columns(0).ColumnName & " NOT like 'z%'")
cb1.DataSource = dsTemp.Tables(0)

Hope this helps,
Calvin Dekker
[cid:image001.jpg@01CE589B.54C0F4F0]<http://www.codabears.com/>
(630) 672-7688 x1484

*Solutions for Epicor users.

"No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Hellings, Lauren
Sent: Friday, May 24, 2013 3:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Product Groups



We currently have 93 different product groups in our system and we are looking to consolidate down to a list of roughly 10 records. However, if the product group has been used in the past we are unable to delete these records from the master table which makes sense. Does anyone know of a way that I can eliminate the ones we no longer want from the drop down on the Sales Order Entry Line screen?

Thank you,

Lauren L. Hellings
Business Analyst
Direct: 281-207-4613
Cell: 832-472-1736
Fax: 281-207-0672
email: Lauren.Hellings@...<mailto:Lauren.Hellings%40c-p-i.com><mailto:Lauren.Hellings@...<mailto:Lauren.Hellings%40c-p-i.com>>
www.c-p-i.com<http://www.c-p-i.com/>

[cid:image001.jpg@01CE5891.D62DEFC0<mailto:image001.jpg%4001CE5891.D62DEFC0>]

----------Legal Disclaimer----------

The information contained in this message may be privileged and confidential, and is intended solely for the use of the named addressee. No other person is authorized to access, copy or re-use this message (or any information contained herein). If you are not the intended recipient, please notify us immediately by replying to this message and delete it from your computer.

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
5
But if you change the description to Z Do Not Use or something similar, you
will lose the original value of the description filed for historical
reports. I wouldn't want 830 product groups all with the description of Z
Do Not Use. However, adding the letter Z in front of the current
description would at least drop the choice down to the bottom of the list
without losing the current description.



Just a thought.



Claudia Stone

Aspacia Systems, Inc.

Office 866-566-9600

Direct 650-965-9903



www.aspacia.com



This email, and any attachments thereto, is intended only for use by the
addressee(s) named herein and may contain legally privileged and/or
confidential information. If you are not the intended recipient of this
email, you are hereby notified that any disseminiation, distribution or
copying of this email, and any attachments thereto, is strictly prohibited.
If you have received this email in error, please notify me by telephone and
permanently delete the original, any copy of any email and any printout
thereof.





[Non-text portions of this message have been removed]