Tech Specs-- Visual Basic 2019, Reporting Tools : Crystal Reports, Microsoft Excel,
Backend : Microsoft SQL Server.
Team Size-- 7
My Roles-- Define the need of the customer, Ideate & Iterate with customer & team, Design, Oversee and manage the development, Oversee the implementation & support, Maintenance.
Masters-- Company, Sales, Purchase & General Accounts, Group & Type , Final Account Group, Password, Fare, Airline, GST, Charge Master for customer and supplier.
Final Accounts-- Ledgers, Trial Balance, Profit and Loss , Balance Sheet, Schedules to Accounts.
Reports-- Outstanding Statement (diff formats), Ageing , Day books, Cash Bank Book, Debtors / Creditors balance, CSR, Docketwise Report
Airwaybill Stock Control
Cargo / CnF / Miscellaneous Billing--
Entry based on option selection rather than typing of all data, entry, modify, deletion, preview and print based on access rights.
Airwaybill control for Cargo. Docket no. control for clearing and forwarding. Charges based on 20ft, 40ft, Pallete or Package for CnF. Updation of all required ledgers from bill. All bills can be e-mailed or faxed directly. Auto calculation of GST based on masters. Total modification of a bill but under password control. Split bills on receipted and non-receipted entries. Covering letter option.
Receipts and Payments with matching or on account for Debtors and Creditors-- Data entry based on option selection. Entry, modification, deletion, view and print based on access rights. E-mail or fax to clients . Automatically adjust receipts from one party for one or more of its sister concerns on the respective accounts and also match immediately. Match all bills by click of a button. Allow write off of amounts and make credit note automatically.
Cut N Pay for Airwaybill Matching
Debtors / Creditors Voucher-- Payments and receipts for a creditor or debtors along with credit note and bills. Pay commission to a third party for business given and link it to the respective tickets to enable recall in case of refunds.
General Voucher--Petty cash payments and miscellaneous receipts and payments made for general expenses.
Cash/Bank Transfer,Bank Reconciliation, BSP Reconciliation, Opening Balances for Debtors & Creditors
Global Edit-- Transfer all entries from one account to another.
Quick query on Airwaybill/Reference/Invoice
Password controlled access to modules & functions of each module.
Option to e-mail / fax / export all reports.
Detail view of any item on trial balance on click of mouse.