Search results for query: *

It look at the email address field to see if the email address is a null value, Null = 1 not null =0 @Null Check // // Replace with email address field if isnull({Command.email_addr})then 1 else 0 // end www.appstratinc.com

You can set the EDI Customers up for Form XX and non EDI for Form YY. You can print invoices by form number. Progression allow you to define the invoice form number at the customer level. You may want to evaluate in your TEST company. www.appstratinc.com

You could unlock protected fields in IM setup. Change the last cost on Location files. Recheck protected fields. Since you are on Standard, there is no GL effect. www.appstratinc.com

The formula is working based on your solution. Please except my apologies if you think it was a waste of your time, your direction was a great help.. Thanks www.appstratinc.com

AAALAHBACBC1 www.appstratinc.com

Here is my Hack for this: if x[i]+x[i+1] Returns "AA" www.appstratinc.com

The x[i] only returns the first Character of the two char code instead of "AA". So the formula will only consider the first character of the code structure. How do you get the X[i] index to return "AA" or "BB" instead of just "A" or "B"? www.appstratinc.com

Crystal XI, SQL2000 30 Char String field (CODELIST), they contains several 2 char codes, with no seperator values. Need to get the 2 char code and lookup the Text value. Rec 1: AABBCCDDEE Rec 2: AACCDD Rec 3: Blank or null "AA" = Part 01 "BB" = Part 02 "CC" = Part 03 etc... Result should look...

agree thanks www.appstratinc.com

Has anyone used the Export\XML and Import\XML functions in Goldmine 6.7 to combine a standalone (single user)Dbase version into a SQL version 6.7. The XML set would be "Appended" to the SQL Contact set. Dbase The Dbase version has the usual contacts, activities, Sales forecast. Both copies of...

I find it intresting that we have only one "user's" response on this topic and this forum has 2951 subscribers. www.appstratinc.com

Progression client install does install components on the local workstation. Administrator rights are required for the Client install to execute correctly. Once the client install is done test it using the administator account, you must manually grant rights to specific files (macola7.ini)...

The tax amount per line is dynamically calculated during the invoicing process and accumulated in the OEHDRHST_SQL.tot_tax_amt field. The SYSTAXHST is used to print the sales tax reports. Assuming you are using tax codes and not tax schedules, you would need to determine the tax codes and rates...

I have seen that only on one other site. You will need to delete the Order Header (OEORDHDR_SQL) and Order Detail(s)(OEORDLIN_SQL, if they exist) using MS SQL Query Analyser or Pervasive control center. Another method is to export the line and header (system manager), remove the approprate...

If you need to add a location from that screen, Type a "new location Code" immediately after you enter the item number. You will be prompted "do you want to add the Location", if the code does not exist. You must have maintenance rights. Alternately you can simply add the Location from the...

Crystal 8.5 MS SQL2000, Manual Crosstab Report with Starting and Ending Date parameter. Report Format: Jan..Feb..Mar........Sep...Oct..Nov..Dec. For a Date Range of 9/1/06 to 8/31/07 Need to print the mm/yy above the Months as Below: 01/07.02/07.03/07......09/06.10/06.11/06.12/06...

You can look at recrystalize as an alternative. http://www.recrystallize.com/ www.appstratinc.com

is there a way to move (Export) the PCC Database settings for an old server on Windows 2k to a new server Win 2003 without rekeying them. The Old server has about 30 DB's defined. www.appstratinc.com

Use designer and change a OE header UDF to hold the values. Then change forms to use this field instead to the freight_pay_code. www.appstratinc.com

Give this a whirl: It will give you more than 256 in 8.5, don't know about V8. http://kenhamady.com/cru/archives/130#more-130 www.appstratinc.com