Create automated Individual invoices using (MS Excel) sales ledger & (MS Access)
- or -
Post a project like this£75(approx. $94)
- Posted:
- Proposals: 14
- Remote
- #2169099
- Expired
Microsoft Certified Power BI Data Analyst & Advance Excel Specialist¦Professional Power BI consultant ¦ (ACCA)- Chartered Certified Accountant ¦ Accounting- Reconciliations ¦DAX ¦Data Models ¦
Doha
I am certified Microsoft Professional.. With 20 year plus experience in IT, I am expert Excel , VB and VB.net and Python programmer, Desktop Aplications & MS Office Integration and automation
Lahore
140641614494732269291241775719681036600342223564238176919011424046271092611144529
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Hello,
I have my monthly sales ledger which I would like to create individual invoices for each order.
I have 2 main customers.
All information will remain the same apart from the following:
Changing info on Invoice:
1. Date
2. Invoice/Reference Number
3. KK Gross
4. KK Vat
5. KK Net
6. Payment Date
I have attached an example of the x2 ledgers we use with example data.
The fields highlighted in green is the only information which needs to be pulled.
I look forward to hearing from you.
Also I am open to all solutions such as coding.
Many Thanks
David Green
I have my monthly sales ledger which I would like to create individual invoices for each order.
I have 2 main customers.
All information will remain the same apart from the following:
Changing info on Invoice:
1. Date
2. Invoice/Reference Number
3. KK Gross
4. KK Vat
5. KK Net
6. Payment Date
I have attached an example of the x2 ledgers we use with example data.
The fields highlighted in green is the only information which needs to be pulled.
I look forward to hearing from you.
Also I am open to all solutions such as coding.
Many Thanks
David Green
Karl M.
100% (30)Projects Completed
28
Freelancers worked with
17
Projects awarded
13%
Last project
21 May 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
How automated do you want it Karl? This can easily be done with a mail merge but if you dont want to touch it at all then you will need some coding of some kind. What is the output format you are looking for?
721333
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