Search results for query: *

I'm trying to find ways to optimize searching capabilities in the Customer card. I know that I can add fields to search on in the Advanced Lookups setup - but these added fields show up below a list of seemingly pre-defined fields to search on. These pre-defined fields are also the choices in...

Here's an odd one ... For tracking paid invoices using Crystal Reports, I've been pulling data from both main History tables (SOP30200 and SOP30300), as well as the Sales Payment Work and History table (SOP10103). For the GL Posted Date, I've been using SOP10103.GLPOSTDT. Well, as it turns...

This is a known issue with Great Plains. Any split information entered into the Commissions window on an Order will be lost when that Order is transferred to an Invoice. I'm trying to track Orders all the way through their cycle, to determine what number never get transferred to Invoice because...

Hi, I have a running total field which worked fine as Field to summarize: table.commissions Evaluate on change of field: table.Invoice# Reset: on change of group SalesRep I need it to evaluate on change of Invoice# because there may be more than one item on an invoice, and a sales rep's...

Hi, I'm connecting to an Excel spreadsheet via ODBC, trying to link it to some SQL tables. The field on which I can link to the SQL tables is "Sales Rep" which, although it is a number, is a String field. So I altered my data in Excel to make "Text" cells which happen to...

Hi, I'm trying to write a SELECT statement for use in Crystal Reports 8.5, reporting on some tables from Great Plains. I need to access the exact same fields in two Posted Documents tables, and two Unposted Documents tables, and I'm told that UNION is the way to achieve this. But I'm having...

Here's a problem I can't seem to get my head around. I am creating a two lists of the orders placed each day, for the Shipping Dept. to pull the stock and send it. For the overview version, I need to show just a count of products ordered, as in: Item # Ordered (across all invoices) ABC...

I got no response to this prob. my first time out, so am trying again ... I'm creating a report in which several item lines may appear for any given invoice payment. Each line must show, but the first item line is the most important. So if three lines have the same payment number, I'm...

Hi all, I'm creating a report in which several item lines may appear for any given invoice payment. Each line must show, but the first item line is the most important. So if three lines have the same payment number, I'm conditionally formatting the fields' font by saying: If {pymnt#} =...

Hi, I've created an invoice, and would like to suppress lines of the address (Business Title, Address Line @ etc.) if they are null, so that there are no blank lines. However: I can't divide the address and make each line into a separate Detail section, because one address set has a box around...