How to Change the Columns You See or the Sorting in the Grid View in MISys

Manufacturing Software Implementation..png

I was talking to Normita recently and she was commenting on how crazy it was driving her that her Manufacturing Orders didn’t seem to be in alphabetical order anymore.  I thought that if Normita was running into this then others probably were as well.  One of the things that the MISys development guys did recently (thanks fellas) was to work on how the system keeps our preferences stored.  Once you upgrade up to 6.4 you get some changes to the grid view in MISys – I’m going to point out two of them here:


First, when you sort the columns in your grid view using the column headers like I did below in the PO screen MISys will remember the sort until you change it to a different sort.  That means that if you don’t click back on the standard sort (in this case the PO Number) it will continue to display whatever sort you most recently used.

MISys table 1.png

Second, you can now change what columns show up in your grid view by clicking on the little icon in the top left corner of the grid view (see below).  This is a pretty sweet change (again thanks to the dev guys at MISys for this very useful improvement). 

MISys Table 2.png

That’s all I’ve got, talk to you soon.


Manufacturing Systems: Data Ownership

MISys Manufacturing Software.png

Great Manufacturing software is built upon a well-engineered data framework. For example, MISys Manufacturing software has a range of master tables that include: Items, Bills of Material, Suppliers, Locations, and Workcenters.

As with any other system, Manufacturing System success results from deploying good strategy and managing it well. A company with solid manufacturing processes that do not support the manufacturing data, can end up with inaccurate data that prevents many benefits a manufacturing system can provide. For example, planners can have difficulty running Material Resource Planning (MRP), which could be caused by bad data not owned by them. Unfortunately, too often, many of those Planners resort to spreadsheets that are disconnected from the manufacturing database.

Let’s have a look at the Item Master table. Problems with any of the following can prevent useful results coming out of MRP:

·      Purchased item Units of Measure not set correctly (Stock UOM and Purchase UOM).

·      Item stock setting has a missing or outdated Shortage Basis or Reorder Quantity 

·      Finished Good items are not linked correctly to the current Sales Item in the accounting system.

Most manufacturing systems have utilities that assist in maintaining clean data. When key individuals are responsible for owning data and become engaged in maintaining data quality the results can be significant, including the ability to run MRP with the benefits that come along with it.

Any questions? Contact us.


Posting Period End in MISys

MISys Manufacturing Software.png

Most of the transactions that accumulate in the Master Transaction Log have accounting implications which must be transferred to your accounting system's General Ledger. By running the Period End function, you create subledger journal entries for all the unposted transactions in the Master Transaction Log depending on the General Ledger feed option selected in the MISys Company Options.

The Period End function should be run on a daily basis OR in the worse case every couple of days.  Posing the Period End monthly is not encouraged.

1.     To complete a period end in MISys, click on the “Accounting” module to get to the accounting section

2.     Click on “Period End”

3.     Keep the dates as is

4.     On the print layout, click on the combo box pull down icon

5.     Select “Summary by Date”

6.     Click on the “Print Unposted” button

MISys Manufacturing Software 1.png

7.     Review the dates listed to make sure that all the transactions can be posted in the accounting program

NOTE: This step is VERY IMPORTANT.  Posting transactions that are outside the allowable posting dates in the accounting program WILL CAUSE SIGNIFICANT errors in the accounting program that could lead to posting errors.

8.     Click the “Close” icon

MISys Manufacturing Software 2.png

9.     Once the transaction dates are reviewed and confirmed that the dates fall within the open posting dates in the accounting program, click on the “Post” button

MISys Manufacturing Software 3.png

10.     MISys will prompt you to create a backup.  ALWAYS Click “Yes’

MISys Manufacturing Software 4.png

11.     Click “OK” button

MISys Manufacturing Software 5.png

12.     MISys will show the journal number used for posting, click on the “OK” button.

MISys Manufacturing Software 6.png

Any questions? Contact us!


Looking up Items Using the Manufacturer’s or Supplier’s Part Number in MISys

Manufacturing Software Implementation.png

All right, I’m sitting in the office between Christmas and New Years and Mona wants a blog post so I think ‘what’s come up recently that might be useful to folks in the MISys world?’  Then I remember Frank calling and saying ‘Why can’t I look up parts by the number that the manufacturer uses?’.  Frank’s been using MISys for a while and I’m thinking if Frank didn’t know where it is then maybe a lot of others don’t know so here you go.  You can lookup parts using either the supplier’s or the manufacturer’s part number by going to the Master Files Menu and choosing Look-Ups->Product Code like you see here:

MISys Manufacturing-Sample Company Inc..png

That will bring up the search box so you can search by either the Supplier or Manufacturer Product codes and choose how you want to search:


Hit the Look Up button and the results will appear below in the grid area.

Hope that helps, call us for more information.


A bit of information for MISys users who upgrade to Sage 50 Canada 2019.1 while on a MISys Version prior to


OK, for those in the MISys community who are using Sage 50 Canada and are keeping current with payroll, here’s a quick bit of information for you.  When you upgrade to Sage 50 Canada 2019.1 you may find that suddenly you’re having some issues doing your period ends.  You may get an error saying something like ‘Latest Transaction occurs after the end of the current fiscal year in Sage 50 CAN’.  This is happening because Sage made an unexpected change to the system that impacted the period process in MISys when it connects to Sage to do the period end posting.  Fortunately, the industrious guys at MISys have created a patch that can be applied to deal with the change made by Sage (big thanks to the dev team at MISys).  If you need the patch give us a call and we’ll hook you up.