+ Reply to Thread
Results 1 to 5 of 5

Hello all , Ala'a From Amman

  1. #1
    Registered User
    Join Date
    10-14-2016
    Location
    Jordan,Amman
    MS-Off Ver
    2007
    Posts
    2

    Hello all , Ala'a From Amman

    nice to meet you all and i hope you are doing great

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    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]

  3. #3
    Registered User
    Join Date
    10-14-2016
    Location
    Jordan,Amman
    MS-Off Ver
    2007
    Posts
    2

    Re: Hello all , Ala'a From Amman

    Thank you mate , i have small issue i need solution for it , where i can ask ???

  4. #4
    Registered User
    Join Date
    10-14-2016
    Location
    Jordan,Amman
    MS-Off Ver
    2007
    Posts
    2

    Re: Hello all , Ala'a From Amman

    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

  5. #5
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Hello all , Ala'a From Amman

    Quote Originally Posted by ALAAKHALIL View Post
    .... , i have small issue i need solution for it , where i can ask ???
    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 )

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1