Jump to content


Photo

Tracking Sales ID


  • Please log in to reply
2 replies to this topic

#1 Chief Blogster

Chief Blogster

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 08 March 2005 - 07:00 AM

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

#2 john

john

    Advanced Member

  • Members
  • PipPipPip
  • 30 posts

Posted 09 March 2005 - 06:31 AM

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.

#3 George

George

    Newbie

  • Members
  • Pip
  • 5 posts

Posted 09 May 2005 - 03:21 PM

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




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users