• How to get username programmatically in macro

    Hi all, I want to get the username of current login user in macro. What Roto ID should I use?
  • Journal Entry errors: unable to add new GLJED row because of multiple error

    Hi, I am doing customization to add multiple lines to GLJED. But I get multiple error that I cannot find out why it is happening, note that I only trying to add to GLJED, not GLJEH Below is my code. Instead of getting the record by Batch in GLBCTL…
  • Use Browse() with "NOT IN" where clause/filter

    Hi, I need to do filtering using the "NOT IN" just like in SQL SERVER, but with Browse() function in ACCPAC library. I try using NOT IN with browse but got error, I guess its not supported. Is there other way to filter similar to "NOT IN"? Thank you.
  • How to do data filtering in macro VBA?

    Hi all, how do I do data filtering in macro? Lets say I want to filter by invoice number in OE0520
  • Indicator for a successful and failed insert in Order Entry

    Hi all, I am making a macro program to insert OE transactions in bulk by reading a csv file with a lot of Order transaction. Some of the Order might have error while trying to insert. So, I need an indicator that this specific transaction failed or…
  • Sage 300 ERP 2016 %1 error when I try to edit or run macros in Order Entry in Windows Server 2012 R2 Terminal Server

    %1 error when I try to edit or run macros in Order Entry in Windows Server 2012 R2 Terminal Server Trying out simple order entry macros Sage 300 ERP 2016 Windows 2012 R2 using Terminal Server