Hi, all
Before printing a receipt, I need to compute a value for a field to be printed, based on other data that will also be printed. I believe the formula will be more complicated than a can handle. My understanding is that the cannot do string parsing, substrings, arrays, etc. Is that correct? The documentation made a reference to VBA, saying that the subroutine would be called like in VBA, but I didn't get the impression that the sub is actually VBA code. If it is, then I think a sub will work. Is there more detailed documentation of writing subroutines somewhere?
Another idea I had is to write a DLL, and call it via the PrintReceipt hook. In the documentation, I get the impression that the DLL may only return a true/false, indicating if I still wish the receipt to print. I don't see how I can return a value to be printed, or modify any Receipt variables within the DLL.
I could even write a custom SQL Server function, if I could figure out how to call it.
So, is there a way to do what I need?
Cheers Dan