Hello,
You are in need of a MySQL stored procedure for calculating and creating Open Item Statement table from Transaction History table with Payment closed in chronological order.
We are really interested to work on your project as we have already worked on many projects that involves MySQL, database development and database programming.
I have gone through the attached file and I m outlining the details you require -
1. Creating a MySQL stored calculating method.
2. Open item statement should contain the columns transaction number, date 1, date 2, document number 1, document number 2, invoice, paid part and balance which will be prepared from transaction history via calculation.
3. Amount in the i balance should be represented at the bottom of the Open item statement.
4. All the details input in open item statement should be following the order in which they occurred.
Can we have a discussion as we have some queries related to the project?
It will be great if we can discuss so that we can have a clear understanding of the project requirement and can amount to a more real cost and time estimate.
Please let me know what time UTC will work best for you to have a discussion.
I will make sure our tech lead is present in the meeting so as to eliminate any confusion in understanding.
I hope to receive a positive and prompt response from you.
Thank You.