Hi Nancy,

 

Below are responses to your questions.

Don’t hesitate to question Cathy or I regarding details below.

 

Thanks!
Ronda

 

 

Ronda:

Could you please review the IC/PO information listed below and let me know you thoughts on these PUSH issues?

§       Inventory

1.      Year End – Is there a way to archive the inventory master at year end for reference?  Could the users just export the inventory master list?

            The Inventory Master is currently saved (archived) each year; however, user screen access hasn’t ever been developed.  If screens would be valuable, we will           consider this as a potential future enhancement.  Let us know on this.

We are not sure what specific information they prefer to reference in the future.  They may want to export the following reports:

IC – Inventory Master List provides the Accounting Cost

IC – Inventory Value Rpt provides the Accounting Cost, Committed Quantity, On Hand Quantity & On Hand Value by Department

IC – Inventory Master Rpt provides all Inventory Detail information including the On Hand Value

IC – Inventory Master by Department/Account Rpt provides all Inventory Detail information by Department and Account & includes On Hand Value

2.      Maintenance – IC Vendor – How to make “inactive” – the second screen in the inventory master?  Currently, the procedure is very time consuming.  Any suggestions for improving this procedure?

We can create an IC Invoice Vendor maintenance option which can allow IC Invoice Vendor records to be made Inactive by Vendor Number, Item Number and/or Last Purchase Date

§       Purchase Orders

1.      No one likes the “reprint” feature that increases the revision number.  Consider removing this feature or making it a module control option.  Are there currently any plans to remove the revision number?

When the user is printing additional copies of the PO (not due to a change), if they inquire/print the PO from the Inquiry option, it will not change the revision number.

We can certainly remove the feature if all CRCs no longer utilize it.  This functionality was originally requested to track the volume of Purchase Order modifications after the initial approval.  For Purchase Orders in question, it also alerted the manager that changes were made to his/her original approval.

We can add PO Revision Number tailoring to the PO Module Control, PO Maintenance & PO Report processing.  This tailoring will allow the user to disable the revision number functionality.

2.      Provide a push pin on the distribution account in Purchase Order maintenance for repetitive Non-Inventory items.

We can add push pin capability for the distribution account in the PO Detail screen for repetitive Non-Inventory items

§       When do you estimate that the next service pack is going to be ready and what is its focus?

The next Service Pack is focused on user requested enhancements & it has not been scheduled.  We are currently reviewing and prioritizing the specific projects to target.

§       Any new developments to share? 

We are addressing the CRW exporting to Excel formatting issue, etc.  The initial solution was demonstrated this month at the Clerk’s meeting.  We had very positive feedback and will continue to simplify the process.  This is projected to be included with the next Service Pack.

            We are also proceeding with development in the Inventory Module of (a) Touch Screens for the IC Material processing and (b) improving functionality to better           accommodate those utilizing bar coding.

Let me know your thoughts on these items.  Our next meeting is planned for February 25^th & will address HR & PR. 

Thanks!

Nancy K. Hiestand

Information Systems Manager

Road Commission of Macomb County

117 S. Groesbeck Hwy.

Mount Clemens, MI 48043

(586) 463-8671 ext. 1330