GP 10.0 Customer Order Reports

(0) Share

Report

Posted on by kjbaiii

Our sales force sells through a distribution channel of country reps. We try to know who the end-user is of our product, although, this is not always the case. When we do we imput into GP our Rep. as well as the end-user name/location. We would like to write a report that shows where our products are going. No one in our org. has knowledge of this. Any tips?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at

Like (0)

Report

Re: GP 10.0 Customer Order Reports

Call Victoria Yudin at Flexible Solutions (www.flex-solutions.com). She can fix you right up with just about any report you need.

Was this reply helpful? Yes No
Matthew Magrum 275 on at

Like (0)

Report

Re: GP 10.0 Customer Order Reports

Are you looking for the SQL script for a report that you want to put in Crystal? Is this a item based report off of the invoices? If so, you can use this SQL to view all the products that are going in certain states in a given date range.

Select a.custnmbr, a.custname, a.slprsnid, a.state, b.itemnmbr, b.itemdesc from SOP30200 a inner join SOP30300 b on a.sopnumbe = b.sopnumbe and a.soptype = b.soptype where a.docdate between '1/1/2010' and '8/24/2010' and a.state = 'IL' order by a.state, b.itemnmbr

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: GP 10.0 Customer Order Reports

In what fields are you storing the end user name / location? What is the field name and on what window?

I presume you are storing the Rep name n the Sales Person ID Field.

Depending on where you are inputting the end user name and location, you can probably get this info out on a Sales smartlist.

Was this reply helpful? Yes No
Victoria Yudin 22,768 on at

Like (0)

Report

Re: Re: GP 10.0 Customer Order Reports

Thanks to Frank for the endorsement!! Yes, we can definitely help with this if you would like someone to create this report for you.

If you're looking to do this yourself, Ian and Matthew have brought up some great questions that are critical in determining where and how you get this data. If you're storing this information in GP fields, you most likely can get the data from SmartList. If you're using your own tables or Extender, or want to report in some other format, you will most likely want to use SQL.

If you're doing this in SQL, I have a page on my blog with a listing of SOP tables: http://victoriayudin.com/gp-tables/sop-tables/ that can help as a reference. I also have a blog post with a SQL view for all SOP line items that you can use as a start and add/change what you need: http://victoriayudin.com/2009/05/17/sql-view-with-all-sop-line-items/.

Was this reply helpful? Yes No