2 replies to this topic

[Chief Blogster]

I have been having troubles tracking down a solution for this issue.

We import orders and it defaults to a Sales ID, 13. If a customer calls and changes the order or needs a reship, I am not able to track which sales person made the change.

Sales IDs are required for all orders but I can not find any place in the databases OR within MOM that shows who changed the order.

Help is greatly appreciated.

Thanks,

Chief Blogster
http://www.blogster.com

[john]

there is an operator ID which shows who actually processed the order. it shows up on the invoice (by your sales id) as -- 13/"operator initials". you can sort on the operator id in the sale listing report.

[George]

This is a clumsy option, but it does work. Open your Database Utility (dbuwin.exe), open the CMS.dbf, scroll down to find the order number you need, then use the right arrow key to go to the Last_user field. There you'll see the operator ID initials of the last person to open the order.

There are two pitfalls to watch out for. If you opened the order in the regular MOM interface first, then you'll see your own initials in that field. Also, try not to erase anything in the fields while you're in there!

If other people are using MOM when you're checking, you'll need to put a space, then the letter "s" after dbuwin.exe, to run it in shared mode. Example: C:\dbuwin.exe s