Python Code for Automated Billing System
Budget: ₹12,500 – ₹37,500 INR
Need to create a python code to perform the following tasks from the Dashboard,, viz
1."Import Email Data" button will Extract data from a given email with subject "Billing information" and update table "Email_ billing_info" with the email data and complete all fields on the basis of Client_master
2."Estimate Billing" button will Update Estimated_Billing table on the basis of Contract_master
3. "Exception report" button will compare Email_ billing_info table with Estimated_Billing table for each contract and update the Exception_billing table with the contracts not billed -this report would be downloadable
4."Update Exceptions" button should open the Exception_billing table and allow the user to mark any contract for billing by updating the Action field with "Bill" and "No_Billing_Reason" with text data -default is "No Billing"
5."Bill Exceptions" button will create billing data on the basis of rows marked with "Bill" and update Estimated_Billing table (billing_source field=exceptions) and delete the relevant rows in Exception_Billing
6.E-invoice button will create a json file for uploading into GST portal
7.Accounting button will post appropriate accounting entries into Tally through API
1."Import Email Data" button will Extract data from a given email with subject "Billing information" and update table "Email_ billing_info" with the email data and complete all fields on the basis of Client_master
2."Estimate Billing" button will Update Estimated_Billing table on the basis of Contract_master
3. "Exception report" button will compare Email_ billing_info table with Estimated_Billing table for each contract and update the Exception_billing table with the contracts not billed -this report would be downloadable
4."Update Exceptions" button should open the Exception_billing table and allow the user to mark any contract for billing by updating the Action field with "Bill" and "No_Billing_Reason" with text data -default is "No Billing"
5."Bill Exceptions" button will create billing data on the basis of rows marked with "Bill" and update Estimated_Billing table (billing_source field=exceptions) and delete the relevant rows in Exception_Billing
6.E-invoice button will create a json file for uploading into GST portal
7.Accounting button will post appropriate accounting entries into Tally through API