Recent content by CarolineS

Try IV30300 ...A trick that often works is to open the screen you're interested in, and then choosing from the top menu Tools > Integrate > Table Import. This will show you what tables are involved with the window. When I do that on the card you're referring to, I only get Item Master and...

Just use Explorer (or "Smartlist" if you're on the latest version of GP). Use one of the existing views under Sales Transactions - look for one that contains the field Customer Number. You may have to add the field Customer PO Number. Then hit Search and select/type in the criteria...

zemp, If you build a little table - in SQL, in Access, anything - as I laid out above, link it to the tables in your subreport and then place the field of that new table on your subreport (you can suppress it so it can't be seen), you will achieve exactly what you describe. I do it all the time...

zemp, try this: Create a table which contains a single field with values in rows as follows: 1 2 2 3 3 3 4 4 4 4 etc. (i.e. you'll have one 1, two 2's, three 3's ... six 6's ...) Create an equal join between this field and the QUANTITY field of your table, and Crystal will produce the...

In Excel, go to Tools>Add-ins and check the Crystal Reports Wizard. If there is no Crystal Reports Wizard available, hit the Browse button and find the file called crptxls.xla in C:\Program Files\Seagate Software\Report Designer Component. Double-clicking it will allow you to now select...

Thanks for this info - not encouraging news as I'd hoped, but it does make sense. I'm not familiar with dex but will look into it.

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...

Sorry I disappeared there for a while ... Are you using Crystal Reports for your invoices / inventory forms / whatever you need to put the barcode on? I put barcodes on our invoices etc. (which are done in Crystal Reports). We purchased a barcode font, which has to be added to any PC from...

How do you want to use the bar code with respect to Great Plains? Can you give more specifics, i.e. what parts have to be automated, or automatically generated; are you reading them, printing them, etc. etc. We use barcodes to some degree with our setup, but I need to understand more about what...

An amendment to my post: the overall count of Orders will not be incorrectly inflated, since the Order will only show one rep getting 100% of the commission. But I'm still looking to accurately reflect splits as they exist on the Invoice. Also, apparently this "commissions not being...

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...

Great, that's perfect. Thanks, Ken. :-)

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...

There is a complete list in GP itself which lists all the tables and the fields on each table. But a lot of additional info is not filled out unfortunately. Go to Tools>Resource Descriptions>Tables, then choose the series of tables you wish to view (Financial, Sales, etc.) You can print at this...