Recent content by leftfldr

OK. Well the formlua works great in teh details now, but then when it has to move back to the next GH2 I get stuck. I think the problem might be because the dr and cr amount formulas for the GH2 have to be different than the dr and cr formulas on the details section. The details section pulls...

Thanks for the reply. OK. I tried your suggestion. The problem is that the sale document numbers are in the GH2 and the applied payments are in the details. So if I place the formula you suggested in the details it does not take those into consideration. Here is what the balance looks like...

Using Crystal Reports 10 and SQL2008 DB (Dynamics GP backend accounting software). I am trying to recreate customer statements that are produced within Dynamics GP. I want it to look similar to this: Document # Code Date Debit Credit Balance 517020 Sale 12/12/08...

I would not want to set the Unit of Measure and Unit of Measure Price equal to each other would I since I want to compare CATPRICE EX to NET EX?

Using SQL2008 I have two pricing tables that have the exact same columns. I need to find the records in 1 table that do not exist in the other table. If TABLE A has a Price Level and Unit of Measure combination = CATPRICE EX I need to know which of those item numbers do not have a Price Level...

select * from (select Field, count(*) over (partition by substring(Field, 1, LEN(Field)-2)) as CntUnique from myTable) X where CntUnique %2 = 1 combined with and Field like '%+%' to get only items including +. This worked great!

Thanks so much. The first solution did work for me and got me exactly what was needed!

OK, this makes sense, but I could we alter it to because we have items with no plus at all or just one or the other. So I am only concerned if it has a +C to start with. Example: 111 1234 1234+C 1234+O 4567+C 678+O 9876+C 9786+O 999+C Expected result: 4567+C 999+C

Using SQL2005 against Dynamics GP. I have a table that contains inventory items. We have inventory items that end with a +C and +O with the same preceeding characters. I need to generate a query that will give me a list of all +C items without correspoding +O items. How should I go about...

Using SQL 2005 I have a contact name field where the first and last names are stored together. Some of the last names start with Mc. I need a script that will capitalize the letter after the Mc. Here are examples of data in the table. Bill Mcconnell Jim Mccall Joe Smith Tim Lansing Dan...

Make two formulas (I know that my text field only has one hard return) Split1: If INSTR((table field), chr(13)) > 0 then LEFT((table field), INSTR((table field), chr(13))) else '' Split2: If INSTR((table field)), chr(13)) > 0 then MID((table field), INSTR ((table field), chr(13)) +1) Now I...

Nevermind I figured it out on my own.

Using Crystal 10, SQL 2005, GP Dynamics backend database I have a memo field that I need to split into separate fields for the purpose of formatting. For example, my field reads: "Repair Only - 90 Day Warranty (hard return) Specify Tilt & Lighting Volts" I need the words Specify Tilt &...

PERFECT! Thanks so much for your help!

Using Crystal 10 with Microsoft SQL Server and the ERP package of Microsoft Dynamics GP. All information in the item database is stored in uppercase. For this particular crystal report we do not want all uppercase so I am using the propercase function first. When I use the propercase some...