Re: [SL] Adding notes without reposting

[C. D. H. <Du...@Du...>]

Wallace Roberts Consulting wrote:
> On 11/20/06, Kevin Bailey <kb...@fr...> wrote:
>   
>> Hi,
>>
>> Does anyone have any ideas RE how to add to the internal notes without
>> reposting the invoice?
>>
>> I would rather not repost any transactions as this may affect how they
>> are listed in the reconciliation screen.
>>     
>
> Well...
>
> I suppose you could sniff around in the database a bit, figure out
> which table contains that information, & update it ("update
> relevant_table set notes='notes go here' where key=1234567...").  Of
> course, before doing any of that, you'd want to shutdown SL access &
> backup the DB... just in case you didn't get it right. :-)
>
>   
Not that I condone doing it, but the fields in question here are 
AR.NOTES and AR.INTNOTES.  We add notes to our INTNOTES field to record 
payment history.  Each time a payment is received a trigger fires that 
records the date, time, user amount paid and % paid in the internal 
notes field.  Perhaps you could build a separate table with a trigger on 
it - each time a record was entered it could update & append your note 
to the corresponding invoice record. 

Dunc