This post explains the extension in data model resulting from change in business rule. A Prime Group is a steel rolling mills and Export Company having its offices in Dubai and Pakistan. This project was to create /upgrade database and creating Crystal Reports to facilitate changes in business rules and expansion in manufacturing facility.

Company’s Business rule of receiving full payments on export invoices was changed in partial payments, consequently it became critical to record the related exchange rates, commission charges and bank charges on partial payments. In coordination with management, SQL Server database functionality was extended by creating additional table to store partial export receipts and related data along with foreign key from the respective invoices from Invoices table.

After the above modification an additional data was available facilitates which crystal reports for higher management showing payments received against each export invoice along with detail of related exchange rates, the bank charges, commissions and discount and sum of net amount received and related information like average exchange rates and summary of all expenses. Please also read