Import bills against existing purchase orders

In QuickBooks it is possible to receive items on a bill against an existing purchase order and create a link between the two transactions, this is also possible when importing bills when using Zed Axis.

 
Link Purchase Order to Bill

To link a bill to a purchase order in the invoice mapping select the field called Link To Purchase Order and map that to the column in your import file which contains the Reference number of the Purchase Order you wish to link to.  When the bill is imported a link will be created between the two transactions. 

Points to consider:
  • The vendor on the purchase order should match the vendor on the bill otherwise QuickBooks will return and error
  • The items on the purchase order should match those on the bill.

Feedback

Add Feedback
When I do this, it is duplicating all of the line items. Is there a way to prevent this?
Jeff (February 20, 2015 at 12:28 PM)
Hi Jeff, if you are linking then you only need to import one line with the linking as it automatically pulls the items from the purchase order.
Steve (March 18, 2015 at 12:11 AM)
With our distributors, the various items on a single PO may be spread across multiple bills (based on when they ship). Is it possible to link the bill to an existing PO while specifying specific items and quantities?
Ricky (April 5 at 12:04 PM)
Is there any way to create a single bill of items I'm receiving from multiple POs?
Lianne Perez (August 29, 2016 at 10:39 AM)
Hi Lianne, At the moment there is a bug in the QuickBooks API that will not permit us to Link a Bill to Multiple Purchase Orders, until this is resolved we can only do one Bill to One PO. Sorry,
Steve (November 24, 2016 at 1:24 AM)
Has there been a resolution to this QuickBooks API bug?
Daniel Sossaman (March 24 at 8:09 AM)

Add Feedback