Welcome, Guest. Please Login.
04/30/24 at 12:18:12
News:
Home Help Search Login


Pages: 1
Send Topic Print
report by customer PO (Read 2330 times)
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
report by customer PO
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
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
DawnS
Browser
*


I Love EvoERP!

Posts: 14
Re: report by customer PO
Reply #1 - 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
Back to top
 
 
  IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: report by customer PO
Reply #2 - 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.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
Laura Oliver
Active Member
*****




Posts: 984
Gender: female
Re: report by customer PO
Reply #3 - 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.
Back to top
 
 

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com



Email WWW   IP Logged
Pages: 1
Send Topic Print