A general contracting company in North Carolina contacted AccessDeveloper.net to update their invoice report. The existing rptInvoice worked well for years, but new billing requirements demanded additional line-item fields, tax breakdowns, and a revised company header.

Client Requirements

• Add JobNumber and PONumber fields to the invoice header.
• Show labor hours and material costs as separate line-item categories.
• Calculate state tax (NC 4.75%) and county tax separately.
• Include updated company logo and revised payment terms footer.
• Export to PDF with auto-generated filename: Invoice_[InvoiceNum]_[Date].pdf

Our Approach

1. Query update:Modified qryInvoiceDetail to JOIN tblJobs for JobNumber and PONumber. Added calculated columns for LaborTotal and MaterialTotal using IIf on Category field.
2. Report layout:Opened rptInvoice in Design View. Added text boxes in the Report Header for new fields. Created a Group Footer for tax calculations.
3. Tax logic:Added expressions: =Sum([LineTotal]) * 0.0475 for state tax and =Sum([LineTotal]) * [CountyTaxRate] for county tax pulled from tblSettings.
4. PDF export:Updated the btnPrintInvoice VBA to use OutputTo with dynamic filename: 'Invoice_' & Me.InvoiceNum & '_' & Format(Date, 'yyyymmdd') & '.pdf'
5. Testing:Generated 10 test invoices against historical data and compared totals with manual calculations.

Outcome

The updated report was deployed within 4 hours. The client's accounting team verified all tax calculations matched their CPA's expectations. PDF auto-naming eliminated manual file renaming, saving approximately 30 minutes per billing cycle.

Need Report Modifications?

Whether you need new fields, layout changes, or automated PDF export, our team modifies Access reports efficiently while preserving your existing data and business logic. See also our guide on Microsoft Access reporting tools.