Start a new topic

Purchase Order Report

Hi Matt


Does QW have a report that can show Purchase orders ?


Example   i want to see every PO created between  Jan 1 thru Feb 1  to read


Vendor PO #          Vendor/supplier            Purchase Value

NUMB11111          Techdata                       2200

NUMB11111          Ingram Micro                1400

single Line value  (example)   at techdata i bought 3 line items , multi qty,  the total value sent to techdata was  2200
i am looking for a cumulative PO value per vendor, per PO

Thanks Mark

Is this via the Purchasing Module of QuoteWerks (Purchasing icon) or just using the Purchase Order layouts from the Deliver window?

 Hi Matt

i am open to any way to accomplish this task,

Scenario:  Report for All materials purchased on a PO to All vendors for example a Month.


we want to confirm our accounting SW has all entries


Example   i want to see every PO created between  Jan 1 thru Feb 1  to read


Vendor PO #          Vendor/supplier            Purchase Value

NUMB11111          Techdata                       2200

NUMB11111          Ingram Micro                1400
NUMB22222         Synnex                          1825
NUMB22222         D&H                              1230
NUMB33333         BestBuy                         3400

Date Range          PO  &  Vendor  Name      =  $ ordered from Vendor  cumulative

( or   by line item )  not preferred but we can manage

Thank you  Mark
xlsx

Thanks Mark, is it enough to say "The document was converted to an order between mm/dd/yyyy and mm/dd/yyyy", or does it have to be when the PO was generated - possibly not being the same day?

Hi Matt

Yes,  the document was converted to an order between   example   1/1/2018  thru 1/31/2018

We created a PO via Quotewerks and sent to the supplier.  We are looking for a history report. A report that i can export to excel,  or even Pdf ,  that i could use to go back to my supplier invoice tool, and compare, example   my PO created  1/5/2018 for $ 3416.86  and see my supplier value is a match that billed on 1/9/2018


Thank you Mark.

Hey Mark,


Ping me an email and I'll send you a quick mockup for you to review.

matt@prestigequoting.com

Login or Signup to post a comment