Would it be possible to add a "Start Date" for IC Items in the same way as Customers and Vendors shows us the start date? We have a terrible time differentiating between new item codes that have no activity and item codes that are several years old and have had no activity for a few years. In order to maintain our inventory database we need to merge our old item codes in to an item code we call ZZ OBSOLETE and make room for new item codes at least a couple of times per year. Having a Start date for the item codes would save us many hours of manually trying to make this determination and greatly reduce the potential for accidentally removing new item codes.

Also, it would be fantastic if IC Item Inquiry had an Edit button in the same way as you can view a Customer in AR and then click on Edit when you want to make changes. IC is so much more time consuming since you have to see the details in Item Inquiry and then open Item Edit to make changes and switch back and forth.

Hi Susan

Although it doesn't automatically default to today like the Start Date does for customers, why don't you instruct users to fill in today's date in the "Sale ends" field. I've never run into anyone who actually uses that field for its intended purpose, and using it to record the date the item was entered wouldn't have any impact on anything else.

Steve

Hi Steve,

I added an optional date field called "Start Date" which will work going forward from today if everyone remembers to put the date in. We use the Sale end date occasionally when we have limited time offers.

Hi Susan

You can force someone to visit the optional date field and not leave it blank under File | Optional Fields - select the "Start Date" field and uncheck "Allow Blank".

Steve

Steve:

Unless it's been recently changed and I missed it, I believe your process only works with optional text fields.

My I/C optional date and amount fields don't show up in File/Optional Fields.

Wouldn't it be the best if you could make all the fields you want mandatory or not in I/C, A/R and A/P when setting up new items, customers and vendors?!

You're right. I agree with you that all optional fields, not just text fields, should have the option to be made mandatory.

Hi Susan,

You should be using GridView to determine which old items should be made obsolete.

While I agree it would be useful to have a "Start date" for an item, you can use the "Last ship date" and "Last receipt date" fields, along with the Quantities shipped This year and last year to determine whether an item has not been received or sold for a while. A new item will have no receipt or shipment date on file.

We have hundreds of items that have no receipt date and no ship date that are dead stock. For example WP LVB12SINGLE. 7 were adjusted in when we counted inventory in 2007. No activity since.

We can't assume that no receipt date and no ship date means it's a new item code. A "start date" would help us identify dead stock easier as well as identify old item codes with zero quantities.

We have a start date in AP but IC is way more challenging since we're working with 6500 Item Codes compared to 600 Vendors.