Create MySQL Stored Procedures for recording and calculating Payment & Credit Invoice Allocations

$30-250 AUD

Completed

Posted

almost 7 years ago

$30-250 AUD

Paid on delivery

We are searching for a proficient MySQL Developer that also possesses some knowledge of accounting principles, specifically ageing of invoices and allocation of payments and credits to invoices. You will be required to create procedures in MySQL to allocate client payment records to line items on invoices, allocating to the earliest line items first. Allocations of both payments and credit invoices must occur (can be in separate procedures). All work is to be completed within MySQL, with all operation logic contained in MySQL (using cursors, loops etc). The successful freelancer will create the required procedures using existing database & table schematics. ** Please do not submit a bid on this project if you do not have an understanding of accounting principles, specifically the allocation of payments and credit invoices.

Project ID: 14660035

About the project

15 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@sachinraghav

Hi There, I have working on Stored Procedures and function in Database. I have also worked on credit transactions. I can do this project. Message me for more detail Relevant Skills and Experience MYSQL, SQL, Stored Procedures, Database Programming, Credit Transactions Proposed Milestones $50 AUD - Starting Milestone $83 AUD - Final Procedure.

$133 AUD in 3 days

4.8

(25 reviews)

4.5

15 freelancers are bidding on average $141 AUD for this job

@sitwebsolution

To The Hiring Manager, We are from S IT Solution, we're already skilled and experienced with your Desired skills. Relevant Skills and Experience If you Consider us to full fill your job then we will try our best level. We're looking forward to some feedback from you. Thanks & Regards S IT Solution Proposed Milestones $98 AUD - 98

$98 AUD in 3 days

5.0

(7 reviews)

4.2

@webdev1802

I am oracle certified.I have 6+ years of experience. I have reviewed your project requirement and I can do this work, it will be good if we once discuss about the requirement. Relevant Skills and Experience php,mysql,codeigniter,wordpress,bootstrap,ajax,html,yii,laravel,angularjs,mongodb,nodejs,android,iphone, web services,javascript,opencart,joomla,drupal,magento. Proposed Milestones $155 AUD - w Do you have any reference links, can we have more discussion. I can show you my previous work.

$155 AUD in 3 days

4.9

(6 reviews)

4.4

@adisapsystem

HI, I ahve very good functional knowlwdge of ERPs and accounting systems. I can work on stored procedures for the same, Relevant Skills and Experience Accounting, Database Development, Database Programming, MySQL, SQL Proposed Milestones $150 AUD - Project milestone Thanks for reading my bid . Please share more details so we can start.

$150 AUD in 3 days

4.9

(2 reviews)

3.5

@nojnish

Hi, I have 5 years experience in MySQL the scope is to deliver stored procedure to allocate payments against oldest invoice of the customer and balance if any to subsequent invoices regards Babu Relevant Skills and Experience 15+ years experience in SQL 5 years in MySQL procedure development and accounting project experience have done allocation of material receipt against purchase order to calculate pending purchase qty Proposed Milestones $250 AUD - on completion of task Stay tuned, I'm is still working on this proposal.

$250 AUD in 5 days

5.0

(2 reviews)

3.6

@sarunjat

summary of this project will complete in mySQL ,and must have accounting ,payment and invoice skill Relevant Skills and Experience I have been working on the database for more than 20 years and currently work on invoicing and receipts. If I choose to work for this job, you will get results as well. Proposed Milestones $111 AUD - none How can i see the first document of your database structure? How to know this Job was finish?

$111 AUD in 10 days

0.0

(0 reviews)

0.0

@gourishpatil01

A proposal has not yet been provided

$110 AUD in 10 days

0.0

(0 reviews)

0.0

@codeforgeek19

Hi I've reviewed your complete project Details and I can strongly assure you that I will be able to provide you good quality of work. I have done lot of projects in this domain You can check skills from my profile And I ensure you that I can complete your project with good quality. We can discuss more about this project in chat Looking forward to work with you on this project. Thank you

$30 AUD in 5 days