MAS 90 & MAS 200 – Custom Office VB Script to Open a Related Set Of Documents

Thanks to Scott Hickman of Service World for this tip.

This script was written for a client that has a "Sales Order" file that they scan into the system after the order has been completed. The PDF contains various correspondence, technical data etc regarding a specific order.

Same concept can be adapted for customer, vendor and inventory entities. A path that is off the MAS90 system directory is usually used since some of the scans can become large and I do not want to grow the MAS90 directory unnecessarily.

This shows how just a few lines of code can make for a large productivity increase:

Dim FileSystemObject

dim objapp

path = "\\S1\savin-scanner\MAS-SOAttachments\"

Set objApp = CreateObject("WScript.Shell")

Set FileSystemObject = CreateObject("Scripting.FileSystemObject")

If (FileSystemObject.FileExists(path & AR_InvoiceHistoryInquiry_bus_SalesOrderNo & ".pdf")) Then objApp.Run path & AR_InvoiceHistoryInquiry_bus_SalesOrderNo & ".pdf"

Thanks Scott!

© 2009, Mark Chinsky. All rights reserved. Formed in 2005. the 90 Minds Consulting Group is a collaboration of 100 Sage partners who independently join together online in a 24 x 7 private communication network to solve difficult issues for their customers. The group is not affiliated with Sage and our collaboration provides for unparalleled member access to early warnings of bugs and other issues which members in turn are encouraged to use to provide an exceptional customer experience.

Mark is a partner at Clients First Business Solutions, LLC. He is based out of the NY/NJ office. Mark has been in ERP sales and service for more than 20 years and at least 15 with Sage

Mark Chinsky

View all posts by Mark Chinsky
Mark's website

« MAS90 or MAS200 – Use Visual Integrator to Import Ship To Codes | Home | How to move Paperless Office documents in Sage MAS 90 and MAS 200 4.3+ »

• 
  
  
  
  
  
  
• Ask a Question on Ask The 90 Minds Group