Purchase order for multiple Work Orders

Question

Is there a way to allocate a purchase order to more than one work order? 
 I only see the Work Order option at the top of the PO. I'd like it available by line item, if possible. 
 I can't be the only company that issues one purchase order to a vendor, but has to apply it to multiple projects. How do you deal with this? 
 
 Thanks 
 Sue

RandyW · Accepted Answer

Sue Clifford said: The biggest reason I was hoping to do this is so that I can export the Open POs report and know what is still outstanding by project. But it doesn't look like I'll be able to do this on the POs where our supplier wants one PO. It's manageable, just not as seamless as I was hoping for. 
 The data is stored internally line-by-line, so I'd guess the PO linking to Projects has been limited to a 1:1 choice when it was brought over from a more 'advanced' product to be more limited in the 'entry level' Sage 50 product. 
 I'm sure some of the other more 'advanced' Sage products would do multiple Projects on a single PO. We occasionally look at converting to one, but the cost and learning curve chases us away.

RandyW · Answer

Sue Clifford said: I can't be the only company that issues one purchase order to a vendor, but has to apply it to multiple projects 
 Hi Sue, 
 If you are buying and selling inventory items , the automatic COGS accounting takes care of allocating the costs to each project as it is invoiced, so it doesn't matter that you don't know where each of those dozen air filters are going over the next three months, code it all to a project for 'Stock' or 'Warehouse'. 
 If you are doing Assemblies or Bill of Materials, there's no Project tracking through from purchase to sale. 
 If you need to keep track of unallocated / unbilled inventory , or are coding the purchase order items as expenses / 'Service Items', then you would have to change the allocation for each line when posting the Purchase Order into an Invoice, or keep each Purchase Order separate. 
 We make a lot of notes in the Description column, then have the person 'flipping' the Order to an Invoice code each line to a Project. 
 Or just issue individual Purchase Orders by project. If the vendor bills these as individual Invoices, they are easy to track to billable Project (even / especially in a paper system. If a Project is cancelled, you pull all the Orders to cancel them, pull the purchase invoices to return them). 
 I hope that helps, please post back.

Sage 50 Canada

Purchase order for multiple Work Orders

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING