Inventory parts, inventory and ordering

Closing multiple PO

Closing multiple PO

Postby Qbasic8 » Tue Sep 12, 2017 10:41 am

My boss has a habit of not closing 'any' PO after parts are ordered. I would say their is roughly 1,000 + open PO's. Is their a way I can close
all of these with only a few clicks instead of going through each one of them? (That would take forever and a day to do..)
Qbasic8
25 Club: Starting Contributor
 
Posts: 38
Joined: Thu Apr 16, 2009 5:38 am
Location: Ohio

Re: Closing multiple PO

Postby ricmorin » Tue Sep 12, 2017 10:43 am

You can get this done with the help of support.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5289
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Closing multiple PO

Postby Qbasic8 » Tue Sep 12, 2017 11:15 am

Just got off of the phone with tech support and they said the only way to handle it is to do it one by one. Strange figuring m1files.com shows a SQL script to do such a task (viewing the sql command in notepad confirms the script is meant to do such a thing). Any suggestions?
Qbasic8
25 Club: Starting Contributor
 
Posts: 38
Joined: Thu Apr 16, 2009 5:38 am
Location: Ohio

Re: Closing multiple PO

Postby Pauls Automotive » Tue Sep 12, 2017 11:23 am

I would retry calling support. I think you got someone unfamilair with this process. I know it is possible for support to do this.
Paul
Pauls Automotive
6320 Falls Road
Baltimore, Md 21209
410-825-2224
paul@paulsauto.com
TRUE HAPPINESS IS WITHIN YOU
User avatar
Pauls Automotive
1000 Club: Interstellar
1000 Club: Interstellar
 
Posts: 1330
Joined: Wed May 24, 2006 6:32 am
Location: Baltimore Maryland

Re: Closing multiple PO

Postby ricmorin » Tue Sep 12, 2017 11:26 am

Call back and ask for second level support, unless something changed they used to be able to do this.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5289
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Re: Closing multiple PO

Postby Qbasic8 » Tue Sep 12, 2017 11:46 am

Well, got off the phone with the same guy saying their was no other way, but I kept telling him I was looking at "their script" that does it and he finally started asking others some questions and realized they could in fact do this. So script was executed and problem is solved.

In the future if anybody else needs the info their script is located at : http://www.m1faqs.com/fix/SE/index.htm
Line 14: SE Database Queries for use by Technical Support Updated 12/13

That contains the script 'ClosePOMaster.sql' which will need to be ran on the host machine. You can enter a start and end date and close all PO's within that range.
Qbasic8
25 Club: Starting Contributor
 
Posts: 38
Joined: Thu Apr 16, 2009 5:38 am
Location: Ohio

Re: Closing multiple PO

Postby ricmorin » Tue Sep 12, 2017 12:02 pm

Lets just state that the user should consult support before applying any of these and that at least one backup should be done before beginning. :D If you do something wrong without support, you may be on your own.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434
https://www.facebook.com/motorcaralternatives

Reality continues to ruin my life.- Calvin
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
 
Posts: 5289
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire

Return to Inventory / Purchase Orders

Who is online

Users browsing this forum: No registered users and 1 guest