locked
Query to get Debit,Credit,Balance RRS feed

  • Question

  • User-172769993 posted

    Hi i have the following tow tables

    i need to get statement for certain customer where each receipt voucher must be under invoice so i avoid getting negative values

    the out put supposed to be like this

    Type ID Date Debit Credit Balance
    Sales Invoice 70 17/Sep/2015 225.00 0.00 225.00
    Receipt Voucher 43 17/Sep/2015 0.00 150.00 75.00
    Receipt Voucher 46 19/Sep/2015 0.00 75.00 0.00
    Sales Invoice 107 17/Oct/2015 225.00 0.00 225.00
    Receipt Voucher 72 17/Oct/2015 0.00 225.00 0.00

    your help is much appreciated

    Monday, January 4, 2016 2:07 PM

All replies