Has anyone successfully added the invoice dates to the Transaction Detail grid in Chart Tracker?
I tried one method where it essentially does a lookup for each row and, while it works, it’s horribly inefficient and nearly unusable due to speed.
I tried creating a BAQ and rebinding the grid, but I’m having trouble with the publish/subscribe.
In order to filter the data properly, it needs to subscribe to multiple values, which is fine, but the one I’m having trouble with is subscribing to a date range. I need to have the BAQ be filtered on the date range from the fiscal period selection (Filter.StartDate and Filter.EndDate).
In addition, I’d like it to behave the same way as the original where it populates when clicking the retrieve button. I must be misunderstanding the code to publish and subscribe because if I put it on the Click event for the button, I get an error about the key already being in the dictionary.
Need to add invoice date to Chart Tracker Trans Detail