SO Line Count Report

Posted By jland47 over 2 years ago

We are trying to see how many SO lines a user types up in a date range. The SO can be open or invoiced, I thought I could run an export of the SO Detail History table, but it is not going the way I thought. Tried to put a date parameter but it looks like it is pulling all the data from inception. Is there an easier way to get this information?

Top Replies

jland47 over 2 years ago in reply to Doc102208 +1

Sorry if I seem uneducated but, is Sage Intelligence an add on? Or just another term for BI?

MM_Logic over 2 years ago

Need to use the SO_SalesOrderHistoryHeader and SO_SalesOrderHistoryDetail tables to be joined by Sales Order No. The header table will have the date created and user created keys that you need.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
jland47 over 2 years ago in reply to MM_Logic

So would using access DB be easier then running the export through VI?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
MM_Logic over 2 years ago in reply to jland47

Either SQL, Access DB or ODBC with Excel. Dealers choice.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Doc102208 over 2 years ago

Thought I'd try and set this up in Sage Intelligence and this is what I came up with:
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
jland47 over 2 years ago in reply to Doc102208

Sorry if I seem uneducated but, is Sage Intelligence an add on? Or just another term for BI?
Cancel
Vote Up +1 Vote Down

Sign in to reply

Cancel
Doc102208 over 2 years ago in reply to jland47

https://www.sageintelligence.com/solutions/sage-100/
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage 100

SO Line Count Report

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING