How to track the Vendor PO number on the customer Sales Order and Invoice in QuickBooks.

Solution – when you need to track Vendor Purchase Orders that are associated with individual customers (i.e. Sales Orders), reference the internal QuickBooks Vendor PO number  in a user defined field.

Also please read this post http://evarsys.com/qbenterprise/?p=40.

Create a user defined field on the customer card, called Memo, or Vendor PO#, or something else that makes sense to you.  I don’t think you want to call it Vendor PO number but you can name it anything you want. I suggest naming it “yourcompanyinitials”#.  For example, XYZ#.  This is your internal tracking number for the Vendor Purchase Order attached to the Sales Order.

Modify the Sales Order and Invoice form to display the Memo or XYZ# field.

On the Sales Order you then click on the drop down by Create Invoice and click Purchase Order.  Complete the PO for the vendor, do a CTRL C on the PO Number to copy. Click Save and Close on the Purchase Order.  Then back on the Sales Order click in the Memo or XYZ# field and CTRL V to paste.

The Memo or XYZ# will be updated on the customer card. Just click save.  This will over write each time and that’s fine. This updated user defined field will default on the next Sales Order or Invoice you create.  But don’t panic, you just blank it out or paste over it each time on the Sales Order or Invoice.

The Memo or XYZ# field will now print on the Sales Order, and transfer to the Invoice.

Modify the Open Sales Order Report by Customer to display the Memo or XYZ#.

Please contact us if you would like some help implementing this functionality.

 

 

 

This entry was posted in QB Enterprise. Bookmark the permalink.

Leave a Reply