Reporting

If you need to get the user name of the person currently signed in for a document field use this query:

SELECT T0.U_NAME FROM OUSR T0 Where internal_k = $[user]

While creating a report in Print Layout Designer (PLD) from a query I noted that the maximum number of fields that the PLD would import was 100.

If you do not use FOR BROWSE in your query and you attempt to create a Print Layout Designer (PLD) report from that query, you may find that there will be no field descriptions for the fields.

Use this query to check for high order quantities on a Sales Orders.

If you make an alert out of this query, then you can be notified when potential keying errors occur.

Use this query to show you a list of open balances by customer group. If you would like to see

open balances by vendor, then change the Where clause to cs.cardtype = 'S'.

Use the query to show all of the customers that do not have sales employees assigned. You can use this as an alert as well.

SELECT CardCode as BP, CardName as 'Customer Name' FROM OCRD Where SLPCODE = -1 and CardType = 'C' FOR BROWSE

You can use this query to view or alert you to items where the min/max on the Inventory tab is not set for an item.

SELECT ItemCode, ItemName, MinLevel, MaxLevel FROM OITM Where MinLevel = 0 or MaxLevel = 0 FOR BROWSE

When referring to a User Defined Table (UDT) in Query use the following syntax:

While listening to one of the expert sessions, I caught that XL Reporter will not show any information unless a measure (i.e., quantity, Dollar Sales, Etc.) is selected. I had created a simple customer list just to test it out and it kept returning no information. Once I added a value (measure) it produced the list.

 I too a look at the sample report pack from SAP and I noticed that when they created a graph (even over expanding groups), they were selecting the cell below the value as well.