I work for a company that doesn't have an IT background. They seem to live in Excel, FilePro, and they recently installed GP 2016, but they do not understand how to use it fully.
I noticed that I can do a query and print out all my purchase orders from GP and save them to an excel file. I'm trying to teach myself how to do access and my goal is trying to make my job easier as they do a LOT of redundancies that make a task that is 10 mins typically .. into a task that can take 4 hours.
Anyway, I'm trying to figure out how I can make something that I can input the data from the report into an access database and let me capture the data info fields for other reporting issues. It's hard to explain but the jist of it is.. I have to enter orders into GP which make a purchase order.. then I have to hand type all those 100's of orders onto excel pages for each purchase order and save them each individually.. to their own file named after each PO# .. and then I have to dig around for Art files.. and it takes hours to do stuff that should take no time at all.. My goal is to centralize it more in Access so I can import the purchase orders from GP.. it auto populate the excel and do stuff a bit more automatically..
Software/Hardware used: Microsoft Great Plans, Microsoft Access 2016, Excel 2016