by Jacky Xu

We needed to record a macro from Sage 300 ERP UI and convert it to our Sage 300 ERP project. But sometimes, we struggled to get a useful macro through the Sage 300 ERP record macro tool (E.g. Bank reconcile statement).

In general, we run the record macro tool first. And then we run UI and do some operations to get macro like below:

But for this transaction, we could not get a useful macro.

We wondered if there was another way to get a macro. Yes, we can use the RVSpy tool. But it’s a little difficult to get a correct macro through the tool. The tool records much information we don’t need, so we need to select part of it to get the macro. Here’s how:

1.       Run RVSpy and set RVSpy off first (I don’t want get many other record about open views).

2.       Open the UI.

3.       After opening UI, turn on RVSpy and minimize the tool (if you keep the tool in the top of windows, the performance of system will be slow).

4.       After you finish your operation steps in the UI, you should close RVSpy. Before closing RVSpy you should check the log file path already assigned.

5.       We can open the log file and get our macro through the file.

I will show you how to get useful information from the file in a later blog.