Topics

Thursday, October 30, 2014

Sales Transaction Entry Open and History Files Transaction Volume Analysis

Recently I answered a forum post by a user who wanted to know the number of transactions by module entered in a given day. I authored a series of queries which allow a user to input a date and execute the query. The queries identify the number of unique transactions and the number of lines in the table. Dividing one by the other will reveal the average lines per transaction. This query reveals the Number of Sales Transactions processed on a given day and the number of overall lines.