Recent content by uff555

I would like to send notification/reminder emails to users on specific dates that are in a list's column (a date time field). Is this at all possible?

I ended up creating the following view: CREATE VIEW "InvNumOfCredited" AS SELECT DISTINCT ("T1" ."INVNUMBER" )FROM "OECRDH" "T1" And this sort of works. In some cases, there are invoice numbers that were never actually credited. Is my database messed up? am I just missing something really...

Just old invoices

I noticed we have multiple copies of the same Ship-To for a customer. I would like to combine the two in one ship location (including historical records). Is this possible?

I am proficient in programming and some DB stuff. I was trying to write a query to make a union of two tables. But pervasive proved unable to query a second database.

How can I combine Data in a temp database? Copy the .DAT files?

I have two databases for two different companies. I would like to look at sales including both companies. Is is possible to select fields from two different databases in one view?

It was way too hard to get the STD prices via Crystal. I decided to create a view in my database to show all items and their STD pricing. I was able to include this in my report and get the result I was looking for. Thanks for all the help.

Now I see what you are saying. How might I convert the formatted item name to a formatted item name.

5.4a

I uncovered the OESELC table as well and made this connection. However I don't see how to make crystal exclude anything appearing in OESLEC.

I am trying to create a report to show sales by item, unit price, and price list used. Then I want to compare the used price list price to the STD price on the price list. I cannot seem to find the STD price objects. I am checking the ICPRIC table for matching items. No dice

I also do not see a way to create conditions on sub reports.

I don't see any keys that will match and OEINVD record with an OECRDD record.

Ahh that makes sense. So, is it possible to eliminate the serial numbers that were later credited?