I am currently writing a small application that takes in sales numbers from our POS system and will eventually write a CSV file for our finance GL software. It will need to include the variances between the reported media (cash, credit, etc) vs deposit information. I have attempted to do this via a datagrid, but I'm not sure it will do what I want.
Basically I constructed a SQL query that grabs these fields:
storeid, media, amount, 0 As Deposit, 0 As Variance
I've want to make the Variance field readonly and have it dynamically updated when someone enters a number into the deposit field. So amount - depoist = variance. I cannont find a good event to do this in.
Basically I constructed a SQL query that grabs these fields:
storeid, media, amount, 0 As Deposit, 0 As Variance
I've want to make the Variance field readonly and have it dynamically updated when someone enters a number into the deposit field. So amount - depoist = variance. I cannont find a good event to do this in.
