CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


How to Write a Sage 300 ERP Macro Based on Accpac RVSpy tool (Part 1)

SHARE THIS
Facebook twitter linkedin Print Print
Print Email

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:

macro screen

macro screen

macro screen

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

macro code

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.

 

User interface

 

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).

RVSpy screen

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.

RVSpy output

macro file name

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.

 




Comments are closed.
Showing 1 Comment
Avatar  [Pingback] 5 years ago

Pingback from scoop.it

CodePartners Blog | How to Write a Sage 300 ERP...http://www.scoop.it/t/sage-300-erp/p/4031138170/2014/11/05/codepartners-blog-how-to-write-a-sage-300-erp-macro-based-on-accpac-rvspy-tool-part-1

On November 3, 2014 in Development by Michelle
Tagged With: macro, Accpac, Sage 300 ERP / 5070 Views

Search

Categories

  • General (166) rss
  • Development (158) rss
  • Success Stories (40) rss
  • Products (29) rss
  • Uncategorized (18) rss
  • BTerrell Group (5) rss
  • Project Management (22) rss
  • Web Development (57) rss
  • Web application (33) rss
  • Integration (19) rss
  • Mobile Development (7) rss

Archives

  • 2015
    • January (5)
    • February (7)
    • March (6)
    • April (5)
    • May (2)
  • 2014
    • January (13)
    • February (12)
    • March (13)
    • April (12)
    • May (11)
    • June (12)
    • July (11)
    • August (13)
    • September (10)
    • October (8)
    • November (6)
    • December (4)
  • 2013
    • April (73)
    • May (22)
    • June (20)
    • July (20)
    • August (22)
    • September (19)
    • October (13)
    • November (12)
    • December (7)

Tags

.NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
Email this article from Codepartners.com
Separate multiple addresses with commas(,)
To: *   Copy me
Subject:
From: *
Message:
ABOUT US / CONTACT US / NEWS & EVENTS
CodePartners / 16200 Addison Rd. STE 270 / Addison, Texas 75001 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
© 2006 - 2015 codepartners.com All Rights Reserved.