I have been using a MS Access 2003 DB for many years, I now need to modify and enhance some basic reporting features and create a few modifications in VB
I have no knowledge in VB, and limited knowledge in Access Macros.
1. Create a monthly customer account statement
This is a standard report displaying amounts due in the respective monthly periods
2. Create Form for payment to customer accounts singular or bulk payment options, part payment option on any invoice, payment methods with split option for cash/card/bank transfer etc.
3. Create Reports based on Product ID
3.1 Product sales history : calculated fields to include profit, quantity sold and supplier price history
4. Create report for Customer Invoice and Quotation history, Calculated fields for total spend and quotes not turning to sale.
4. create financial reports
4.1 VAT report based on date periods
4.2 Profit Report based on date periods
I will add other features to DB as we commence work