VB Studio Application with SQL Database - Telecoms Billing
4718
£150(approx. $188)
- Posted:
- Proposals: 12
- Remote
- #71780
- Archived
MS Access/MS SQL/MS Excel/App Developer/DataBase Developer/Programer/Database Admin
Port-of-Spain
58782767557687311779513360715786216087717246617536114162135971145224
Description
Experience Level: Expert
I Want an application that imports a CSV with 11 columns of data.
Uplift the Cost price by 50% and store data into a temp table
The data is grouped by Telephone numbers and i would like reports produced by month (Each Import) and stored into a master table.
Each report should be seperate by telehpone number and billing period.
(FIlename for PDF can be "NUMBER" & "-" & "BILLING PERIOD"
I would then like to produce a report for each number per month for the billing data imported into the system.
The reason for the temp table is to uplift and check data, produce mass reports and then period close (Shift data into master table)
Single reports can be created at a later date by selecting number and billing period, but you can only do one at a time.
Also store variables like next billing period, uplift %, minimum billing 60 seconds etc into a params table.
Uplift the Cost price by 50% and store data into a temp table
The data is grouped by Telephone numbers and i would like reports produced by month (Each Import) and stored into a master table.
Each report should be seperate by telehpone number and billing period.
(FIlename for PDF can be "NUMBER" & "-" & "BILLING PERIOD"
I would then like to produce a report for each number per month for the billing data imported into the system.
The reason for the temp table is to uplift and check data, produce mass reports and then period close (Shift data into master table)
Single reports can be created at a later date by selecting number and billing period, but you can only do one at a time.
Also store variables like next billing period, uplift %, minimum billing 60 seconds etc into a params table.
Mike M.
99% (28)Projects Completed
30
Freelancers worked with
26
Projects awarded
38%
Last project
27 May 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies