In the History tab of an MBR, I'm guessing that Emerald will only pull up
(invoice) details when you double-click on an item
WHERE (column2) = 'Invoice' AND...
Can that be modified in a future update so that the value in column2 is
compared using LIKE instead?:
WHERE (column2) LIKE '%Inv%' AND...
That would permit us to modify the History stored procedure so that you can
use the following piece of SQL (representing only the invoice section of the
sp) or some slight variation of it so long as the second column contains
"inv" somewhere in it.
Here's an example:
Select Date, "Invoice", Amount, Description, InvoiceID
From Invoices
Where CustomerID = @CustomerID
And Type != 'Void'
UNION
Select Date, "Void Inv.", Amount, Description, InvoiceID
From Invoices
Where CustomerID = @CustomerID
And Type = 'Void'
If the above is done presently, the information displays correctly in
Emerald, but double-clicking on "Void Inv." has no effect, while
double-clicking on "Invoice" does.
Users can also go in and customize the existing invoice-related sections of
the SP by splitting them into potentially 3 different scenarios:
"Invoice - R" (Type = 'Renewal')
"Invoice - I" (Type = 'Invoice')
"Invoice - V" (Type = 'Void')
Obviously the user could come up with whatever display they wanted to (if
they wanted to change it at all), so long as "inv" appears somewhere in
there--enough to indicate to Emerald that it represents an invoice.
Josh Hillman
hillman@talstar.com