Credit/Debit Note Sender Project

Hello! I just finished a program called Credit/Debit Note Sender. I could have come up with a better name but I couldn't

Basically what it does is send credit or debit notes to my customers.

Previously, after we have process credit/debit notes, we have to manually generates them and send to our customers. The amount of credit notes need to be generated could go up until 90 a day. So we would spend time generating 90 credit notes to be sent out to different customers.

On top of that, since credit note sending is too time consuming we have fixed a day to just do all the credit note sending and it really takes up almost a day. Since we sent out credit notes once a week, it demotivates the customers to pay on time because they tend to wait for their credit notes to knock off so that they wont have to pay so much.

Now, since we have this, it is searching for credit note on a daily basis set to run at 1150PM. It is an unmanned process and triggered by time. It will search if there is any credit/debit note posted for the day and send them out to respective customers.

Thus, if let say that particular day, we have processed few credit/debit notes, they will be sent at 1150PM on the same day and customers would receive their Credit/Debit Note in the morning.

This is how it works

Benefit of this automation:
1. Eliminates administrative work (sending credit/debit notes via email to customers).
2. Save working time because it runs when no one is working.
3. Unmmaned and effortless unless the program is broken.
4. Since it has no human intervention, it eliminates error (error sending credit note that belongs to Customer A to Customer B.


It is always good to learn how to program. The time I took to write this program is 3 days but the time saving that I get back is 1/2 day per week until forever =).