ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> report by customer PO
http://www.istechforum.com/YaBB.pl?num=1471031272

Message started by Laura Oliver on 08/12/16 at 12:47:52

Title: report by customer PO
Post by Laura Oliver on 08/12/16 at 12:47:52

I am looking for a report that lists invoices by a customer's Purchase Order. So far the best I can find is SO-O user defined detail, but this reports also includes open sales order and DOES NOT give me a total. I am having zero luck with SA.

Thanks
Laura

Title: Re: report by customer PO
Post by DawnS on 08/15/16 at 07:38:32

I would use TAS-R and

select * from bkarinv where bkar_inv_cuscod = 'XXX' and bkar_inv_cusord = 'YYY'

(XXX is the customer code and YYY is the customer PO)

And export it to Excel. You can limit the fields rather than * if you want and then you can total in Excel

Title: Re: report by customer PO
Post by Lynn_Pantic on 08/15/16 at 08:38:25

SA-M and SA-N can filter by customer PO. SO-O-J & K are open orders, not invoices.

Title: Re: report by customer PO
Post by Laura Oliver on 01/08/21 at 13:01:10

We don't have salesmen but I have just discovered SA-I allows me to print every shipment/invoice to a customer for one single Purchase Order.

Someone may ask what have we shipped and invoiced off a certain customer PO. Until now we had never found a good report that would do. SA-I Print sales person summary is likity split as long as you enter ship date range.