I forgot to mention that when adding the DateTime stamp field you should set it's default value to 'GetDate()' this way every new record will always have the datetime it was created.
Suneel. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Suneel Jhangiani Sent: Friday, February 04, 2005 11:01 AM To: [email protected] Subject: [Rodopi] Deposit Slips (Out Of Order) This should be relatively easy to fix. First, we would need to check that the Table holding the transaction details has a dateTime stamp, if not we could add it since it would not affect Rodopi (just be aware of it during upgrades as they may drop / create the table). The next step is to find the Stored Procedure that Rodopi uses to pull the transactions. You can use the search on http://www.rodopi-faq.com to do this as it has an index of all tables and stored procedures (you simply search for the table name and will get returned every page that mentions that name. You then add an 'ORDER BY {dateTime}' to the query that pulls the transactions. You should keep pestering Rodopi as this is such a minor fix it is silly they haven't done it yet! Regards, Suneel. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of GlobalNet, LLC NOC Sent: Thursday, February 03, 2005 3:42 PM To: [email protected] Subject: [Rodopi] Deposit Slips (Out Of Order) I submitted this to Rodopi again a week ago, and they have failed to answer this thus far, so I am forced to bring it to alls attention, and ask for some insight and some help, for a workaround Every since we have used Rodopi the deposit slip puts the entrys in out of order they are entered, and when this happens the checks are out of order on the deposit slip and causes a great headache for billing when putting them in order for the bank deposit. We have growed to rodopi about this for ever since 1999 and although they do a work around have never seemed to make this a permanent change. Since the last upgrade to 5.4 sp4 its goofed up again, and I have emailed rodopi support about a week ago, and have not heard from them. Heres what I mean Say I enter 5 accounts with payments (they are all checks) Say I enter these in rodopi transactions in the below order 1. Bob Mills 2. Harry Householder 3. Mary Pitts 4. Sam Spade 5. Ritz Crackers Now when I do the deposit ticket that day it will print them on the deposit list out of order they were entered (should be ordered by datetime) 1. Mary Pitts 2. Bob Mills 3. Ritz Crackers 4. Sam Spade 5. Harry Householder This is a really big pain when the deposit is a large one with a hundred or so checks for that day What is everyone else do? Has anyone else complained about this? This should be a permanent fix. Jeff GlobalNet [EMAIL PROTECTED] --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com --------------------- --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com --------------------- --------------------- To Leave the Rodopi mail list send a message to [EMAIL PROTECTED] with the word LEAVE as the message body. Please also visit the Rodopi FAQ at http://www.rodopi-faq.com ---------------------
