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...
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...
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...
Thanks hoogie; yes I found it there, in Company. I must have seen the table in GP at some point and printed it, because I do link to it, but couldn't find it when answering SeanFu (wherever he may be).
But I have a question - on my SY01200 I have only 13 fields in all. Besides the first four...
... Odd as it sounds, you should check the System tables. I know, for example, that I use the INETINFO field on SY01200 to get the Internet Info for Item. There are other fields there which for me are blank, but perhaps you'll find the info you need within. If not, try some other likely sounding...
Thanks to you both for your suggestions. I tried your idea, Ken, which is an (easier) variation on chrisjev's second suggestion.
And that worked fine - however! I just discovered that with Crystal 8.x there is that nice Excel add-in (mine was not enabled because Excel had been re-installed...
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...
I thought I'd just update since this was an interesting problem - in case someone comes up against a similar thing.
The problem I refer to at the end of the post above
I've now got boolean values (0 or 1, or 0 and 2) coming in from SQL to Crystal as numbers like 42,213,120
was a bit of a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.