+ Reply to Thread
Results 1 to 4 of 4

Posting Maltiple Payments to Multiple Invoices – FIFO Method

  1. #1
    Registered User
    Join Date
    09-11-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Post Posting Maltiple Payments to Multiple Invoices – FIFO Method

    How to Posting Maltiple Payments to Multiple Invoices – FIFO Method

    Example Data as below :



    Open/ Oustanding/Pending Invoices Details
    Account InvoiceNo Invoice_Date Invoice_Amt
    6524001 1654321 01-Jan-13 6,589.00
    6524001 1654350 01-Feb-13 6,548.00
    6524001 1654377 01-Mar-13 3,562.00
    6524001 1654410 01-Apr-13 6,524.00
    6524001 1654443 01-May-13 5,124.00
    7521436 1654355 01-Feb-13 3,256.00
    7521436 1654388 01-Mar-13 6,589.00
    7521436 1654421 01-Apr-13 5,874.00
    7521436 1654454 01-May-13 5,984.00
    5487541 1654366 01-Feb-13 9,542.00
    5487541 1654399 01-Mar-13 7,542.00
    5487541 1654432 01-Apr-13 6,325.00
    5487541 1654465 01-May-13 3,562.00


    Payment Received Details
    Account Recvd_Amt Chq_No Chq_Dtd
    6524001 20,005.20 002546 05-May-13
    7521436 15,745.60 652114 05-May-13
    5487541 18,000.00 065214 05-May-13


    I want to Result as below.

    Account Invoic no Invoice_Date Invoice_Amt Amt to be Posted
    6524001 1654321 01-Jan-13 6,589.00 6,589.00
    6524001 1654350 01-Feb-13 6,548.00 6,548.00
    6524001 1654377 01-Mar-13 3,562.00 3,562.00
    6524001 1654410 01-Apr-13 6,524.00 3,306.20
    6524001 1654443 01-May-13 5,124.00 -
    7521436 1654355 01-Feb-13 3,256.00 3,256.00
    7521436 1654388 01-Mar-13 6,589.00 6,589.00
    7521436 1654421 01-Apr-13 5,874.00 5,874.00
    7521436 1654454 01-May-13 5,984.00 26.60
    5487541 1654366 01-Feb-13 9,542.00 9,542.00
    5487541 1654399 01-Mar-13 7,542.00 7,542.00
    5487541 1654432 01-Apr-13 6,325.00 916.00
    5487541 1654465 01-May-13 3,562.00 -


    Please provide the excel template
    Attached Files Attached Files
    Last edited by amardas; 06-15-2013 at 03:03 AM. Reason: Excel Attached ADD

  2. #2
    Registered User
    Join Date
    09-11-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Posting Maltiple Payments to Multiple Invoices – FIFO Method

    Dear All Friends,

    Please help urgent.............................

  3. #3
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Posting Maltiple Payments to Multiple Invoices – FIFO Method

    Cross-Post @ http://chandoo.org/forums/topic/post...93-fifo-method

    amardas.. Please check there..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  4. #4
    Registered User
    Join Date
    09-11-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Posting Maltiple Payments to Multiple Invoices – FIFO Method

    Dear Debraj,
    Thank you so much for your kind information

+ 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