Announcements
I would like to output any new or changed Purchase Orders to a directory as a file automatically. If this is not possible is there a way to automatically email any new or changed Purchase Orders to a specified email address?
*This post is locked for comments
PO's!!
All POs tracked as new or change order until they are printed. So, you should be able to write a process that can extract these (reporting tools, SmartList, SQL, et cetera.) before the POs are printed. Once they are printed you need a tool that will know which ones are new. Knowledgesync is such a tool. You set it up to export new/changed POs, let it make one "setup run" where it will export all of the current ones, and it then makes a record of what it has exported. From that point on, it will automatically (on a schedule) export new orders (one time only) without reguard to the printed status.
If you want to look into Knowledgesync, it is offered by Vineyardsoft. Look them up on the web and tell them I said to call.
See if this will be helpful to you-?
www.mssqlcity.com/.../TbToFile.htm
#1 You need to create a separate table for yourself and Keep copy of all existing SOP's. They query against you table from GP Tables to see what has changed. And based on the changes you can export query results to TXT file. That all depends how much technical you are. If you are intrested to higher somebody to do that for you I might be able to help you too.
André Arnaud de Cal...
293,474
Super User 2025 Season 1
Martin Dráb
232,592
Most Valuable Professional
nmaenpaa
101,158
Moderator