Results 1 to 2 of 2

Thread: Automatic invoice generation

  1. #1

    Automatic invoice generation



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Excel Guru's,

    Model PO No Line Item Qty Del Date
    A 124 1 200 15-08-2015
    B 123 1 300 16-09-2015
    A 123 2 250 15-09-2015
    B 124 2 500 16-08-2015
    A 124 3 600 15-10-2015
    B 123 3 200 16-10-2015
    A 124 4 300 15-11-2015
    B 123 4 400 16-11-2015
    A 124 5 500 15-12-2015
    B 123 5 600 16-12-2015


    If i invoice enter Model & Qty, then it should first consider oldest delivery date, then take PO no,
    Line item and qty. After invoice qty should be detected from PO and balance to be shown as pending PO..

    For Example, if i dispatch Model "A" - 600 Nos, it should take

    Model Del Date PO No Line Item Total Balance
    A 15-08-2015 124 1 200 0
    A 15-09-2015 123 2 250 0
    A 15-10-2015 124 3 150 450

    Give me the Formula to come out of this issue.

    Thanks & Regards,

    Senthilrajagopi.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    cross posted:
    http://www.mrexcel.com/forum/excel-q...eneration.html
    http://forum.chandoo.org/threads/aut...invoice.25960/
    http://www.excelforum.com/excel-form...eneration.html

    senthilrajagopi, for your information, you should always provide links to your cross posts.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

Posting Permissions

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