Order Report Program

I need to get a program made wherein we will need to feed in the order received from various libraries for various languages and for various Branches.

i.e Library A has 6 Branches, Branch A, B, C, D, E, F and G.

And they order per the attached list.

We will need a Program, wherein we feed the order for each of the Library Branch-wise and then we supply the books, we can add the data Like Invoice no.

Date and then the amount supplied for the language.

The Maters we rwequire for this will be: 1.

Library name alongwith the details of Various Branches, Their Budget for Various languages, with different classification Fiction, Non Fiction, Children and Dual Language books- The budget amount for each category and then as and when we supply anything, we will add the Invoice number, Date and Amount spent for the language with its category ( Fiction, Non-Fiction-Children, Dual language), as also the Quantity ( Number of books Supplied). I must mention that each Invoice will have only one language and one category of the category.

The Budgets we get are pertaining a one financial year.

As such we will also require the provision to close one budget and start a new one.

The purpose of this program will be to prepare a report at any particular time, wherein it will provide as to how much amount of books for each category has been supplied to a particular branch, and what amount is left in the budget that needs to be supplied.

We would require to take out such reports on regular basis.