Search results

example of what I have: item - transactionNO - Qty - Balance - date X - Receive 123 - 10 - 20 - 1-1-2001 X - Receive 456 - 10 - 20 - 2-1-2001 on "receive 123" I need the balance to be "10 only" which is the balance at the date of the transaction...

it is a calculated field based on the data in he table. it is calculated directly in the report.

I tried this but it will sum the balance. what I need is to show what was the balance at the date of the transaction and not the current one.

I created a report to show stock level and transactions. there are date, transaction, quantity and balance fields. the balance field show the total balance of the item at the moment. what I need is to show the balance at the transaction date.