nice to meet you all and i hope you are doing great
nice to meet you all and i hope you are doing great
Hello ALAAKHALIL,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thank you mate , i have small issue i need solution for it , where i can ask ???
Dear Sir ,
I have a collection of payments from several clients,as well many of invoices for them , I have summed the payments for each client to be as one payment in order to cover several Invoices .
My Question now , by excel How can I distribute the payment based on the due date of invoices " Oldest to newest " to settle it ,Knowing that maybe the payment closed full or part of the bill.
My Case
1-Payment
Customer Name Payment
A 5,000$
B 3,000$
2-Invoices
Customer Name Invoice No Invoice Amount Bill Date Solution / I looking for it
A 5 3,000$ Jan 2016 3,000
A 6 2,300$ Feb 2016 2,000
So, please note regarding invoice 5 ,300$ not taken because the payment from customer A was only 5,000$ so there is remaining balance from invoice 5 =300$ will settle in next payment
Your cooperation is highly appreciated
Best Regards
Ala'a Khalil
Hi Ala'a Khalil
Welcome to Excel Forum
This is just the Sub Forum to say hello
You must start a new Thread here if you need help:
http://www.excelforum.com/excel-general/
or here:
http://www.excelforum.com/excel-formulas-and-functions/
or if you would consider a macro solution then here:
http://www.excelforum.com/excel-programming-vba-macros/
If you are not sure, then probably the first will do
http://www.excelforum.com/excel-general/
_............................................
Please, also, if you get time, take some time before posting to read the Forum Rules here
http://www.excelforum.com/forum-rule...rum-rules.html
http://www.excelforum.com/forums-rules/
http://www.excelforum.com/showthread...09#post4494031
It is usually worth it in the long run.
Thanks
_..............................................
P.s.
Your explanation is quite clear, , but these notes describe the preferred ways to give us Info: ( Most people prefer to Upload a Workbook )
Remember to reduce the amount of test data, as you have done , to the minimum required to demonstrate typical scenarios. Desensitize the data if necessary.
Show us clearly what you have ( The BEFORE ) and the results you want to achieve ( the AFTER ).
Please do not use images as we cannot copy them to a worksheet.
( Most people prefer b) to upload a File BUT remember to minimize the amount and desensitise data )
Either:
_a) Post screenshots COPYABLE to a Spreadsheet: – See my signature below,
or here:
http://www.excelforum.com/excel-prog...ml#post4399581
Practice here:
http://www.excelforum.com/development-testing-forum/
OR:
_b) Upload a Workbook: See here:
http://www.excelforum.com/the-water-...his-forum.html ( Method 2 and Method 3 )
http://www.excelforum.com/suggestion...ml#post4335120
OR:
There is also the file share site option such as this free thing:
https://app.box.com/signup/personal
(_ .Remember to select Share after uploading and give us the link they provide if you use that )
But Note: a lot of people can’t / won’t download a File from an external site. So this method is not preferred here
For security reasons and to increase your chances of a response, It is preferable to upload a File with no codes in it and post any codes in the Thread ( using Code Tags # )
OR:
_c) Select the table Icon above, select an appropriate size table and fill it in (If replying to a Thread you may need to select the Go Advanced Button, ( bottom right of reply Window ) to get the Table Icon to show )
Practice Posting techniques here:
http://www.excelforum.com/development-testing-forum/
Thanks,
Alan
Last edited by Doc.AElstein; 10-16-2016 at 01:17 PM.
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks