Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. maccrystal

    Email Check / Validation

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

    how to print paper invoices for non-edi customers only

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

    Correcting UOM errors in standard cost environment

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

    String Extract

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

    String Extract

    AAALAHBACBC1 www.appstratinc.com
  6. maccrystal

    String Extract

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

    String Extract

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

    String Extract

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

    Merging two Databases

    agree thanks www.appstratinc.com
  10. maccrystal

    Merging two Databases

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

    Future of the Macola Product Line ?

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

    Question on old thread - local admin privileges

    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)...
  13. maccrystal

    Sales tax

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

    Sales Order #00000000

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

    Add Raw Material Location

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

    Manual Crosstab Print Month Headings

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

    Creating an intranet site to display CR

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

    SERVER PSQL 8.5 Move

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

    freight pay code

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

    How to concatenate items in a field into a group summary

    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

Part and Inventory Search

Back
Top