When placing an order, my coworkers input it onto an excel spreadsheet, which I then retype onto the PO. Is there a way to upload the spreadsheet directly into the PO?
Thank you,
*This post is locked for comments
Integration Manager is likely to be your best option; an integration could be configured to read your spreadsheet (saved to CSV) and import the PO.
A macro is tricky when you have a scrolling window.
There are numerous options. SmartConnect, eConnect, Integration Manager and Macros come to mind.
Smart Connect - Doesn't Require a GP User ($3000) to import Excel files right to GP.
eConnect - is powerful, but complicated.
Integration Manager is simple, and direct from Microsoft, but requires a GP User be logged in to run, so you have to factor this into the true cost of the solution.
Macros are free with GP, require a user be logged in, and need to be set up each time you are going to load data, but they have the added advantage of supporting custom fields when needed.
Good luck Denice!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (