Topic Options
#8569 - 03/07/07 09:54 AM Duplicate a Purchase Order
Barb9 Offline
Adagio Prodigy

Registered: 03/06/06
Posts: 273
Loc: Langley
We are running three locations out of one data base. Yesterday, a purchase order was received that had one location on its header (the correct location), but each item was unfortunately not in the correct location. This was not noticed until the entire PO had been received. I have since edited this employee's top bar, and added the "Loc" column, however is there a quick way to duplicate a purchase order that has been completed? There are many items on this PO, so that feature would be very helpful.

Thank you!

Top
#8592 - 03/08/07 02:19 PM Re: Duplicate a Purchase Order [Re: Barb9]
Douglas Dickie Online   content
Adagio God

Registered: 06/02/99
Posts: 4421
Loc: Vancouver, BC
There is no quick way. I believe you can use the export function to export a completed order and then the import function to bring it in as a new PO. This would take some experimentation and testing as there does not appear to be supplied templates to do this.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#8602 - 03/08/07 09:44 PM Re: Duplicate a Purchase Order [Re: Douglas Dickie]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4514
Loc: Wynnewood, PA
This is going to sound roundabout, but I think it is the easiest approach, and it works.

Create a CSV file (or an Excel file that can be saved as a CSV file) that looks like this..

"H","CUST#"
"D","ITEM1","",100
"D","ITEM2","",200
"D","ITEM3","",300
"D","ITEM4","",400

where CUST# is a valid customer code, ITEMx are valid item codes, and the last number is the quantity on PO. There is no limit to the number of "D" rows you can have. Then...

1) Save the file with the name OEORDIM.CSV in the data directory
2) Go into Adagio OrderEntry - yes OrderEntry
3) Go to File | Import | Orders, select the template called "Orders Version 1 Default", and import. This will create an order in OrderEntry with the items and quantities you entered in the file above. You will eventually delete this order, but for now post it and remember the order number.
4) Go back to Purchase Orders, start a new PO, and on the Header tab, check off OE Reference, enter your order number, and click on Import OE lines. This will bring all of the items on the sales order into the PO.
5) Now go back to OrderEntry and delete the order.

This isn't perfect - the unit cost may not be correct, it only works for inventory items (not sundry items, comments, instructions), and you will have to fill out the information on the other tabs, but it might save you from doing a lot of data entry.

Let us know if you try this and how it goes.

Steve

Top
#8607 - 03/09/07 10:40 AM Re: Duplicate a Purchase Order [Re: Steve Schwartz]
doswalt Offline
Adagio Specialist

Registered: 11/10/06
Posts: 319
Loc: AL
I'm just researching Purchase orders at this point so this is more of a question than answer:
In purchase orders: Edit|Profile|Runtime Variables -select "Allow Edit of Completed Orders" - Select PO|Edit PO - "Duplicate" to recreate the PO. At this point, could you receive the duplicated PO correctly and "Return" the receipt that is improperly entered? Then go back and reset the Runtime Variable.

Top
#8770 - 03/26/07 12:38 PM Re: Duplicate a Purchase Order [Re: doswalt]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1739
Loc: Waterloo, Ontario, Canada
Yes Steve,
You are correct. If you want to duplicate or replicate a completed PO, then you change the runtime variable to edit completed PO's and you will be able to duplicate or copy a completed PO to a new Order.
In this situation, the location code would also have to be revised for the line items. Then as you suggested, receipt the new PO, and credit (return) the completed PO (for the wrong location), to correct the quantities by location.
The only hitch is that you will have to take both the credit and the receipt on the duplicated order into AP and offset there. We do not have the function that allows you to combine a credit with a receipt.
You can duplicate an existing open PO without modifying the edit completed PO's. You could also duplicate recurring PO's by creating a PO template.
Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (1 invisible), 84 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14482 Topics
70726 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31