Find Jobs
Hire Freelancers

Brightpearl API integration + php database - repost

£250-750 GBP

Ditutup
Dibuat lebih dari 11 tahun yang lalu

£250-750 GBP

Dibayar ketika dikirim
We have a client who uses Brightpearl as their CRM and accounts package. ([login to view URL]). They use it to manage their customers, and all their invoices. Brightpearl does not have a facility to send automatic invoices on a regular basis. Our client needs to be able to automatically send invoices to clients on a monthly, quarterly or yearly basis. We would like to build:- 1) A web based database to log a list of automated invoices that need to be created 2) A script which will use the BrightPearl API ([login to view URL]) to create and send the invoices based on information in the web based database we build So we would like to build a solution based on the following spec:- Web based database (php / mySQL) ============================ Here is an example of the database structure:- tblAutomatedInvoices - nAutomatedInvoice_ID - primary key - nClientID (the client ID in BrightPearl) - sClientName (the name of the client - taken from Brightpearl) - sDescription (description of the project being invoiced for) - sFrequency (monthly, quarterly, six monthly or yearly) - nAmount (the amount to invoice the customer) - sCurrency (the 3 digit currency code - eg USD, GBP, EUR etc) - nNextInvoiceDate (the date of the next invoice - date in YYYYMMDD format) - nLastInvoiceDate (date last invoice was sent - if applicable - date in YYYYMMDD format) - bChargeVAT (bit field - charge vat - yes/no) - sEmail (email address for invoice to be sent to) tblAutomatedInvoiceLog - nAutomatedInvoiceLog_ID (primary key) - nAutomatedInvoice_ID (foreign key) - nDate (date in YYYYMMDD format) - sTime (time in HH:MM:SS format) - sFrequency (from tblAutomatedInvoices) - nAmount (from tblAutomatedInvoices) - sCurrency (from tblAutomatedInvoices) - bChargeVAT (from tblAutomatedInvoices) - sEmail (from tblAutomatedInvoices) The web based database will allow you to:- 1) Add records to tblAutomatedInvoices (with facility to select which customer from BrightPearl using API) 2) Edit records 3) Remove records 4) View a log of invoices created (from tblAutomatedInvoiceLog) Python or php script ================== This script can be written in either python or php. It will be scheduled as a cron job on a daily basis. It will:- 1) Check tblAutomatedInvoices to see if there are any invoices that need to be created today (by finding records where nNextInvoiceDate is today) 2) For each matching record that is found it will:- a) Use the BrightPearl API to create the invoice b) Download the invoice information and save in a PDF c) Email the customer with the invoice d) Insert a record in tblAutomatedInvoiceLog e) Update nLastInvoiceDate in tblAutomatedInvoices to the current date f) Update nNextInvoiceDate in tblAutomatedInvoices to the date when the next invoice should be sent
ID Proyek: 4068099

Tentang proyek

21 proposal
Proyek remot
Aktif 11 tahun yang lalu

Ingin menghasilkan uang?

Keuntungan menawar di Freelancer

Tentukan anggaran dan garis waktu Anda
Dapatkan bayaran atas pekerjaan Anda
Uraikan proposal Anda
Gratis mendaftar dan menawar pekerjaan
21 freelancer menawar dengan rata-rata £518 GBP untuk pekerjaan ini
Avatar Pengguna
pls chk pmb
£630 GBP dalam 7 hari
4,9 (534 ulasan)
7,9
7,9
Avatar Pengguna
********************************************.. YOUR SEARCH ENDS HERE .. ********************************************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and getting started. I've been working in simple and extensive Website Coding (PHP, MYSQL, .NET, C#, ASP, DRUPAL, JOOMLA, DOTNETNUKE, PERL JAVASCRIPT, CSS, HTML & A LOT MORE!), Website Designing and Graphic Design for ***over 10 years now. After working as a ***top sales and marketing representative for Sears, I began to independently pursue my career. I have experience in do-it-yourself CMS, Logos with flare and flash design to name a few. I went to college for business and marketing so ***I know what it takes to sell. Get it done professionally and get it done right! Thank you, Timothy
£1.000 GBP dalam 8 hari
4,7 (33 ulasan)
7,2
7,2
Avatar Pengguna
Thanks for inviting us to bid on this project. We have a team of highly qualified and creative professionals. Give us a chance to show our talents and we assure you quality.
£600 GBP dalam 7 hari
4,3 (72 ulasan)
7,1
7,1
Avatar Pengguna
Looking forward to discuss further details in terms of design aspects
£620 GBP dalam 18 hari
4,8 (91 ulasan)
7,0
7,0
Avatar Pengguna
Ready to start. Highly interested. Thanks.
£600 GBP dalam 8 hari
5,0 (81 ulasan)
6,2
6,2
Avatar Pengguna
Hi, I can provide the required solution. Regards.
£400 GBP dalam 5 hari
4,7 (18 ulasan)
5,9
5,9
Avatar Pengguna
hello i can help your sir let's start
£600 GBP dalam 20 hari
5,0 (43 ulasan)
5,8
5,8
Avatar Pengguna
Dear Sir, Expertise in Open Source/CRM/ERP/POS/Custom Solutions/Web designing. We do customization as per your requirements. ! With a good Profile in Freelancer and experience of over seven years in the Software Arena we strive for Customer satisfaction by providing Post Development Support. We stand out through our Customer-centric and Quality-driven approach. Please reach us, we are there to help you to achieve your GOAL and subsequently brighten our Profile... More on message.... Thanks and Regards Business Development Manager AuricleSoft
£510 GBP dalam 22 hari
5,0 (20 ulasan)
5,6
5,6
Avatar Pengguna
I can do it.
£350 GBP dalam 10 hari
5,0 (43 ulasan)
5,5
5,5
Avatar Pengguna
Hello, i can do this in a timely, accurate and professional manner look to work with you At your disposal for any query. Regards softwarevamp
£650 GBP dalam 30 hari
4,9 (25 ulasan)
4,8
4,8
Avatar Pengguna
hey please check PMB
£400 GBP dalam 10 hari
4,7 (7 ulasan)
4,5
4,5
Avatar Pengguna
hi sir, I m ready to start.
£500 GBP dalam 5 hari
4,7 (12 ulasan)
4,1
4,1
Avatar Pengguna
HI, This is very simple task. we can deliver you the results on time.
£300 GBP dalam 2 hari
5,0 (4 ulasan)
3,9
3,9
Avatar Pengguna
Let's get cracking on this job. Expect quality work.
£550 GBP dalam 15 hari
4,7 (14 ulasan)
3,8
3,8
Avatar Pengguna
Hello. I can start right now
£250 GBP dalam 7 hari
5,0 (6 ulasan)
3,8
3,8
Avatar Pengguna
I have read your requirement, i have over 6+ years of experience in php, mysql, css, looking forward to work with you.
£250 GBP dalam 10 hari
4,5 (5 ulasan)
3,6
3,6
Avatar Pengguna
I can deliver the solution in php&mysql quite quickly. Kindly check private message. Thank you
£275 GBP dalam 3 hari
5,0 (4 ulasan)
3,0
3,0
Avatar Pengguna
Dear Sir, Veltrod Technologies is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and technologies, Veltrod provides high-quality software development and BPO services to independent software vendors and enterprises. We are specialized in developing Mobile applications, Search Engine optimizations, Social Network frameworks and ERP applications. We are pleased to take care of this project, if it is offered to us. We assure that we will work towards 100% client satisfaction. Thanks Santhosh
£700 GBP dalam 25 hari
5,0 (2 ulasan)
0,7
0,7
Avatar Pengguna
Hello, I'm interested to build it for u, it may take 7-10 days to be implemented as you specified above.
£750 GBP dalam 7 hari
0,0 (0 ulasan)
0,0
0,0
Avatar Pengguna
Dear Client, We have gone through with your project requirement. Please check PMB for more details. Thanks
£300 GBP dalam 10 hari
0,0 (0 ulasan)
0,0
0,0

Tentang klien

Bendera UNITED KINGDOM
Beckenham, United Kingdom
4,5
5
Memverifikasi Metode pembayaran
Anggota sejak Mei 12, 2011

Verifikasi Klien

Terima kasih! Kami telah mengirim Anda email untuk mengklaim kredit gratis Anda.
Anda sesuatu yang salah saat mengirimkan Anda email. Silakan coba lagi.
Pengguna Terdaftar Total Pekerjaan Terpasang
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuat pratinjau
Izin diberikan untuk Geolokasi.
Sesi login Anda telah kedaluwarsa dan Anda sudah keluar. Silakan login kembali.