FAQ - Where does the Sales Recap Report get its numbers ?

Question:
How does the Sales Recap select the data for the report?   I am getting a different amount for adjustments when comparing the two columns.   What is the difference between the two columns?  How are adjustments calculated?

Answer:  
In all cases, the revenue reported is pulled from the invoice records that fall within your selection criteria, like date range .  If selecting by dates, the system looks at the bill date of that pro.   Rebills are not included in this report in the adjustments or voids figures.

1. Adjustments and Voids to Gross Revenue Regardless of Date
This data is pulled from the invoice file.  It is including only adjustments and voids made to those invoices selected.  That does not mean the adjustment or void was performed in the date range specified; the adjustment might have been performed outside of the date range.  For example, I have an invoice dated in November.  I make an adjustment to the invoice on December 1.  On December 2,  I pull a November report.  The November invoice that I adjusted is on the report because it falls within my requested date range of November.  Even though I made my adjustment in December, it is also included in the adjustments column.  This is because it selects my November invoice, and then reports all adjustments and voids that have ever been made to that invoice (regardless of the date of the adjustment).  This column should balance to your Summary Sales Register, as it selects invoices and adjustments in the same manner.

2. Adjustments and Voids to Any Revenue for Date Range Only:
This data is pulled from the Adjustments file, and the Voids file.  The date range selection is applied to those files, regardless of the date on the invoice itself.  For example, if you adjusted a November invoice in December, and you pull the report for December.  The November invoice is NOT included in the revenue because your selected dates were for December.  However, the adjustment is included in this column because your adjustment is dated in December and December was the selected date range.  If you pull the report for November, the November invoice that you adjusted is included in revenue.  But the adjustment to that invoice is NOT included in this column because the date on the adjustment falls outside of your selected date range of November.  The adjustments figure here should match an Adjustments Report

Below is the detailed information on the actual files used.

1. Adjustments and Voids to Gross Revenue Regardless of Date

Gross Revenue  = Total Charges for Bills within the Date Range specified
Current File:  FRMAST.TotChgs
History File:  FRYMST.TotChgs
Both Files:  FRMAST.TotChgs + FRYMST.TotChgs

Adjustments = Total Adjustments for the Bills that were selected
Current File:  FRMAST.Adj
History File:  FRYMST.Adj
Both Files:  FRMAST.Adj + FRYMST.Adj

Voids = Total Charges for Bills where the Status is Voided (Status = "V")
Current File:  FRMAST.TotChgs
History File:  FRYMST.TotChgs
Both Files:  FRMAST.TotChgs + FRYMST.TotChgs

2. Adjustments and Voids to Any Revenue for Date Range Only

Gross Revenue  = Total Charges for Bills within the Date Range specified
Current File:  FRMAST.TotChgs
History File:  FRYMST.TotChgs
Both Files:  FRMAST.TotChgs + FRYMST.TotChgs

Adjustments = Total Adjustments from the Adjustments files for Date Range specified
Current File:  FRIADJ.Amt
History File:  FRYADJ.Amt
Both Files:  FRIADJ.Amt + FRYADJ.Amt

Voids = Total Charges from the Voids files for Date Range specified
Current File:  FRVOID.TotChgs
History File:  FRYVOI.TotChgs
Both Files:  FRVOID.TotChgs + FRYVOI.TotChgs