Description |
We should be able to run Open Payables by the following Date criteria:
As of = 09/30/2014 = This should show all open payables that were not paid as of 09/30/2014.
Between = 09/01/2014 - 09/30/2014 = This should show open payables for this date range
Currently we only have "Equal To" as option for Date. Not sure what Equal to means in Open Payables. I tried the help manual and the page does not exist yet.
Here's an example with numbers when running report as of 09/30/2014. This should be the balance in general ledger for account payable and should match the report.
|As of Date|9/30/2014| | | | | |
| | | | | | | |
| | | | | | | |
|Vendor|Inv #|Inv Date|Orig. Inv Amnt|Amount Paid|Inv. Balance|Inv Paid|
|A|1|8/15/2014| 150.00| 100.00| 50.00|8/31/2014|
|B|2|9/1/2014| 345.00| 300.00| 45.00|9/30/2014|
|C|3|10/2/2014| 487.00| - | 487.00| |
|Total| | | 982.00| 400.00| 582.00| |
| | | | | | | |
| | | | | | | |
|The balance as of 09/30/2014 should be $95.00 |The balance as of 09/30/2014 should be $95.00 |The balance as of 09/30/2014 should be $95.00 |The balance as of 09/30/2014 should be $95.00 | | | |
| | | | | | | |
|Vendor|Inv #|Inv Date|Orig. Inv Amnt|Amount Paid|Inv. Balance|Inv Paid|
|A|1|8/15/2014| 150.00| 100.00| 50.00|8/31/2014|
|B|2|9/1/2014| 345.00| 300.00| 45.00|9/30/2014|
|Total| | | 495.00| 400.00| 95.00| |
|