Python Web App development
Budget: $25 – $50 USD
About Us:
Our company is a wholesale distribution company that buys and stocks products from manufacturers/suppliers/vendors and resales these products to smaller storefront/retail businesses.
Project Simple Overview:
Create a web app, written in python, to calculate rebates our company has earned from purchases from our suppliers. The web app needs to:
On Front End:
- Require users to log in.
- Allow users to input a rebate program for each supplier. This would be standard create new, edit, delete rebate programs.
- Generate a statement by vendor for the amount of rebate owed. Should be calculated at the Purchase Order level.
- Allow users to see all rebate programs and the amount accrued, and when it will be paid out.
On back End:
- connect to ms sql server, all Purchase data for tool exists in a ms Sql Server database, located on prem.
- store rebate programs in a new table, table needs to be designed.
- should have a job that runs over data in a PO data table and calculates rebate on new purchase orders that have been placed, for every rebate program.
- store job results in a new table as 'accrued rebates'. table also will need to be design.
- should have another job that runs over data in a Accounts Payable data table and calculates rebate payments that have been received from suppliers.
- the job results should also be stored in the same rebate table as 'rebate payment'
Example Use Case:
- Buyer 1 has a new vendor, Tape Co., that he buys tape from. The vendor gives 2% rebate on all purchases, paid out at the end of each quarter.
- Buyer 1 goes into the new Rebate Tool web app and creates a new rebate program for Tape Co. (vend # 123), 2% on all purchases, due at the end of each fiscal quarter.
- Each day, a job will run inside the rebate tool that checks a table in a ms SQL db for any new purchase orders. For any order that it finds for Tape Co., it calculates 2% of the total PO amount, and saves the Vendor #, PO #, and Amount to a rebate table as 'accrued rebate'.
- Another job will run and check the data in an accounts payable table and captures any rebate payment that has been made by Tape Co. I then inserts a record in the rebate table as 'rebate payment'.
- When Buyer 1 looks into the Rebate Tool web app, he can see the total amount of rebate due from Tape Co and what date it is supposed to be paid out.
Our company is a wholesale distribution company that buys and stocks products from manufacturers/suppliers/vendors and resales these products to smaller storefront/retail businesses.
Project Simple Overview:
Create a web app, written in python, to calculate rebates our company has earned from purchases from our suppliers. The web app needs to:
On Front End:
- Require users to log in.
- Allow users to input a rebate program for each supplier. This would be standard create new, edit, delete rebate programs.
- Generate a statement by vendor for the amount of rebate owed. Should be calculated at the Purchase Order level.
- Allow users to see all rebate programs and the amount accrued, and when it will be paid out.
On back End:
- connect to ms sql server, all Purchase data for tool exists in a ms Sql Server database, located on prem.
- store rebate programs in a new table, table needs to be designed.
- should have a job that runs over data in a PO data table and calculates rebate on new purchase orders that have been placed, for every rebate program.
- store job results in a new table as 'accrued rebates'. table also will need to be design.
- should have another job that runs over data in a Accounts Payable data table and calculates rebate payments that have been received from suppliers.
- the job results should also be stored in the same rebate table as 'rebate payment'
Example Use Case:
- Buyer 1 has a new vendor, Tape Co., that he buys tape from. The vendor gives 2% rebate on all purchases, paid out at the end of each quarter.
- Buyer 1 goes into the new Rebate Tool web app and creates a new rebate program for Tape Co. (vend # 123), 2% on all purchases, due at the end of each fiscal quarter.
- Each day, a job will run inside the rebate tool that checks a table in a ms SQL db for any new purchase orders. For any order that it finds for Tape Co., it calculates 2% of the total PO amount, and saves the Vendor #, PO #, and Amount to a rebate table as 'accrued rebate'.
- Another job will run and check the data in an accounts payable table and captures any rebate payment that has been made by Tape Co. I then inserts a record in the rebate table as 'rebate payment'.
- When Buyer 1 looks into the Rebate Tool web app, he can see the total amount of rebate due from Tape Co and what date it is supposed to be paid out.