Posted by Rich on January 16, 2018

Have VISUAL automatically open your "Start Up" windows after signing in

Infor VISUAL ERP - VMX Default windowsDo you often find yourself opening the same VISUAL windows after signing in?  It'd be nice if you can have VISUAL open them automatically.

VISUAL doesn't have this as a built-in feature - but that's not to say we can't make it happen.  

We can use a VMX file to achieve this.

FYI:

VMX files are shortcuts to specific records in VISUAL.  You may have come across them if you have ever used the Send To feature in VISUAL - they will be attached to emails for recipients to open.  VMX files are associated to the VISUAL application - so the system will know what to do when the user double clicks on them. 

The VMX file is basically a text file that VISUAL reads and executes.  If you look at the contents of the file (using a text editor like Notepad), you will notice that all VMX files start with LSASTART.  The next line indicates the module (program) to open and the document id to retrieve.

For example, if we wanted the VMX file to open Customer Order Id 123897, the file would contain:

LSASTART
VMORDENT~123897

VMORDENT refers to Customer Order Entry window - which is the VMORDENT.EXE executable file.  The 123897 is the customer order record to retrieve.  The tilde("~") is used to separate the program file and the record.

Now why am I explaining this?

Well, we can use this in our VISUAL hack.  The VMX file does not limit us to the number of programs to open at once.  And the document id reference is optional - meaning we can just reference the program without having it retrieve a record.

And another thing, because the VMX file is associated with VISUAL - the system will check whether you are signed in.  If you are not, the Sign In window will appear before opening your windows.  

So, all you need to do is create a VMX file with all the VISUAL windows you want to have opened after signing in.  This VMX will now be your Shortcut to Signing into VISUAL (as oppose to your standard sign in shortcut pointing to the VM.exe file)

Here's a quick Walk-Through

  1. Create a new file using your favorite text editor (like Notepad)
  2. Enter "LSASTART" on the first line
  3. On the next line(s), enter the program name(s) of the VISUAL window(s) you want opened as part of your startup.  For example, if you want Part Maintenance, Customer Order Entry and Material Planning Window to be part of your start up - you should have the following:

    LSASTART
    VMPRTMNT
    VMORDENT
    VMPLMWIN

    If you are not sure of the program name, you can look this up by calling up the window in VISUAL and selecting "About..." under the Help menu.

    Infor VISUAL ERP - Material Planning Window
  4. Save the file to your desktop.  Be sure to save it with a "VMX" extension.
  5. At lastly, make sure VMX files are associated to VISUAL. 

    To do this, right click on your VMX file - and select OPEN WITH from the popup menu. 
    Select Infor VISUAL from list of applications (and check the checkbox to always use the application) - and click the OK to confirm

    Infor VISUAL ERP - VMX File association


 

Thanks for stopping by! If you liked this VISUAL NUGGET, you might consider
following me on twitter.
Posted by Rich on January 11, 2018

Speed things up by skipping over default confirmation prompts in the Manufacturing Window

Have you seen these before?

Infor VISUAL ERP - Manufacturing Window - Load Operation Type Defaults
Infor VISUAL ERP - Manufacturing Window - Part ID already is used

Oh, I'm confident you have.  I'm also betting that for the most part you responded YES, YES, YEEESSSS!!!  

In fact, for some of you, it's probably so second nature you don't even notice what's being asked and hitting the ENTER key.

These prompts mean well - and they may have stopped you from making a mistake and made you seriously think of what your doing - but for the most part they are annoying and slowing you down - and yes, you know what you're doing! 

You can prevent these prompts and skip over them by configuring your preference settings.

Your preference settings can be found in Preference Maintenance under the ADMIN menu. 

The two settings that affect these prompts are in the ManufacturingWindow section: SkipMsgLoadOpTypeDef and SkipMsgPartAlreadyUsed

If you have these two entries with a value of 'Y'  -  VISUAL will skip over these prompts and you can now speed through your builds

Infor VISUAL ERP - Preference Maintenance

 

One of the many options you have available to enhance your VISUAL User eXperience!

Infor VISUAL ERP - Preference Maintenance - User Experience 

Posted by Rich on January 9, 2018

VISUAL's AutoRun feature to automate Cost Utilities, Concurrent Scheduler and other processes

VISUAL_AS_A_Service
For as long as I can remember, the user community has been looking for ways to schedule and run certain VISUAL processes automatically and un-attended; Processes like Costing in Costing Utilities, MRP and the Concurrent Scheduler.

Earlier versions of VISUAL did not have this built-in feature - leaving many users to resort to creative ways and workarounds to accomplish this – some good and some not so good. Most involved 3rd party applications such as AutoIT and Automate.

But now with VISUAL 8 and up, using AutoRun Services, you can schedule and automate the following:

  • Running Concurrent Scheduler
  • Printing of Work Order Travellers
  • Costing (Cost Utilities)
  • Running Material Requirements Planning
  • Updating the Reporting Database Tables (for Dashboard Analytics)

Setting up the schedule can be done within each window of the specific process – under the FILE menu.

EXCEPTION: For Updating the Report Database Tables, you need to go to Admin > Application Global Maintenance > Maintain > Visual Reporting Data…

For example, to setup an automated schedule for the Concurrent Scheduler, select “Set as Scheduled…” item from the FILE menu of the Concurrent Scheduler window

 

VISUAL ERP - Concurrent Scheduler Automation
Concurrent Scheduler > File > Set as Scheduled...

The following window will appear. The left area are the parameters that you would typically set for running the Concurrent Scheduler. The right area is where you set the parameters to schedule the running of the Concurrent Scheduler – the fields are fairly straight forward.

ScheduleParameters

 
Also note that you can have the process run several times a day – up to 6 times - which is great if you have lots of activity (transactions) going on (inventory movement, labor reporting, shipping/receiving, etc)...it helps in keeping the system up to date (where needed).


Now
, out of the box, these services are not installed...

Don't fret - there are some setups involved but it's not overly complicated

Each automated process has its own service executable file – which are typically found in the VISUAL executables directory

Service EXE What does this service do? How many times do you need install this service?
VRDTASVC.EXE Loads data into the Reporting database tables Once per database
VMSCHSVC.EXE Runs a schedule Once per site
VMDBRSVC.EXE Runs a schedule in a DBR-enabled database Once per site
VRPTSVC.EXE Once per database Once per database
VMCSTSVC.EXE Runs costing Once per site
VMMRPSVC.EXE Runs MRP Once per site

You may have to go through the installation procedure more than once for a given service if you are a multi-site operation.


I'll walk you through an installation of the Costing Service.

  1. On the computer or server that will be running the service, go to the directory that contains the VISUAL executables and find the file VMCSTSVR.EXE (this is the service executable file to run the Costing Utilities as a service)
  2. Right Click on the VMCSTSVR.EXE and "Run as administrator"

    Infor VISUAL ERP - AutoRun     
  3. You will then be prompted to Sign Into VISUAL.  You can use any VISUAL User ID as long as it has the permissions to the respective area (in this case the Costing Utilities).

    Infor VISUAL ERP - Sign In

  4. In the following window, you'll need to specify the following:

    Site ID
    :  The Site to which the service will be running against.
    Log File Directory: Directory Location to store the log files for this service
    Polling Interval:  Frequency the service checks for updates - I just accept the default
    Log Level: You can specify the amount of details you want to capture when the service is running.  The recommended level is to set to None (logs just basic information - timestamps, etc).  Refer to the VISUAL manual if you would like more info on this

    Infor VISUAL ERP - AutoRun Service

  5. Hit the Install Service Button

  6. Click Yes at the following prompt

    Infor VISUAL ERP - AutoRun Service 
  7. Then CLOSE the window

The costing service is now running!!

You can verify this by going into the Services Console in Windows and scroll through the list for the service.  In this case, the service is called Infor Visual Costing Service (database name:site id) 

Infor VISUAL Services - Windows Services

 

Now that the Costing Service is running - you can now set the schedule to run Costings. 

Remember how? ... Go to the Costing Utilities window and click on Costing Service Schedule under the FILE menu. 

OK...here's a screenshot...
Infor VISUAL ERP - Costing Utilities AutoRun

  

Posted by Rich on February 11, 2015

Get your shades! Future is looking mighty bright on things to come in VISUAL 8!

Ryleigh
Ryleigh's reaction when I told her about VISUAL 8

Just got back from the Infor Partner Conference last week....and I gotta tell you that I was floored on all the new features and functions that are coming down the pipe with VISUAL 8.  Rich Lagoy and Frank Maglio did a great job on presenting (and demo'ing!) VISUAL 8 and discussing the products' roadmap.

Here are some of the highlights:

  • Macros will be managed within the database
  • VISUAL API Suite -  That's right, the COM objects are back!  They will be upgraded and incorporated into a full API suite and part of the VISUAL core.  Oh, did I mention that they will be supported and documented?  What does this mean to the VISUAL user? Integrating to VISUAL will be easier, faster, more secure.
  • Built-in Automation of Processes - You will now be able to autorun Global Scheduler, Costing, MRP and VISUAL Analytics
  • New UI, Navigation, and Document Information Capture
    • New and improved Graphical Document Lifecycle.
    • You want more drill down capabilities?  You got 'em - even at the order line level!
    • Source & Target Navigation - Easily walk through the lifecycle of a document to view upstream or downstream relationships.  For example, from the Customer Order you can jump to the corresponding quote and/or the packlist(s).
    • Activities and Reminders - You can now create and log activities on all documents - allowing you the ability to categorize and record various “activities”.  In addition, users can set follow-up reminders associated with these activities.
    • Enhanced Query Tool - Yes this little tool is undergoing a much needed facelift.  You will be able drag and drop tables and fields into the query window, export results to Excel and save to the database.
  • Wait until you see the View Panels.  Major Enhancements!  They can display data graphically which you can also drill-down into for details.  So many features have been added that each document can have it's own living dashboard/KPIs metrics.
  • Dashboards, Dashboards and more Dashboards - Remember EIS?  Those days are long gone and forgotten! Amazing stuff - and very much needed.
  • VISUAL Mobile Automation
  • Customer Sponsored Feature Enhancements - You've asked for them - so you're getting them.  Thank you very much
    These are just a few - but there's many:
    • Print Packlists by warehouse or territory
    • Customizable UDFs on AR, AP and GL Entry modules
    • View Work Order Receipts option from the Manufacturing Window
    • On-hand balance check when backdating in Inventory Transaction Entry window
    • Printing associated documents when printing a range of Work Order Travelers
    • Security Enhancements - Permission settings to Add & Delete parts, customers and vendors
    • Added "Entered By" fields to Customer Order Entry (in both the header and line level)
    • Vendor Supplying Part - ability to add the same vendor more than once to a part.
    • Added OnDelete and OnAfterDelete for macros
    • Supplier Performance window - to compare performance on delivery and quality

I should add a disclaimer here only to let you know that what was presented on VISUAL 8 may change - many factors can affect Infor’s product development plans and the nature, content and timing of future product releases, all of which remain in the sole discretion of Infor.

That beings said - I'm anxiously looking forward to VISUAL 8!

 

Posted by Rich on February 1, 2015

Auto-Issuing from multiple locations for a single Part

Yes it is possible.

VISUAL allows you the capability to setup a part to be automatically issued to a work order as labor is reported against an operation.  To do this there are a couple of settings that you need to have in place for this to happen.  At a minimum, you need to flag the part as being AUTO ISSUE and specify the Warehouse and Location to issue from.  These settings can be found in the PART MAINTENANCE module

Infor VISUAL ERP - Part Maintenance
Part Maintenance in VISUAL 7.1.2

Now you may have situations where you need the ability to auto issue a part from multiple locations.  From the onset it may appear that you are limited to only having one - but it is possible to configure VISUAL to have more. 

Here's how...

  1. Call up the part in PART MAINTENANCE.
  2. Go into "Warehouse Locations..." from the MAINTAIN menu to bring up all the warehouse locations assigned to the part
  3. Now your first instinct would be to check the checkbox in the Auto Issue column.  DON'T because you may find yourself in a frustrating game of "Whack-A-Mole"!  Go ahead and try - you'll see what I mean.

    Whack a mole
    A Classic!
    Instead, simply select the checkbox under the Default Part Auto Issue column (the AUTO ISSUE checkbox will check automatically).  Once you have all your auto issue locations set - save and close the window

    Infor VISUAL ERP - Part Maintenance Warehouse Locations 
  4. Now you have configured the part to have multiple auto issue locations.  The only step left is indicating which location VISUAL should auto issue from on your work orders and/or engineering masters.  You can do this in the MATERIAL (REQUIREMENT) card of the auto issued part in the WO/EM under the PLANNING tab.

    Infor VISUAL ERP - Work Order Requirement Material Card Location ID 
    Note: The locations available will only be those that belong to the WAREHOUSE specified on the Work Order Header.  Also, if you choose not to override the location - then VISUAL will auto issue from the Default Auto Issue Warehouse and Location in PART MAINTENANCE.
     

Now you're all set.

  

Posted by Rich on December 9, 2014

How to ensure that your VISUAL "peeps" are using the current version of a macro

Don't you hate it when you find out that one of your VISUAL users is using an old version of a macro?  Wouldn't it be great if you could modify a macro and it would instantly be deployed across your VISUAL network? 

Well you can...and here's how you can do it.

The solution involves 2 sets of macros. 

The first set of MACROS (let's call them your ACTION macros) are  your main macros that contain the scripts that account for your business logic and rules.  Place these ACTION macros in a centralized location on your network where your VISUAL users have access to. 

The second set of macros (let's call them your SHELL macros) will have the same file name as your ACTION macros but will contain a script that will run it's respective ACTION macro.  These SHELL macros are the ones that should be place on each VISUAL workstation (and/or profile) in their respective VISUAL local directory.  You will only have to configure these SHELL macros once for each workstation.

Once the ACTION & SHELL macros are in place - any modifications you do to the ACTION macros will immediately be deployed in your VISUAL environment because your SHELL macros are pointing to the ACTION macros and executing them.

Say what?!?  How do you get these SHELL macros to run the ACTION macros?

I'll demonstrate with a simple example (much easier to explain)

Let's say you have an OnSave macro in Part Maintenance that checks to see if the user has populated the PRODUCT CODE field. 

Your ACTION macro would contain something similar to the following:

Infor VISUAL ERP - Action Macro

So this ACTION macro would have the filename "VMPRTMNT_OnSave.vms".  You will want to place this ACTION macro file on your network where your VISUAL users have access to.  In this example - let's assume it's stored in location \\SHARED\MACROS

Now let's create it's respective SHELL macro, which will also be an OnSave macro, BUT it will contain the following script to call the ACTION macro.

Infor VISUAL ERP - Shell Macro

Download the SHELL macro script

Place this SHELL macro on each VISUAL workstation (in the local directory).

You're all set. 

Now when you save in PART MAINTENANCE, the SHELL macro will call the ACTION macro to verify whether the PRODUCT CODE has been entered.

With this setup - you don't need to chase down and update workstations if you modify a macro (or have users log out & log back to initial the login script to deploy macro files).

Just modify the ACTION macros - and the update is instant.


I would like to thank Jenifer Barcus, Applications Specialist at Waukesha Foundry Inc., and Jim Herzfeld for allowing me to share this solution on VisualNuggets.com. It's awesome! 

 

Posted by Rich on November 28, 2014

Pimp your VISUAL Browse window

The BROWSE window is available all throughout the VISUAL application.  You likely use it day in and day out as you filter through the records you need.  With every new version of VISUAL, you may have noticed added functionality to the window - such as:

  • Dynamic Searching
  • Searching on Initial Entry
  • Stopping the Searching Process
  • Sorting by Columns
  • Printing the Result Set
  • Browsing by SQL Statement
  • Editing Data in the Browse Table
  • Exporting and Import using Excel

These are all great features - but you can do so much more....

The BROWSE window can be customized to include additional information and fields that are not typically available "out of the box".  You can then search on these fields.

Couple of examples are:

  • Specifications Field
    Specifications are used in many areas of VISUAL (parts, customer orders, purchase orders, work orders, etc).  Once they are configured to your browse window, you can perform searches on them.
  • Line Items on Quotes
    If you use quotes extensively in your company, you know how difficult it can be to sift through quotes for non-Part ID line items.  By adding line item details to the Quote Browse window - you can easily search through to the quote you want.
  • Line Item Details on Orders
    Much like the previous example, you can browse through your orders at the line level as oppose to the header detail.
  • Shipper line details with Trace IDs
    This one, I use quite a bit.  I have configured the Packlist BROWSE window to include not only the shipped line information but I also include all the Trace IDs (if any).  Now if I want to know when (or how) a particular Trace ID was shipped - I just enter the Trace ID to pull up the packlist that it was shipped on.
These are just a few examples - but the possibilities are endless. (well, maybe not endless...)
 
The easiest way to customize the BROWSE window is to use SQL Views and having the VMBROWSE.ini file point to it.
 
Infor VISUAL ERP - VMBROWSE.ini fileWhat the heck is the VMBROWSE.ini file?  The VMBROWSE.ini file contains all the parameters and settings to all the BROWSE windows in VISUAL.  This file is user-specific - every user "should" have their own unique file.  And depending on how your VISUAL environment was installed - it can be found in the users' local directory for VISUAL.  If you open the file, you'll notice sections that refer to the various areas of VISUAL where the BROWSE window is available.  Each section starts with [section name] (open and close square brackets).  Within each section, you'll find the database table(s) used, visible columns to display in the grid, column sizes, sort order, etc.
 
So to customize the BROWSE you need to change the value set for the database table and the columns to display (based on the SQL View you created).
 
Here's a quick example to customize the QUOTE BROWSE window to include the line items.   Please keep in mind that this example assumes you are current and on VISUAL 7.1.2.  You have upgraded - haven't you?
 
Step 1 - Create a SQL View that links the QUOTE table to the QUOTE_LINE table.  Give the SQL View the name V_QUOTES.  Download this script to create the SQL View.
 
Infor VISUAL ERP - SQL View
 
Step 2 - Open your VMBROWSE.ini file and find the section [Quote].  Set the value for table to V_QUOTES (as shown).  Download this section to copy and paste into your VMBROWSE.ini file.
 
Infor VISUAL  ERP
 
Step 3 - Log into VISUAL and browse your Quotes with line items.  You will need to add the new columns using EDIT COLUMNS under the DATA menu.
 
You may get an initial error when you first browse for your quotes.  This should only happen once.  It's because you need to reset the columns to display.  Just ignore the error and reset your columns.
 
There you have it.
 
BONUS!
Here's the solution (which I get asked quite a bit for) to PIMP your PACKLIST browse window to include shipped line items with Trace IDs.  The solution includes a SQL function to concatenate multiple Trace IDs per shipped line item (if any).
 
 
 
Step 3 - Modify the [Shipping Packlist] section of your VMBROWSE.ini file. Download the entire section.
 
 
Infor VISUAL ERP - Shipper Browse Window with Trace IDs
Packlist Browse Window that includes Trace IDs which you can search against
 
 
 :-)
 
Posted by Rich on May 27, 2014

Here's a neat little tip that's undocumented when entering a date in the grid.

Some of the "little" challenges of manually entering dates in the various grids throughout VISUAL...

Is it mm/dd/yyyy?  dd/mm/yyyy?  yyyy/mm/dd ? ...  You can easily mix up the month and day positions - which could greatly affect your day-to-day operations - and not in a good way.

Is the date you've entered land on a day that you're closed?  It's difficult to meet a ship date if it falls on the weekend.  It's hard to tell without having a calendar in front of you.

CO_DateColumn

These are just a couple of things to consider when you have to manually key in a date in a grid in VISUAL.  Wouldn't it be great if you can visually pick a date from a pop-up calendar (similar to the available calendars in the header areas of orders)?

Well you can....just hit the space bar when you are in a date column of the grid.

Infor VISUAL ERP - Calendar
Hit the space bar to pop-up the calendar.  Presto!

Space bar, select a date...done...move on

Who has time to manually enter dates anyway?  Not this guy.

 

Posted by Rich on December 12, 2013

Should you CLOSE or LOCK an accounting period?

Infor VISUAL ERP - Financial Calendar MaintenanceWhen you maintain your fiscal calendar in the Financial Application Global Maintenance window,  you can set a period to have either an Active, Closed or Locked status. 

The ACTIVE status is pretty straight forward -- It will allow transactions to occur in the period. 

Setting the period to CLOSED or LOCKED status will prevent new transactions from being entered into the period. 

But why have 2 settings to prevent transactions?  What is the difference?

Well it all comes down to security.

If you CLOSE a period, anyone who has access to the Accounting Window (under the LEDGER menu) can easily toggle the status back to ACTIVE using the "Close/Reopen Period" function (as shown below) - and allow new transactions to occur in the period.
 

Infor VISUAL ERP - Accounting Window
 

If you LOCK a period, then this "Close/Reopen Period..." feature will be disabled.  The only way the period can be "Reopened" is through the Financial Application Global Maintenance which should be locked down (with limited access) from users. 

This setup allows for tighter controls in your organization.


Update!!

OK.  So no sooner did I just post this piece I get pinged from a colleague letting me know that I may be promoting bad “Visual” accounting practice. 

Infor ERP VISUAL - Accounting WindowSo let me put on my accounting hat on…

By no means did I intend to say that you should be opening and closing your periods from the Financial Application Global Maintenance window.  You should be doing this from the Accounting Window using the “Close/Reopen Period” feature.  The reason being is that the Accounting Window will ensure that there are no unposted transactions in the period you’re closing, whereas the Financial Application Global Maintenance window will allow you to CLOSE or LOCK a period with unposted transaction (not good). 

The Locked status is only available from the Financial Application Global Maintenance window and will prevent users from reopening the period from the Accounting Window - reinforcing the fact that the reporting of the period is final

This post was intended to explain the difference between the CLOSED and LOCKED status when maintaining your fiscal calendar.

Accounting hat off

Posted by Rich on December 10, 2013

Automatically link new work orders to line items in the customer order entry window

The New Work Order feature in Customer Order Entry (and Order Management Window) allows you to create and link work orders as you enter the sales order into VISUAL.

Infor VISUAL ERP

This feature can save you quite a bit of time for situations where creating work orders on the fly from the order entry screen makes sense.  It allows you enter the sales order, create the work order and link (allocate) it all in one step. 

If linking work orders to customer order lines is common practice in your work place you might want to consider this option - Again, if it makes sense for your business

If you do use this feature or plan to use it - this macro might be of use to you.

Chances are, not all line items of a sales order require a work order....

  • Some items may be purchased.
  • Some items may be stocked items
  • Some items fall under specific planning policies
  • Some items are service charges
  • etc...

So the decision to link work orders to customer order lines may rest on the person entering the sales order.  You can streamline this process (and make the decision automatically) coding the business logic into an OnSave macro.

The following macro will automatically create and link work orders to line items for FABRICATED parts.  Simple requirement - but you get the idea

Macro breakdown

The Database Connection parameters:  You will need this to for the database lookup - which we will be doing to verify whether the line item meets the criteria to create a new work order.

strServerName="E N T E R   Y O U R   S E R V E R    N A M E"
strDatabase="E N T E R    Y O U R    V I S U A L    D A T A B A S E    N A M E"
strUserName="E N T E R    Y O U R    R E A D O N L Y    U S E R    I D"
strPassword="E N T E R    Y O U R    P A S S W O R D"

'*** Connection string for SQL Server
strcnn="Driver={SQL Server};Server=" & strServerName & ";Database=" & strDatabase & ";Uid=" & strUsername & ";Pwd=" & strPassword & ";"

set rs = CreateObject("ADODB.Recordset")

The remaining code uses the LINES object which allows us to read the line items (grid) of the customer order.  As we cycle through the lines, the macro will do a database lookup to determine whether the PART meets our requirement to create a new work order.  If a work order is required, we check the "New W/O" checkbox.  To do this we set the ADD field to "true".

FYI: In macro terms, the variable ADD represents the "New W/O" checkbox you see in the grid.

Now because whenever you set the New W/O checkbox, VISUAL prompts the user to set the status of the new work order (Unreleased, Firmed or Released).  To accept the defaults, we use the SendKey function to hit the enter key. 

Infor VISUAL ERP - New Work Order Defaults
New Work Order Prompt - Use the Sendkeys to "hit" the OK button

 

set objShell = CreateObject("WScript.Shell")

Set ORDERLINES = LINES.Value
Lcnt = ORDERLINES.Count

Set ORDERLINE = ORDERLINES(Lcnt-1).VALUE
Set OrderLines = LINES.VALUE

For i = 0 To (ORDERLINES.COUNT - 1)

    Set ORDERLINE = ORDERLINES(i).VALUE
    
    PartID=ORDERLINE("PART_ID")
    
    '*** Check SUPPLY_TYPE to make sure that line has not been allocated yet
    SupplyType=ORDERLINE("SUPPLY_TYPE") & ""
    
    '*** Verify that the line item is a VISUAL Part and that
    '*** it has not been allocated yet
    if PartID<>"" and SupplyType="" then
        
        '*** Database lookup to check whether part meets
        '*** new work order requirement
        '*** In this case if the part is FABRICATED
        
        SQL="SELECT FABRICATED FROM PART WHERE ID='" & PartID & "'"
        rs.open SQL, strcnn

        if not rs.eof then
            rs.movefirst
            if rs("FABRICATED")="Y" then
                
                '*** Part meets requirement.
                '*** Check New W/O checkbox
                ORDERLINE("ADD")=true

                '*** Send the ENTER key to accept
                '*** new work order defaults
                objShell.SendKeys("~")

            end if
        end if
        rs.close
    end if
Next

Download the macro and try it yourself

WHO IS VISUALNUGGETS?

Rich Ferlatte
Results Driven VISUAL Specialist

CONSULTING SERVICES

Of course, I am available for hire!

ERP Implementations & Upgrades
Analytics & Reporting
Integrations & Macros
General VISUAL Support

ONLINE VISUAL WORKSHOPS

Taking it to the next level and designing a program around "Hands On VISUAL Training".

Check them out - there's sure to be one to interest you!

Operational Workshops
Reporting Workshops
Financial Workshops
Inventory Workshops
Quality Workshops

VISUAL EXTENSIONS

BOM Xploder
Drastically improve your BOM visibility and discover shortages at ANY level of your bill of material no matter how deep.
SmartViews
See, analyze, and track information that helps you better support individual, departmental, and your company’s performance metrics and goals.
Credit Card Integration
Easily accept and process credit card payments right from within VISUAL.
CAD Integration with CADLink
Reduce rework, minimize scrap, and work more efficiently with CADLink - a fully automated, two-way connection between VISUAL and your CAD system.
Sales Tax Automation with AvaTax
Easily automate sales and use tax in VISUAL with AvaTax. No more manually entering data or uploading rate tables and tax information.
Workforce Management with Kebrite Solutions
Streamlines the collection of Job, Labor, Payroll, Time & Attendance, and a vast array of HR related data-- with live VISUAL integration.
ACH Document Processing
Leveraging VISUAL's payment scheduling and batch payment functions, with the added convenience, performance, and security of Electronic Funds Transfer payment processing.