VBScript macros - code examples

I'm looking for samples of macro code for Visual ERP, to see what can be done, and how the code has to be written. Anyone have a resource to suggest? Can you just use Visual Basic Scripting Edition right out of the box, or are there things that have to be changed in the code to make it work with Visual?

Find more posts tagged with

VISUAL - Enterprise General Discussions

Comments

andreas-hanschmann

The macro scripting environment in Visual provides the values on the screen. Other than that, everything you can do in VBScript you can do in Visual macros.

I've developed COM objects that are called from Visual macros to handle more complex tasks.

Does that help?

Legacy Contributor

Do you still have examples of macros? I am trying to filter on the total_shipped_qty on customer order lines and can't seem to get anything to work.

jm-yzon

usually, we write a sql script. and run it in Viusal Query Tool(visual 8.0 or up).

this is samples.

==============================================================

select col.CUST_ORDER_ID,col.LINE_NO,col.PART_ID,co.order_date,co.customer_id,col.ORDER_QTY,col.TOTAL_SHIPPED_QTY

from customer_order co,CUST_ORDER_LINE col where co.CREATE_DATE >= '01.01.2018' and co.STATUS = 'C' and co.id = col.CUST_ORDER_ID

==============================================================

result is tell us each part. how many customer ordered and shipped from 2018 all closed CO.

Copyright © 2025 Infor. All rights reserved.