How To Connect/query Sage100(Mas90) Follow
I have a question regarding Bartender and Sage 100 (MAS90). But first a little background, my only practical experience with bartender is creating and printing label templates. It’s only in the past week that I started reading about how to input data from a database.
The company I work for uses Bartender 10.1 SR2 to create and print labels for all of our products. Currently every label that’s printed requires the user to manually input a lot number into a text field on the label before printing, which is labor intensive and leaves us vulnerable to typo errors. So what we we’d like to do is automate the manual inputting of lot numbers.
I’ve looked through the forums and the help docs and was able to create a simple spreadsheet in excel and link the text field of the label to the spreadsheet and successfully print a label using data from the spreadsheet. However, I would prefer not to create and maintain an extensive spreadsheet of all of our inventory’s lot numbers in addition to the inventory system we already use. That inventory system being Sage 100 (MAS90) which brings me to my point. How would I go about connecting Bartender to Sage 100 (MAS90) in order to get the lot numbers from our inventory and input them into a text field on an appropriate label? Any help on this would be most appreciated.
Please sign in to leave a comment.